PROFESSIONAL SUMMARY:

• 6 years 9 months of IT experience in analysis, design, development, implementation and troubleshooting in the area of ETL Tool Informatica, Data warehousing Methodologies and BI Reporting.
• Extensive experience in designing and developing ETL involving Source databases Oracle, DB2, Flat Files (fixed width ,delimited) and Target databases Oracle, DB2 and Flat Files (fixed width , delimited).
• Extensive experience in handling ETL using Informatica Power Center 8.X/7.x.
• Certified Informatica Power center 8.x Developer
• Extensively worked on Informatica Designer Components - Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet and Mapping Designer.
• Strong Experience in using Workflow Manager Tools - Task Developer, Workflow & Worklet Designer.
• Extensively used Informatica Repository Manager and Workflow Monitor.
• Strong experience in developing complex mappings using varied transformations like Unconnected and Connected lookups, Router, Aggregator, Sorter, Rank, Joiner, Normalizer , Stored Procedure and Update Strategy transformations.
• Strong experience in developing Workflows, Worklets, sessions and tasks to effectively manage the huge Loads.
• Strong Experience in Source System/Data analysis for identifying different data measures and developing Functional data requirement documents.
• Excellent knowledge in identifying performance bottlenecks and tuning the Informatica Load for better performance and efficiency.
• Extensive experience in error handling and problem fixing in Informatica.
• Experience in Business Objects 6.5 and Business Objects XI for creating different types of reports and graphs.
• Strong knowledge of different Schemas (Star and Snow Flake) to fit reporting, query and business analysis requirements.
• knowledge in Creating database objectslike Stored Procedure, Views, packages, functions using PL/SQL.
• Excellent knowledge in UNIX Shell Scripting.
• Experience working on Oracle 10g/9i/8i.
• Excellent experience with Quality Assurance / Quality Testing on Data warehousing using Manual testing procedures
• Ability to prioritize multiple tasks.
• Strong working experience with various clients ranging from Telecommunication, Finance, Insurance domain industries.
• Experience of having worked for bigger merger projects in securities domain, the Wachovia-Wells Fargo merger.
• Extensive experience working with customer / client / end-user, strong communications, interpersonal skills, ability to work under own initiative and respond to peaks in demand
• Extensive experience on ‘Offshore-Onsite Delivery Model’. Implementing the technical design and conducting unit and system testing
• Quick learner and adaptive to new and challenging technological environments
• Followed complete Software Development Life Cycle (SDLC), agile methodologies in various projects.
• Experience in data refresh in lower environments for testing.

PROFESSIONAL SKILLS:

ETL Tools : Informatica Power Center 8.x/7.x
Reporting Tools : Business Objects, Microstrategy reporting
Operating System : Win NT/XP/7
Languages : SQL, UNIX Shell Scripting
Database : Oracle 9i. 10g, DB2
Front-End Tools : VB 6.0
Config. Mgmt. Tool : HARVEST, Microsoft VSS
Other Tools : Toad, Rapid SQL, Autosys Scheduling, HP Quality Center

Certifications:

• Informatica Power Center 7 Mapping Design (Code –N) Certified.
• InformaticaPower Center 7 Advanced Mapping Design (Code-P) Certified.
• Informatica Power Center 8 Developer Update (Code-W) Certified.
• Oracle Certified (Exam – Introduction to Oracle9iSQL 1Z0-007).

PROFESSIONAL EXPERIENCE:

Confidential, St Louis, MOFeb 2008 - Present.

ETL Tech Lead

Responsibilities:

• Understand the existing subject areas, source systems, target system, jobs, deployment processes with minimal supervision.
• Worked with BA’s and Application teams and gathered requirements
• Design ETL jobs for the Data Management team in various projects.
• Improved performance of various slow mappings especially for historical load related jobs.
• Proactively resolved open issues raised by development and testing teams.
• Worked closely with the Administrator to get code deployments in production and different environment.
• Designed and developed ETL process to load and extract data using Db2 Load and Oracle Sql Loader.
• Used Lookup, Sequence generator, Expression, Router and Update Strategy transformations to insert, delete and update the records for Slowly Changing Dimension tables
• Worked on change data capture for slowly changing dimensions (SCD-2) to update a target table to keep full history. Also implemented using Slowly Changing Dimension Type 1 Technique.
• Automated scheduling of Unix Scripts and Informatica session using Autosys
• Involved in preparing the tech specs for the customized code which can take the Wells Fargo Converted data and load into the Wachovia brokerage data warehouse
• Participated and conducted code reviews, unit and integration testing of the code.
• Involved in creating the technical runbooks and playbooks which will have the list of all tasks and jobs and the sequence in which they need to be executed as part of each cycle
• Coordinated with QA team during QA and Preproduction testing process
• Experience in Designing test plans, defining test cases, generating and maintaining test scripts, analyzing bugs, interacting with other team members to debug the errors and etc
• Prepared QA and Preproduction Release notes
• Creation of Test Execution Plan
• Coordination of Quality Center Activities - Result Entry, Defect tracking and Management.
• Analysis and coordination of Testing related activities with various stake holders and teams.
• Involved in Informatica Code Migration across various Environments
• Ensured smooth execution of project deliverables with co-ordination of offshore team.
• To provide status reports to Wachovia management as specified.

