SUMMARY:

• Thirteen years of experience as an Ab Initio ETL developer/ Architect in multi - terabyte Data warehouse Projects. I am currently employee as a Senior Professional Service ETL (Ab Initio) Consultant by Teradata Confidential
• I have solid experience in software development using SDLC methodologies, strong knowledge of relational data bases, dimensional modeling and business analysis. Wide work experience in end-to-end completed data warehouse projects in different industries like health insurance ( Confidential ), credit card companies ( Confidential ), financial institutions ( Confidential, Confidential and Confidential ) and airspace industry ( Confidential ). I have experience with ETL design and architecture using Teradata utilities and Teradata SQL tune up.

TECHNICAL SKILLS:

ETL: ETL Ab Initio, GDE version 3.0.2 Ab Initio EME (Enterprise Metadata) Ab Initio Co>System 2.14.130 (release 2.14 patch level 130)

RDBMS: TERADATA VR12 (SQL Assistant Version 13.10.0.02, Fast Load, Multi Load, Teradata Administrator) ORACLE. Versions: 8, 9, 10g and 11g. ORACLE Software SQL FORMS, PL/SQL, SQL*PLUS, SQL*REPORTWRITER CASE DICTIONARY, SQL LOADER SYBASE DB2 DL/1 HIERARCHICAL DBASE SQL SERVER 2005 VSAM

SCRIPTING: K - SHELL PERL REXX

OPERATING SYSTEMS: UNIX AIX MVS, VM, OS/400, WINDOWS XP, VISTA AND 7, DOS

HARDWARE: SMP AIX SP/2 AIX IBM 43XX IBM 390 AS/400 HP SERVERS SOLARIS (Solaris8 - SPARC-n32)

PROFESSIONAL EXPERIENCE:

Confidential, FL

Professional Services Consultant

Responsibilities:

• As an Ab Initio architect I have been in charge of architect a Proof of Concept (POC) Ab Initio platform which simulates Home Depot applications in one of our ETL test servers to help engineers to set up the use of Teradata tools and Ab Initio Teradata Load utilities using the latest GDE version (3.12+) and Teradata Unity Server.

Confidential

Teradata Ab Initio Professional Services Consultant

Responsibilities:

• I was working on conversion project from IS-MART (oracle) to Teradata C2T environment. I developed high and detail ETL design and architecture.
• Using smart code generators developed in SQL (teradata and Oracle), Ab Initio ETL graphs and k-shell UNIX scripts to automatically generate all code required for the Initial load of Teradata DB. Also implemented automatic data validation scripts to compare demographics between Oracle and Teradata.

Confidential

Teradata Professional Services Consultant

Responsibilities:

• I have been working as a Teradata Data Integration Analyst. I am part of Conversion Team (Oracle to Teradata) of existing Disney Guest Data Warehouse. I have been working on conversion of complex PL/SQL procedures into
• Teradata store procedures and also actively adjust DataStage ETL jobs to use Teradata tools. I have developed a generic comparison system between Oracle and Teradata databases using UNIX k-shell scripting, BTEQ and SQL PLUS utilities. It has been widely used by QA analysts.

Confidential - Wilmington, DE

Teradata Professional Services Consultant

Responsibilities:

• Team member of IDW project focused on a migration from Oracle to Teradata RDMS for JPM Morgan Application Data Store (ADS). I was responsible of TIVOLI scheduler modifications to accommodate both Oracle and Teradata to be executed in parallel while the Oracle system is gradually decommissioned. A combination of composer TIVOLI language
• UNIX k-shell scripting and a set of Ab Initio ETL support utilities were developed to integrate offshore and onshore requirements. These utilities were adopted by Chase to be reused for up-coming projects including the complete decommissioning of Oracle ADS system.

Confidential - Tampa, FL

Senior Consultant ETL (Ab Initio Architect)

Responsibilities:

• Development of ETL processes using Ab Initio (GDE 3.0.2) for the integration of Confidential General ledger Information for all worldwide subsidiaries. The source files are received and processes via People Soft Oracle then load them into Sybase IQ. Daily activities include hands-on development using Ab Initio, Oracle and Sybase IQ and also task and co-ordination of offshore team members (India)

Confidential - Dallas TX

Senior Ab Initio Developer (Enterprise Data Warehouse Project)

Responsibilities:

• Analysis, high and detail level design, software construction, deployment, and production implementation of ETL Ab Initio applications for Data Warehouse. Last project included duties on a new system for Customer and Travel History in Oracle 11g moving data from the enterprise data base supported in NCR Teradata.
• ETL architecture of several projects to ensure Ab Initio best practices. Mentoring and guiding other developers
• Construction of complex Teradata SQL queries for executive Reporting to populate star schema dimensional models to be used by essbase reporting tool.
• Tune up and ETL database base design of staging areas for Teradata to meet aggressive SLA requirements. Some cases we reduced processing overall time from 5 hours to minutes.

Confidential - Fort Lauderdale, FL

Senior Consultant ETL Ab Initio Architect

Responsibilities:

• Analysis, design and architect the ETL process (using Ab Initio) for a corporate Data Redaction effort needed to protect sensitive data (obfuscate) when moving it to non-production environments. This system has been designed dynamically to be used for more than 600 Confidential Corp applications for Latin American region using Confidential
• Corp SDLC. I lead several end-to-end Ab Initio development projects which have been successfully implemented in production.

Confidential - Dallas TX

Senior Ab Initio Consultant (Enterprise Data Warehouse Project)

Responsibilities:

• I was responsible of Analysis, design and construction of ETL applications for the Corporate Southwest Data Warehouse. I actively participate in the optimization of current production Ab Initio applications including performance tune-up, review the overall process, and optimize Ab Initio graphs to meet critical customer SLA’s. Play roll as ETL architecture and Ab Initio developer for
• Executive Reporting Data-marts using dimensional models and star-schema design methodologies. I have lead several end-to-end Ab Initio development projects which have been successfully implemented in production.

Confidential - Chicago, Illinois

ETL Ab Initio Consultant / ETL Data Movement Analyst

Responsibilities:

• As aData Movement Analyst (ETL designer) at Confidential (credit card company) in Richmond, Virginia, I was responsible for High Level Design, Detail Design, Construction and unit testing in two data warehouse projects: recoveries and campaign management.
• The technical set used by this client was: as ETL product Ab Initio (using GDE version 1.13.1 and EME repository) and the target data base Teradata Version V2R5. I was also responsible for development of Data Base connectivity Ab Initio graphs thru Teradata using multi-load and fast-load utilities

Confidential - Chapel Hill, NC

Lead ETL Developer Specialist in Data Warehouse Project

Responsibilities:

• As a lead developer, I prioritized and multi-tasked ETL development issues, tracked project plans, coached, mentored and motivated teammates and assumed a general roll of an ETL architect. We utilized following software products: Ab Initio, Teradata, Oracle, UNIX, k-shell, Reflection, ERWIN, Visio, PVCS version control, VM and CONTROL-M scheduler. In addition, I developed production implementation plans, post-production implementation follow-ups, performed on-call duties and continuously looked for ETL performance improvements for current and future applications. On a daily basis we followed the Software Development Life Cycle methodology.
• Development of BCBS Claims ETL process. Participated in analysis, data modeling, ETL design and ETL development to load legacy system claims into the Warehouse.
• Development of BCBS ETL process. Conversion of mainframe COBOL programs to UNIX/Ab Initio to improve performance and maintainability for members and subscribers.
• Data Mart Development for Clinical Constructs: A combination of Ab Initio and SQL scripting.
• Oracle to Teradata DBMS conversion. Switch the Ab Initio Oracle infrastructure to Teradata including the conversion of several SQL scripts to the new SQL syntax.

Confidential - Research Triangle Park, NC

Programmer/Analyst

Responsibilities:

• I was responsible for the analysis, design, development and support of EDI (Electronic Data Interchange) application. EDI transactions were Order Entry, Order Entry Change, Invoice, Order Status, etc.
• I became very proficient using MVS, JCL, PL/1 and CICS. I also used DB2 relational databases and Utilities such as IDCAMS, ISPF, VM, LOTUS NOTES, etc.

Confidential

Programmer/Analyst

Responsibilities:

• As systems Analyst, responsible for the analysis, project management, system design, programming, documentation, development and administration of system policies and procedures, and troubleshooting.
• As Oracle Developer, involved in the implementation of a third party insurance software, the implementation of health insurance products, and the development of the new claims subsystem for all insurance products
• As mainframe Developer I was responsible of project development (end-to-end) under Computer Systems Application Methodology using PL/1, CICS, COBOL and JCL MVS.

Confidential

Programmer/Analyst

Responsibilities:

• As a mainframe Developer, I was responsible of analysis, Design and code development of the accounting system using mainframe software tools (COBOL, VSAM, and JCL)
• As an AS/400 Developer, I was responsible of analysis and design of the claims system using COBOL/400, DB2, PL, and AS/400 utilities.