CAREER OVERVIEW:

Certified Informatica Developer having 4.5 Years of experience in Informatica Power Center and OBIEE Development . Strong command on Data warehousing concepts. Capable of end to end delivery. Proficient on BI (Siebel Analytics, Oracle Business Intelligence) and ETL (Informatica, DAC) tools . Also worked on Oracle Customer Hub (MDM) .

SUMMARY:

• Working in the IT industry since Dec 2010(Total Exp 4.5 yr), with rich experience in the field of Business/Data analysis, ETL Development
• Strong experience in Business and Data Analysis, Data Profiling, Data Migration, Data Integration and Metadata Management Services.
• Software Development Life Cycle (SDLC) experience including Requirements, Specifications Analysis/Design and Testing as per the Software Development Life Cycle.
• Experience in understanding Stored Procedures, Stored Functions, Database Triggers, and Packages using PL/SQL.
• Good Data Warehousing concepts including Meta data and Data Marts.
• Worked on Order Management Module
• Worked on Supply Chain Module
• Experience in Development of Dashboard reports and RPD.
• Involved for more than a year with the Runtime Production Support to handle production emergencies with a key focus on providing the analysis and resolution of production issue to the user and all the server, reports should up & running fine
• Worked in creating mapping, monitoring log, migration of repository using ETL tool (Informatica Power Center).
• Experience in Informatica Developer and Informatica Analyst tools (IDQ).

CORE COMPETENCE:

Informatica Power Center

OBIEE 11g

Unix, PL - SQL

DAC

WORK EXPERIENCE:

Confidential, Cleveland, OH

Responsibilities:

• Implement and Integrate Oracle CDH
• Migrate and Integrate Oracle CDH for 13+ ERPs
• Implement Customer data validation through third party services, D&B
• Design & Integrate Oracle CDH with OBIEE Analytics for Customer 360 view
• Integration of 13+ Core ERPs for Sales margin and Financial OBIEE Analytics & Reporting
• Understanding the requirements from Clients and converting it into Design.
• Created Informatica Mappings, Sessions and Workflows as the Data Integration .
• Involved in Data Cleansing and Data filtering Activities for writing Source Qualifier SQL's.
• Worked on Customizing of Out of the Box implementation for oracle TCA registry.
• Closely worked with Data Stewards for Merging and De - Duplication process of Data and Getting the Data Enriched from Third Party(D&B).
• Got appreciations from the customer for Performance Improvement .
• Suggested couple of more better solutions and 1 of them implemented as well.

Informatica Developer

Confidential

Responsibilities:

• Understand the requirements from Clients
• Conversion of Customer Requirements into Design.
• Creation of Dimension and Facts mappings in Informatica.
• Enhancement of existing Out Of Box mappings.
• Have taken initiative to suggest performance improvement measures.
• Creation of new task and task groups in DAC to a specified Subject Area.
• Importing new tables and related indexes into DAC.
• Creation of custom ETL execution plans.
• Testing newly developed using PL/SQL .
• Automation of jobs using UNIX scripting for scheduling the data load
• Worked on Order Management Module
• Data modeling for the given business requirement
• Analysis of Informatica SDE,SIL & PLP mappings in informatica
• Gap Analysis for bugs in mapping/ mapplet
• Gap Analysis in existing mapping for exposing new data fields
• Backtracking of PLP,SIL & SDE mapping
• Analysis of source qualifier queries for debugging data at EBS level
• Worked on EBS level data for SCM order, Invoices, Backlog & Pipeline data
• Matching of data between OBAW & EBS system for SIT & troubleshooting
• Worked on OBAW staging & fact level data for troubleshooting the issues
• Customization of mappings for HR/SCM analytics domain for exposing new fields
• Tracking of various task in DAC environment and issue resolution
• Working with various technology partners to collate information from various sources
• Working with indexes and explain plan to improve and enhance report performance.
• Got appreciations for Automation Processes.
• Took Initiative to lower down the number of Tickets/Month which was the add on to the Quality Support and Got appreciation.

Informatica and OBIEE Developer

Confidential

Responsibilities:

• Understand the requirements from Clients
• Conversion of Customer Requirements into Design.
• Creation of Dimension and Facts mappings in Informatica.
• Enhancement of existing Out Of Box mappings.
• Developed separate workflow and session for Full and Incremental load of Facts and Dimensions.
• Enhancement in the existing RPD.
• Creation of Dashboard report in OBIEE.
• Creation of new task and task groups in DAC to a specified Subject Area.
• Importing new tables and related indexes into DAC.
• Have used the DAC to schedule workflows.
• Creation of custom ETL execution plans.
• Testing newly developed using PL/SQL
• Automation of jobs using UNIX scripting for scheduling the data load
• Maintaining documentation for each process activity
• Worked on Order Management Module
• Got appreciation for Creating the Execution plan in DAC .
• Delivered the project On time.