Summary:

• Around 7 years of extensive experience with Informatica Power Center in all phases of Analysis, Design, Development, Implementation and support of Data Warehousing applications using Informatica Power Center 8.X/7.X/6.X/5.X, SQL, PL/SQL, Oracle and Unix.
• Expertise in using Oracle 8i/9i/10g and had hands on experience in building advanced relational database objects which uses Oracle 8i/9i/10g database.
• Experience in full life cycle implementation of Data Warehouses.
• Involved in all the phases Analysis and Design, Data Modeling - ER Diagrams and Normalization, System Testing, Development, documentation and implementation.
• Strong experience in Extraction, Transformation and Loading of data from multiple sources into Data Warehouse and administrating the Informatica PowerCenter environment such as maintaining Informatica Repository and Server processes.
• Performing code migration from Dev to Test, backup and restoring of Informatica Repository, upgrades, security administration and versioning.
• Involved in ETL Architecture and Data modeling tool like Erwin.
• Troubleshooting and problem solving applications with Informatica Debugger.
• Validating,TESTING & Debugging ERRORS with in ETL Transformations.
• Experienced in creating entity relational & dimensional relational data models using Kimball/Inmon Methodology i.e. Star Schema and Snowflake Schema.
• Experience in Slowly Changing Dimensions (Type 1, Type 2 and Type 3), OLTP, OLAP, Data Reports and Surrogate keys, Normalization/De normalization.
• Designed complex mappings using Source Qualifier, Filter, Normalizer, Aggregator, Router, Updated Strategy, Union, Lookup, Joiner, Sorter and Stored Procedure Transformations.
• Developed various Data Documentation Standards and ETL Mapping Documentation using Informatica Velocity as a guideline to document the Mappings, Workflows and Data marts.
• Designed Reusable Transformations and Mapplets.
• Hands on experience in Performance Tuning of sources, targets, transformations and sessions
• Experience in all phases of the project life cycle and production support.
• Experience in writing PL/SQL stored procedures, functions, packages and triggers using PL/SQL developer.
• Proficient working experience in SQL, PL/SQL, Stored Procedures, Functions, Packages, DB Triggers, Indexes, SQL *Loader, SQL *Plus, External tables, Collections, Cursors and other database objects using SQL, PL/SQL.
• Worked with DAC for job scheduling.
• Expertise in fine performance tuning of SQL statements and PL/SQL modules using Explain Plan, SQL Trace for optimizing the cost and evaluating the performance.
• Experience in translating business requirements into creation of database objects: tables, indexes, constraints, packages, stored procedures, functions, and triggers using Oracle PL/SQL tool.
• Extensive experience in analysis and design of database, database modeling, ER Diagrams, normalization and de-normalization.
• Knowledge of working with tools like Toad and utilities like SQL*Loader.
• Experience in UNIX Shell Scripting (Korn & Bourne) on UNIX & Linux platform.
• Experienced in Installation, Configuration, and Administration of Informatica Power Center/Power Mart on Client/Server environment.
• Highly Proficient in Informatica Designer Components like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Transformation Developer, Workflow Manager and Workflow Monitor.
• Excellent analytical and logical programming skills with a good understanding at the conceptual level and possess excellent presentation, interpersonal skills with a strong desire to achieve specified goals. Excellent written and verbal communication skills including experience in proposal and presentation creation.
• Hands on experience on scheduling tools

Technical Skills:

ETL: Informatica 7.x/8.x/9.x, SQL Server 2005 (SSIS) Scheduling Tool: DAC (Data Warehousing Admin Console) Reporting Tool: Oracle Business Intelligence (OBIEE) 10.1.3X, SiebelAnalytics, Cognos Databases: Oracle11g/10g/9i/8i, MS SQL Server 2005/2000 Operating Systems: Windows 95/98/2000/2003 Server/NT Server Workstation 4.0, UNIX Programming: Visual Basic 6.0/5.0, PowerBuilder 6.0, C, SQL, PL/SQL, Java, HTML, XML, DHTML Other Tools: SQL*Loader, SQL*Plus, TOAD, MS Visio Scripting Languages: UNIX Shell Scripting Methodologies: E-R Modeling, Star Schema, Snowflake Schema Data Modeling Tool: Erwin 3.5/4.1

