SUMMARY

• 8+ years of experience in estimation, design and implementation of Information Systems.
• Extensive consulting experience with various clients in areas of building datawarehouses and data migration.
• Experience in using Informatica Power Center 9.1/8.6.1/8.1.1 - Source Analyzer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• As a Developer, responsible for advising, developing and testing coding solutions to meet the business needs.
• Strong understanding of Performance tuning in Informatica and Databases.
• Worked with Oracle and SQL Server Stored Procedures, Triggers, Index, and experienced in loading data into Data Warehouse/Data Marts using Informatica.
• Developed complex Mappings, used transformations such as lookups, Router, Filter, Expression, Aggregator, Joiner, and Update Strategy.
• Good understanding of Star and Snowflake Schema, Dimensional Modeling, Relational Data Modeling, Slowly Changing Dimensions and data ware housing concepts.
• Strong Experience and knowledge in creating Stored Procedures, Packages and Triggers using Oracle 11g/10g.
• Data Processing experience in designing and implementing Data Mart applications, mainly transformation processes using ETL tool Informatica Power Center in Extraction/Transformation/Loading of data and developed ETL worklets, workflows, and ETL mappings (using Version Control) (and also monitoring the Production Environment.)
• Enjoy working in teams. Self motivated with good communication skills.
• Experience in providing Business Intelligence solutions in Data Warehousing using Informatica ETL tool (Extraction, Transformation and Loading).

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9x/8.6/8.1/7.x

Data Modeling: Dimensional Data Modeling, Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical / Logical Data Modeling, Erwin 4/3

Databases: Oracle 11g/10g/9i/8i. Netezza,DB2, Sqlsever 2008/2012

Reporting Tools: BUSINESS OBJECTS - Designer XI 3.1, SSRS, Micro Strategy, OBIEE

GUI: Visual Basic, Macromedia Dreamweaver MX, FrontPage 98/2K, Visio, MS Project

Programming: ANSI-SQL, SQL, PL/SQL, C

Operating Systems: Windows95/98/2000/XP/2003,Unix

PROFESSIONAL EXPERIENCE

Confidential

Sr. Informatica Consultant

Responsibilities:

• Participated in business requirement walk-through and identify gaps.
• Worked and Developed a Project FROI (First Report of Injury) to submit the claims to the States.
• Worked in the balancing process to verify the Premium information is in sync across all the levels (i.e., Source to DataMart)
• Worked as a part of 24/7 Production support team.
• Created and executed unit test cases for various scenarios for all the mappings, workflows and scripts.
• Worked on resolving the Production issues by identifying the root cause and providing a feasible solution to resolve it.
• Extensively used Informatica Debugger for testing the mapping logic during Unit Testing.
• Participated in Performance Tuning of ETL maps at Mapping, Session, Source and Target level as well as writing Complex SQL Queries from ABSTRACT Data model.
• Worked in a team environment to meet the goals and expectations with respect to timeframes and productivity.
• Used Data Transformation to read the data from an XML source.
• Designed and developed complex ETL mappings making use of transformations like Source Qualifier, Expression, Joiner, Update Strategy, Connected Lookup and unconnected Lookup, Rank, Router, Filter, Aggregator and Sequence Generator transformations.

Environment: Informatica Power Center 9.5, SQL Server (2008/12), Data Transformation

Confidential

Informatica Consultant

Responsibilities:

• Analysis of business requirements and design of ETL solutions.
• Implementation of code with robust audit processes for efficient process tracking.
• Transformation and loading of data from source systems to different schemas based on the dimensions and fact tables by using the slowly changing dimensions type two and type one.
• Coding of ETL mappings and workflows (develop and unit test using Informatica Powercenter).
• Execute unit tests to ensure the mappings meet technical design specifications.
• Implementation of complex solutions using Dynamic lookups, Unconnected lookups and Stored procedure transformations.
• Development of unit test scripts, test conditions, expected results and sample data for ETL mappings.
• Execution of unit tests to ensure the mappings meet technical design specifications.
• Increased the team productivity by maintaining quick turnover time and efficient code practices.
• Addressed performance issues with the ETL processes and ensured best practices and standards are implemented.

Environment: Informatica PowerCenter 9.1, Oracle (RAC), Erwin 7.2, Oracle 11g/10g,TOAD

Confidential

Senior Informatica Developer

Responsibilities:

• Extraction of data from various source systems like Oracle, Flat files DB2 etc. and loading of data into Enterprise Data ware house.
• Worked on Power Center Designer client tools like Source Analyzer, Target Designer, Mapping Designer and Mapplet Designer.
• Created Mapplets with the help of Mapplet Designer and used those Mapplets in the Mappings.
• Created reusable transformations and mapplets by using Lookup, Aggregator, Normalizer, Update strategy, Expression, Joiner, Rank, Router, Filter, and Sequence Generator etc. in the Transformation Developer and Mapplet Designer respectively.
• Working with the operations team to resolve production issues and assist in defect resolution.
• Raised change requests, incident Management, analyzed and coordinated resolution of program flaws in the development environment and hot fixed them in the QA, Pre-Prod and prod environments during the runs.
• Created an infrastructure to ensure data quality and appropriate data linkage and deliver self service reporting to business and speeding and improving the decision making.
• Used Parameter files to reuse the mapping with different criteria to decrease the maintenance.
• Experience in using XQuery to extract and manipulate data from XML documents.
• Used Informatica Data Migration to decrease the risk and minimize the errors.
• Used UC4 to schedule Informatica, SQL script and shell script jobs.

Environment: Informatica 8.x, Power Exchange, Erwin 7.2, Flat Files, XML, Oracle 10g,TOAD, DB2,SQL Server 2008/2005, PL/SQL, UNIX, UC4,SSAS 2005

Confidential

Senior Informatica Developer

Responsibilities:

• Led the effort of design and analysis to gather requirements and define scope of the Data Migration.
• Define and capture metadata and rules associated with ETL processes.
• Code ETL mappings (develop and unit test using Informatica Powercenter).
• Implement business driven requirements using Informatica.
• Develop unit test scripts, test conditions, expected results and sample data for ETL mappings.
• Worked creating proof of concept with Netezza loading a Data warehouse model. Involved in connecting to the Netezza Database objects and running a prototype Informatica load for Mappings created against Netezza Database objects.
• Extensively used Informatica Designer, Workflow Manager, Repository Manager and Workflow Monitor.
• Assist in defect resolution process during testing and production support including completing code fixes, tracking and recording defect resolutions, working closely with test execution resources to identify and resolve issues and re-execute unit test scripts.
• Informatica workflow manager was used to create, schedule, execute Sessions, Worklets, Command, E-Mail Tasks and Workflows.
• Performed validation and loading of the Flat files received from business users. Wrote UNIX Shell scripts for Informatica ETL Tool.
• Developed complex Procedures, Functions, and Triggers etc to implement ETL solution through PL/SQL.
• Escalate issues to ETL lead in a timely manner. Identify options and recommend approach to resolve issues.
• Participate in code reviews and status meetings.

Environment: Informatica PowerCenter 8.6.1, Oracle, Netezza, Unix

Confidential

Informatica Developer

Responsibilities:

• Took major role in understanding the business requirements, designing and loading the data into Datamart.
• Used ETL (Informatica) to load data from CDW (DB2) to Oracle Datamart (SFCDM).
• Worked on Power Center Designer client tools like Source Analyzer, Target Designer, Mapping Designer and Mapplet Designer.
• Moving the data from source systems to different schemas based on the dimensions and fact tables by using the slowly changing dimensions type two and type one.
• Informatica workflow manager was used to create, schedule, execute Sessions, Worklets, Command, E-Mail Tasks and Workflows. Performed validation and loading of the Flat files received from business users. Wrote UNIX Shell scripts for Informatica ETL Tool.
• Participated in Performance Tuning of ETL maps at Mapping, Session, Source and Target level as well as writing Complex SQL Queries from ABSTRACT Data model.
• Tuned SQL Queries in Source qualifier Transformation for better performance.
• Created and executed unit test cases for various scenarios for all the mappings, workflows and scripts.
• Used Parameter files to reuse the mapping with different criteria to decrease the maintenance.
• Extensively used Informatica Debugger for testing the mapping logic during Unit Testing.
• Provided data to the reporting team for their daily, weekly and monthly reports.
• Used Autosys to schedule Informatica, SQL script and shell script jobs.

Environment: Informatica 8.x, Power Exchange, Erwin 7.2/4.0, Flat Files, Oracle 9i, Rapid Sql, DB2,SQL Server 2008/2005, PL/SQL, UNIX, Clear Case, IBM Rational Doors, HP ALM, Autosys.

Confidential

ETL Developer

Responsibilities:

• Developed and maintained ETL (Data Extract, Transformation and Loading) mappings to extract the Data from multiple source systems like Oracle, and Flat Files and load into Warehouse through STAGE and ODS.
• Scheduled Sessions and Batches on the Informatica Server using Informatica Server Manager/Workflow Manager.
• Worked with pmcmd to interact with Informatica Server from command mode and execute the shells scripts.
• Involved in fixing of Invalid Mappings, testing of Stored Procedures and Functions, Unit and Integration Testing of Informatica Sessions, Batches and Target Data.
• Generated Test Scenarios and monitored the regulatory changes using Quality Center.
• Worked on UNIX machine to connect to the Oracle database and run PL/SQL scripts.
• Tuned SQL queries for better performance.
• Optimized the mappings by changing the logic to reduce run time.
• Developed the mappings to extract the data on incremental load basis.
• Developed reusable transformations for Date Conversion.

Environment: Informatica Power Center 8.6.1, Oracle 9i, SQL/ANSI SQL, DB2, ERWIN 4.0, Unix-AIX4.3, Test Director, VSAM.

Confidential

Informatica Consultant

Responsibilities:

• Designed ETL solutions for bidirectional data exchange with corporate partner, integration of SAP financial and MDM accounts for a legal compliance requirement.
• Implemented SDLC methodologies, best practices and mentored the team to adopt the same.
• Remedied the existing processes to minimize risk of failures and smooth production rollover.
• Led a time critical data migration project enabling the retirement of the legacy system.
• Worked closely with business partners to gather requirements and analyze them.
• Coded ETL mappings and workflows (develop and unit test using Informatica Powercenter).
• Used Teradata utilities like Tpump and FastLoad to load data into Teradata data warehouse from Oracle.
• Developed reusable code for implementing Slowly Changing Dimensions.
• Developed Crystal reports integrating SAP data and data from Quality control systems to help supply chain and planning team which helped reduce overstocking materials.
• Automated the ETL processes by implementing filewatcher logic.

Environment: Informatica PowerCenter 8.6.1, Oracle 10g, Teradata12, MC Service Desk, Crystal reports, BOE.

Confidential

ETL/Informatica Consultant

Responsibilities:

• Took major role in understanding the business requirements, designing and loading the data into Enterprise data warehouse.
• Used ETL (Informatica) to load data from source to Oracle DWH.
• Participated in Performance Tuning of ETL maps at Mapping, Session, Source and Target level as well as writing Complex SQL Queries from ABSTRACT Data model.
• Used techniques like source query tuning, single pass reading and caching lookups to achieve optimized performance in the existing sessions.
• Used Informatica client tools - Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer, and Transformation Developer for defining Source & Target definitions and coded the process of data flow from source system to data warehouse.
• Developed mappings to extract data from SQL Server, Oracle, Flat files, DB2, Mainframes and load into Data warehouse using the PowerCenter, power exchange.
• Participated in Performance Tuning of ETL maps at Mapping, Session, Source and Target level as well as writing Complex SQL Queries from ABSTRACT Data model.
• Created complex Informatica mappings using reusable objects of Mapplets depending on client requirements.
• Used UNIX Shell scripting for automation of the process, invoking PL/SQL procedures, and Informatica sessions.
• Implemented performance tuning logic on Targets, Sources, mappings, sessions to provide maximum efficiency and performance.

Environment: Informatica Power Center 7.x, SQL, PL/SQL, Oracle 9i, MS SQL server 2005, DB2,TOAD 8.5, Erwin 4.0, Unix Scripting, Flat Files, Windows NT/2000, Autosy.

Confidential

ETL /Informatica Developer

Responsibilities:

• Involved in study of existing operational systems, data modeling, analysis and translated business requirements into data mart design.
• Define the entity-relations - ER Diagrams and designed the physical databases for OLTP and OLAP (data warehouse).
• Identified all the dimensions to be included in the target warehouse design and confirmed the granularity of the facts in the fact tables.
• Used Informatica Data Migration to decrease the risk and minimize the errors.
• Created reusable transformations and mapplets based on the business rules to ease the development.
• Design and development of UNIX shell scripts to schedule jobs. Also wrote pre-session and post-session shell scripts.
• Optimization of performance of SQL queries.
• Developed workflow tasks like reusable Email, Event wait, Timer, Command and Decision.
• Used various debugging techniques to debug the mappings.
• Creating Test cases for Unit Test, System Integration Test and UAT to check the data quality.

Environment: PowerCenter7.x, Oracle9i, SQL Server 2000, SQL, PL/SQL, shell scripts, Toad 8.0, UNIX, Tivoli.