PROFESSIONAL SUMMARY:

• 7 years of extensive experience in IT industry in Data warehousing stream, which includes Designing, Development, Implementation, migration and testing of large data warehouse projects in Ab initio ETL tool.
• Strong experience in defining ETL design and integrating data from disparate source systems and disparate data formats including Requirements gathering, Source system analysis, Data Mapping, Data Quality, ETL-QA and Performance Tuning using Ab initio Co-operation systems 1.15 2.13, 2.14, 2.15,3.0.
• Strong development skills include ability to work through the entire development life SDLC cycle from gathering requirements through implementation, development, support and documentation of the complete project.
• Close to 6 years of strong functional exposure in US and Canadian Banking Financial Markets.
• Strong work experience in using ETL methodologies for supporting data extraction from multiple source systems, transformations and loading processing using Ab Initio.
• Experience in several UNIX commands and UNIX Shell Scripts including Korn Shell Scripts.
• Strong knowledge of DB2 SQL queries and methodologies.
• Deep knowledge of all Data Warehousing and Dimensional modeling concepts.
• Expertise with most of the Ab initio components like Database, Datasets, Partition, De-partition, Sort and Transform components.
• Worked on CONDUCT>IT which includes plan to merge all the processes like Ab initio graphs and scripts for production deployment.
• Expertise with development of fact table code which includes aggregated fact table jobs and components like rollup and scan.
• Experienced in designing scalable architectures addressing parallelism, data integration, ETL, data repositories and analytics, making use of Ab initio suite.
• Experience in all the Ab initio parallelism techniques and implemented Ab initio Graphs using Data parallelism and MFS techniques.
• Extensive experience in using Ab initio EME data store/sandbox for version control, code promotion, and impact analysis.
• Involved in creation of jobs in Mainframe CA7 scheduler and testing the jobs in QA environment in an orderly way.
• Strong experience in migration of various projects from Ab initio version 1.15 and version 2.15 to Ab initio version 3.0.
• Experienced in working with testing team and developed Unit test plan, test cases for component, data, stress test, regression test etc.
• Good experience in working with different kind of source data such as flat files and XML files.
• Ability to quickly grasp new concepts and apply software methodologies as per business needs.
• Excellent interpersonal skills and professional communication skills and have worked extensively in a team oriented environment with a strong desire to achieve specified goals.

TECHNICAL SKILLS:

PROFESSIONAL SUMMARY:

Confidential

Role: Ab initio Developer

Responsibilities:

• Worked as senior Ab initio developer.
• Created Technical Design document, Source to Target mapping documents based on the client business requirement based on frequent interactions with the client.
• Defined foundational areas such as policies and procedures, standards, testing framework and an operational model applicable to any required to Ab initio implementation project.
• Created ETL best practices and Developers guide.
• Implement best practices in the Ab initio code and followed all the document standards provided by the client.
• Created reusable Sub graphs and functions to use in multiple mappings.
• Involved in physical/logic data model reviews.
• Implemented CDC type 1 and type 2 using Ab initio graphs.
• Created several graphs for aggregated fact tables by using components such as rollup and scan.
• Handled the performance tuning of Ab initio Graphs.
• Involved in migration of several Ab initio projects from Ab initio version 1.15 and 2.15 to version 3.0.
• Involved in creation of parameter sets to fit in the graphs from old version of Ab initio to newer version of Ab initio.
• Responsible for code migration, Code review, test plans, test scenarios, test cases as part of Unit/Integrations testing.
• Experience in supporting integration testing and regression testing.
• Automated the Production jobs using Ab initio graphs, CA7 scheduler and UNIX.
• Experience in leading the team and also provided training on Ab initio to new members in the team.
• Strictly adhered to the strict timelines of all the deliverables.

Environment: Ab initio GDE 1.15, 2.15, 3.0, DB2, UNIX Shell Scripting, CA7 scheduler

Confidential

Role: Ab initio Developer

Responsibilities:

• Developed and supported the extraction, transformation and load process ETL for the Data Warehouse from heterogeneous source systems using Ab Initio.
• Created Technical Design document, Source to Target mapping documents based on the client business requirement based on frequent interactions with the client.
• Developed and tested some major source entities which involved XML data as well.
• Used UNIX environment variables in all the Ab initio Graphs, which comprises of specified locations of the files to be used as source and target.
• Extensively used Ab initio components like Reformat, Redefine Format, Rollup, Scan, Input Table, Output Table, Partition By Expression, Partition by Key and Sort, Merge, Concatenate, Gather, Dedup, Replicate, Join.
• Implemented the Parallel application by replicating the components and processing modules into number of partitions
• Involved in major testing process by creating test plans and source data which helped in extensive testing of all the sources.
• Extensive experience using EME data store to check in and checkout the graphs which helped in version control.
• Produced the required documents like Migration Documents, Design Documents.
• Involved in Ab-Initio Graph Design and Performance tuning to Load graph process

Environment: Ab-Initio GDE 1.15 , DB2, SQL, UNIX shell scripting

Confidential

Role: Ab initio Developer

Responsibilities:

• Implemented Ab initio configuration and set up well-tuned environments for Production, Development and Testing.
• Constructed an ETL system using the Ab initio tool providing a fast development in a unified environment that will allow for easy maintenance of the system for the future.
• Majorly involved in creation of source to target data mappings based on the client system requirements.
• Part of an important team called as continuous development team which handled all the developments, enhancement and migration of Ab initio code.
• Created checkpoints, phases to avoid dead locks and tested the graphs with some sample data then committed the graphs and related files into Repository from sandbox environment.
• Created generic code to load data from several source systems to data staging area which included source files in Excel, XML and flat files format.
• Involved in creating the Generic graph for pulling the Data from the mainframe data files using the FTP component.
• Modified the Ab initio components parameters, utilize data parallelism and thereby improve the overall performance to fine-tune the execution times.
• Responsible for creating the MFS Multi-file, which gives the user the ability to centrally control the distributed data files and they provide the scalability and the kinds of access patterns that parallel applications require.
• Used Ab initio Components like Partition by Key, Partition by round robin, reformat, rollup, join, scan, normalize, gather, replicate, merge etc.
• Implemented different types of CDC type 1 and type 2 using Ab initio code.
• Implemented the concept of PLANS to create complete production systems consisting of Ab initio graphs and scripts to run ETL processes for each source system.
• Responsible for analyzing the source data and reporting data quality levels using Ab-Initio as an OLAP tool.
• Extensively worked with UNIX environment and created lots of UNIX process through the shell scripts and worked closely with UNIX administrator for any performance tuning.
• Performed development and test extraction, transformed and loaded ETL processes packaged as part of a large data warehouse application using Ab Initio, SQL and Unix Scripts.
• Utilized the EME for version control, and tracking of changes made to new and old graphs.
• Responsible for interpreting the transformation rules for all target data objects and develop the software components to support the transformation. Coded and tested complex Ab initio ETL routines.
• Worked on parallel processing methodologies, scalable architecture, appropriate use of Multi-File Systems, Ab initio environment administration and performance efficiency techniques.
• Used Check in/Check out for the EME version control system.

Environment: Ab initio GDE 1.15, UNIX, DB2 SQL

Confidential

Role: Data stage developer

Responsibilities:

• Participated in all the phases of the project including requirements gathering from the client and creating data mappings for the source systems.
• Created several Data stage jobs to perform ETL operations on all types of source systems.
• Created several jobs to which also performed data quality checks on all the data as well.
• Created several UNIX scripts to run all the Data stage jobs at the back end in the production environment.
• Handled XML data from the source systems.
• Created some major wrapper scripts for the Data stage jobs for purging and archival of the files.
• Closely worked with Sr. DBA and Sr. Developers to fasten certain daily jobs.
• Worked with Quality assurance to develop test plans and test cases to conduct system testing.
• Prepared user manual and technical support manual.

Environment: Data Stage and Quality stage V8.0.1, Unix, DB2 SQL.