Professional Experience:

Confidential, AUG 11 - Present
Sr.Informatica Developer

Serving more than 2,500 U.S. hospitals and 76,000-plus other healthcare sites, the Premier healthcare alliance and its members are transforming healthcare together. Approximately 200 hospitals and health systems created and entirely own the Premier alliance. Premier\'s mission is "to improve the health of communities."

IPP/SADVISOR and PHYSICIAN FOCUS
Every physician wants to know how he is performing, and he also wants to compare with others in the same hospital and also in other hospital all over the country. So, we had created self, internal peer and External peer. All the mappings were done in Oracle database using Informatica. The performance was not as expected as assumed. So, the whole data is being migrated to Netezza and fix the bugs which rose during production. Performance increased by 49% during the testing.

Responsibilities:

• Designed ETL mapping based on Existing ETL logic.
• Worked with various transformations like Source Qualifier, Look up (connected and unconnected), Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Rank and Router transformations.
• Involved in the development of Informatica mappings and also tuned for better performance.
• Worked with Informatica and other consultants to develop IDQ plans to identify possible data issues.
• Applied business rules using Informatica Data Quality (IDQ) tool to cleanse data.
• Integrated Informatica Data Quality with Informatica Power Center.
• Installed IDQ on Informatica power center server machine.
• Involved in jobs scheduling, monitoring and production support in a 24/7 environment (with a paging system).
• Made substantial contributions in simplifying the development and maintenance of ETL by creating shortcuts, re-usable Mapplets and Transformation objects.
• Implemented slowly changing dimensions Type 1, and Type 2 methodology for accessing the full history of accounts and transaction information.
• Provided data loading, monitoring, system support and general trouble shooting necessary for all the workflows involved in the application during its production support phase.
• Provided production support by monitoring the processes running daily.
• Created, optimized, reviewed, and executed SQL test queries to validate transformation rules used in source to target mappings/source views, and to verify data in target tables.
• Taken part of Informaticaadministration. Migrated development mappings as well as hot fixes them in production environment.
• Used Informatica scheduling for defining, scheduling, monitoring the jobs
• Extensively used ETL to load data from flat files (excel/access) to Oracle.
• Load balancing of ETL processes, database performance tuning and Capacity monitoring.
• Made adjustments in Data Model and SQL scripts to create and alter tables.
• Worked extensively on SQL, PL/SQL, Perl and UNIX shell scripting.
• Analyzed the source system of ETL Maps.
• Developed the ETL routines.
• Designed and developed the fact/dimension entities.
• Involved in the Unit testing, Event & Thread testing and System testing of the individual
• Written Unix Shell Scripting based on requirements
• Performed unit testing of the shell scripts developed with various scenarios.
• Worked in Agile environment.

Environment: Informatica Power Center 9.1, Netezza, Oracle 11i/10g, SQL Server 2005, MS Excel, UNIX, Shell Scripting, DAC, Cognos.

Confidential, NOV 10 - AUG 11
Sr.Informatica Developer

GE is an advanced technology services and finance company taking on the world’s toughest challenges, dedicated to innovation in energy, health, transportation and infrastructure.

TKL Project
Transform Knowledge Language.
The overall project goal is to know how many users are using it, how many clicks are happening in a particular day, how much time a costumer is spending and how many downloads are done on a particular file.

Responsibilities:

• Involved in system study, analyses of the requirements and designing of the complete system.
• Worked closely with business analysts to understand and document business needs for decision support data.
• Designed and developed complex aggregate, join, look up transformation rules (business rules) to generate consolidated (fact/summary) data identified by dimensions using Informatica ETL (Power Center) tool.
• Used Informatica features to implement Type I changes in slowly changing dimension tables.
• Used the Update Strategy Transformation to update the Target Dimension tables.
• Developed ETL procedures to transform the data in the intermediate tables according to the business rules and functionality requirements.
• Used Repository manager to create user groups and users, and managed users by setting up their privileges and profile
• Created Complex mappings using Connected/Unconnected Lookup, Aggregator and Router transformations for populating target table in efficient manner.
• Created Mapplets and used them in different Mappings.
• Used designer debugger to test the data flow and fix the mappings. Tuned Informatica Mappings and Sessions for optimum performance.
• Involved in writing various PL/SQL stored procedures, functions and packages.
• Provided detailed technical, process and support documentation like daily process rollback and detailed specifications and very detailed document of all the projects with the workflows and their dependencies.
• Worked with mapping parameters and variables to load data from different sources to corresponding partition of the database table.
• Created events and tasks in the work flows using workflow manager
• Created Schema objects like Indexes, Views, and Sequences.
• Created mappings using the Transformations such as the Source qualifier, Aggregator, Expression, lookup, Filter, Router, Rank, Sequence Generator, Update Strategy etc.
• Used Informatica Workflow Manager and server to read data from sources to write to target databases, manage sessions/tasks and to monitor server ETL Implemented for Oracle and SQL Server.
• Worked with DAC for job scheduling.
• Production Support and issue resolutions.
• Created test cases and completed unit, integration and system tests for sales data mart system.
• Involved in writing procedures, functions in PL/SQL.
• Involved in Unit testing of Mappings, Workflows and debugging mappings for failed sessions.
• Created partitions, SQL over ride in source qualifier, session partitions for improving performance.
• Performed unit testing and system testing of the mappings developed and documented with various scenarios.
• Written Unix Shell Scripting based on requirements
• Worked in Agile environment.

Environment: Informatica Power Center 9.1,Informatica Power Center 8.6.1, Oracle 11i/10g, SQL Server 2005, UNIX, Shell Scripting, MS Excel, DAC, Cognos.

Confidential,Atlanta, GA AUG 09 – OCT 10
Informatica Developer/Analyst

AutoTrader.com, the biggest and best used car site on the planet, with more than 3 million vehicle listings and over 12 million qualified buyers each month;

Ad Impressions DataMart
The overall program goal for the Site Metrics 1.0 project is to provide data that is accurate, consistent and that will enable each business unit to make sound decisions. The objective of this project’s Definition is to identify the current ad impressions metrics and attributes required to design and develop a new data mart in the ATC data warehouse.

Automated Incentive System
AutoTrader.com pays monthly commissions to its sales employees, and quarterly incentives to employees that support our Customers. The objective of this project is to implement a solution that will automate the calculation of commissions and incentives. The solution should integrate with internal ATC applications [wherever possible] to gather all relevant and pertinent data, thereby improving the accuracy and efficiency of the current process

Data Exports:
Involved in multiple projects involving FTP File transfers sent to third Parties and automated through ETL.

Responsibilities:

• Involved with Business Analysis team in collecting the business requirements based on user specifications and transformed them into ETL Specs.
• Created Design/Technical documents to handle various process and the necessary dependencies so that the developers can refer it as a design document.
• Have worked on ODS/Staging environment in Data ware house projects.
• Fine Tuned the SQL queries using hints for maximum efficiency and performance.
• Interacting with the users and troubleshooting the problems involved with the development of stored procedures, triggers and with the privileges.
• UsedTeradata’s BTEQ, FLOAD, MLOAD and Sql Assistant for data testing, analysis and loading
• Extensively worked with stored procedure, Expression, Filter, Joiner, Source Qualifier, Look up, Router, Update strategy and Aggregator transformations.
• Analyzed performance bottlenecks, tuned various mappings and created reusable transformations to increase the performance.
• Have discussed/finalized standards for various ETL coding.
• Designed and developed complex mappings using various transformations in Designer to load data from Flat Files, SQL Server, Oracle 9i into the target Data warehouse
• Developed several Informatica mappings for Extraction/Transformation, data cleansing and loading of data into staging areas and data marts.
• Developed pre-session, post-session routines to drop indexes and to reassign them and batch execution routines to run Informatica sessions.
• Created various tasks, arranging related tasks in different worklets, arranged different worklets in workflow depending upon their interdependencies in workflow manager.
• Developed parameter file templates and used parameters, variables to make mappings more flexible, also developed shell scripts to automate the process.
• Automated sending Car data files to the third party users through FTP
• Performed unit testing and system testing of the mappings developed and documented with various scenarios.
• Used ETL Metadata tables to verify performance of the various sessions used in the workflow and fine tune for the long running sessions.
• Closely worked with the production support team and data team to recover from issues and various defects that encounter while running the jobs and analyzing the data.
• Worked with DAC for job scheduling.

