As a lead of offshore team of 5, responsibilities include attending Business Meetings and work with Requirements Team in writing the Technical Specs, Analyzing profiling results, Work closely with the downstream systems.Build a re-usable staging area in Oracle for loading data from multiple source systems.Hands-on experience on ETL design, Build and Implementation of code ( worked on complex mappings like SCD type 2, XML file processing, VSAM file processing, Teradata parallel transporter loads, loading Netezza tables,

Acted as a single point of contact for the Design, Build and Delivery of the project by involving in requirement Discussions across various teams.Handled and mentored a team of 3 offshore members.Development included writing UNIX shell scripts, creating complex informatica mappings involving Push Down Optimization, SCD type 2 mappings etc.

Leading a team for the development of Informatica ETL application.Proposed PoC for converting the rules from Legacy Black Box to Informatica mappingsTuning the Queries/ Code to handle huge data.The project includes generation of documents like Property Policy Decs, Enhanced Billing communication, and Agency compensation statements, Doc generation of Excess and Surplus policies and one time policy savings report / Corrective action letters

Transition Lead of the Testing team from Infosys Technologies (India) to Infosys Technologies (China).As the lead of TCoE (Testing Center of Excellence) had to Plan, Organize, Coordinate and track the planning, design and execution of Test Cases, Training and knowledge transfer to the new members of the team, Worked on creation of Test scenarios and Test cases, Review of Test cases, test scripts and defect management.

Project was moved to Infosys Technologies (China). I was the key member for the transition of the project.Responsible for development and maintenance of Mainframe and Informatica ETL application for member enrollment application and integration with downstreamHandling an offshore team of 6 members.

Developing Informatica ETL flows for getting data from Mainframe landing zone to downstream systems like Billing, claims etcTuning the SQL Queries/ Code to handle huge data.Building the Reconciliation process using SQL and Shell Scripting.Responsible for developing and maintenance of Mainframe application for member enrollment application