EXECUTIVE SUMMARY:

• 13 + years of experience on Ab Initio ETL, Data Mapping, Transformation and Loading in complex and high - volume of data processing applications.
• Usage of EME for Version control, Impact analysis, Dependency analysis for common projects, package migrations to higher environments.
• Extensive experience in the implementation of large-scale applications with leading technologies in Data warehousing.
• Well versed with various Ab Initio Parallelism techniques and implemented Ab Initio Graphs using Data Parallelism and Multi File System (MFS) techniques.
• Proficient knowledge in Oracle, DB2, UNIX and shell scripting.
• Excellent communication skills, problem solving skills and an attitude to learn the new cutting-edge technologies.
• Demonstrated ability to complete multiple assignments simultaneously and maintain high standards of client organizations.
• In Depth Knowledge of Requirements gathering, Analysis, Development, QA Testing, Enhancement, Implementation, Warranty Support and Production Support Activities of various ETL-based applications.

CORE SKILL:

Ab - Initio 3.2.*, Query IT, Express IT, Conduct IT, Acquire IT,SQL, Oracle, DB2, EME, PVCS, Autosys, Control -M,ESP, Control Center Toad, Putty and UNIX Shell Scripting.

TECHNICAL SKILLS:

ETL Tools: Ab-Initio 3.2.*, Query IT, Express IT, Conduct IT.

Database: SQL, Oracle and DB2.

Version Control: EME, PVCS.

Scheduling Tools: Autosys, Control -M, ESP, Control Centre.

Other Utilities: Toad, Putty.

Scripting: UNIX Shell Scripting.

PROFESSIONAL HIGHLIGHTS:

Confidential

Managing Consultant

Responsibilities:

• Requirement gathering from the client for specific service
• Development of ETL code to pull the data from different source (oracle,db2)
• Developed the graph for webservice to pull the data for different sources (eDD, CI and CPP)
• Developed the graph to pull the data from mainframe server to ETL server.
• Created the job in Control Centre to make the process run smoothly
• Worked with SME’s to analyse the Cobol code and convert it into ETL process.
• Review the code and graphs and delivered it to client on time.
• Carrying out Unit Testing for code with test data
• Extensively used Ab Initio for ETL processing
• Providing immediate solutions to client/end user for run-time errors based on the severity of the issues
• Preparing list of Deliverable during code delivery
• Handling all aspects of customer reported issues and their causes

Environment: Ab Initio, Express IT, Unix, Oracle and Control Center

Confidential

Managing Consultant

Responsibilities:

• Requirement gathering from the client for collect Module
• Created the Configuration and Feed to onboard different sources (Oracle, Flat File, JMS data) using Acquire IT tool
• Comparison of end to end legacy Output with Ab Initio Output and provide the explainable differences to the SME’s.
• Created the job in Control Centre to make the process run smoothly
• Worked with SME’s to understand the different sources and converted them into ETL process.
• Review the code and graphs and delivered it to client on time.
• Carrying out Unit Testing for code with test data
• Providing immediate solutions to client/end user for run-time errors based on the severity of the issues
• Preparing list of Deliverable during code delivery
• Handling all aspects of customer reported issues and their causes

Environment: Ab Initio, Express IT, Acquire IT, Unix, Oracle and Control Centre

Confidential

Managing Consultant

Responsibilities:

• Requirement gathering from the client for specific service
• Development of ETL code and Unix utilities
• Review the code and graphs and delivered it to client on time.
• Carrying out Unit Testing for code with test data
• Extensively used Ab Initio for ETL processing
• Creating reusable components to improve performance in graph
• Providing immediate solutions to client/end user for run-time errors based on the severity of the issues
• Preparing list of Deliverable during code delivery
• Resolving QA issues and queries to support the process
• Handling all aspects of customer reported issues and their causes

Environment: Ab Initio, Express IT, Unix, Netezza and Control Center

Confidential

Senior Technology Specialist

Responsibilities:

• Analysing the Functional Specification Design document with Business Analyst.
• Working as Offshore lead for getting the work done from offshore team.
• Requirement gathering from the client for specific service.
• Development of ETL code and UNIX utilities.
• Review the code and graphs and delivered it to client on time.
• Carrying out Unit Testing for code with test data.
• Extensively used Ab Initio for ETL processing.
• Creating reusable components to improve performance in graph.
• Providing immediate solutions to client/end user for run-time errors based on the severity of the issue.
• Extensively used Anthill build and deployed tool for code Promotion.
• Using AUTOSYS for Scheduling the Jobs and setting up the Jobs for execution.
• Preparing list of Deliverable during code delivery.
• Resolving QA issues and queries to support the process.
• Handling all aspects of customer reported issues and their causes.
• Conducting Knowledge Transfer sessions to extend and share technical knowledge with team-mates.
• Extensively involved in production support incidents which are run through AUTOSYS.
• Extensively involved in various iterations for designing and developing the code.
• Participating in peer-review process of the code-fix for the quality of deliverable.
• Development tracking through Jira tool.
• Extensively worked in Express IT tool.
• Extensively used control center tool to monitor the ETL jobs and its failures.

Environment: Ab Initio, Unix, Oracle, Teradata, Express IT and Autosys.

Confidential

Application Developer

Responsibilities:

• Analysing the Technical Specification Design document with Business Analyst.
• Working as Onsite Coordinator for getting the work done from offshore team.
• Requirement gathering from the client for specific service.
• Development of ETL code and UNIX utilities.
• Review the code and graphs and delivered it to client on time.
• Carrying out Unit Testing for code with test data.
• Extensively used Ab Initio for ETL processing.
• Creating reusable components to improve performance in graph.
• Providing immediate solutions to client/end user for run-time errors based on the severity of the issues.
• Extensively used PVCS version control for code Promotion.
• Using ESP for Scheduling the Jobs and setting up the Jobs for execution.
• Preparing list of Deliverable during code delivery.
• Resolving QA issues and queries to support the process.
• Handling all aspects of customer reported issues and their causes.
• Conducting Knowledge Transfer sessions to extend and share technical knowledge with team-mates.
• Extensively worked with Multi files system and used Partition Components and departition components.
• Extensively involved in production support incidents which are run through ESP.
• Extensively involved in various iterations for designing and developing the code.
• Participating in peer-review process of the code-fix for the quality of deliverable.

Environment: Ab Initio, Unix, DB2, ESP and Control -M.

Confidential

Software Engineer

Responsibilities:

• Analyzing the Technical Specification Design document with Business Analyst.
• Requirement gathering from the client for specific service.
• Development of ETL code and UNIX utilities.
• Reviewing the code and graphs and delivering it to client on time.
• Carrying out Unit Testing for code with test data.
• Creating reusable components to improve performance in graph.
• Providing immediate solutions to client/end user for run-time errors based on the severity of the issues.
• Extensively used PVCS version control for code Promotion.
• Using ESP for Scheduling the Jobs and setting up the Jobs for execution.
• Preparing list of Deliverable during code delivery.

Environment: Ab Initio, Unix, DB2 and ESP.