OBIEE developer

Reshu Gupta **, K-Pocket, Sarita Vihar

New Delhi,110076

956-***-****

************@*****.***

Objective

Looking forward for an opportunity in Data warehousing Applications with a Growth-oriented Organization where I can utilize my experience and skills to their fullest potential.

Experience

OBIEE Developer

Jan 2011 – Present

WIPRO Limited –Greater Noida ,INDIA

Oracle BI Platform Solutions was implemented for providing interactive Dashboard access to strategic business information from the company-wide data warehouse.

Responsibilities:

• Primary responsibilities include gathering business requirements, designing the functional and technical specifications.

• Involved in Creating and Administering the Physical Layer, Business Model & Mapping

• Layer and Presentation Layer using Oracle Business Intelligence Admin tool.

• Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository.

• Created Dimensional Hierarchy, Level based Measures and Aggregate navigation in BMM layer.

• Managed security privileges for each subject area and dashboards according to user requirements.

• Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance.

• Developed custom reports/Ad-hoc queries using Oracle Answers and assigned them to application specific dashboards.

• Developed different kinds of Reports (pivots, charts, tabular) using global and local Filters.

• Created proactive agents iBots and interactive Dashboards to alert the financial team about business changes.

• Managed Oracle Delivers, Scheduler & iBots. Involved in Design and Data Modeling using Star schema.

Engineer Trainee

Sep 2010- Dec 2010

WIPRO Limited – Hyderabad, INDIA

• Got classroom training on SQL, PL\SQL, ORACLE DBA.

• Got 15 days classroom training on data warehousing tools: OBIEE, Datastage, Hyperion.

• Successfully completed training by ranking 1st in class.

Technical Skills

• Reporting tool : Oracle Business Intelligence Enterprise Edition(OBIEE)

• RDBMS : Microsoft SQL Server, Oracle 10G

• Operating System : Microsoft Windows

• Languages : SQL, PL\SQL, C, C++

Education

GAUTAM BUDDH UNIVERSITY Sep 2006 – June 2010

Inderprastha Engineerring College,Ghaziabad(U.P)

• B.TECH., Information Technology

• Score: 77.1%

• Top ranked in college for IT Branch continuously 3 yrs.

M.G.Public School (C.B.S.E) Apr 2003 –Mar 2004

Muzaffarnagar(U.P)

• High School, Science

• Score: 83.4%

Summary

• Interacted with Operation/Maintenance business representatives for gathering the OBIEE Reports/ Dashboards requirements and to define business and functional specifications.

• Analyzed and used various data sources- Oracle and Excel and Web services.

• Identified Facts and Dimensions levels/ Hierarchies of Dimensional model.

• Customized and developed RPD (Physical, Business model and Presentation Layer), configured metadata objects and Web Catalog Objects.

• Developed many reports/dashboards Analytic views (Pivot Tables, Charts, Column Selector, and View Selector).

• Created measures and level Based measures in Business Model

• Created logical Tables and logical columns, Physical Columns.

• Created measure with Logical Columns and Physical Columns.

• Created Dimension hierarchy in Business model layer.

• Developed PL/SQL procedures and functions.

• Performance tuning of Dashboard/Reports and made changes to database by implementing materialized views and partitions, rebuilding of indexes.

• Performed Unit, Integration and Regression testing to validate report and mapping functionality.

• Working closely with users/developers and administrators to resolve the production problems by reviewing design changes.

Honors /Awards

• Got 81 percentile in National IT Aptitude Test(NITAT) 2010 conducted by NIIT.

• Won first prize for Chemistry project and third prize for Physics project in 12th standard.

• Stood first in chemistry in 11th standard.

Contact this candidate