Professional Summary

• I have 5 years of experience working as an Informatica PowerCenter developer with a Bachelor degree in Computer Science and Engineering from reputed university. Informatica PowerCenter 7.x 9.x Oracle 10g OBIEE 11g and have intimate knowledge of Data warehousing concepts and ETL.
• Core technical expertise Oracle Business Intelligence Enterprise Edition OBIEE ETL Informatica Data Warehouse Administration Console DAC and OBI Application Data Modeling data warehousing.
• Very good experience on Informatica PowerCenter 7.x 9.x to extract source data transformations and loaded into target repository and checking the data quality of the loaded data into warehouse.
• Hands on Experience in debugging and performance tuning of ETL jobs.
• Experience in creating executing and testing Data warehouse jobs using Informatica PowerCenter 7.x 9.x to load data from source to target.
• Experience in debugging and performance tuning of ETL jobs.
• Exposure towards creating jobs transforming data in desired format load the data into target database using ETL tool.
• Thorough knowledge and extensive experience working on OBIEE reports development.
• Hands on experience in developing ETLs Develop Extract Transform and Load using Informatica.
• Exposure to all steps of project life cycle such as Requirement Gathering High Level Design and Estimation Development and Unit Testing Production Migration Support.
• Strong organizational leadership communication interpersonal and analytical skills.
• Team player with excellent communication and problem solving skills.
• Clear understanding of Software Development Life Cycle.
• Good exposure towards the principles of Data warehousing.
• Highly motivated to take independent responsibility as well as ability to contribute and be a productive team member.
• Ability to quickly analyze and come-up with an efficient standard solution for a given problem.

Technical Skills

Software Applications

• Informatica PowerCenter 7.x 9.x
• Toad for Oracle 9.x
• OBIEE 11g

Programming Languages

• SQL Oracle PL/SQL

Operating Systems

• Windows XP Windows

Professional Experience

Confidential

Title Systems Engineer

Project Profile

Confidential

ETL Developer

Tools Informatica 8.6.1 Data warehouse Application Console DAC OBIEE

Admin Tool

Confidential is one of the largest international oil and natural gas service companies. The Confidential SCM BI Apps is a maintenance project wherein the data is to be migrated from JDE to data warehouse and later the OBIEE reports are tested with the obtained data. In Informatica we have created mappings which extract the data from JDE and load it into the warehouse and test the reports in Oracle Answers by checking whether the data is populated as per the requirement.

Responsibilities

• Configuring Informatica mappings
• Designed the Informatica ETL jobs.
• Prepare Test Plan/Scenario
• To report the development and the test status to the team.

Confidential

ETL Developer

Tools Informatica 7.x OBIEE 10g

Confidential is prominent pharmaceutical firm based out in New York and one of the biggest clients of Infosys Limited. MCM-OSF Application is one of Pfizer s Marketing Applications Multi Channel Marketing- Offer Sample Fulfillment maintained by Infosys.

Responsibilities

• To be a part of the design phase discussions and creation of documents.
• To create the ETL jobs for data migration from Relational source to Oracle s OLAP data warehouse using Informatica7.x and testing of the same.
• To create materialized views
• To create stored procedure to refresh the materialized views
• To create the test plans for Test activities for the end to end functionality.
• To report the development and the test status to the team.

Confidential

ETL Developer

Tools Informatica 9.x OBIEE 11g

• Confidential is an international group of quality supermarkets based in United States and Europe. Ahold s brands in Europe are Albert Heijn Etos Gall Gall Albert Hypernova and ICA.
• The real estate project aims at replacing the existing Orion system with Manhattan. OBIEE will be used for Management / Analytical reporting in addition to Manhattan Grids and Report Wizard tools which will be oriented towards process based reports.

Responsibilities

• To create the ETL jobs for data migration from Relational source to Oracle s OLAP data warehouse using Informatica9.x and testing of the same.
• To create test scenarios for Unit Testing.
• To report the development and the test status to the team.

Confidential

OBIEE developer

Tools OBIEE 11g

• Confidential is an international group of quality supermarkets based in United States and Europe. Confidential s brands in Europe are Albert Heijn Etos Gall Gall Albert Hypernova and ICA.
• The Pallas project is a migration project which aims at moving the existing Microstrategy reports to OBIEE 11g with similar features and appearance. It is to be carried out in phases with an aim of moving almost 10 000 reports to OBIEE 11g.

Responsibilities

• To analyze the already existing reports in micro strategy.
• To create similar reports using OBIEE 11g
• To test the reports for all the features those were available in microstrategy.
• To help new joinees in the project with report designing.
• To fix the defects during testing phase