OBIEE 10/11g , Sql/Mysql , .NET
Midas Infotec Pvt Ltd
June 2012 - March 2014
OBIEE - Developer
Anheuser-Busch Companies, Inc
From August 2012
The Project involves setting up Sales Marketing Data mart using transforming an existing reporting application into Oracle Business Intelligence Suite on the Windows environment. The task requires establishing central repository for collecting and reporting the trend in beer brand media spending for all brands of drinks advertised within the United States with the use of particular media type and provides trend reporting using OBIEE which answers the business goals regarding the media spending.
➢ Collaborated with the OBIEE team and System Analyst to understand Business goals and translated those into ad-hoc queries.
➢ Involved in designing the STAR Schema with the ETL team in order to define dimensions, facts and measures.
➢ Created the Repositories with complete Physical, Business and Presentation layers.
➢ Created Dashboards, iBots and used Oracle Delivers for delivery of Reports in multiple formats to the power users to fax and mobile devices.
➢ Developed various report output formats such as tables views, charts, pivot tables.
➢ Created Logical Joins/keys Initialization Blocks, Repository variables, Set levels to support Drill-down, Aggregation over columns in the repository.
➢ Integrated BI Publisher reports with the Oracle Business Intelligence Enterprise Edition to create highly formatted reports in Oracle BI Publisher by using OBI Answers and OBI Server metadata.
➢ Translated the Oracle BI Answers request to the Excel Worksheets and applied Excel specific data formatting to Gauge views and Funnel views to the charts and pivot tables.
➢ Integrated Oracle BI Presentation Services with Oracle BI Web Services to allow extract results from Oracle BI Presentation Services and deliver them to external applications.
➢ Environment: OBIEE 184.108.40.206, Oracle Database 11g, BI Publisher, WIN XP.
Qualifications & Certifications
Nimra College Of Engineering