SUMMARY:

• Over 20 years of experience in Data Warehousing primarily focusing on ETL development with SQL Server, Oracle, Informatica Power Center, IICS, SSIS, Business Intelligence.
• Strong understanding of various business functional areas in industries including Healthcare, Financial and Insurance.
• Strengths include broad based technical knowledge, high level of motivation, strong analytical and teamwork skills.

TECHNICAL SKILLS:

RDBMS & Tools: SQL Server 2012, Oracle, Snowflake Data Cloud, SQL Loader Export/Import

ETL Tools: Informatica PowerCenter 10.1, IICS, SQL Server Integration Services, Magnitude/Kalido

Languages: T - SQL, PL SQL, Stored Procedures, PowerShell/Batch scripting

DB Query Tools: SSMS, Visual Studio, Toad, SQL Server Query Analyzer, SQL Profiler

PROFESSIONAL EXPERIENCE:

Confidential, Philadelphia, PA

ETL/DW Developer

Responsibilities:

• Developed IICS ETL with RestAPI and WebService transformation.
• Developed Jason Swagger files to define web service request.
• Developed and designed data store database to stage the information from vendor.
• Developed denormalized SQL views on top of data store and SSIS packages to read/populate data warehouse.
• Developed SQL views and SSIS to integrate information into enterprise web product.

Technologies: Informatica IICS, SSIS, SSRS, Microsoft SQL Server 2012

Confidential

Senior ETL/DW Developer

Responsibilities:

• Developed complex SQL views to be used as the source extract objects for the ETL processes.
• Worked on analysis and resolution of query performance issues in views which read information from highly normalized source system. The views performed adequately after staging the information and implementing some indexing strategy and optimizing joins.
• Developed Informatica mappings to consume information from the views and persist in the staging layer and process downstream for processing and producing data feed.
• Worked closely with various teams and business units both on and off shore on multiple projects in a very high paced environment.

Technologies: Informatica 10.1, Microsoft SQL Server 2012

Confidential

Senior ETL/DW Consultant NJ

Responsibilities:

• Developed PowerShell scripts to accomplish file management from SFTP to Azure/SharePoint.
• Developed complex SQL ETL and Talend orchestration.
• Developed complex SQL Stored Procedures to process raw eligibility information and implement Change Data Capture and Slowly Changing Dimensions Type 2.
• Designed an ETL strategy for identifying Change Data Capture utilizing complex business rules and heavy usage of PIVOT/UNPIVOT functionality. Recommended this implementation over CURSOR for significant performance gains.
• Produced Member Eligibility extracts from Central Data Repository for import into 3rd party BI tool for BI analysis.
• Developed views in Snowflake Data Cloud for ingestion into Data Warehouse.

Technologies: T-SQL ETL, Azure Storage Server, Snowflake Data Cloud, PowerShell, Microsoft SQL Server 2012

Confidential

Senior ETL/Data Warehouse (DW) Consultant

Responsibilities:

• Developed SSIS packages to land source information into the Staging area of the DW.
• Developed numerous views to gather information from the Landing database that would be consumed by Unified Load Controllers (ULC) in Kalido, the views are essentially ETL components of various complexity in logic and attribute transformations.
• Proposed and implemented numerous performance improvement strategies i.e. revisit table indexes, disable/enable indexes before and after ETL load, pre-process data sets in temporary tables used in joins and apply indexes to gain performance advantage.
• Mapped multiple ETL sets and coordinated all team development into sharable, non-redundant mappings.
• Worked with Data Modeler and DBAs to build the data model and table structures.
• Developed complex batch scripts that would control the execution flow of the ETL processes.
• Developed complex SQL scripts to build Data Marts.

Technologies: Magnitude Kalido/T-SQL ETL, Microsoft SQL Server 2012

Confidential

Senior ETL/Data Warehouse (DW) Developer

Responsibilities:

• Developed SSIS packages to stage source information into the Landing Zone of the DW
• Compiled source to target mapping documents to design the ETL jobs.
• Developed complex batch scripts that would control the execution flow of the ETL processes.
• Developed complex SQL scripts to build Data Marts
• Worked on setting up Informatica environment
• Developed numerous Informatica mappings

Technologies: Magnitude Kalido, Informatica 10.1, Microsoft SQL Server 2012, Oracle

Confidential

Senior ETL Developer

Responsibilities:

• Data was extracted from flat files, Excel spreadsheets and relational databases and transformed according to the target database specification using Informatica 9.1
• Analyzed business requirements and worked closely with various application teams and business teams to develop ETL procedures that are consistent across all applications and system.
• Designed and developed ETL mappings using transformation logic to extract data from various source systems.
• Identified and implemented slowly changing dimensions methodology to access full history of claims and transaction information.
• Developed SQL scripts, views and stored procedures to enhance ETL processes.
• Worked with DBA team to analyze queries submitted either ad hoc or from Informatica and reports, and create indexes on fact tables.
• Implemented procedures to disable and enable indexes between loads to enhance ETL performance.
• Responsible for performance tuning and optimization of Informatica mappings and sessions to ensure the system performed adequately against dimensionally modeled database.
• Performed data reconciliation between source systems and Data Mart to validate the ETL loads and ensure data quality.
• Production support and troubleshooting of daily/monthly ETL loads.

Technologies: Informatica 9.1, Microsoft SQL Server 2008/2012