Oracle Business Intelligence(OBIEE) Developer

Veera

OBI Architect

E-mail: ********@*****.***

Career Summary:

V Having 7 Years of information technology experience in Data Warehouse

applications and Business intelligence Applications .

V Strong experience in Installation configuration of Oracle Business

Intelligence Applications for Financial Analytics, Supply Chain

Analytics, Service Analytics and Sales Analytics.

V Strong expertise in customizing BI Apps modules based on requirements.

V Very strong experience in developing OBIEE Repository (.rpd) at three

layers (Physical Layer, Business Model & Presentation Layer).

V Experience in creating Time series measures using AGO & TODATE

functions and Level based measures.

V Serve as the subject matter expert for OBIEE demonstrating expertise

in Oracle BI Server, Oracle BI Answers, Oracle BI Interactive

Dashboard, and Oracle BI Publisher.

V Experience in creating Metadata Objects using OBIEE Admin Tool and Web

Catalog Objects (Dashboards, Pages, and Reports) using Siebel

Analytics Web.

V Having experience to integrate OBI Dashboards into Siebel Application

and Oracle EBS.

V Experience in Installation and configuration of DAC and resolving

issues in ETL loads.

V Experience in creating and modifying subject areas, execution plans

and tasks in DAC.

V Extensively worked on ETL tool Informatica.

V Having experience in customization of Prebuilt Informatica ETL

mappings and adding those into DAC.

V Experience in Toad to write,validate and analyse SQL queries and

monitor the execution statements.

V Collaborate with business users to capture & define business

requirements and then contribute to defining the appropriate data

warehouse BI solution.

V Familiarity with implementing Oracle Business Intelligence (OBIEE)

custom data warehouse solutions and pre-built BI analytics

V Analyze, design, develop, implement, and support Business Intelligence

technical solutions using OBIEE.

V Experience in developing Strategies for Extraction, Transformation and

Loading Mechanisms using Informatica.

V Experience in modifying and creating new mappings in Informatica -OEM

for Siebel.

V Well Versed with general business processes and Customer Relationship

Management requirements.

V Good Knowledge on Data Warehousing concepts like Star Schema,

Dimensions and Fact tables.

V Having knowledge on Siebel CRM Tools.

V Knowledge on Tools to create views, Applets, Screens and Business

Components.

V Knowledge on Integration Administration to create symbolic URLs and

integrate Oracle BI into Siebel Application.

V Strong experience on SQL and PL/SQL.

V Extensively used Toad to write, validate and analyze SQL queries.

Experience Summary:

* From July 2010 working as Lead Consultant in CSC,Hyderabad.

* From march 2010-June 2010 worked as Consultant in American Express,

Bahrain.

* From June 2007- Feb 2010, worked as Consultant in Genpact, Hyderabad

* From Sep 2004 - June2007, worked as Consultant in Zensar Technologies,

Pune.

Technical Skills:

Siebel Analytics 7.7 & 7.8, OBIEE 10.1.3.x, DAC,

Informatica 6.2/7.1/8.1.1/8.6

SQL, PL/SQL, ER-win, Toad, SQL Developer

Oracle 9i/10G

Win NT / 9x / 2000, UNIX

Siebel 8.0

Qualification:

Bachelor of Technology (B.Tech) From Nagarjuna University.

Projects:

Beckman Coulter, Oracle BI Apps Tech Lead

Beckman Coulter, Inc. is a leading manufacturer of biomedical testing

instrument systems, tests and supplies that simplify and automate

laboratory processes. Beckman Coulter has implemented Oracle Business

Intelligence Enterprise Edition (OBIEE) reporting environment. The OBIEE

program involves activities across multiple functional tracks, each track

doing their own development work. These functional tracks are Service,

Commercial Operations, Finance, Supply Chain Management and Human

Resources.

> Interacted with Business Users for gathering the Reports / Dashboards

requirements and to define business and functional specifications.

> Developed and implemented the coding of Informatica Mapping for the

different stages of ETL(SDE/SIL/PLP).

> Fixed the invalid mappings and troubleshoot the technical problems of

the database.

> Debug the sessions by utilizing the logs of the sessions.

> Developing and modifying the program code, implementation, testing and

provide documentation for the Oracle EBS System and related

interfaces.

> Analyzed and validated the business model in OBIEE Administration Tool

by performing consistency check, validating logical source tables,

logical columns, and also validating repository level calculations

done in the business model layer.

> Developed OBIEE Repository per user requirements and available

