SUMMARY

• About 7+ years of extensive experience in Information Technology SDLC (Software Development Life Cycle) with a strong background in Database development and Data warehousing that includes experience inData Integration, Migration and ETL process using Informatica Power Center 9.x/8.x/7.x/6.x.
• Experience in Design & Development of Enterprise Data Warehouse infrastructure processes for extracting, transforming and loading data
• Strong experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Metadata Manger), Power Exchange, Power Connect as ETL tool on Oracle, DB2 and SQL Server Databases.
• Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping & Mapplet Designer and Transformation Designer.
• Efficient in all phases of the development lifecycle, coherent with Data Cleansing, Data Conversion, Performance Tuning and System Testing.
• Create mappings using reusable components like worklets, mapplets using other reusable transformations.
• Worked on Informatica Source Analyzer, Mapping Designer & Mapplet, and Transformations.
• Extensively used SQL and PL/SQL for development of Procedures, Functions, Packages and Triggers.
• Knowledge of Informatica components required to operate Data Quality (PowerCenter required).
• Experience with Dimensional Data Modeling, Star Schema Modeling, Snowflake Modeling, Physical and Logical Data Modeling using Erwin and ER-Studio.
• Create mappings using reusable components like worklets, mapplets using other reusable transformations.
• Well acquainted with Informatica Designer Components - Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet and Mapping Designer.
• Worked extensively with complex mappings using different transformations like Source Qualifiers, Expressions, Filters, Joiners, Routers, Union, Unconnected / Connected Lookups and Aggregators.
• Strong Experience in developing Sessions/tasks, Worklets, Workflows using Workflow Manager Tools - Task Developer, Workflow & Worklet Designer
• Over 6 years of Data Warehousing ETL experience, using Informatica Power Center 9.5/9.1, Oracle Warehouse Builder
• Good understanding of Views, Synonyms, Indexes, Joins, and Sub-Queries.
• Extensively used Informatica Repository Manager and Workflow Monitor.
• Experience in debugging mappings, Identifying bugs in existing mappings by analyzing the data flow and evaluating transformations.
• Expertise in working with relational databases such as DB 2 9.7/8.0/7.0 , Informix IDS 7.31/11.x, Oracle 11g/10g/9i/8x, SQL Server 2008/2005.
• Experience in Unix Shell Scripting, DOS batch scripting, SQL, PL/SQL.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.5/9.1/8.6.1/8.5/7.1 , informatica IDQ 9.1 Warehouse Builder 9.2, 10g (Rel 1 and 2);, MS BI SSIS 2005/2008

Databases: DB 2 9.7/8.0/7.0 , Oracle 10g/9i/8i, Informix IDS 7.31/11.x,SQL Server 2008/2005/2000 , MS Access

Data Modeling: ERWIN 3.1/4.0, ER-Studio, MS Visio

Programming Tools: UNIX Shell Scripting, SQL, PL/SQL, HTML, XML, Java, Perl

Tools: Clear case, Visual Source Safe, Autosys, Control - M, Toad, SQL Developer

Environment: Windows 95/98/2000/2005/2008/ XP, UNIX - Sun Solaris 2.x, IBM-AIX

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Sr. ETL Developer

Responsibilities:

• Involved in requirements gathering and design of data warehouse and data mart entities to integrate data from various source systems.
• Involved in design and executed the technical characteristics of the overall strategy of the data warehouse and ETL process capable of near real time reporting.
• Define conceptual models, develop logical and physical models using Erwin data modeling tool.
• Documenting user requirements, translated requirements into system solutions and developed implementation plan and schedule.
• Designed and developed PL/SQL Procedures and Functions.
• Preparing software requirement specifications, business rules interacting with business units and designed ETL process.
• Extensive experience in extraction, transformation and loading of data from heterogeneous source systems like flat files, Oracle, SQL server.
• Developing Informatica ETL mappings using complex transformations, Mapplets to Extract, Transform and load data into Operational database from legacy mainframe systems.
• Create mappings using reusable components like worklets, mapplets using other reusable transformations.
• Worked on Informatica Source Analyzer, Mapping Designer & Mapplet, and Transformations.
• Developing Complex transformations, Mapplets using Informatica to Extract, Transform and load data into Data marts, Enterprise Data warehouse and Operational data store. developed ETL mappings and workflows to facilitate dimension and fact data loads in the Data warehouse
• Extensively used all utilities in Informatica like Designer utilities (Source Analyzer, Target Designer, Transformation Developer, Mapplet Designer and Mapping Designer), Workflow Manager utilities (Task Developer, Worklet Designer and Workflow designer) and Workflow Manager
• Involved in performance and tuning of the existing ETL mappings.
• Creating sessions, sequential and concurrent batches for proper execution of mappings using server manager.
• Managed the Metadata associated with the ETL processes used to populate the data warehouse.
• Performance tuned the data load processes and the corresponding Informatica mappings for optimal performance.
• Responsible for working with IBM for incidents occurring during development and production migrations.
• Involved in worked on developing mobile reporting solutions for Top Management of Hyatt
• Tuned the database queries used for operational reporting against the OLTP database, to get to sub second response times.

