SUMMARY:

• Over 6 years of overall IT experience as a ETL/Data warehouse Developer with extensive project lifecycle Experience in Design, Development, Implementation and testing of various sized applications using ETL Tools.
• 6 years of AbInitio experience in ETL, Data Mapping, Transformation and Loading from Source to Target Databases.
• Designed and deployed well - tuned Ab Initio graphs.
• Worked on Autosys, creation of JILS for scheduling.
• Worked as a Software lead and managed the onshore offshore resources.
• Practical experience with various Ab Initio components such as Join, Rollup, Scan, Reformat, Partition by Key, round robin, gather, merge, Dedup sorted etc
• Extensive experience with EME for version control, impact analysis and dependency analysis.
• Experience in Scheduling, Production Support and Troubleshooting for various ETL Jobs.
• Experienced in developing UNIX shell wrapper scripts to run Ab Initio graphs. Practical experience with working on multiple environments like production, development, testing.

TECHNICAL SKILLS:

ETL Tools: Ab Initio (GDE 3.2, Co-Operating System 3.2), EME, Oracle SQL* plus.

Database Tools: Oracle SQL Developer 2010 version 3.1

Tools: Squirrel, Tivoli Workload Scheduler, Altova XML Spy, Putty.

Programming Languages: SQL, UNIX Shell Scripting, SQL*Plus, Oracle SQL, JIL (Autosys).

Operating Systems: Windows 2007, UNIX, LINUX

PROFESSIONAL EXPERIENCE:

Confidential, Chicago

Sr. ETL AbInitio Developer/ Lead

Responsibilities:

• Worked in onshore-offshore model.
• Worked as a lead for the offshore/onshore developers to resolve queries and guide in respective processes.
• Responsible for Design the technical design document and estimates the hours for ETL project.
• Closely work with business users to gather the requirements and also responsible for creating mapping documents.
• Developed Complex Ab Initio XFRs to meet the business requirements.
• Actively participated in ETL code review sessions to get approvals form DEV to QA.
• Interact with Release Management, Configuration Management, Quality Assurance, Database Modeling Support, other Development teams and Operations
• Good experience on EME and migrate AbInitio objects to various environments.
• Developed JIL’s to customize the ETL Ab Initio Graphs at runtime.
• Responsible for debugging QA, prod batch jobs if any abends on weekly basis.
• Experienced in represent as ETL contact person for all cross work stream projects for any files consume/creations.
• Responsible for data requests and pulling the data out of PROD to downstream & source application.
• Communicated directly with clients to gather information for the various development projects.
• Understanding the requirement and implementing the transformations using the Data Mapping and Interface Design document.

Environment: AbInitio (GDE 3.2, Co-Operating System 3.2), EME, DB2, SQL 3.1, LINUX, Windows 7.

Confidential, Northbrook

Sr. ETL/Ab Initio Developer

Responsibilities:

• Implemented various ETL projects in Confidential .
• Worked in onshore-offshore model.
• Responsible for Design the technical design document and estimates the hours for ETL projects
• Closely work with business users to gather the requirements and also responsible for creating mapping documents.
• Developed Complex Ab Initio XFRs to meet the business requirements.
• Actively participated in ETL code review sessions to get approvals form DEV to QA.
• Interact with Release Management, Configuration Management, Quality Assurance, Database Modeling Support, other Development teams and Operations
• Good experience on EME and migrate Abinitio objects to various environments.
• Developed shell scripts to customize the ETL Ab Initio Graphs at runtime.
• Responsible for debugging QA, prod batch jobs if any abends on weekly basis.
• Involved in modifying the Ab-initio generic graph and wrapper scripts for unloading data from source systems.
• Experienced in represent as Confidential ETL contact person for all cross work stream projects for any files consume/creations.
• Responsible for data requests and pulling the data out of PROD to downstream & source application.
• Communicated directly with clients to gather information for the various development projects.
• Understanding the requirement and implementing the transformations using the Data Mapping and Interface Design document.

Environment: Abinitio (GDE 3.0.3.1, 3.15, Co-Operating System 3.15), EME, UNIX shell Scripting, DB2, SQL 2008, UNIX, Windows 7.

Confidential

Sr. ETL/Ab Initio Developer

Responsibilities:

• Involved in Data transfer design and development for legacy data to a newly defined data model for the data warehouse.
• Involved in meetings to gather requirements from the Business Users.
• Used Ab Initio data cleansing functions like is valid, is defined, is error, is defined, string substring, string concat and other String, Date, Inquiry and Miscellaneous functions
• Developed Complex AbInitio XFRs to solves rigorous and meet the business requirements.
• Developed shell scripts to customize the ETL Ab Initio Graphs at runtime.
• Automated the Data Loads using UNIX shell scripting for Production, Testing and development environment.
• Involved in modifying the Ab-initio generic graph and wrapper scripts for unloading data from source systems.
• Implemented Data Parallelism through graphs, which deals with data, divided into segments and operates on each segment simultaneously through the Ab Initio partition components to segment data.
• Extensively used ETL to load data using Ab Initio DB components from heterogeneous source systems from DB2, Oracle etc to target DW oracle Database.
• Involved in scheduling the jobs in Tivoli Workload Scheduler.

