SUMMARY:

• 9 years of experience in Requirement Analysis, Functional Analysis, Design, Development, implementation, Testing, Debugging, Productions Support, and Maintenance of various Data warehousing Applications (Informatica, Informatica IDQ,Oracle and UNIX).
• Nine years IT industry experience includes Data Integration and Analysis for Decision Support System in Banking, Insurance, Financial, Telecom,Health,Aviation,Industarial Sector.
• Worked on Development, Migration development and Production support project.
• Working closely with architects for requirement gathering and working with teams on the solution.
• Have good analyzing skills to analyze existing system and also planned system to discover a feasibility of systems.
• Involved on Data analysis using Query analyzer, Understand the requirement and do the mapping layout document to implement in Informatica code.
• Nine years of Data Warehousing experience using Informatica Power Center 9.6.1,9.1.0, 8.6.1/8.1/ 7. x/6.x/5.1.2, Power center Designer,, Repository Admin console, Repository Manager,, Workflow Manager, Workflow Monitor, Informatica Analytics, IDQ,Informatica Power Exchange ETL, Data mart, OLAP, OLTP.
• Worked on Informatica IDQ for Data profiling and Data Cleansing.
• As a ETL developer also worked on DATASTAGE and SAP - BODI tool.
• Experience with Database Systems like flat file,Oracle 11g,10g/9i/8i/7.3,PeopleSoft,,SQL SERVER,Teradata, Mainframe,SapR/3 and SAP HANA
• Excellent experience in extraction, transformation and loading the data from various source databases to target database.
• Worked in Incident and change management processes(SLA)
• Experience in writing, reviewing and executing test cases and test scripts as per the client process
• Programming and debugging skills in SQL, PL/SQL and UNIX shell scripting. Experience in developing Stored Procedures, Functions and Packages.
• Strong experience working with Banking and Insurance industry.
• Experience in working with Support teams like Production support, Code migration
• Involved in Full Life Cycle Development of building a Data Warehouse.
• Experienced in Performance of Mapping Optimizations in Informatica.
• Experienced in the Analysis, Design, Development, Testing, and Implementation of business application systems for Financial, Insurance, Telecommunication and Manufacturing Sectors.
• Experienced in using the Oracle SQL* Loader feature for loading the data from Flat Files to Data Base tables for Bulk Loading.
• Extensive experience in error handling and problem fixing in Informatica.
• Excellent skills in retrieving the data by writing simple/ complex SQL Queries.
• Understanding in writing Test plans, Test cases, Unit testing, System testing, Integration testing and Functional testing.
• Implemented scheduling tools like Informatica Scheduler,Ctrl -M, DAC, ESB.
• Involved in many Informatica Admin activities like Creation folder,User creation,Assigning role the USER,Code back up,Migration of code(Dev to QA to UAT),Informatica connection creation(relational and application) etc
• Experience with Informatica adminstartion.
• Exposure towards OBIEE,Cognos and Business object reporting tool.
• Possess good interpersonal, presentation and development skills with strong analytical and problem solving approach.
• Excellent Team Player, self motivated with good communications skills.
• Worked on onsite\offsore model
• Excellent skills in analysis and business requirements gathering from end users to the client and experience in documentation of developed applications.

TECHNICAL SKILLS:

Informatica Power Center: 9.6.1,9.1.0, 8.6.1/8.1/7. x/6.x/5.x Repository Manager, Designer, Server manager, Workflow Monitor, Workflow Manager, Power Mart 6.2/6.1/5.1. x/4.7,Oracle Ware House Builder 9.2/10g, Power Connect for DB2/Siebel/SAP, DataStage

Databases: Oracle11g/10g/9i/8i,DB2,Mainframe,SQLServer2008 R 2/2000/7.0/6.5 , TERADATA,Peoplesoft,SAP R/3 and SAP HANA

ControlM, DAC:, Tivoli,ESP,Informatica Scheduler

Environment: Windows 95/98/2000/NT, UNIX, MS-DOS, SQL*Plus

SQL, PL/SQL:, C, C++, Shell scripts

WORK EXPERIENCE:

Confidential, Winston Salem, NC

Informatica Developer/Technical Consultant/Data Analyst

Responsibilities:

• Extensively used Informatica 9.6.1 for extracting the data from Mainframe, Flat File, Oracle and Sqlserver to loading data into SAP HANA..
• Creation of jobs using different transformations and validate the mapping.
• Created various mappings, mapplets to implement the business logic using different transformations as Aggregator, Connected and Unconnected Lookups, Router, Update Strategy, Filter, Rank, Joiners.
• Expression, Sequence generator. Used debugger to test the mapping and fixed the bugs.
• Created Informatica IDQ mapping for Data profiling and Data Cleansing
• Used Power Exchange for extracting the data from Mainframe.
• Extensively used Informatica Analyst, IDQ tool for source data profiling.
• Implemented Slowly Changing dimensions Type 1,Slowly Changing dimensions Type 2 history of dimensional data in the table
• Designed and Developed the Informatica workflows/sessions to extract, transform and load the data into dimension, fact tables and transactional tables.
• Used Workflow Manager for creating, validating, testing and running the sequential and concurrent sessions.
• Used Workflow Monitor to monitor the progress of workflow.
• Responsibility involved in Non Function point Estimation, Impact Analysis, Defect Closing, preparation of HLD, LLD, Test Case etc. maintain the coding standard according to the Naming convention.
• Interacted with technical team and business users to perform analysis of business requirements
• Prepare the technical document after going through the functional specification.
• Worked with testing team on ALM to resolve the defects

Environment:, Informatica 9.6.1, Power Exchange,IDQ,Oracle 11g,SQL SERVER,Flat File, SAP HANA and UNIX

Confidential, Philadelphia, PA

Informatica Consultant /Technical Consultant

Responsibilities:

• Extensively used Informatica 9.6.1 for extracting the data from legacy system and loading data into SQL SERVER
• Creation of jobs using different transformations and validate the mapping.
• Created various mappings, mapplets to implement the business logic using different transformations as Aggregator, Connected and Unconnected Lookups, Router, Update Strategy, Filter, Rank, Joiners.
• Created Informatica IDQ mapping for Data profiling and Data Cleansing
• Expression, Sequence generator. Used debugger to test the mapping and fixed the bugs.
• Implemented Slowly Changing dimensions Type 1,Slowly Changing dimensions Type 2 history of dimensional data in the table
• Designed and Developed the Informatica workflows/sessions to extract, transform and load the data into dimension, fact tables and transactional tables.
• Used Workflow Manager for creating, validating, testing and running the sequential and concurrent sessions.
• Used Workflow Monitor to monitor the progress of workflow.
• Responsibility involved in Non Function point Estimation, Impact Analysis, Defect Closing, preparation of HLD, LLD, Test Case etc. maintain the coding standard according to the Naming convention.
• Interacted with technical team and business users to perform analysis of business requirements
• Prepare the technical document after going through the functional specification.

Environment:, Informatica 9.6.1, IDQ,SQL SERVER,DMF,Winows

Confidential, Hoboken,NJ

Informatica Developer/Tech Lead

Responsibilities:

• Extensively used Informatica 9.1 for extracting the data from PEOPLESOFT application and loading data into OBIEE DATAWAREHOUSE.
• Creation of jobs using different transformations and validate the mapping.
• Created various mappings, mapplets to implement the business logic using different transformations as
• Used Aggregator, Connected and Unconnected Lookups, Router, Update Strategy, Filter, Rank, Joiners.
• Expression, Sequence generator. Used debugger to test the mapping and fixed the bugs.
• Implemented Slowly Changing dimensions Type 1,Slowly Changing dimensions Type 2 history of dimensional data in the table
• Designed and Developed the Informatica workflows/sessions to extract, transform and load the data into dimension, fact tables and transactional tables.
• Used Workflow Manager for creating, validating, testing and running the sequential and concurrent sessions.
• Used Workflow Monitor to monitor the progress of workflow.
• Responsibility involved in Non Function point Estimation, Impact Analysis, Defect Closing, preparation of HLD, LLD, Test Case etc. maintain the coding standard according to the Naming convention.
• Interacted with technical team and business users to perform analysis of business requirements
• Prepare the technical document after going through the functional specification.

Environment:, Informatica 9.1, Oracle 11g, PL/SQL, OBIEE and DAC.

Confidential, DETROIT, MI

Informatica Developer/Project Lead

Responsibilities:

• Extensively used Informatica 8.6 for extracting the data from Flat FILE and loading data into Mysql.
• Creation of jobs using different transformations and validate the mapping.
• Created various mappings, mapplets to implement the business logic using different transformations as
• Used aggregator, Connected and Unconnected Lookups, Router, Update Strategy, Filter, Rank, Joiners, Expression, Sequence generator transformations. Used debugger to test the mapping and fixed the bugs.
• Implemented Slowly Changing dimensions Type 1 and Type 2 to keep a full history of dimensional data in the table
• Used Workflow Manager for creating, validating, testing and running the sequential and concurrent sessions.
• Designed and Developed the Informatica workflows/sessions to extract, transform and load the data into Transactional tables.
• Used Workflow Monitor to monitor the progress of workflow.
• Wrote SQL queries, PL/SQL Procedures/Functions to support the business requirements and to
• Interacted with technical team and business users to perform analysis of business requirements
• Prepare the technical document after going though the functional specification.

