SUMMARY

• Have 8+ years of extensive IT experience in ETL includes Design Analysis, Application Development, Implementation, Maintenance and Documentation of Data Warehouse, Data mart and Business Intelligence using OBIEE, Informatica, Oracle SQL & PL/SQL, Unix Scripting, and BI Applications.
• Experience in integration of various data sources (Oracle 8i/9i/10g/11g, Teradata, MS SQL Server, DB2, MQ, Flat Files, XML files, and various File systems) into staging area and target Data warehouse.
• Extensively used Power Centre to design multiple mappings and profiled data using Informatica Data Quality (IDQ).
• Good knowledge in interacting withInformatica Power center, Informatica PowerExchange and Informatica Data Quality (IDQ).
• Experienced in Data Analysis, Data Cleaning and Data Validation.
• Working knowledge of Informatica MDM Hub and involved in the configuration of landing tables, staging tables, Data Models, relationships.
• Extensive experience with Data Extraction, Transformation, and Loading (ETL) from disparate Data sources like Multiple Relational Databases and also worked on integrating data from flat files, CSV files and XML files into a common reporting and analytical Data Model.
• Experience in Oracle SQL & PL/SQL and Unix Shell Scripts on the projects which related to Data warehousing, Data migration and Data management.
• Extensive experience with Fact, dimensional tables, slowly changing dimensions, Physical and Logical Data Modeling.
• Practical, hands - on experience working with Informatica Data Integration Tools - Repository Manager, Designer, Workflow / Server Manager, and Workflow Monitor.
• Worked extensively on Optimization and Tuningof PL/SQL scriptsfor increasing Query and Database performance.
• Experience in working with Slowly Changing Dimensions (SCD type 1/2) and setting up Change Data Capture (CDC) mechanisms.
• Actively participated in ETL Migration using Deployment groups and Migrated ETL Objects from DEV to TEST environment
• Worked Extensively on OBIEE Administration Tool, Agents, OBIEE Answers and Interactive Dashboards and customized reports (Aggregations, Drilldown to meet client requirements).
• Hands on experience in configuring, developing, debugging, optimizing and performance tuning of OBIEE Analytics repository which involves Dimensional Hierarchies, Aggregate Navigation, Level based measures, Security management, Variables, Initialization blocks and Cache Management.
• Implemented Single Sign on Integration for OBIEE security
• Experience working on Informatica HA and GRID.
• Adept at working with internal and external teams including offshore teams and coordinating for on-time delivery of solutions and training end users.
• Excellent Presentation, Communication, Interpersonal, Leadership, Decision Making, Influencing, Problem Solving and Motivational Skills.

TECHNICAL SKILLS

Database: Oracle (10g and 11g), MS SQL Server 2008/2005, MySQL,DB2, Teradata

ETL Tools: Informatica PowerCenter9.x/8.x/7.x, OBIEE11g, OBIA, Informatica MDM Hub, Oracle Warehouse Builder (OWB), Informatica Power exchange, DAC, Tableau

Languages: C,C++,SQL,PL/SQL, Shell Script, Java, HTML,CSS, Unix

Data Modeling: Rational Rose, Oracle Data Modeler, Erwin

Tools: PL/SQL Developer,Toad, QualityCenter,JIRA, Escenic Content Management Studio, Microsoft Server management Studio, Bugzilla, Eclipse, VMware, Oracle APEX

Operating Systems /Environments: Windows NT/XP/Vista/98/2000/7/8,UNIX, LINUX, MAC-OS, Ubuntu.

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Sr Informatica/OBIEE Consultant

Responsibilities:

• Interacted with business users to understand the business requirements
• Analyzed business requirements and worked closely with the various application teams and business teams and developed ETL procedures that are consistent across all application and systems.
• Designed the ETL processes using Informatica PowerCenter to load data from Oracle, Flat Files, and Mainframe files to target Oracle Data Warehouse
• Loading the OLTP data into the Warehouse OLAP and built the Re-usable Mappingsusing Informatica PowerCenter
• Used various transformations to develop robust mappings in the Informatica Designer
• Extensively used pre-session and post-session variable assignment for simulating multi-threading scenarios for Load balancing and performance improvement
• Develop, test and migrate Informatica ETL mappings for OLTP AND OLAP systems and executed Stored Procedures from Source Qualifiers and SQL transformations and used the return data set in the mapping
• Developed Custom and out of box Dashboards using OBIEE 11g.
• Extensively used Parameter file to override Mapping parameter, Mapping Variables, Workflow Variables, Session Parameters, FTP Session Parameters and Source-Target Application Connection parameters
• Created various Documents such as Source-To-Target Data mapping Document, Unit Test Cases and Data Migration Document
• Actively coordinated with testing team in the testing phase and helped the team to understand the dependency chain of the whole project
• Extracted data from data warehouse to feed downstream systems
• Provide post implementation support on user queries and provide fix to issues identified