Environment: Informatica power center 8.x, DB2, Oracle, Autosys, HP Quality Center, UNIX Shell Scripting, WINDOWS XP, Microsoft Visio, TOAD

Confidential, Hartford, CTOct 2007 – Jan 2008.

Onsite ETL Lead

Responsibilities:

• Lead to a team of 3 offshore resources to work on this project
• Understand the existing subject areas, source systems, target system, jobs, deployment processes with minimal supervision
• Design ETL jobs for the DW team.
• Coordinated the development effort with offshore team
• Discover the source data that causes the problems downstream.
• Implemented Lookup, Sequence generator, Router and Update Strategy transformations to insert, delete, update the records for Slowly Changing Dimension tables
• Implemented using change data capture for slowly changing dimensions (SCD-2) to update a target table to keep full history
• Used Mapplets and Reusable Transformations to prevent redundancy of transformation usage and maintainability
• Worked closely with Cognos reporting team in order to meet users/business Adhoc and other reporting needs.
• Designed the ETL solution including preparation of high level, detailed design documents, test plans and deployment strategy.
• Analyzed the data models of the source & target systems to develop comprehensive mapping specifications.
• Involved in all the code migration activities across the test environments
• Participated and conducted code reviews, unit and integration testing of the code.
• To provide status reports to TWC management as specified.
• Coordination of Quality Center Activities - Result Entry, Defect tracking and Management.
• Analysis and coordination of Testing related activities with various stake holders and teams.
• Involved in Informatica Code Migration across various Environments
• Ensured smooth execution of project deliverables with co-ordination of offshore team.

Environment: Informatica power center 8.x, Oracle, HP Quality Center, UNIX Scripting, WINDOWS XP, TOAD

Confidential, Chicago, IL Jun 2007 – Sep 2007.

Onsite lead

Responsibilities:

• Lead to a team of4 offshore resources.
• Involved in complete SDLC.
• Involved in Frame work and Report design and transformed the requirements to business specs and technical specs.
• To provide the impact analysis and estimates for any change requests.
• Designed and coordinated the development of Reports, Dashboards, Framework required for the reportsthrough offshore team
• Designed and developed complex PL/SQL code togather the custom data for the Dashboards
• Participated in test plan creation defining the scope and approach.
• Participated and conducted code reviews, unit and integration testing.
  Conducted TEST, ACCEPTANCE runs
• Ensured smooth execution of project deliverables with offshore team co-ordination.
• Analyzed technical issues and performance bottle necks and resolved them.
• To provide status reports to higher management as specified.
• To provide technical support after production implementation.

Environment: Business Objects XI, Oracle, HP Quality Center, PL/SQL Scripting, TOAD, WINDOWS XP

Confidential, May 2005 – May 2007.

Software Developer

Responsibilities:
.

• Demonstrated strong analytical, problem-solving, organizational, communication, learning and team skills.
• Analyzed system data model, created proof of concepts to prepare high level and low level design documents.
• Forage through rows of data, discovering patterns.
• Coordinated with Onsite team on day to day basis regarding day to day activities.
• Created Hyperion reports for adhoc and general reporting.
• Identifying and removing bottlenecks to improve the performance of Mappings, Sessions and Workflows.
• Development of Reports, Dashboards, Framework.
• Design and develop ETL mappings using Informatica to support the reporting data mart
• Conducted unit and integration testing for ETL routines.
• Performed day to day migrations of various Informatica objects using export-import option.
• Preparing the Test cases and Test plans and worked on Quality Center to run the test cases and log defects.

Environment: Business Objects 5.9, Informatica Power center 7.x, Oracle, UNIX, Mercury Quality Center and Admin server

EDUCATION:

Masters of Sciences in Information Technology
Bachelor of Computer Applications