Environment:, Informatica 9.1, Oracle 11g, PL/SQL, Unix

Confidential, Hoboken, NJ

Informatica Developer/Tech Lead/Migration Lead

Responsibilities:

• Extensively used Informatica 8.6 for extracting the data from Flat FILE and loading data into oracle.
• Creation of jobs using different transformations and validate the mapping.
• Created various mappings, mapplets to implement the business logic using different transformations as
• Aggregator, Connected and Unconnected Lookups, Router, Update Strategy, Filter, Rank, Joiners,
• Expression, Sequence generator. Used debugger to test the mapping and fixed the bugs.
• Implemented Slowly Changing dimensions Type 1 and Type 2 to keep a full history of dimensional data in the table
• Used Workflow Manager for creating, validating, testing and running the sequential and concurrent sessions.
• Designed and Developed the Informatica workflows/sessions to extract, transform and load the data into Transactional tables.
• Used Workflow Monitor to monitor the progress of workflow.
• Wrote SQL queries, PL/SQL Procedures/Functions to support the business requirements and to
• Interacted with technical team and business users to perform analysis of business requirements
• Prepare the technical document after going though the functional specification.
• Excellent skills in analysis and business requirements gathering from end users to the client and experience in documentation of developed applications
• Responsible for ensuring that the requirements of the business clients have been captured and documented correctly before a solution is developed.
• Responsible for issue resolution, work closely to perform data quality & analysis and monitoring of data load
• Peer review,code review.

Environment:, Informatica 8.6/9.1, Oracle 11g,, PL/SQL, UNIX Shell Scripts.

Confidential

Tech Lead

Responsibilities:

• Responsible for ensuring that the requirements of the business clients have been captured and documented correctly before a solution is developed.
• Responsible for issue resolution, work closely to perform data quality & analysis and monitoring of data load.
• Excellent skills in analysis and business requirements gathering from end users to the client and experience in documentation of developed applications
• Implemented the Informatica coding in BODI tool
• Involved in doing code review
• Extensively used Informatica 8.6 for extracting the data from Flat FILE and loading data into Mysql.
• Creation of jobs using different transformations and validate the mapping.
• Created various mappings, mapplets to implement the business logic using different transformations as
• Aggregator, Connected and Unconnected Lookups, Router, Update Strategy, Filter, Rank, Joiners,
• Expression, Sequence generator. Used debugger to test the mapping and fixed the bugs.
• Implemented Type II slowly changing dimension to keep a full history of dimensional data in the table
• Used Workflow Manager for creating, validating, testing and running the sequential and concurrent sessions.
• Designed and Developed the Informatica workflows/sessions to extract, transform and load the data into Transactional tables
• Debug mappings to gain troubleshooting information about data and error conditions using Informatica Debugger.
• Used Workflow Monitor to monitor the progress of workflow.
• Wrote SQL queries, PL/SQL Procedures/Functions to support the business requirements and to

Environment:, Informatica 8.6, SAP-BODI,Oracle 11g, UNIX Shell Scripts.

Confidential

Informatica Developer

Responsibilities:

• Requirements Gathering and Business Analysis.
• Interpreted logical and physical data models for Business users to determine common data definitions and establish referential integrity of the system.
• Designing the Data marts based on the requirement using Informatica Power Center
• Created data model structure and E-R modeling with all related entities and relationship with each entities based on the rules provided by the business manager using Erwin
• Prepared and implemented data verification and testing methods for the data warehouse.
• Developed data movement exception handling and worked with business people to address resolve exceptions.
• Extensively used ETL to load data from Oracle, SQL server,.
• Developed ETL mappings, transformations using Informatica Power Center 8.6
• Worked on Informatica Utilities - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer & Transformation Developer
• Used debugger to test the data flow and fix the mappings.
• Created and monitored workflows and tasks using Informatica Power Center Work flow Manager.
• Tuned the workflows and mappings
• Setting up Batches and sessions to schedule the loads at required frequency using Power Center Server manager.
• Involved in Writing Shell scripts to automate Pre-Session and Post-Sessions Processes.
• Involved in Developing Stored procedures using PL/SQL