Environment: Informatica Power Center 9.5/9.1, Oracle 11g, OBIEE11g,CA ERwin Data Modeler, Main Frames, UNIX AIX, Micro Strategy, Autosys, MS Office

Confidential, New York

Sr.ETL Consultant

Responsibilities:

• Participated in business requirement gathering through interactive sessions with Business Teams and DB Architect teams.
• Identified Facts and Dimensions according to the design specification.
• Interacted with Informatica Team and worked on developing many complex Informatica Objects (Workflows, Sessions, Mappings, Mapplets with various transformations i.e., expressions, XML, source qualifier,Filter,Look up,Update strategy, Sequence, Aggregator, Sorter, application source qualifier, custom transformation, stored procedure) for performing the full, incremental loading and processing.
• Worked on Informatica Power center to load the source data into the target star schema.
• Analyzed the PL/SQL scripts to identify the business logic and developed the same in Informatica.
• Perform Informatica code migration from one environment to another environment including Production.
• Extensively worked on PL/SQL procedures, packages, functions, views and cursors.
• Involved in Performance tuning at source, target, mappings, sessions, and system levels.
• Created the migration documents to migrate the Informatica, UNIX scripts using Informatica repository manager and Powerexchange Navigator.
• Supported multiple applications involving different kinds of technologies (Oracle, UNIX), source-targets, transformations, file transfer protocols.
• Extracted and customized the pre-built BI solutions of tables using Oracle BI Apps 7.9.6.4 (HR Analytics)
• Worked on repository development, configured metadata objects (Subject Area, Table, and Column) and web catalog objects (Dashboards, Folders, Reports).
• Configured Physical Layer - Import tables, Create Tables, add / change physical joins / keys.
• Closely worked with ETL team to configure Informatica connections, source DB connection and target DB connection in DAC.
• Knowledge on configuring new customized mappings and work flows in DAC for new customized subject area.
• Experience in configuring DAC to run nightly data loads on daily basis.
• Created reports using BI Publisher on MS Word and Excel.
• Involved in optimizing mappings And Monitoring Production system.
• Creating Sessions and Involved in writing Unit Test cases.
• Performed Incremental, and Full Refresh load.

Environment: Informatica Power Center/Powerexchange 9.1, Informatica IDQ 9.0,OBIA 7.9.6.4, OBIEE 10g,DAC, Oracle 11g, Windows XP, SQL developer, UNIX,MS SQL Server 2005,Quality Center.

Confidential, Minneapolis

SR. ETL Consultant

Responsibilities:

• Involved in building the PL/SQL procedures and functions to do the complex business validations and transformation logics.
• Used Informatica power center for (ETL) extraction, transformation and loading data from heterogeneous source systems like flat files, RDBMS source systems to Warehouse.
• Generated PL/SQL and Shell scripts for scheduling periodic load processes.
• Extensively worked on the Database Triggers, Functions and Database Constraints.
• Helped Data Analysts in designing Data Models, cleansing rules, staging tables, landing tables in MDM console.
• Involved in data profiling and cleansing using Informatica Developer and Analyst.
• Implemented the Tableau dashboards for Phase 1 and 2 under prototype release, currently working on production solution release on data loading and reporting requirements.
• Working with end users on the requirements gathering and technical feasibility in designing the quality reports and dashboards.

Environment: Informatica Power Center 9.1.0,UNIX shell script,Oracle 10g, SQL Developer, EXPLAIN PLAN, PL/SQL, putty, Tableau, Query Analyzer, Informatica MDM hub

Confidential, Oak Brook, IL

ETL Developer

Responsibilities:

• Involved in gathering the business requirements from Business Analysts, stake holders and Technical leads.
• Used Workflow Manager for Creating, Validating, Testing and running sequential, parallel, initial and Incremental Load.
• Worked on analyzing Source to Target mappings and documented the business flow.
• Involved in the modeling of data marts in STAR schema using oracle data modeler.
• Extensively worked on Facts and Slowly Changing Dimension (SCD) tables.
• Knowledge on using Debugger within the Mapping Designer to test the data flow between source and targetand to troubleshoot the invalid mappings.
• Used various transformations like Filter, Router, Expression, Lookup (connected and unconnected), Aggregator, Sequence Generator, Update Strategy, Joiner, Normalizer, Sorter and Union to develop robust mappings in the Informatica Designer.
• Developed and implemented sessions for incremental load into staging tables and scheduled them
• Developed detailed Unit Test Document with all possible Test cases/Scripts and helped the QA team in testing the extracted data and business logic.
• Implemented Real time warehousing in Financial Transformations.

Environment: s: Informatica Power Center 7.1/8.6, Oracle 9i, Informatica power exchange,PL/SQL, SQL*Plus, TOAD, Windows NT, Shell Scripting, UNIX, Control-M