ODI Resume

(1)

Email:

ODI, Informatica & OBIEE Developer Mobile:

+91

Professional Summary



Having 5 years of IT experience in the field of Oracle Business

Intelligence, Data Warehouse, providing BI solutions using

Informatica, ODI and OBIEE.



Hands on experience with Data Extraction, Transformation and

Data Loading in Data Warehouse environment using ODI and

Informatica.



Experience in Configuration and setup ODI, Master Repository,

Work Repository, Projects, Models, Sources, Targets, Packages,

Knowledge Modules, Interfaces, Scenarios, Filters based on

required condition.



Designed the detailed ELT architecture, including agents,

scenarios, packages, data mapping, data extractions,

transformations and validations. ELT design and

implementation include stand-alone and Java/J2EE agents, ODI

Console, ODI studio.



Having experience in data warehousing technologies like

Oracle Business Intelligence Enterprise Edition (OBIEE 11g),

Oracle Data Integrator (11g and 12c)



Having experience in configuring and developing the

Analytics/OBIEE Repository (.rpd), which involves Schema

Import, Implementing the Business Logic by customization,

Dimensional Hierarchies, Security , Utilities, Subject Areas

etc...



Having Experience in Configuring the Physical, BMM and

Presentation Layers



Experienced in User Acceptance Testing (UAT), Unit testing,

System testing, Integration testing, Development and

Production.



Having good experience in Informatica.



Extensive experience using Informatica components Designer,

Workflow Manager, Workflow Monitor.



Created mappings using different transformations like Source

Qualifier, Filter, Expression, Lookup, Router, Update Strategy,

and Joiner.

(2)



Having good experience in Data warehousing concepts such

as dimensional modeling, Star Schema and snowflake schema,

galaxy schema, Data marts, Dimensions and facts

identification.



Having knowledge in developing of Repository and Reports

Using Oracle Business Intelligence Enterprise Edition (OBIEE).



Having good experience in Informatica.

Work Experience

Education Qualifications

Technical Skills

ETL and Scheduling

Tools

ODI 11g and ODI 12C, Informatica 8.6

B.I Tools

OBIEE 11g

Operating Systems

Windows 7, Windows xp, Windows 2003

RDBMS

Oracle, Toad, SQL Developer.

Application Packages

MS-Office

Project Experience

1. Platform for Growth (PfG)

Client : Balfour Beatty, UK. Duration : April 2015 to till date.

Technologies

:

Oracle10g, OBIEE, ODI and Oracle Apps Tools : TOAD, Sql Developer

Organization :

Tech

Mahindra

.

Balfour Beatty’s UK construction business is a leading integrator of complex, sophisticated and innovative infrastructure projects that improve the UK’s national infrastructure and is an experienced provider of local and regional projects that help build lasting communities. We offer a broad range of capabilities in construction, civil engineering and mechanical & electrical engineering services. With offices throughout the US, we offer locally-focused service delivery - with the support of our national network of expertise and resources. Provide access to legacy data through Oracle BI, as a possible legacy data retention solution.

(3)

Responsibilities:

 Created the load plans, packages for the interfaces.  Export/Import interfaces across different environments.  Implemented error handling and error notification process.

 Converted data types in Oracle apps and SQL Server and populated the target system.

 Scheduled batch jobs using ODI scheduler.

 Created versions for interfaces using Version control.  Analyze and design of ELT processes.

 Configured and setup ODI, master repository, work repository, Project, Models, sources, targets, packages, Knowledge Modules, Interfaces, Scenarios, filters, condition, metadata.

 Implemented CDC (Change Data Capture) to capture the changes on the source.

 Worked in the implementation of DW Incremental load and Full load.

 Interacted with business analysts and modelers for better understanding of individual subject areas and modified specifications to reflect accurate user requirements.

Environment: Oracle Business Intelligence Application, ODI, DAC, Oracle Applications R12 (12.1.3), Oracle9i/10Gdatabase, SQL Developer, PL/SQL, Forms 6i, Reports 6i

2. Energy and Utilities

Client : British Petroleum Role : Technology Analyst

Technologies

:

Oracle10g, OBIEE, Informatica. Tools : TOAD

Organization : Infosys. Description:

The primary focus of Informatica and OBIEE Reporting application is to provide quality information and business intelligence to analyze the data at various work streams like P2P, WMS and MM. The main purpose of this project is to develop a single code for data warehouse and deploy in multiple entities. It read data from various Region systems and cleanses and populates to Warehouse. On top the warehouse reports/dashboards are built for analytical purpose. This project has been running on multiple codes base versions.

Responsibilities:

 Understanding user requirements and system specifications.

 Created users and groups and assigned explicit and individual permissions and privileges.

 Worked on creating Reports and Dashboard and Creating Dashboard prompts and filters.

(4)

 Created mappings using different transformations like Source Qualifier, Filter, Expression, Lookup, Router, Update Strategy, and Joiner.

 Creation of logical tables / columns and calculated measures.  Prepared the UTP.

 Involved in peer review.

3. FedEx Reporting

Client : Richo, USA.

Role : Technology Analyst, Reporting Developer. Technologies

:

Oracle10g, OBIEE, ODI.

Tools : TOAD, Putty. Organization : Infosys. Description:

Richo aims to accelerate delivery of the business benefits associated with the roll-out of the new Oracle R12 platform as part of their program. This is aimed to be achieved through the implementation of specific acceleration opportunities under the umbrella of Project FedEx reporting, designed to deliver certain business capabilities to their users in advance, as also to provide a platform for validation and cleansing of data that will eventually be migrated to the new Oracle platform. Responsibilities:

 Understanding user requirements and system specifications.

 Created users and groups and assigned explicit and individual permissions and privileges.

 Creation of logical tables / columns and calculated measures.  Prepared the UTP.

 Involved in peer review.

4. Operational Reports

Client : Union Bank of California, N.A.

Role : Technology Analyst, Reporting Developer. Technologies

:

OBIEE, Oracle10g.

Tools : TOAD and Putty.

Organization : Xenon software solutions Description:

Operational Reports is a data warehousing project for banking applications. It’s a core banking Reporting project and uses the reports for analysis Purpose. We extract the data from different applications Informatica PowerCenter and develop the data mart. By using the OBIEE, we will generate the reports with the

underlying datamart. Responsibilities:

(5)

 Understanding user requirements and system specifications.  Involved in development of RPD & dashboards, Answers.

 Modeling physical/business/presentation layers In OIEE on top of data marts.  Creation of logical tables / columns and calculated measures.

 Building dimensional hierarchies and setting up Drill Hierarchies.  Developing the complex reports in OBIEE.

 Developing complex reports in Answers such as Pivot tables, charts, gauges, Narrative view, and Ticker view and using union functions.

 Development of criteria with respect to the design of reports.  Preparation of UTP.

 Unit testing of developed components.  Reviewed components developed by others.