Senior ETL/Data Warehousing Consultant Resume

SUMMARY:

Over 19 years of large scale Data Integration and Data Warehouse design and deployment experience
Strong analytical and problem solving skills
Solid application - database design and development expertise
Excellent mentoring and knowledge transferring experience
Well versed in various Data Warehousing methodologies
Solid application programming skills especially in the area of data processing
Good communication skills especially working with business analysts
Very experienced in working and coordinating in an on-shore off-shore development environment

TECHNICAL SKILLS:

Languages: C/C++, JAVA, SQL, Pro*C, PL/SQL, Unix Shell Scripting, Visual Basic, HTML, Assembly, COBOL, JCL, ABAP/4

Operating Systems: Unix (Solaris/SunOS, AIX, Linux), Windows, Mainframe, Tandem Non-Stop Kernel

Databases: Oracle, DB2/UDB, MS SQL-Server, Teradata, MS Access, Tandem Non-Stop SQL, ODBC/JDBC

Messaging system: IBM MQSeries

Applications: SAP R3 SD Module

Tools: Informatica, ERwin, Brio, ETI*EXTRACT, MicroStrategy, Tandem DataLoader, SAS, Syncsort, Control-M

WORK EXPERIENCE:

Senior ETL/Data Warehousing Consultant

Confidential

Responsibilities:

Data Quality. Developed a DQ project to validate, monitor, and record DQ exceptions for multiple types of source feeds
Informatica/ETL environment upgrade from 9.5 to 9.6
On boarding a new source system for the Operational Risk Control Data Warehouse
Completely re-written the process to the Operational Risk Control Data Warehouse from a feed file based source system to an OLTP source system

Senior ETL/Data Warehousing Consultant

Confidential

Responsibilities:

The environments include: DB2/MVS, VSAM, Oracle, Sybase, and Informix. The ETL tool used: Informatica PowerCenter/PowerExchange. a large scale ODS (Operational Data Store) project with sources from vendor provided flat files and xml files, as well as in house sources from distributed systems and mainframe. This is a operational critical project providing a centralized Risk Management platform for certain institutional clients.
FILI BI, a Data Warehouse project for the company’s insurance division.
This is a large scale Business Intelligence project with complicated business rules.
This is an infrastructure project that provides a centralized Informatica service within the Company.
Taking the role of a lead developer for the project; 2. ETL tool vender evaluation and selection; 3. Proof of concept for business users for them to understand how Informatica works and its strength and limitation;
Initial development environment set up; 5.Creating the core reusable mapplets that encapsulate critical and complex business rules; 6. Mentor other developers.

Independent Consultant

Confidential, Weston, Massachusetts

Responsibilities:

This is a ODS (Operational Data Store) project with sources from SQL Server and Mainframe flat files and target on DB2/UDB. The ETL tool is Informatica PowerCenter 6.2
Taking the role of a lead technical consultant in the ETL team; 2. Working on the full life cycle of the ETL part of the project including: business rule gathering, ETL process design, Informatica mappings/Stored procedures development, ETL process testing and implementation;
Mentoring four Informatica developers to help them developing, testing, and debugging of Informatica mappings.

Confidential

Senior Data Warehouse Developer

Responsibilities:

Taking the leading responsibility of design, construction and testing for a Home Owner Insurance Data Warehouse.
The sources are MVS flat files and DB2 tables.
The Data Warehouse is built on DB2/UDB on an AIX box and the ETL tool is Informatica PowerCenter 6.1 and PowerConnect to Mainframe 4.2
Mentoring 4 Informatica developers