SUMMARY

• Over 7+ years of IT experiences in Data Warehousing (ETL) Requirements Gathering, Analysis, Design, Development, Implementation, Integration, Testing, Profiling, Cleansing and Validation of data using the Technology, Informatica PowerCenter/Data Quality (IDQ) from versions 7.1 to 9.1 for Health Care, Insurance, Bank and Wireless Industries in different Methodologies.
• Hands on Data Warehousing ETL experience of using Informatica 9.1/8.6.1/7.1 PowerCenter Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools - Informatica Server, Repository Server manager.
• Expertise in Data Warehouse/Data mart, ODS, OLTP and OLAP implementations teamed with project scope, data modeling, ETL development, System testing, Implementation and production support.
• Experienced to Profile, Analysis, Standardize, Clean, Integrate, Score Carding, and Reference Data from various source systems using Informatica Data Quality (IDQ) Toolkit. Worked with Address Doctor, different algorithms, Biogram/Jaro/Edit/Hamming/Reverse distance in IDQ.
• Used transformations like Joiner, Expression, Connected and Unconnected lookups, Filter, Aggregator, Store Procedure, Rank, Update Strategy, Router and Sequence generator.
• Designed ETL process using Informatica Tool to load from Sources to Targets through data Transformations.
• Experience in Dimensional Modeling using Star and Snow Flake Schema, Identifying Facts and Dimensions, Physical and logical data modeling using ERwin and ER-Studio.
• Expertise in working with relational databases such as Oracle 11g/10g, SQL Server 2008/2005 and Teradata.
• Hands on experience in developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries using SQL Server, Oracle SQL and Oracle PL/SQL.
• Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.
• Experience in all phases of Data warehouse development from requirements gathering for the data warehouse to develop the code, Unit Testing and Documenting.
• Proficient in the Integration of various data sources with multiple relational databases like Oracle11g /Oracle10g, MS SQL Server, DB2, Teradata, VSAM files and Flat Files into the staging area, ODS, Data Warehouse and Data Mart.
• Experience in using Automation Scheduling tools like Autosys and Control-M.
• Worked extensively with slowly changing dimensions.
• Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, system integration and user acceptance testing.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.0.1/8.6.1/8.5.1/8.1.1/7.1 , Metadata Manager 9.0.1, Informatica Data Quality 8.6.1, Informatica Data Explorer 8.6.1

CRM: Siebel Tools 7.8/7.5.3, EIM, EAI, Sales force CRM, Analytics

OLAP Tools: Oracle BI Enterprise Edition 10.1.3.2.1 , Business Objects XI 11.2.

Data Modeling Tools: Erwin 4.5/4.0, MS-Visio 2000/2005, Sybase Power Designer 15.2

Databases: Oracle 11g/10g/9i/8i/7.3, IBM DB2, MS Access, SQL Server 2000/2005, MS Access, MS Excel, Flat Files

Database Tools: SQL *Plus, TOAD 8.6/7.6

Programming Languages: SQL, PL/SQL, C, C++, JAVA, VISUAL BASIC 2003, 2005

Operating System: MS-DOS, MS-Windows 2003 Server/Vista/XP/98/95, UNIX

Applications: MS Word, Excel, Outlook, FrontPage, PowerPoint, Dreamweaver 8

PROFESSIONAL EXPERIENCE

Confidential, Buffalo, NY

ETL Informatica Developer

Responsibilities:

• Analyzed the systems, met with end users and business units in order to define the requirements.
• Involved in the requirement definition and analysis in support of Data Warehousing efforts.
• Developed ETL mappings, transformations using Informatica PowerCenter.
• Extensively used Informatica client tools Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Informatica Workflow Manager.
• Extensively used ETL Tool Informatica to load data from Flat Files, Oracle, SQL Server and DB2.
• Developed data Mappings between source systems and warehouse components using Mapping Designer.
• Developed and Implemented Error Handling Strategies.
• Developed reusable Mapplets and Transformations.
• Developed and tested all the Informatica mappings and update processes.
• Developed data Mappings between source systems and warehouse components using Mapping Designer.
• Worked extensively on different transformations like source qualifier, Expression, Filter, Aggregator, Router, Update strategy, lookup, Normalizer, Stored procedure, Mapping Variables and Sequence generator.
• Successfully Implemented Slowly Changing Dimensions. Used Type 2 dimension to keep the history changes.
• Responsible for tuning ETL procedures to optimize load and query Performance
• Setting up Batches and sessions to schedule the loads at required frequency using Power Center Workflow manager.
• Involved in Writing Shell scripts to automate the Pre-Session and Post-Sessions Processes.
• Trouble shoot connectivity problems, Looked up and read session, event and error logs for troubleshooting
• Developed and maintained Reports using Business Objects
• Involved in Designing BO reports & Universe & guiding designers and developers for each component.
• Worked closely with the testing team for the testing of maps.
• Worked on Pre-Production and Post-Production Issues. Good Understanding of the EDI (Electronic data interchange), Implementation and Knowledge of HIPAA code sets.
• Involved in Up-gradation of HIPAA X12 4010 transactions to HIPAA X12 5010 and ICD-9 to ICD-10
• Worked on HIPAA Transactions and Code Sets Standards according to the test scenarios such as 270/271, 276/277,837/835 transactions.
• Generated, published and scheduled reports in Web Intelligence.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.

