GAGANDEEP SINGH
26 ASHDALE RD
BRAMPTON ON L6Y 5M7
Cell Phone: 647-654-8878
Phone: [Send email to request phone number] 30-8155
Email: [Send email using form at bottom]
SUMMARY
A versatile and innovative IT Consultant with solid analytical skills, strong
logic building aptitude, business acumen and over 9 years of experience and
expertise in Datawarehouse/BI Engineering (Architecture, Design, Development and
Implementation). Acknowledged and recognized in transforming complex business
requirements into robust, efficient and productive Information and Decision
Support Systems in Insurance, Retail, Health, Telecommunications and Software
Industries.
RELEVANT SKILLS
Datawarehouse / BI Design and Architecture 9+ years
Dimensional Modeling (Kimball / Inmon Methodologies) / Logical and Physical
Design 9+ years
ETL Design / Data Integration Model / Reporting Layer Frame-work 9+ years
PROFESSIOANL EXPERIENCE / EMPLOYMENT HISTORY
Blue Cross and Blue Shield of Vermont Apr 2009 – Present
http://www.bcbsvt.com/visitor/index.html
The Blue Cross and Blue Shield Association (BCBSA) is a national federation of
39 independent, community-based and locally operated Blue Cross and Blue Shield
companies. Collectively, the Blue Cross and Blue Shield System provides
healthcare coverage for more than 100 million people or one-in-three Americans.
It is among the 20 largest employers in the U.S. and more than 90 percent of
hospitals and 80 percent of physicians and doctors contract with BCBS companies.
As an ETL Lead Consultant I am involved in the design and development of various
data marts that enhance decision support for client’s products and services in
the State of Vermont. Leading a team of 4 ETL developers, I designed and
engineered a scalable, optimized and atomic grained dimensional model and
integrated various data sources into consolidated data marts via conformed SCD
Type 2 dimensions and fact-less facts. Designed and developed the transformation
process for data cleansing, enforcing complex business rules, de-duplication,
surrogate key generation, aggregations and integration. Conducted triages and
training sessions for ETL and BI developers.
Loblaw Companies Limited (LCL) Jan 2009 – Mar 2009
http://www.loblaw.ca/
Loblaw Companies Limited is Canada’s largest food distributor and a leading
provider of general merchandise products, drugstore and financial products and
services. Loblaw stores provide a wide, growing and successful range of products
and services to meet the everyday household demands of Canadian consumers. Over
140,000 full-time and part-time employees execute its business strategy in 1200
corporate and franchised stores from coast to coast. This makes Loblaw one of
Canada’s largest private sector employers. As a Sr. Datawarehouse Developer, my
role is to assist in the data migration initiative, which is carried out a store
level. Each Store POS and In-Store Processor application is being migrated from
Informix on SCO UNIX to Oracle on AIX platform. The central datawarehouse,
pricing, CAO, scales and many other applications are being migrated to an
integrated SAP Solution.
Canadian Institute for Health Information (CIHI) Jul 2008 – Oct 2008
http://secure.cihi.ca/cihiweb/splash.html
The Canadian Institute for Health Information (CIHI) is an independent,
not-for-profit organization that provides essential data and analysis on Canada’s
health system and the health of Canadians in many different areas such as Health
care services, Health human resources, Population health, national health
indicators—measures such as life expectancy or what we spend on health per
capita—that are used to compare health status and health-system performance and
characteristics for sound decision-making. As a Data Architect, I was hired for
redesigning the implemented ETL System.
Royal Bank of Canada Insurance Jul 2007 – Jun 2008
http://www.rbcinsurance.com/
Project: Nexus Program (Data Integration and End User Access [DI&EUA] Project)
RBC Insurance’s Program NEXUS began in September 2004 with a strategic vision
and scope to transform the RBC Life & Health Insurance Business and to repatriate
the business data from the UnumProvident systems residing in the U.S. The
Implementation was planned to occur in 3 releases and there are nine projects
within Program NEXUS that are necessary to enable the Living Benefits New
Business platform and the UnumProvident conversion. As a Sr. ETL Developer,
supported and troubleshot ETL Batches in four iQA environments consisting of 150
jobs each for converting 4 million policies per cycle and developed SQL stored
procedures and scripts for ETL Batch control, redesigned and tuned ETL jobs with
up to 93.3% performance gain and fixed over 200 bugs in the existing ETL jobs to
ensure data quality and smooth execution runs.
Govt. of Ontario Ministry of Health & Long term Care Oct 2005 – Jun 2007
http://www.health.gov.on.ca/
Project: Long-Term Care Homes Common Assessments Project (CADRe)
The Long Term Care Homes Common Assessment Project (LTCH CAP) is sponsored by
the Continuing Care e-Health Council and is supported by the Ministry of Health
and Long Term Care in the province of Ontario, to facilitate the implementation
of new standards for assessing residents of Long Term Care Homes in the Province.
Common assessment is widely recognized as a key enabler of quality care through
the collection of assessment information in a standardized way. The scope is to
implement a robust analytical layer for various operational database systems used
in different spheres of Long Term Care. As a Datawarehouse Engineer, I researched
and outlined the pros and cons of various data warehouse implementation
approaches, documented and presented the various stages, processes and
architectural components to the solutions architect and team members.
VeriSign (M-Qube Canada) Jan 2005 – Sep 2005
http://www.verisign.com/m-qube/index.html
M-Qube, a part of VeriSign Inc., is a leading developer and distributor of
mobile content and applications that make it possible for media companies and
consumer brands to reach the broadest audience of wireless subscribers across
North America. The company provides a single interface for connectivity, an
extensive content catalog, application development, monitoring, billing and
transport to enable brands of all types to offer their consumers a wide variety
of mobile products. M-Qube’s strategic wireless partners include Verizon
Wireless, Cingular Wireless, Sprint PCS, T-Mobile USA, Nextel, US Cellular,
Cincinnati Bell Wireless, MTS, Bell Mobility, Rogers Wireless, Telus Mobility,
Microcell Solutions, etc. As an ETL Developer in the Product Engineering
Department, researched and developed datawarehouse standards, road maps and
presentations for department meetings and designed an automated script deployment
of ETL process for Beta, Staging and QA Servers.
Microsoft Corporation Canada Aug 2003 – Dec 2004
http://www.microsoft.com/
Microsoft (NASDAQ: MSFT) offers a wide variety of custom, packaged, and
self-help choices to support businesses, IT professionals, developers, home
users, and partners. As a Product Support Engineer for Microsoft SQL Server, I
provide premium-level, responsive and reliable technical solutions and
information to our corporate customers - fortune 1000 companies that use
Microsoft SQL Server as their database management/information system. As a part
of Microsoft Product Support Services team, my responsibilities/accomplishments
were to communicate with corporate customers to acknowledge and analyze their
problems and to provide effective and timely solutions to meet customer needs and
project deadlines. Analyzed and formulated troubleshooting and performance
optimization steps for integrated environments and ETL process to populate data
marts and OLAP databases. Tested, identified and filed bugs, regarding
unidentified problems found in the product. Researched and developed policies,
guidelines, roadmaps and procedures for troubleshooting issues related to
Microsoft SQL Server.
Infosys Technologies Ltd India May 2000 – July 2003
http://www.infosys.com/
Project: Finacle® Enterprise Banking Solution
INFOSYS Technologies Ltd. (NASDAQ: INFY) is an IT consulting and service
provider, providing end-to end consulting for global corporations. The company
has partnered with several Fortune 1000 companies providing a wide range of
services for technology driven business transformation initiatives to clients
globally, in different sectors and industries. Finacle, the new generation core
banking solution from Infosys, is a centralized, fully integrated retail,
corporate and trade finance solution that is designed to extend the bank's reach
to the entire enterprise in a seamless manner - from the front office to the back
office. As an ETL Developer, I was involved in the ETL development and testing
process of the Finacle BI Suite, being used by Worlds leading banks like: BHF,
First USA, IDBI, ICICI, Punjab National Bank, National Bank of Abu Dhabi, etc.
Asset International India Aug 1999 – Apr 2000
http://www.aptech-globaltraining.com/
Asset International is the high-end training division of Aptech Limited India
and a Microsoft Certified Solution Provider. It is one of the leading players in
education and training in information technology, e-commerce and software
engineering in India and caters both retail and corporate segments. As a
Certified Trainer, I trained MCSE, MCDBA and OCP DBA students according to
Microsoft Official Curriculum and Oracle Press study material.
EDUCATION
• MCDBA - Microsoft Certified Database Administrator (MS SQL Server 7.0/2000)
• Brainbench Certified Master (MS SQL Server 2000) – 2005 (Score: 96%) Highest
in Canada in 2005
• Post Graduate Diploma in MIS from Microedge India – Aug 1999 (Score: 85%)
• Bachelors Degree from Punjabi University, India – Apr 1998 (Score: 80%) |
