Onsite Tech Lead Resume Profile

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.
Extensive knowledge of Banking Finance with certifications Oracle Financial Professional and Cognizant CCP in Banking Financial Services.
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

As Associate - Projects

Confidential

As Associate Consultant

Projects Handled :

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.

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.

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.

3	Project	:	Confidential
Client	:	Confidential
Duration	:	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 SPIDER 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.

Responsibilities:

Developed scripts for generating reports from the controls

Designed the informatica mappings and workflows for report generation

Involved in unit testing for all the interfaces and had done the validations.

Had managed the share point for maintaining the latest code.

Provided technical support for the client after the release.

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