Environment: Informatica Power Centre 9.1, Oracle 11g, UNIX, SQL Server 2008, MS Office, WinSCP, Toad, Teradata, Power Exchange 8.1,SSIS, PL/SQL,UNIX, Business Objects 5.1, Shell script and Perl Scripts.

Confidential, Dallas, TX

ETL Developer/Designer

Responsibilities:

• Worked with Informatica Data Quality 8.6.1 (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities of IDQ 8.6.1.
• Identified and eliminated duplicates in datasets thorough IDQ 8.6.1 components of Edit Distance, Jaro Distance and Mixed Field matcher, It enables the creation of a single view of customers, help control costs associated with mailing lists by preventing multiple pieces of mail.
• End-to-end ETL development of the Data Mart. Designed and developed Informatica mappings for data loads.
• Informatica Data Quality (IDQ 8.6.1) is the tool used here for data quality measurement.
• Designed, developed, implemented and maintained Informatica Power Center and IDQ 8.6.1 application for matching and merging process.
• Utilized Informatica IDQ 8.6.1 to complete initial data profiling and matching/removing duplicate data.
• Extensively used ETL and Informatica to load data from Oracle, MS SQL Server, flat files into the target Oracle database.
• Informatica Data Explorer (IDE) and Informatica Data Quality (IDQ 8.6.1) are the tools are used here. IDE is used for data profiling over metadata and IDQ 8.6.1 for data quality measurement.
• Developed mappings and workflows which supported the mappings in Power Center, IDQ and MDM
• Exported the IDQ Mappings and Mapplets to power center and automated the scheduling process.
• Knowledge of data profiling using Informatica Data Quality(IDQ
• Experienced with DVO, Informatica Data Quality (IDQ) tools for Data Analysis / Data Profiling and Data Governance.
• Designed, tested, and deployed plans using IDQ 8.5

Environment: Informatica Power Center 8.6.1 7.1, Informatica Data Quality (IDQ), Oracle 11g/10g, SQL, PL/SQL, TOAD, WinSCP, UNIX Shell Scripting, MS-SQL Server 2008, SQL-Developer

Confidential, Minneapolis, MN

ETL Informatica Developer

Responsibilities:

• Client Interaction, Design, Testing, Support and Documentation.
• Interact with Stake Holders for developing strategies and future requirements.
• Altering the Database Design as per Business Users requirements to meet DATA MIGRATIONS from legacy systems.
• Responsible for creating Deployment groups and deploying them into various environments.
• Raise cases with Informatica and assist the team in solving the Informatica issues.
• Extensively worked on Informatica PowerCenter 8.6/7.1.4 for Extraction, Transformation and Loading of data from various sources into the target database which is in Oracle 11g/Oracle 10g.
• Created SOP's for Organization to enable smooth Knowledge Transfers.
• Created various Informatica jobs using transformations such as Update Strategy, Sorter, Aggregator, Router, and Reusable Sequence Generator etc.
• Designed Reusable Transformations using the Transformation Developer & created Mapping Parameters and Variables.
• Performed column and cross table structural profiling by using Informatica Data Explorer.
• Extensively used Teradata utilities FastLoad, Multiload to load from Teradata database to Oracle
• Performed Data profiling by making use of Metadata in an efficient way using Informatica and SQL Server.
• Extensively used Teradata utilities FastLoad, Multiload to load from Teradata database to Oracle
• Created various Informatica tasks such as Sessions, Email, Decision, Control, Command, Timer, Assignment, Event Wait and Event Raise. Used UNIX Shell Scripts for processing the jobs.
• Tuned Informatica sessions for better performance using various strategies based upon the analysis performed.
• Created and ran pre-existing and debug sessions in the Debugger to monitor and test the sessions prior to their normal run in the Workflow Manager.
• Design and Development of data validation, load processes, test cases and error control routines using PL/SQL, SQL.
• Involved in unit and integration testing of the various Informatica sessions.
• Coordinated in Testing, writing and executing test cases, procedures and scripts, creating test scenario.
• Co-ordinate changes in the source. Designed and developed implementation strategies to implement source structures changes.
• Responsible for creation of implementation strategies, procedures & standards.
• Manage & Coordinate the support team at different stages such as backup & recovery, enhancements etc.

Environment: Informatica, Power Center 8.6, Oracle 9i, PL/SQL Developer, SQL*Loader, Toad, ER-Studio, UNIX, Informatica 8.6

Confidential, Dallas, TX

ETL Informatica Consultant

Responsibilities:

• Design of ETL mappings for the CDC change data capture
• Extensively used various transformations like Filter, Router, Sequence Generator, Look Ups, Update Strategy, Joiner, Source Qualifier, Expression, Sorter, and Aggregator.
• Extensively used Mapping Variables, Mapping Parameters, and Parameter Files for the capturing delta loads
• Worked with various tasks like Session, E-Mail, Workflows, Worklets, and Command
• Worked with the Informatica Scheduler for scheduling the delta loads and master loads
• Extensively worked with aggregate functions like Avg, Min, Max, First, Last, and Count in the Aggregator Transformation.
• Extensively used SQL Override, Sorter, and Filter in the Source Qualifier Transformation.
• Extensively used Normal Join, Full Outer Join, Detail Outer Join, and master Outer Join in the Joiner Transformation.
• Extensively worked with various re-usable tasks, workflows, Worklets, mapplets, and re-usable transformations
• Implemented various new components like increasing the DTM Buffer Size, Database Estimation, Incremental Loading, Incremental aggregation, Validation Techniques, and load efficiency
• Worked with slowly changing dimension Type1, Type2, and Type3
• Performance tuning of the process at the mapping level, session level, source level, and the target level
• Extensively used Mapplets for use in mappings thereby saving valuable design time and effort
• Responsible for Production Support
• Worked with the Business Intelligence tools like Business Objects and Crystal Reports
• Extensively worked with various Look up Caches like Static, Dynamic, Persistent, and Shared Caches.
• Worked with session logs, Informatica Debugger, and Performance logs for error handling when we had workflows and session fails
• Worked extensively with the business intelligence team to in corporate any changes that they need in the delivered files

Environment: Informatica Power Center 7.1/6.2(Repository Manager, Designer, Workflow Manager, and Workflow Monitor), Oracle 9i, SQL Server, CA Autosys, Teradata (T-Pump, Fast Load, Multi Load), Business Objects, UNIX, Windows XP, Autosys

Confidential

ETL Developer

Responsibilities:

• Involved in functional specification Analysis and prioritizing requirements.
• Study on the existing systems used for operational data management in Oracle 8
• Creating the Source Definitions, Target Definition and Mapping in Informatica Designer.
• Designed the mappings between sources to operational staging targets
• Creating reusable transformations and mappings (using store procedures for Transformation.
• Configuring and running test sessions using Server Manager available with Informatica.
• Used workflow manager for session management, database connection management and Scheduling of jobs to be run in the batch process.

Environment: /Tools: Informatica Power centre, Oracle, PL/SQL, MS Excel, Windows NT 4.0

Confidential

Responsibilities:

• Involved in meetings with Business analysts to gather the requirements and analysis of data
• Prepared technical approach documents on how to implement the design changes needed and got the approval from the Architects before starting the development work.
• Used the advanced features and implemented various techniques at Informatica level and database level to improve the performance of the applications
• Created Optimized Stored Procedures to match the business logic and for better performance.
• Identifying and tracking the slowly changing dimensions, heterogeneous Sources and determining the hierarchies in dimensions.
• Enhanced session and workflows performance by applying performance tuning on targets, sources, mappings and sessions.
• Scheduled ETL process on daily basis, Weekly Basis, monthly basis.
• Scheduling the sessions to load the data into the target for testing.
• Prepared test plans and test data and performed unit testing as well as integration testing of the system with full load.

Environment: Informatica PowerCenter 7.1, Oracle, PL/SQL, SQL Server 2005, Windows Server, Linux