Onsite Tech Lead Resume

EXPERIENCE SUMMARY:

Working as ETL Developer with 5.8 years of experience in Abinitio, Informatica, Mainframe, Unix & SQL.
Technically adept and confident software programmer with exceptional skills in coding and documentation.
Good knowledge of Data warehousing concepts and expertise in ETL Tools Abintio & Informatica and domain knowledge of MANTAS.
Had worked on code optimization in Abinitio to improve the weightage and running time of the Graphs.
Experience in SQL tuning and creation of Indexes for faster database access and used explain plan for better query performance.
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.

TECHNICAL SKILLS:

Good expertise in the ETL Tools: Ab Initio GDE 1.15.9 and Informatica 8.6

Also worked with the Ab Corp tools: BRE 1.15.2.5 and Data Profiler 1.15.2

Has worked in database: Oracle 9i & 10g and DB2 with tools TOAD & Pl/Sql Developer and Mainframe.

Has worked on the: Unix environment with good knowledge on shell scripting.

WORK EXPERIENCE:

Confidential

Technology: Ab Initio 3.04, Mainframe, DB2

Onsite Tech Lead

Responsibilities:

Discussing and understanding the business requirements from the Client and sharing the same with the off shore team .
Coordinating the development work and guiding the off shore team regarding the business requirements, mapping & code clarifications
Reviewing the ETL code and checking if the business logic has been properly implemented.
Scheduling the jobs through Mainframe scheduler and also verifying the output data both technically and functionally.

Confidential

Technology: Ab Initio 3.04, Mainframe, DB2

Sr 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 Confidential 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.

Confidential

Technology: Ab Initio 1.15.9, DB2

Performance Analyst

Responsibilities:

Analyzed the scenarios and gave valuable technical inputs for improving the performance of Abinitio graphs.
Analysed the SQL queries for performance and suggested ways to improve running time through Index creation & used explain plan for better query performance.
Modified the design of Abinitio graphs to drop unwanted components which were taking longer time for execution.
Was involved in Testing the Graphs and plans by running automatic scripts using UNIX commands and also through front end in GDE.
Was involved in technical support to the client during & after the release into production and solved the production issues on time.

Confidential

Technology: Ab Initio 1.15.9, Abinitio BRE 1.15.2.5, Data Profiler 1.15.2, Oracle Pl/Sql, Unix

Senior Developer

Responsibilities:

Analyzed the scenarios and gave valuable technical inputs for design of graphs as per the business requirements.
Developed graphs as per the requirements and delivered objects (dml’s & xfr’s) into production to refine undulated data in the expected Confidential and CDL forms.
Was involved in Testing the Graphs and plans by running automatic scripts using UNIX commands and also through front end in GDE.
Profiled data using Ab Initio Data Profiler to generate datasets.
Applied business rules using Ab Initio Business Rule Environment by developing rulesets and generated xfr’s.
Was involved in technical support to the client during & after the release into production and solved the production issues on time.

Confidential

Technology: Informatica8.1, Oracle, Unix

Junior Developer

Responsibilities:

Confidential

Technology: Informatica 8.1, SQL, Unix

Junior Support

Responsibilities:

Monitoring the JOBS using Workflow monitor & checking for any Production issues or status alerts
Getting the business data from the source, validating and checking the correctness of the data before loading into the Database.
Learnt the MANTAS process for running jobs using Informatica.
Done the analyzing work for generating matches and alerts using Informatica using the scenarios and to alter the datasets to make the data to generate matches.
Done documentation for the “Scenario Execution Process”