0biee developer

RAMESH BABU.A Email: **********@*****.***

OBIEE Developer Ph. no: +91-954*******

________________________________________________________________

Professional summary

● 3+ years of IT experience in Oracle Business Intelligence Enterprise Edition.

● Experience in Design and Implementation of Datawarehouse/DataMart, Gathering Business Requirements, System Analysis, and Design and Data model.

● Experience in developing OBIEE Repository (.rpd) at three layers (Physical Layer, Business Model & Presentation Layer).

● Expert in Creating the Dimensional Hierarchies, Level Based Measures, Time- series Functions, Initialization Blocks and Variables depending upon the need for Business Reports using the OBIEE Admin tool.

● Good Knowledge in Reports, different charts, narrative view, column selector, view selector, pivot table and Dashboards with Prompts.

● Creating Dashboards prompts and configuring them onto dashboards.

● Worked with different Sources such as Oracle, and XML Files.

● Good knowledge on Data level & object level security.

● Good knowledge of the SDLC and Experience in Support, Maintenance and Development of Projects.

● Knowledge on Data Warehousing concepts like Star Schema, Snow Flack Schema Dimensions and Fact tables.

● Quick learner and adaptive to new and challenging technological environments.

Professional Experience:

● Working as OBIEE Developer in Sierra Atlantic, Hyderabad from 25- NOV-2010 to till date.

● Worked as OBIEE Developer in Tavant Technologies, Bangalore from 16-JUN-2008 to 05-NOV-2010

Technical Skills:

OLAP Tools : OBIEE 10.1.3.4.1

Data Bases : Oracle 10g, SQL

Operating Systems : Windows 2000, XP

Qualification:

B.Sc(Computer Science) from Acharya Nagarjuna University in 2008.

Projects#1:

Project Name : Sales Pattern Analysis System

Client Name : Valeant Pharmaceuticals, USA

Role : Developer

Duration : 15-DEC-2010-Tilldate

Project description:

This project involves building of a Data Warehouse solution to meet the various requirements of Valeant Pharmaceuticals Sales depots, which are located across the country. The basic requirements for Valeant Pharmaceuticals with respect to sales and distribution are Stock availability across location and products, Sales reports, analysis, Inventory Management, Order Management, Customer Accountancy and Sales.

Role and Responsibilities:-

• Understanding the Business requirements, Involved in Designing and Configuration of Business Intelligence Server Repository as per Business Needs and improving performance.

• Extensively used OBIEE Administration Tool for Customizing and modifying the physical, business model, and presentation layer of the repository.

• Creating the Dimensional Hierarchies, Level Based Measures, Time series -Functions, Initialization Blocks and Variables depending upon the need for Business Reports using the OBIEE Admin tool.

• Customized Reports look and Feel using Column Formatting & Conditional formatting.

• Developed Interactive Dashboards using Reports with different Views, implementing pagination (Drill-Down, guided navigation, Pivot Table, Chart, Column Selector, dashboard and page prompts) using Oracle Presentation Services.

• Developed different kinds of reports (pivots, charts, tabular) using Filters and Modifying Views. Adding column filter prompts.

• Assigned Data Level & object level security to users.

• Modified and formatted requests, along with charts and filters, in Obiee Answers.

Projects#2:

Project Name : Trade Promotion Management

Client : Procter & Gamble (P&G)

Duration : 05-JUL-2009-25-OCT-2010

Description:

Trade Promotion Management (TPM) allows for planning and tracking of marketing expenditures throughout the Marketing program lifecycle. TPM is the foundation for closed loop marketing as it will enable analysis of forecasted spend vs. actual spend. Benefits can be measured by being able to plan for marketing expenditure downstream more effectively while allowing world-wide collaboration in the creation of marketing programs and campaigns. The different TPM entities are Initiatives, Funds Allocations, Programs and Campaigns.

Responsibilities:

• Understanding requirements and customizing the Repository to meet the requirements i.e., Physical Layer, Business Model & Mapping and Presentation Layer level

• Drill down Hierarchies and implemented Business Logics and Facts.

• Created Identified the Dimensions, Developed the repository model for the different work streams with the necessary logic that involved creating the Physical, BMM and the Presentation layer. Also created hierarchies, variables in the repository.

• Analysed and validated the business model in Administration Tool by performing consistency check, validating logical source tables, logical columns, and also validating repository level calculations done in the Business Model & Mapping layer.

• Created Reports using different Analytics Views (Pivot Table, Chart, Column Selector, Table)

• Extensively worked with the web catalog giving permissions for the required subject areas.

• Interacted with the business users to gather reporting requirements focusing on Sales groups mainly focusing on Service Requests and Sales Analytics

Projects#3:

Project Name : End-to-End BI Solution

Client : Ronald Reagan UCLA Medical Center, Los Angeles

Duration : 10-AUG-2008 to 20-JUN-2009

Description:

Client is $1.2 billion consortium of Hospital & Clinics, known worldwide for advanced patient care in areas of Cardiac care, Cancer treatment, Neurosciences, Surgery and Organ transplants. The organization is recognized as one of "America's Best Hospitals" and consistently ranked within top 3 in the U.S.

Responsibilities:

• Developed data and reporting requirements.

• Build core reports with Clinical Analytics Reporting Environment.

• Gathered Data repository for Patient (inpatient & outpatient) demographics & encounter summary data.

• Collected Patient Results for Lab, Cardiac, Respiratory, Transfusion, Orders and Pharmacy.

• Created Star and Snowflake schemas, set up foreign and primary key relationships. Set up dimension hierarchies and level-based measures for drilldown detail within Analytics Reports.

• Created Reports using different Analytics Views (Pivot Table, Chart, Column Selector, Table).

Contact this candidate