Environment: Informatica Power Center 8.6.1, Oracle 11i/10g, ERWIN, SQL Server 2005, XML files, UNIX , Shell Scripting, MS Excel , DAC.

Confidential,Irving, TX AUG 08 – AUG 09
Informatica Developer/Analyst

Verizon Wireless is one of the top telecom companies. The primary objective of this project was to provide a central repository of the customer information, service usages, billing information, and account details of partners, resellers, residential and business subscribers.

Responsibilities:

• Working with Business analysts to understand business/system requirements in order to transform business requirements into effective technology solutions.
• Working on Informatica tools like Designer, Workflow Manager, and Workflow Monitor.
• Working mostly on Lookup, Aggregator, Router and Expression Transformations to implement complex logics while coding a Mapping.
• Monitoring the Jobs, observing the performance of the individual transformations and tuning the code.
• Creating Indexes on tables for most retrieved fields of tables and views.
• Follow up with appropriate documents for the Change Management, Incident Management, and Problem Management.
• Worked with Informatica and other consultants to develop IDQ plans to identify possible data issues.
• Applied business rules using Informatica Data Quality (IDQ) tool to cleanse data.
• Integrated Informatica Data Quality with Informatica Power Center.
• Installed IDQ on a informatica power center server machine.
• Involved in jobs scheduling, monitoring and production support in a 24/7 environment (with a paging system).
• Made substantial contributions in simplifying the development and maintenance of ETL by creating shortcuts, re-usable Mapplets and Transformation objects.
• Implemented slowly changing dimensions Type 1, and Type 2 methodology for accessing the full history of accounts and transaction information.
• Provided data loading, monitoring, system support and general trouble shooting necessary for all the workflows involved in the application during its production support phase.
• Provided production support by monitoring the processes running daily.
• Created, optimized, reviewed, and executed SQL test queries to validate transformation rules used in source to target mappings/source views, and to verify data in target tables.
• Taken part of Informaticaadministration. Migrated development mappings as well as hot fixes them in production environment.
• Used Informatica scheduling for defining, scheduling, monitoring the jobs.
• Involved in analyzing the year end process and managed the loads that have yearend aggregations.
• Was involved in Informatica Power Exchange to import SQL Server Source.
• Was involved in Informatica Power Exchange to test the data at mainframe .dat files.
• Executed sessions, both sequential and concurrent for efficient execution of mappings and used other tasks like event wait, event raise, email, command and pre/post SQL.
• Created Workflows with worklets, event wait, decision box, email and command tasks using Workflow Manager and monitored them in Workflow Monitor.
• Creating stored procedures, sequences and triggers to insert key into the database table.
• Created Pre/Post Session/SQL commands in sessions and mappings on the target instance.
• Used the command line program pmcmd to run Informatica jobs from command line. And used these commands in shell scripts to create, schedule and control workflows, tasks and sessions.
• Provided detailed technical, process and support documentation like daily process rollback and detailed specifications and very detailed document of all the projects with the workflows and their dependencies.
• Involved in writing shell scripts for file transfers, file renaming and several other database scripts to be executed from UNIX.
• Created documents for data flow and ETL process using Informatica mappings to support the project once it implemented in production.
• Created and Documented ETL Test Plans, Test Cases, Test Scripts, Expected Results, Assumptions and Validations.