Environment: Informatica Power Center 9.1, SQL server 2008/2005, Oracle 11g, Cognos 10.2 BI, Cognos TM1 9.2, Cognos 8 (Analysis Studio, Report Studio, Query Studio), Power Play 7.3, Power Play Transformer 7.3/7.4, Erwin, Tableau 8.1, Windows Active directory, IS 7 Web Server, TOAD, Linux and Windows/NT/2003/2008

Confidential, Atlanta, GA

ETL developer

Responsibilities:

• Worked on Informatica Designer Tool’s components - Source Analyzer, Warehouse Designer,Transformation Developer, Mapping Designer and Mapplet Designer.
• Extensively involved in Data Extraction, Transformation and Loading (ETL process) from Source to target systems using Informatica.
• Used DataStage as an ETL tool to extract data from sources systems, loaded the data into the SQL Server database.
• Performed data cleansing and transformation using Informatica.
• Documenting user requirements, translated requirements into system solutions and developed implementation plan and schedule.
• Preparing software requirement specifications, business rules interacting with business units and designed ETL process.
• Developing Informatica ETL mappings using complex transformations, Mapplets to Extract, Transform and load data into Operational database from legacy mainframe systems.
• Worked extensively with Designer tools like Source Analyzer, warehouse designer, transformation Developer, Mapping and Mapplet Designers.
• Involved in the development of Informatica mappings and also tuned for better performance. In the Mappings most of the Transformations were used like the Source Qualifier, Expression, Filter, Aggregator, Look Up, Update, and joiner, Sequence Generator, Sorter, Rank and Router.
• Implemented Slowly Changing dimension type2 methodology for accessing the full history of accounts and transaction information.
• Preparing the Documentation for the mappings according to the Business Requirements
• Good Knowledge on Data Warehousing concepts like Star Schema, Dimensions and Fact tables.
• Optimizing Informatica Mappings and Sessions to improve the performance Possess complete domain and development Life Cycle knowledge of Data Warehousing
• Worked with different types of source and target systems like Flat files, XML files, COBOL files, Oracle, SQL Server.
• Extensive experience in extraction, transformation and loading of data from heterogeneous source systems like flat files, Oracle, SQL server.
• Involved in the Successful Production Deployments as followed by Change Management process.
• Good experience in UNIX and PL/SQL.
• Knowledge of Data Warehousing and Business Intelligence Concepts
• Worked with the business users for the Approval of new designs/projects coming into production.
• Assigning tasks to the team members after finalizing the requirements by having discussions with clients and users and Review of tasks accomplished by team members.

Environment: Informatica 9.0/8.6.1, Oracle 11g/10g/9i, DB2, SQL, PL/SQL, T-SQL, UNIX, Shell Scripts, Java, XML, Crystal Reports, JIRA, MATT, Track Record

Confidential, IL

Dwh / ETL Developer

Responsibilities:

• Participated in requirements gathering workshop, analyzed business rules and requirements from the Application detail level.
• Analyze the enterprise data and develop logical models using Erwin data modeling tool based on the approved conceptual model.
• Developed E-R model for the Operational data store and Enterprise data marts.
• Create/update physical models for the enterprise data warehouse and Data Marts.
• Prepared the System Design Document for ETL and Reporting.
• Implemented ETL mappings involving complex business logic for Global Inventory Management.
• Lead the development team during the development process, this included providing help with their tasks, troubleshooting issues and transferring knowledge of reports and business logic.
• Performed QA and Code review for the developer’s code.
• Responsible for code migration across environments ( DEV, SIT,UAT, Prod)
• Automated Cube build jobs using UNIX shell scripts.

Environment: Informatica Power center 7.1, Sun Solaris 8.0, Shell scripting, Oracle 10g, Cognos 8, Cognos 8 Framework Manager, Cognos Power play Transformer 7.3.

Confidential

DWH Developer

Responsibilities:

• Involved in the design & development of the New Data Warehouse.
• Responsible for ETL Design and DQAR activities.
• Involved in preparing HLD&LLD documents for business areas like POS, BP and CRM, IN Prepaid.
• Designed & implemented the mappings for loading dimensions and facts, data cleansing rules.
• Responsible for Installation for Cognos Report net and Cognos Enterprise server.
• Redesigned the all existing reports in Oracle Discoverer in Cognos Report net.
• Designed & implemented d many UNIX Shell Scripting programs.
• Designed and developed PL/SQL Procedures and Functions.
• Involved in Application testing.

Environment: Oracle Warehouse Builder 10g/9i, Cognos Report Net, Cognos Power play Enterprise Server, ERWIN 4.0. Oracle Discoverer Administrator, Oracle Discoverer User Edition, Oracle Discoverer Plus, Oracle Discoverer Viewer, Oracle Discoverer Audit Browser, Edit Plus 3.1, TOAD 7.4, Sun Solaris, Windows 2000.