SUMMARY

• Having 11 years of experience as an ETL consultant in Business Analysis, Design,Development and Production Support using industry accepted methodologies and procedures.
• Extensively experience on Informatica handling with sales Force,Mainframe, WebServices(WSDL),XML/XSD,OLTP,Flat Files,Sybase,DB2,SQL Server,Teradata,Netezza and SAP R/3 system.
• Experience in creating mappings, mapplets, reusable transformations, Sessions, Worklets and workflows using Designer, workflow manager, workflow monitor Using Informatica Power Center.
• Experience on Informatica Data Quality (IDQ) and Informatica Cloud with Sales Force and Web sevices.
• Experience in SQL, PLSQL queries and stored procedures.
• Having good experience in writing UNIX/Linux scripts.
• Involved in various testing like unit testing and Responsible for performance Tuning and Error Handling of Informatica mapping.
• Experience in Informatica mapping specification documentation, tuning mappings to increase performance.
• Strong experience in Dimensional Modeling using Star and Snow Flake Schema, Identifying Facts and Dimensions, Physical and logical data modeling using Erwin.
• Strong skills in Requirement gathering and study, Gap Analysis, Scope Definition, Recommendations to Business Process Improvements, Development of Procedures.
• Taking part in Client Servicing, Team Management and Knowledge on Software Development Life Cycle.
• Experience in using Tivoli, Control M,Autosys and crontab scheduling tools.
• Extensively worked on CR’s raised by client and Ability to cope up with any complex situation and innovation.
• Worked independently, and with Team and under less supervision.
• Excellent analytical and logical skills with ability to provide quality technology solutions, with in committed time frames.
• Good experience in change management, incident management and problem management methodologies and also part of CAB team defining the process as per ITIL methodologies.
• Good experience in defining the new process as per business requirement to support the applications.

TECHNICAL SKILLS

Data Warehousing Tools: ETL Tool: Informatica 9.6/9.1/8.x/7.x, Informatica Power Exchange,Informatica Cloud, Informatica IDQ OLAP: Actuate

Domain Experience: Telecom,Healthcare and Insurance

Operating Systems: Win 98/2000/2003/ XP,Unix and Linux

RDBMS: Oracle 9i/10g/12c,Teradata,SQL Server,Sybase,Netezza

SQL Querying tool: Teradata SQL Assistant, TOAD,SQL Developer,Win SQL

Tools: Sales Force, Tivoli JSC 8.4, BMC,Control M,True Comp Manager, True Comp Viewer, Core FTP, Visio, Putty,Remady,Service Now

PROFESSIONAL EXPERIENCE

Senior Consultant/Lead

Confidential, Capgemini,Chicago

Responsibilities:

• Involved in understanding and preparing Technical design and estimation documents.
• Analyzed the existing informational sources and methods to identify problem areas and make recommendations for improvement. This required a detailed understanding of the data sources and researching possible solutions.
• Preparing Mapping sheet (Design Docs).
• Designing Frame work and Developing of Informatica mappings.
• Reviewing of informatica mappings.
• Prepared test case and test scenario’s for unit testing.
• Responsible for system integration testing, UAT testing and migrations.
• Used Push down Optimization and Partitioning to improve perfomenace.
• Worked on Informatica cloud for Safes force Integration.
• Worked on Informatica to extract data from third party databases, web services and XML/XSD.
• Single POC for all ETL development related issues.
• Developed UNIX scripts to handle files.
• Data Profiling using Informatica Data Quality.
• Performance tuning has been done to increase the through put for both mapping and session level and SQL Queries Optimization as well.
• Responsible for identifying Defect Management process, tracking and validating defects.
• Root Cause Analysis of the Production Defects reported and fixes the same.
• Proactively Identified existing bugs in the system and bring to client attention for planning of an appropriate action.
• Worked as a Senior ETL Lead for onsite/offshore model and leading a team
• Used Control M job scheduler for automating the daily runs of Integration cycle in both production and UAT environments.

Environment: Operating Systems: Windows XP,Linux, ETL: Informatica Power center, Informatica Data Quality and Informatica Cloud,Database: Oracle Tools: SQL Developer, Putty,WinSQL WCPOLS

Consultant/Lead

Confidential, Capgemini,Chicago

Responsibilities:

• Involved in understanding and preparing Technical design and estimation documents.
• Interacted with End user community to understand the business requirements and in identifying data sources.
• Analyzed the existing informational sources and methods to identify problem areas and make recommendations for improvement. This required a detailed understanding of the data sources and researching possible solutions.
• Preparing Mapping sheet (Design Docs).
• Designing and Developing of Informatica mappings.
• Reviewing of informatica mappings.
• Worked on Informatica to extract data from web services and XML/XSD.
• Single POC for all ETL development related issues.
• Documented ETL test plans, test cases, test scripts, and validations based on design specifications for unit testing, system testing, functional testing, regression testing, prepared test data for testing, error handling and analysis
• Responsible for identifying Defect Management process, tracking and validating defects.
• Root Cause Analysis of the Production Defects reported and fixes the same.