Environment: Informatica Power center 8.6.1, Informatica Power Exchange 8.6.1, Oracle 10g/11g, SQL Server 2008, MS Excel, Toad for Oracle,DB2, Flat Files, WinNT 4.0, UNIX, Linux, AIX and COGNOS.

Confidential,Houston, TX JAN 08– AUG 08
Sr. Informatica Developer

Description:
BP is of one of the world\'s largest energy companies with well-established operations in the UK and the rest of Europe, North and South America, Asia, Australasia, Africa and Russia. Enterprise Data Warehouse (EDW) was intended to be global data warehouse system to enable Exposure and Risk estimations by downstream systems like Strategic Credit Risk (SCR), Gross Margin Reporting (GMR), and other future systems.

Responsibilities:

• Coordinated/Managed the development and project implementation and production support activities.
• Participated in business analysis, ETL requirements gathering, physical and logical data modeling and documentation.
• Designing the data transformation mappings and data quality verification programs using Informatica and PL/SQL.
• Extracted source definitions from various databases like Oracle, Sybase, MS SQL Server, MS Access and Flat-files into Informatica repository.
• Developed and Tested Mappings using Informatica Power Center Designer.
• Designed Reusable Transformations and Mapplets. Used most of the Transformations like Source Qualifier, Joiner, Update Strategy, Lookup, Rank, Expressions, Aggregator, Filter, and Sequence Generator for loading the data into Oracle database.
• Designed Workflows, reusable Tasks and Worklets using Informatica Workflow Manager SQL and Database tuning.
• Investigate, debug and fix problems with Informatica Mappings and Workflows, BO reports
• Participated in Decision support team to analyze the user requirements and to translate them to technical team for new and change requests.
• Performed unit and integration testing in User Acceptance Test (UAT), Operational Acceptance Test (OAT), Production Support Environment (PSE) and Production environments.
• Technical Documentation.

Environment: Informatica Power Center 8.1, Oracle 9i, MS SQL Server 2000, PL/SQL, and MS Access.

Confidential,OK Sept 06– Dec 07
Informatica Developer

Description:
Devon Energy Corporation is a leading independent natural gas and oil exploration and production company. The company\'s portfolio of gas and oil properties provides stable, environmentally responsible production and a platform for future growth. The business’ IM environment uses a version of the Decision stream tool associated with its ERP and non-ERP databases that is de supported by the decision stream and not certified with its Oracle 9i upgraded databases. Objective of the project is to perform the migration of Decision Stream tool to Informatica to ensure compliance with Devon tech stack and to reduce business risk from inter-compatibility and lack of vendor support.

Responsibilities:

• Involved in gathering the business requirements and molding them in to the technical specifications required for the conversions team.
• Designed ETL mapping based on Existing ETL logic.
• Worked with various transformations like Source Qualifier, Look up (connected and unconnected), Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Rank and Router transformations.
• Involved in the development of Informatica mappings and also tuned for better performance.
• Extensively used ETL to load data from flat files (excel/access) to Oracle.
• Load balancing of ETL processes, database performance tuning and Capacity monitoring.
• Made adjustments in Data Model and SQL scripts to create and alter tables.
• Worked extensively on SQL, PL/SQL, Perl and UNIX shell scripting.
• Analyzed the source system of ETL Maps.
• Developed the ETL routines.
• Designed and developed the fact/dimension entities.
• Involved in the Unit testing, Event & Thread testing and System testing of the individual
• Co-ordination with Client Business & Systems team for QA.
• Performed the tuning of ETL SQLs.

Environment: Informatica Power Center 7.1.2, Oracle9i, SQL, PL/SQL, SQL*PLUS, SQL Server, UNIX, Windows NT, and MS Excel.