SUMMARY:

• Functioned as a Data Warehouse lead in designing, developing, and documenting successful ETL solutions in large - volume data migration/integration projects using Informatica, Data Stage, PL/SQL, DB2, Oracle, XML, Sybase, and PeopleSoft.
• 17 years of experience in all stages of data warehouse/mart development life cycle.
• Knowledgeable in broad range of technologies and methodologies, including Big Data/Hadoop, Java, XML, UML, EJB, MicroStrategy, Agile, and Design Patterns.
• Solid track record of delivering successful integration solutions in Fortune 500 companies.

TECHNICAL SKILLS:

Apps/Tools: Informatica, DataStage, SSIS, XMLSpy, ETI*EXTRACT, Autosys, ClearCase, ClearQuest, MicroStrategy, Rational Rose, Visio, Erwin, Analysis Services, JNI, RMI, JMS, Microsoft Office

Database Systems: DB2, Oracle, SQL Server, Sybase, Informix, Teradata, Access, ADO, RDO, ODBC, JDBC

Platforms/OS: Windows, AIX, UNIX, Linux, Solaris, MVS

Languages: PL/SQL, Xquery, SQL/XML, Unix Shell, Java/Swing, sAS, ASP, JavaScript, JSP, Servlet, Visual Basic, HTML, ColdFusion, EJB, XML, XSD, XSL, UML, C/C++, COBOL, PERL, Assembly, Pascal, Lisp, Lex, Yacc

PROFESSIONAL EXPERIENCE:

Confidential

ETL/DBA Lead

• ETL Lead for implementing Enterprise Data Warehouse project using Data Vault methodology.
• ETL Lead for DataStage to SSIS conversion projects.
• Developed ETL solution for PAIRS project. Utilized QualityStage framework for identity resolution based on multiple input variables.
• Created ETL pipeline prototype for merging 2 data sources in Hadoop Big Data ecosystem using Hortonworks Sandbox.

Confidential

ETL Tech Lead

• ETL Lead in DataStage daily process multi-batch update project.
• ETL Lead for Investigate Case Depository Sybase to Oracle data conversion project.

Confidential

Associate

• Lead DataStage ETL developer in Corporate Finance Data warehouse and Data mart.
• Lead in Corporate CODA system ETL streamline and upgrade project.
• Lead designer in daily ETL feed to RMS downstream system redesign.

Confidential

Development Senior

• Lead Informatica ETL designer in Multi-Family Reporting Oracle dimensional data mart sourcing from XML hierarchical data stored in db2 database.
• Lead Informatica ETL developer for large-volume type-2 Oracle dimensional data mart sourcing from heterogeneous historical relational tables and flat files in Single Family Credit Data Mart Project.
• Lead Informatica ETL developer for Agile pilot project for Mortgage Fraud reporting data mart in db2.
• Utilized Informatica partition/parallel load strategy and push-down optimization to improve performance of workflows that process large volume of data.
• Tuned multi-pass/complex SQL against large table through SQL statement rewrite and table partition/index redesign.
• Designed and developed Informatica mappings and utilities to facilitate different types of historical data correction in type-2 dimensional tables.
• Designed and implemented DataStage ETL to load large type-1 dimensional db2 tables in Single Family Profitability project.
• Developed custom DataStage Parallel Extender plug-in to integrate with external Java Tax Calculation Engine.
• Assisted in architecting solutions for Tax Automation project using DB2, Java, C++, Shell, Perl, and DataStage.

Confidential

Senior consultant

• Designed and developed DataStage Parallel Extender jobs for loading large scale data mart fact tables and dimension tables in DB2 database sourcing from mainframe and relational inputs.
• Developed custom DataStage plug-in in C++ to streamline data error/exception handling.
• Designed source table partition strategy for in-parallel data conversion process in DataStage Server jobs.

Confidential

Senior consultant

• Designed and developed ETI*EXTRACT data conversion programs to migrate mainframe data to PeopleSoft HR data structures in data warehouse staging area for Oracle and Teradata database.
• Developed comprehensive ETL program testing plan and data validation process.
• Developed Visual Basic utility to generate Access-to-Oracle batch loading scripts.
• Developed customized C module in ETL process for fuzzy join on personnel names across tables from different data sources.

Confidential

• Functioned as lead Java architect and developer for Confidential - Confidential Fleet project
• Functioned as Java developer for Confidential - Confidential of Canada project.
• Designed and implemented client and server components including persistent shopping cart object, singleton logging module in n-tier B2B and B2C web sites using Java, ASP, HTML, JavaScript, IIS, COM, and SQL Server.
• Integrated third-party server and remote components for fax/email confirmation, credit rate check, and XML order processing.

Confidential

• Designed data acquisition solutions using ETI *EXTRACT tool suite to migrate mainframe legacy data to Sybase database.
• Customized extensively in C and COBOL Sybase EXTRACT DSL’s to improve performance of data conversion and integration solution automation.
• Interviewed users, advised on integration solutions, documented requirements, created design and technical specifications, and established test plans.