Environment : Operating Systems: Windows XP,Unix, ETL: Informatica Powercenter and Informatica Power Exchange, Database: Oracle Tools: SQL Developer, Putty, Mainframes, Web Services

Associate consultant/Senior Developer

Confidential

Responsibilities:

• Studied the requirements
• Understood the existing data model, ETL flow and architecture of the project.
• Prepared detail design document.
• Worked on validation part extensively.
• Worked on the base table for the project.
• Did analysis on the granularity.
• Helped in doing the functional testing.
• Acquired all the changes being made by documentation.
• Tested successfully during the unit testing and UAT.
• Creating Deployment Ticket and Deployment support.
• Worked as a Senior ETL Lead for onsite/offshore model and leading a team
• Mentored software associates and assigned work, validated their code.

Environment: Operating Systems: Unix,Windows XP, Database: Oracle 10g, ETL: Informatica 8.6.1 Tools: Silver stream 3.7, Toad,Putty

Associate consultant/Developer

Confidential

Responsibilities:

• Understanding the requirements of client and database design schemas for different sources.
• Ensured high quality work products and processes by following proper coding standards during the Design.
• Preparation of the ETL Detail design document and ETL Specs.
• Developing, Reviewing and Unit Testing of Informatica mappings.
• Tracking the defects and fixing the defects.
• Helped in doing the functional testing.
• Created connections between Informatica to SAP systems to load data into them.
• Acquired all the changes being made by documentation.
• Mentored software associates and assigned work, validated their code.

Environment: Operating Systems: Windows XP.Database: DB2,SAP R3 ETL: Informatica Powercenter and Informatica Data Quality,Tools: VPN

Associate consultant/Developer

Confidential

Responsibilities:

• Understanding the requirements of client and database design schemas for different sources.
• Developing of Informatica mappings.
• Creating sessions, Relational connections and workflows using Informatica Workflow Manager.
• Reviewing of informatica mappings.
• Involved in Unit Testing of mapping.
• Tracking the defects and fixing the defects.

Environment: Operating Systems: Windows XP.Database: Oracle 9i ETL: Informatica 8.1,

Associate Consultant/Developer

Confidential

Responsibilities:

• Preparing Mapping sheet (Design Docs).
• Developing of Informatica mappings.
• Reviewing of informatica mappings.
• Unit Testing of Informatica mappings.
• Closing the defects raised by testing team.

Environment: Operating Systems: Windows XP,ETL: INFORMATICA  8.1, Database:Oracle Tools: SQL Developer, Putty Call Center Performance Management (CCPM)

Technical Associate /Dev and Production Support

Confidential

Responsibilities:

• Requirement gathering and requirement Analysis.
• Used various transformations like Source Qualifier, Filter, Aggregator, Expression, Lookup, Sequence Generator, and update Strategy to create mappings.
• Using ETL Process to Extract, Transform and Load the data into stage area and data warehouse.
• Performing unit testing and Integration testing scenarios.
• Performing code reviews.
• Tracking the defects and fixing the defects.
• Creating Deployment Ticket and Deployment support.
• Involved in scheduling workflows by using Informatica Workflow manager and Tivoli.
• Run & monitoring jobs, responsible for giving solution for any failure of jobs while running.

Environment: Operating Systems: Linux, Windows XP,Database: Oracle,10g,Teradata,ETL: Informatica 8.6.1. Tools: Tivoli JSC 8.4, Teradata SQL Assistant, Core FTP, Putty, Webtrax. Callidus PST 3.7 and 5.1

Technical Associate /Production Support

Confidential

Responsibilities:

• Understanding and maintaining the Production Support Run Book.
• Creating and Maintaining Daily and Monthly Interfaces and Reports Processing Schedule.
• Processing status Notification (Morning and weekend) to Business.
• Magic ticket Initial Analysis and Responsible for monitoring all the feed load status and if, any delays needs to inform feed owner and as well as business users.
• Involving on customer tickets and analyzing the root cause.
• Scheduling, Monitoring and validating Application (Pipelines, Interface and Reports) Processing.
• Maintaining defect metrics and provide monthly reports.

Environment: Operating Systems:Unix, Windows X,Database: Oracle 9i,ETL: Informatica 7.1.3. OLAP: Actuate Tools: Toad,Callidus

Software Engineer

Confidential

Responsibilities:

• Extensively used Informatica Power Center for loading the data from various
• Sources involving flat files and oracle tables.
• Designing a mapping with multifile loading using File Repository.
• Creating shell scripts to ftp source files.
• Used most of the Transformations such as Source Qualifier, Aggregator, Lookup, Filter, Sequence generator, Router, Update strategy etc.
• Creating sessions, database connections and Mapplets using Informatica Workflow Manager
• Scheduled and monitored transformation processes using Informatica Workflow Monitor.
• Involved in Unit Testing of mapping.

Environment: Operating Systems: Windows XP.Database: Oracle 9i ETL: Informatica 7.1.3, Tools: Toad, Putty