Environment: Informatica 8.6.Oracle 9i /8i PL/SQL,, TOAD, SQL*Plus, SQL*Loader,, UNIX

Confidential

DW Informatica Developer

Responsibilities:

• Interviewed business partners to determine requirements.
• Determined scope of project phases, and documented the mappings.
• Determined where the data resided and how to write to temporary file for initial load.
• Wrote detailed specifications to code navigation path to store data within proper tables.
• Coordinated execution of the test plans and verified data to be loaded into Warehouse.
• Created Mapping and Mapplets for Transforming data from transient staging to Warehouse and feeding specific data marts.
• Used Informatica Source Analyzer, Mapping Designer and Warehouse Designer for Extraction, Transformation and Loading.
• Created reusable transformations and used in different mappings.
• Used Joiner Transformation to extract data from multiple sources and Sequence Generator Transformation to create unique primary key values.
• Used Aggregator, Sequence Generator, Joiner, Look up, Expression, Filter, Rank, Router, Update Strategy Transformations to populate target. Used debugger to test the mapping and fixed the bugs.
• Implemented SCD1 and SCD2 .
• Involved in analysis, design, development, test and implementation of Informatica transformations and workflows for extracting the data from the source systems.
• Worked cooperatively with the team members to identify and resolve various issues relating to Informatica and databases.
• Used parameters and variables at mapping and session levels to tune the performance of Mappings.
• Coded BTEQ scripts to load data from Teradata staging to Enterprise Data warehouse.
• Worked Extensively on Teradata SQL Assistant to analyze the existing data and implemented new business rules to handle various source data anomalies.
• Used MLOAD,FLOAD to load the data in to Teradata warehouse
• Used PL/SQL for writing stored procedures and database triggers to enforce database integrity.
• Used parallel processing capabilities, Session-Partitioning and Target Table partitioning utilities.
• Developed process for error handling and auto reloading.
• Created reusable objects in Informatica for easy maintainability and reusability.
• Performed the data validations and control checks to ensure the data integrity and consistency.
• Extensively used debugger to trace errors in the mapping.
• Involved in developing test plans and test scripts to test the data based on the business requirements.
• Responsible for regression testing ETL jobs before test to production migration.
• Supported migration of ETL code from development to QA and then from QA to production.

Environment: Informatica 8.1, Teradata,Sap IDOC,SQL, PL/SQL, SQL*Plus, SQL*Loader, SQL Server 7.0, Windows2000, UNIX.

Confidential

Informatica Developer

Responsibilities:

• Extensively used Informatica power center for loading the data from various sources involving sap, flat files, oracle database, spread sheet etc to target (like flat file or database table).
• Creation of Mapping or mapplet using different transformations and validate the mapping.
• Creation of different transformations like lookups, Expression, joiner, Source Qualifier, Sequence Generator, Router, Filter etc.
• Creation of session for created mapping and add the session logic like connection, log file etc. and validate the session.
• Schedule and monitor the sessions work flows using informatica work flow manager and work flow monitor.
• Analyze the existing mappings, if it is producing errors and rectify the errors.
• If any requirement changes then modify the whole life cycle of informatica.
• Responsibility involved in Non Function point Estimation, Impact Analysis, Defect Closing, preparation of HLD, LLD, Test Case etc. maintain the coding standard according to the Naming convention.
• Involved in Client Handling, fix ups the defect, peer review and status updating, defect log, finalizing the unit test cases, integration test cases and testing along with the peers.
• Make sure the NightlyJob/DailyRun jobs are in a running with out any error.
• If job aborts then Preparation of Catch-Up (Job Control) jobs for the aborted jobs and re-start the Catch-Up jobs.
• Running of the individual job sequencers through the DataStage director incase of job aborts after rectifying the root cause.
• Checking the log for jobs to make sure the usage flat files have successfully been SQLloaded. Any load errors will result in an email to Data-Warehousing Business Applications
• Reloading of the data incase of data miss-matches for a particular day/period
• Dealing with Banks like AIB,BOI,TSB…etc if any day data has not loaded then load the data for the particular day
• Involved in Client Handling, fix ups the defect, peer review and status updating, defect log, finalizing the unit test cases, integration test cases and testing along with the peers.
• The main intention of this project is in the area of Development and Maintenance of o2’s Applications Systems. Analyzing the problem, providing initial analysis and fix the issue.

Environment: Datastage, Teradata, PL/SQL, SQL*Plus, UNIX,