Career Summary

• 10 years of total IT experience primarily focused in DW / Data / BI / ETL Technical Architecture and Design, Project Management, Project Assessment and Roadmap, advanced analytics, leading design and development other phase of development lifecycle of Data Warehouse, Data Marts, Data Integration and Business Intelligence solutions
• Highly proficient in different Data Warehousing Architectures/Methodologies Ralph Kimball, Bill Inmon , with full lifecycle experience implementations using various ETL/ BI tools and Databases.
• Managed development/support teams onsite offshore , review deliverables mentoring. Have worked closely with project stream managers release manager on planning, resourcing and co-coordinating releases, own detailed project plan present in weekly status review meetings and in planning / implementation of various EDW / Data Mart initiatives and their estimates.
• Established and implemented ETL best practices and guidelines produced ETL architecture deliverables, ensuring data quality through extensive data profiling, building data quality dashboards to aide periodic monitoring, designing data reconciliation and recovery capabilities for complex data warehouse systems that includes a robust Audit, Balance, Control Error architecture, and with hands-on expertise in complex ETL modules, such as writing custom scripts.
• Worked on diverse business areas, including Health Care Humana / Blue Shield of California / Optum UHG / BCBS LA, MN , Oil Gas Hess Corporation , Information Management Dun Bradstreet, Lexis Nexis

Technical Skillset

Data Integration, Data Governance Master Data Management

Data integration architecture, design development Data quality Master data management MDM SSIS 2012, 2008R2, 2005 Informatica 8 Familiar with IBM Initiate

Databases/Repositories

MS SQL Server 2012/2008R2/2005/2000 Oracle 9i DB2 Sybase MS-Access Familiar with Facets Strong ANSI/native SQL skills

Business Intelligence

Qlikview11: architecture, design, development SSRS / SSAS 2008R2, 2005 PPS Dashboard

Data Modeling, Data Warehouse Datamart Design

Modeling: conceptual, logical, physical Inmon/Kimball/hybrid approaches: star and snowflake modeling Erwin Data Modeler

General Tools Technologies

MS Project Plan TFS SVN PVCS Control-M Scheduler Dollar Universe Scheduler SQL Agent ASP .NET Visual Basic Unix Scripting JavaScript

EXPERIENCE Significant Projects Only

BI ETLArchitect

Confidential

• Defined overall migration architecture, defined coding standards and best practices, lead development team and worked extensively with business analysts for requirement gathering and map data elements source to target. Performed gap analysis, data profiling, created reporting data model, Laid Reporting layout / Charts / Graphs, Developed ETL packages in SSIS and reporting in Qlikview and scheduled in Dollar Universe, deployed the solution and transitioned. My role as development manager includes leading team of four members onshore and offshore to perform a readiness assessment across technology systems landscape, and maintaining project plan / budget and presented weekly status of the project to the management.

Technologies include SQL Server 2012, 2008 R2 SSIS, Qlikview 11, and Dollar Universe

Offshore Delivery Manager/ETL Architect

Confidential

• Projects aim to build Enterprise Data Warehouse for the organization. This phase of the project should gather the necessary data to define the business requirements of each of the business units for inclusion into the Detailed Data Requirements. Prepare the Detailed Data Requirements to address the core EDW functionality.
• Managed ten member team document detailed data requirements for Enterprise data warehousing. Source mapping for these attributes in various source systems in Installation and Membership, Appeals and Grievances Data, Production Analytics data such as Provider, Claims and Customer services data. Prepared Solution Technical Design Documentation based on specification provided by the Business. Developed Packages and scripts to load test data and doing sanity check of data for loading and reporting needs. Prepared and maintained project plan / budget, status reporting, Metrics Reporting, Defect tracking, Casual Analysis and defect prevention and presented weekly status of the project to the management.

Environments include Informatica 8.0, Oracle 10g

BI ETL Lead

Confidential

• Claimsphere is Healthcare Payer Analytical product developed in cognizant in-house to target the healthcare companies having members less than 1 million. This product developed to place adaptor from source systems and load into ODS and ADS. Analytical Reporting built for serving 50 KPI reports and 100 metrics.
• Lead offshore team of 25 member team. Defined overall migration architecture, defined coding standards and best practices, lead development team and worked extensively with business analysts for requirement gathering and map data elements source to target. Documented detailed data requirements. Prepared Solution Technical Design Documentation based on specification provided by the Business. Project Management Activities include plan / budget tracking, project progress tracking and status reporting, Metrics Reporting, Defect tracking, Casual Analysis and defect prevention

Technology and Environments SSIS, SSAS, SSRS, SQL Server 2008, MDX, Performance Point, SharePoint, VSS, MPP

Senior Data Integration Developer

Confidential

• Hess implemented billing software for their retail customers. This project involves data integration of billing data into various sub systems in the company. Also helped on acquisition of Empire State fuels data into Hess System. As Onsite data Integration developer, worked on creating Mapping documents, data profiling, develop, test and deployed DTS packages.

Technology include SSAS, SSIS, SQL Server 2005, MDX Queries, MPP, VSS