Environment: Abinitio (GDE 3.1.0, Co-Operating System 3.1.0), EME, UNIX shell Scripting, UNIX and Windows 7.

Confidential

Sr. ETL/Abinitio Developer

Responsibilities:

• Developed several partition based Abinitio Graphs for high volume data warehouse.
• Involved in all phases of the System Development Life Cycle Analysis, amp; Data Modeling.
• Extensively used Enterprise Meta Environment (EME) for version control.
• Extensive exposure to Generic graphs for data cleansing, data validation and data transformation.
• Created Sandbox and edited Sandbox parameters according to repository Extensive exposure to EME.
• Used AIR commands to do dependency analysis for all ABI objects
• Involved in Ab Initio Design, Configuration experience in Ab Initio ETL, Data Mapping, Transformation and Loading in complex and high-volume environment and data processing at Terabytes level.
• Extensively used Partition components and developed graphs using Write Multi-Files, Read Multi-Files, Filter by Expression, Run Program, Join, Sort, Re format.
• Followed the best design principles, efficiency guidelines and naming standards in designing the graphs
• Developed shell scripts for Archiving, Data Loading procedures and Validation
• Involved in writing Unit Test scripts, support documents and implementation plan.
• Tuned the graphs by creating Lookup files, Memory sort and Max-core parameters for maximum usage of cache memory and enhanced performance.
• Responsible for cleansing the data from source systems using Ab Initio components such as reformat and filter by expression.
• Used the sub graphs to increase the clarity of graph and to impose reusable business restrictions.
• Capacity of designing solutions around Abinitio, with advanced skills in high performance and parallelism in Abinitio.

Environment: Abinitio (GDE 3.0.3.1, Co-Operating System 3.0.3.1), UNIX shell Scripting, Windows 7, DB2, UNIX.

Confidential

Sr. ETL/Ab Initio Developer

Responsibilities:

• Interacting with business partners to gather requirements
• Converting the business requirements into list pull specifications.
• Wrote precise, reusable ETL specifications and patterns to facilitate development of best practices and internal competencies.
• Used Ab Initio as ETL tool to pull data from source systems, cleanse, transform, and load data into databases.
• Developed various AbInitio Graphs for data cleansing using functions like is valid, is defined, is error, string substring, string concat and other string * functions.
• Designed parameterized generic graphs to pass the values from Wrapper script.
• Based on business requirements, developed number of Abinitio Graphs using various Components such as Partition by Key, Partition by round robin, reformat, rollup, join, scan, gather,, merge etc.
• Worked on improving the performance of Ab Initio graphs by using various performance techniques like using lookups (instead of joins), In-Memory Joins to speed up various Abinitio Graphs.
• Preparing Technical Design and Test Plans.
• Created various Unit Test Plans and System Test Plans and involved in testing.
• Worked on scheduling of the Abinitio jobs checking the frequency and the run executions timings.

Environment: Ab Initio (GDE3.1.0), SQL Server 2000, AIX UNIX, Shell Scripts, PL/SQL, Windows 7

Confidential

ETL/Abinitio Developer

Responsibilities:

• Developed Abinitio Graphs for retrieval of the data from upstream and loading the same to table.
• Involved in all phases of the System Development Life Cycle Analysis, amp; Data Modeling.
• Extensively used Enterprise Meta Environment (EME) for version control.
• Extensive exposure to Generic graphs for data cleansing, data validation and data transformation.
• Created Sandbox and edited Sandbox parameters according to repository Extensive exposure to EME.
• Used AIR commands to do dependency analysis for all ABI objects
• Involved in Ab Initio Design, Configuration experience in Ab Initio ETL, Data Mapping, Transformation and Loading in complex and high-volume environment and data processing at Terabytes level.
• Extensively used Partition components and developed graphs using Write Multi-Files, Read Multi-Files, Filter by Expression, Run Program, Join, Sort, Re format.
• Followed the best design principles, efficiency guidelines and naming standards in designing the graphs
• Developed shell scripts for Archiving, Data Loading procedures and Validation
• Involved in writing Unit Test scripts, support documents and implementation plan.
• Tuned the graphs by creating Lookup files, Memory sort and Max-core parameters for maximum usage of cache memory and enhanced performance.
• Responsible for cleansing the data from source systems using Ab Initio components such as reformat and filter by expression.
• Used the sub graphs to increase the clarity of graph and to impose reusable business restrictions.
• To coordinate with Backup team to restore the older files from tape to figure out data anomalies in Production.

Environment: Ab Initio (GDE3.1.0), SQL Server 2000,UNIX, Shell Scripts, PL/SQL, Windows 7