information in DW.

> Implemented security by creating roles and web groups, checks with

External tables and LDAP.

> All the jobs are integrated using complex Mappings including Mapplets

and Workflows using Informatica power center designer and workflow

manager. Version 8.1

> Used TOAD for Oracle to connect to databases in Oracle.

> Written SQL queries to validate the reports and analyzed the SQL

queries to troubleshoot the Reports and informatica Mappings

> Closely working with team to submit the builds for enhancements and

Production issues.

Hardware/Software:

OBIEE 10.1.3.x, Informatica 8.1, DAC,Oracle BI Applications 7.9.5, Oracle

10g, Putty, TOAD, Windows 2000.

BISTP

American Express, Bahrain OBIEE Architect

American Express Company is a diversified worldwide travel, financial and

network Services Company founded in 1850. It is a world leader in Charge

and Credit Cards, Travellers Cheques, travel, financial planning, business

services, insurance and international banking.

Amex is implementing a BI solution for Charge Card. BI STP project that

will be used for providing business intelligence reporting according to

requirements provided by Business and is available within Power Card. This

will be supported by a number of data marts to enhance and support the

business reporting and analysis needs.

> Upgraded the OBIEE environment from 10.1.3.4.0 to 10.1.3.4.1.

> Installed OBIEE in oracle Application server and configured the BI

Publisher.

> Developed the analytics repository and created logical dimensions,

facts and Hierarchies.

> Implemented External table authentication and authorization .

> Implemented Data Level and Object level security.

> Configured iBots and send notification alerts to different webgourps

and dashboards.

> Created different reports using views in Oracle BI Answers like

tabular, pivot and charts.

> Implemented repository merge and webcatalog merge process to deploy

into production environment.

Environment : OBIEE 10.1.3.4.1, OWB11g, Oracle 11g

GEHC International Analytics

GE Healthcare, Oracle BI Apps Developer

GEHC provides transformational medical technologies and services that are

shaping a new age of patient care. GEHC has broad range of products and

services enable healthcare providers to better diagnose and treat cancer,

heart disease, neurological diseases, and other conditions earlier.

The GEHC International Analytics solution has implemented for sales and

service modules.

Using the application users can track the global customer information,

sales management reporting functionality, forecasting ability, service

requests. The solution provides the opportunity to increase sales

productivity and better customer satisfaction in the GE Health Care

Process. Using integration functionality users can access the dashboards

from Siebel Application.

The source systems that GEHE International Analytics connects to

International Instance of Siebel CRM. Using Informatica, data is loading

from Siebel CRM to warehouse database.

> Interacted with business representatives for gathering the OBIEE

Reports / Dashboards requirements and to define business and

functional specifications.

> Customized and developed RPD (Physical, BMM and Presentation Layer),

configured metadata objects and Web Catalog Objects.

> Developed Reports / Dashboards with different Analytics Views (Drill-

Down / Dynamic, Pivot Table, Chart, Column Selector, Tabular with

global and local Filters) using OracleBI Presentation services.

> Implemented authentication mechanism and Position based data level and

Object level security.

> Created Dynamic repository, Session and Presentation variables to use

in reports and in repository.

> Configured OBIEE iBots to deliver Analytics content based on schedule,

automated iBot queries to obtain daily and weekly reports.

> Upgraded the Environment from Siebel analytics 7.8.5 to OBIEE

10.1.3.4.0

> Integrated Analytics dashboards into Siebel application using symbolic

URL concept.

> Resolved the issues in production environment.

Environment :Siebel Analytics7.8.5,OBIEE10.1.3.4.0,Informatica 8.1,

Oracle 10g, UNIX

GEHC Marketing Analytics

GE Healthcare, Oracle BI Apps Developer

GEHC provides transformational medical technologies and services that are

shaping a new age of patient care. GEHC has broad range of products and

services enable healthcare providers to better diagnose and treat cancer,

heart disease, neurological diseases, and other conditions earlier.

DI Marketing Analytics is a new application to consolidate and integrate

the various Marketing, segmentation metrics into a scalable repository to

address reporting needs from DI Marketing, Sales and Finance teams.

The DI Marketing team expects to make increasing use of statistical,

quantitative analytical and data mining techniques to improve the

effectiveness of their segmentation and target marketing strategies.

The goal of this project is to work with the DI Marketing team and the GEHC

central marketing function to implement a consolidated data integration

framework that all the metrics could be provided with minimum manual

process.

> Understanding requirements and customizing the Repository to meet the

