OBIEE Developer

Nagamani Are

Santa Clara, CA-*****

Ph.no: 408-***-****

Email: ********.*****@*****.***

Professional Summary:

4+ years of Experience in OLAP reporting tool like OBIEE 11.1.1.6, Oracle

9i/10g/11g technologies including SQL/PLSQL programming, Performance tuning

on the platforms various Windows versions.

Development of BI Metadata (rpd) and Reports, Dashboards using OBIEE

Analytics.

Proficient in generating OBIEE reports using Oracle Analytics and

Dashboards.

Utilized variables and initialization blocks in the repository.

Created complex requirements like Dimension hierarchies, time comparisons.

Created reports like Table, Chart, Pivot, column selector and Narrative

views and publish them in dash board.

Involved in creating Dimensional Hierarchies, Level Based Measures and

creating navigations from one report to other.

Use Analytics agents to send messages conditionally to Groups / Selective

Recipients.

Integrate the BI Publisher Reports into OBIEE Dashboards.

Involved in performance tuning at RPD level and Database level.

Having good knowledge on Data warehouse Concepts.

Excellent problem solving, organizational, analytical and communication

skills.

Good team worker and has ability to understand and adapt to new

technologies and environments faster.

Good Knowledge In Informatica.

Technical Expertise:

RDBMS : Oracle 9i & 10g,11g

OBIA : OBIEE 11.1..1.6 /10g

Languages : SQL & PL/SQL

ETL : Informatica

Operating Systems : Windows 2003/XP/2000/NT, UNIX.

Tools : SQL Developer, Toad, SQL * Plus,

Putty, Appworx 8

Experience Summary:

Working at "Aditya Birla Minacs Ltd" as OBIEE Consultant (Feb 15th 2013 to

Till-date).

Worked at "Mphasis an HP Comapany" as Delivery software engineer

(sep 30th 2010 to Oct 4th 2012)

Educational Qualification:

MCA (Master of Computer Applications)

Projects Summary:

[pic]

Project #2: Ford

Company : Aditya Birla Minacs Pvt Ltd.,

Client : US Ford

Duration : Feb 2013 - Till Date

Designation : OBIEE Consultant

Operating System : Windows

Database : Oracle 10g/11g

Report Tools : OBIEE V 11.1.1.6

Description: Customer Relationship Management - Integrated Marketing (CRM-

IM)

Ford Red Carpet Loyalty System ( RCLS) & CEM - Customer Experience Movement

CRM-IM - Customer Relationship Management - Integrated Marketing

CRM IM is a website application developed to supports ford motor company

invoice and marketing services for the business partners and the stake

holders

RCLS - Red Carpet Loyalty System

Red Carpet Loyalty System (RCLS) was developed to assist Ford and Lincoln-

Mercury dealerships increase lease renewals by informing their customers

through telephone contact about the leasing process

CEM (Customer Experience Movement): CEM is to increased customer

satisfaction and customer loyalty and then it leads to increasing the Ford

and Lincoln sales and service contracts.

Responsibilities:

Interact with client for requirement analysis and clarifications.

Understanding the Database Designing, reports queries which are related to

reports.

Involved in migration of RPD and web catalog from OBIEE 10g to OBIEE 11g.

Design and development of all layers of Administration tool like Physical,

Business Model, and Presentation layer.

Involved in creating the Repository variables, initialization blocks.

Development of hierarchy dimensions and measures implementations.

Developed aggregate tables to increase query performance.

Involved in developing the Dashboard Pages and reports using Analytics

Created the reports in different views like Table, Pivot, Graphs, Chart,

Filter, Title, view selector, prompts and Narratives.

Involved in creating the Dimensional Hierarchies, Level Based Measures and

creating the navigations from one report to other pages.

Use Analytics agents to send messages conditionally to Groups / Selective

Recipients.

Integrate the OBIEE BI Publisher Reports into Dashboards.

Involved in implementation of OBIA Financial, Sales Analytics.

[pic]

Project #1: Amgen-R&DI

Company : Mphasis an HP Comapny

Client : Amgen Inc, USA

Duration : Sep 2010 - Oct 2012

Designation : Delivery Software Engineer

Operating System : Windows,UNIX

Database : Oracle 10g/9i

Report Tools : OBIEE 10.1.3.4

Description: Amgen is an US based Biotech company. It is one of the largest

biotech/Pharma companies. This is supports for 80+ applications in Amgen

DEV Information Systems division with Oracle Clinical, RAVE, ArisG and

ARGUS are being the major/crucial applications. Most of the other

applications are 3rd party and some of them are in house developed

applications.

Responsibilities:

Developed and customized repository (.rpd) and configured metadata objects

(Subject Area Table Column).

Implemented Level Based Metrics and created Aggregations in the Business

Model and Mapping (BMM) layer as per the user requirements.

Defined Security settings in OBIEE Admin Tool to setup groups, access

/query privileges.

Implemented Object Level Security for the objects like Dashboards and

Reports, and Data Level Security for Region and Product dimensions.

Created new reports in BI Publisher and made substantial modifications to

existing reports, to meet new needs.

Developed different reports using OBI Dashboard and Answers, like views &

charts, pivot and narrative, tabular views using global and local filters.

Integrated BI publisher reports with dashboards and created dashboard

prompts.

Trainings Conducted:

OBIEE and SQL sessions had been conducted.

Personal Details:

Date of Birth : July 21st, 1986

Sex : Female

Nationality : Indian

Marital Status : Married

Designation : Senior Software Engineer

Location : Santa Clara, CA

Passport Details : J2827207

Contact this candidate