SUMMARY:

Lead ETL Developer with over 8.5 years of experience in Application Software, Maintenance, Testing, Optimization, Re - Engineering and Process Improvement projects, using Ab initio Experience with data mapping, transformation and loading data into data warehouse and data marts in complex, high volume environments. Clear and thorough understanding of business processes and workflows, having worked in waterfall methodology. Good knowledge of UNIX shell scripting.

TECHNICAL SKILLS:

ETL Tools: Ab-Initio V2.15, Ab Initio V 3.0.x, Ab initio 3.1.x

Data Base: Oracle, Microsoft SQL Server, IBM Netezza, IBM DB2, Teradata v14

Operating System: UNIX, AIX, DOS, Windows 7, Windows XP

Languages: SQL, PL/SQL, Unix shell scripting

Scheduling Tools: Tivoli workload scheduler, AutoSys and Control-M

Version Control Tool: EME, CA7 Harvest

Domain Knowledge: Banking, Insurance and Logistics

Defect Tracking Tool: HP-Mercury Quality Center

Application Tools: MS Word, MS Excel, WinScp, Notepad ++, EditPlus, TextPad

Data Modeling: Star Schema and Snowflake schema, Erwin tool.

PROFESSIONAL EXPERIENCE:

Confidential

Senior Analyst

• Extensively used Ab initio for creating graph and pset to load data into Teradata tables having flat files as source.
• Worked on different datawarehousing modeling techniques i.e. Star and Snowflake schema. Also, Worked on slowly changing dimension(SCD) tables and hierarchies in dimensions, while working on creating Logical Data Models (LDM) and converting into Physical Data Models (PDM).
• Worked on multi-file (MFS) and parallel file systems on Ab Initio. Well versed with Parallelism concepts.
• Co-ordinate with the team effectively to identify and resolve any issues ahead of time.
• Worked closely with business shareholders to understand the requirements.
• Created ETL technical design documents from the business requirements specifications.
• Developed, executed and documented various unit test cases to test the developed code to handle various data scenarios and assure the end to end data flow.

Environment: Ab Initio GDE 3.1.2.2 (Batch),c o-op 3.1.2.2, Teradata V14, Oracle 11g Enterprise Edition(64 bit), DB2, Netezza, Windows 7 Professional, Control-M, Agile Methodology and HP Quality center.

Confidential

Lead ETL Developer

• Created Ab Initio graphs and psets to load data from ASCII, EBCDIC, and flat files, Netezza, and DB2 to DB2. Reviewed and audited tables before the data were loaded to production database. Created UNIX and SQL scripts to automate loading data into database
• Worked on high-level detailed design documents.
• Worked on dependency analysis of production job to bring down the run time of job streams and reach SLA’s before time.
• Provided support for all the incidents, data integrity issues and any defect arising during the stabilization period of a particular interface. Performed all code Check-in and Checkout operations with EME and CA Harvest.
• Created wrapper scripts and job schedule for sequential execution during production deployment.
• Responsible for fixing defects and develop enhancements to multiple mission critical applications while ensuring that the end users have access to the latest data for reporting needs.
• Worked on multi-file (MFS) and parallel file systems on Ab Initio. Well versed with Parallelism concepts.
• Understood the business requirements and analyzed the source systems.
• Worked on a proof of concept, which primarily focused on Conduct>IT, ACE and BRE.
• Co-ordinated with the team effectively to identify and resolve any issues ahead of time. Advised technical and business issues to management and other technical teams.
• Updated status charts, provided daily status to customer management team.

Environment: Ab Initio GDE 3.1.2.2 (Batch),c o-op 3.1.2.2, AIX, Oracle 11g Enterprise Edition(64 bit), DB2, Netezza, Windows 7 Professional, Control-M, Agile Methodology and HP Quality center.

Confidential

ETL Developer

• Developed and supported extraction, transformation and load process (ETL) for Data Warehouse from heterogeneous source systems using Ab Initio. Further, scheduled Ab Initio scripts using Autosys scheduler.
• Created multiple XFR’s and DML’s files for various transformations and specifying the record format.
• Used PSET’s extensively. Sub graphs were used to increase the clarity of graph and to impose reusable business restrictions.
• Defined business rules and transformations for data coming from source systems into the data warehouse.
• Modified Ab Initio component parameters, utilized data parallelism and improved the overall performance to fine-tune the execution times.
• Utilized phases, checkpoints to avoid deadlocks and multi-files in graphs.
• Provided application requirements gathering, designing, development, technical documentation, and debugging. Assisted team members in defining, cleansing, aggregating the data and transformation need by the business.
• Developed business objects in accordance to clients' needs and requirements
• Interacted effectively with other members of the Business Engineering, and Quality Assurance team.

Environment: Mainframe, Ab Initio 2.14.22/3.01 GDE, EME 2.13.1,SQL SERVER 2005, UNIX and Windows XP, Tivoli.

Confidential

ETL Developer

• Responsible for application design, development and project maintenance of applications that are critical to the enterprise.
• Worked on data extraction, data cleansing and data validation.
• Created Ab Initio graphs that transfer data from sources like Oracle, flat files and CSV files to Oracle database and flat files..
• Constructed and utilized test plans to create and modify Ab initio graphs databases along with UNIX.
• Coordinated and analyzed upcoming requirements by creating document client requirements, business needs and project objectives.
• Pulled data from production based on certain criteria and loading in either development or UAT region.
• Manipulated data to create mockup file and loading into the database using ETL jobs.

Environment:, Ab-Initio 2.14.22 GDE with co-op 2.13.1, EME 2.13.1,SQL SERVER 2005, UNIX and Windows XP, Tivoli.

Confidential

ETL Developer

• Analyzed all the functional and technical requirements to better serve the project
• Implemented different types of parallelism through ab initio graphs.
• Developed number of graphs based on business requirements using various Ab Initio components like filter by expression, partition by expression, partition by round robin, reformat, rollup, join, scan, normalize, gather, replicate, merge, etc.
• Involved in Ab Initio design, Data Mapping, Transformation and Loading in complex and high-volume environment and data processing at Terabytes level.
• Involved in automating the ETL process through scheduling using Autosys

Environment: Mainframe, Ab Initio 2.14.22 GDE with co-op 2.13.1, EME 2.13.1,SQL SERVER 2005, UNIX & Windows XP.