requirements.

> Creating new mappings to populate data into extension tables of SRMW

tables.

> Modifying existing SDE and SIL mappings based on requirements.

> Implementing new requirements in Siebel analytics repository .

> Configured iBots to deliver analytics content based on schedule to

obtain weekly reports and sent notification Alerts.

> Adding new jobs and execution plans in DAC.

> Enhancing the subject areas as and when suggested by the business

analyst.

> Documentation of various activities in the project.

> Creating test plans and writing test cases.

> Review of Metadata Configuration, Web Cat development and writing Test

Plans.

Environment : OBIEE 10.1.3.3.2, Informatica 7.1, DAC, Oracle

10g, UNIX

MQIP (Manufacturing Information Quality Portal)

CISCO US, OBIEE/Informatica Developer

Cisco Systems Inc. is a global leader in the Networking & Telecommunication

industry and has been a pioneer in the usage of the Internet within all key

business areas.

Cisco's Manufacturing Quality effort attains leadership in hardware product

quality. Through this effort, consistent and predictable product quality is

ensured from new product introduction (NPI) process. Effort is to obtain

best-in-class supplier quality management, and maintain an agile, closed-

loop corrective action process.

Purpose of the Manufacturing Quality Information Portal (MQIP) Project is

to provide one-stop shopping place for critical manufacturing quality

metrics. It also serves as the "official" source of quality information. As

the presentation platform for quality metrics and data, MQIP allows access

to integrated product, process, and customer quality data from across

Cisco. The single integrated quality data set improves visibility into

quality issues and facilitates decision making to improve quality.

> Design various reports, i.e., Drill down, Pivot, Breakdown Reports,

Narrative and Nested Reports in Answers and Customer demography with

the facility to drilldown and charts.

> Understanding requirements and customizing the Repository to meet the

requirements.

> Developing Custom Dashboards and reports using Siebel Answers.

> Configured iBots to deliver analytics content based on schedule to

obtain weekly reports and sent notification Alerts.

> Documentation of various activities in the project.

> Resolving issues faced in production environment.

> Enhancing the subject areas as and when suggested by the business

analyst.

> Analyzed the sources, targets, transformed the data, mapped the data

and loading the data into Targets.

> Involved in creating, editing, deleting and scheduling of the Sessions

in Informatica.

Environment : Siebel Analytics7.8, Informatica 7.1, Oracle 9i.

Mclean Auto Finance Group

ETL Developer

The main aim of this project is to generate the Reports from the Mclean

Auto Finance Data Warehouse. Mclean has different applications and Mclean

sold these applications for vendors through dealers on different price

packages. This Data Warehouse contains the data related to the Dealers of

the company, Branches of the company, Vendors they have, and the Orders of

the company etc.

> Monitored the Daily ETLs and send the notification mails to stake

holders.

> Fixed the issues during the Daily ETL monitoring when Jobs got failed.

> Enhanced the mappings and changed the calculations as suggested by

business team.

> Used transformations aggregator, expression, lookup, update strategy,

router, and ranker transformation.

> Worked on CRs related to informatica and fix the issues in the

respective mappings.

Environment : Siebel Analytics7.7, Informatica 7.1, Oracle 9i

IDW for Acro Motors

Acro Motors, USA ETL Developer

Acro motors have specialized in BMW, VW, Porsche, Volvo and Mercedes parts

and accessories since 1974. It offers high quality new OEM parts at the

lowest wholesale prices to public to the public and dealers.

Design and implement a process to extract and populate the IDW tables

related to Quotes, Orders and Shipping with near real time data. Extract

data from Parts ERP Integrate incremental real-time data into the IDW

tables for the critical fields related to Quotes, Orders and Shipping. This

will provide a complete and accurate single-source, near real time data for

the to the ERP Parts business users Provides reporting environment, to

develop multiple user BO's Reports, MS Access reports and other downstream

applications, which are critical to the daily functioning of the business.

> Worked on ETL Mapping design using Informatica.

> Created mappings using the transformations such as the Source

qualifier, Aggregator, Expression, Router, Filter, Ranker, Sequence

Generator, and Update Strategy.

> Extensively used aggregator, expression, lookup, update strategy,

router, and ranker transformation.

> Used source filter in Source Qualifiers and Data Flow Management into

multiple targets using Routers.

> Used Informatica Workflow Manager to create, schedule, monitor

sessions and send pre and post session emails to communicate success

or failure of session execution.

[pic]

[pic]

Contact this candidate