SUMMARY:

• Working as Abinitio Tech Lead with 12 years of experience in ETL tools Abinitio, Informatica, Talend, Unix & Sql.
• Technically adept and confident software programmer with exceptional skills in coding and documentation.
• Good knowledge of Data warehousing concepts and expertise in tools like Abinitio BRE, Profiler & Informatica and domain knowledge of MANTAS.
• Had worked on code optimization in Abinitio and metaprogramming with PDL’s.
• Had taken initiative in identifying the project requirements, analyzing business risk & project risk and evaluating the same with the team in team meetings.
• Had taken responsibilities in analyzing, development, unit testing, integration testing and Production Support after release.
• Had been involved in cordinating the release related activities like migrating the code across different environments and deployment tasks.

TECHNICAL SKILLS:

• Languages: Unix Shell Scripting, SQL
• Operating System: Windows, Unix
• Database: Oracle 9i, 10g, DB2, Teradata
• Scheduler: Autosys, Mainframe, Control M
• Tools: AbInitio GDE3.1.5, AbInitio BRE1.15.2.5, Putty
• Data Profiler 1.15.2, Informatica 8.1,TOAD, Pl/Sql Develope

PROFESSIONAL EXPERIENCE:

Confidential

Technology: Ab Initio 3.1.5, Oracle, Unix

Abinitio Architect

Responsibilities:

• Understanding the Prescriber download flow to identify the areas to implement this change in a timely manner.
• Implemented the address standardization process as per the business rules to do comparison of address fields to identify Insert, Updates & Deletes.
• Supported the SIT and UAT process for executing the process end to end and load the data into Master Prescriber Hub and handle the job level errors & environmental issues.
• Identified the data issues in the input file in production which was generating huge delta count everyday and added check points to fail the process and notify the support team.
• Added logic for implementing threshold to control the allowed count of changes for every processing run.
• Supported the enhancement for building a sync up process to remove the inactive & unused records from MPH there by reducing the huge count of records flowing every run for the comparison logic.

Confidential

Technology: Ab Initio 3.1.5, Oracle, Unix

Abinitio Architect

Responsibilities:

• Designed the generic process for processing multiple files in loop for every run.
• Implemented the business rules for file level, record level & column level validations and captured the bad/failed records to report back to business and support teams for analysis.
• Added threshold checks for failures at each validation step to control the bad/rejected records.
• Was involved in identifying the Root cause of the business incident and built additional validation steps to prevent the issue from occurring in future runs.

Technology: Ab Initio 3.1.5, Oracle, Unix

Abinitio Tech Lead

Responsibilities:

• Gathering inputs from the onshore team to understand the requirements and prepare the High Level Design.
• Assigning modules for individual members during development, reviewing the code and validating the data as per the mapping document given by the business.
• Migrating the code and coordinating the testing process with the testing team, tracking the defects and making changes accordingly.
• Preparing the deployment plan and supporting the production deployments
• Providing warranty support to the project after deployment

Confidential

Technology: Ab Initio 3.1.5, Oracle, Unix, Autosys

Onsite Tech Lead

Responsibilities:

• Gathering inputs from business and implementing the logic into the Abinitio code.
• After the completion of development, reviewing the code and validating the data as per the mapping requirements.
• Migrating the code and coordinating the testing process with the testing team, tracking the defects and making changes accordingly.
• Developed graphs to get the consent and preferences of the customers and update the database. Created separate programs for Loyalty customers to give them the special benefits.
• Involved in the production deployment activities and provided KT to the production support team.

Confidential

Technology: Ab Initio 3.04, Mainframe, DB2

Abinitio Lead

Responsibilities:

• Had worked on complex ETL design and development for building the SFD using Abinitio and have good understanding on project requirements and the IBM BDW customized data model.
• Worked on Coding, Unit testing and integration testing of ETL code for building canonical layer and Shared Foundation Data (SFD) layer
• Discussing and understanding the business requirements from the Client and sharing the same with the off shore team .
• Was responsible for loading the Credit Risk Data into SFD layer in Development and Testing regions.
• Worked on identifying and fixing critical data issues in the Teradata DB in production environment.
• Worked actively in developing a comprehensive checklist for complex data load processes in Testing and Production environments.

Confidential

Technology: Ab Initio 3.04, Mainframe, DB2

Senior Developer

Responsibilities:

• Analyzed the scenarios and gave valuable technical inputs for the conversion process as per the business requirements.
• Developed graphs and objects as per the requirements for the conversion.
• Done the mapping changes for the conversion from CCA to TSYS source.
• Was involved in testing the Graphs through Mainframe scheduler and also verified the output data both technically and functionally.
• Was involved in the history population process, tracking the output files and get the output data in the tables validated through LOB’s