Qualifications Summary

• Experience in OBIEE 10.1.3.4 and OBIEE 11.1.1.6.0 providing end-to-end business intelligence solutions by dimensional modeling design, building business models, configuring metadata, creating reports and using dashboards.
• Excellent problem solving skills with strong technical background and good inter-personal skills, Quick learner and excellent team player, ability to meet deadlines and work under pressure.
• Expertise in Oracle BI Server, Oracle BI Answers, BI Scheduler, Oracle BI Interactive Dashboard and BI Publisher.
• Experienced in interacting with Business users conducting interviews to gather, analyze and document user needs, business processes, identifying reports/KPIs and other requirements then rolling out deliverables.
• Extensive experience in OBIEE repository (Physical, Business Model and Mapping and Presentation layers) for both Stand-Alone and Integrated OBIEE implementations.
• Expertise in using dimensional hierarchy modeling and time series modeling in the Business Model and Mapping layer to meet business requirements.
• Expertise in OBIEE Publisher using multipledata sources. Trained end users to easily design report layouts directly in a Web browser, this dramatically reduced the time and cost needed to develop and maintain reports.
• Proficient in implementing comprehensive Security functionality - created users & web groups, external table security using session variables, tested and validated the model using OBIEE Admin tool and associating Catalog objects & Web modules with the created users / groups to data and object level security
• Building star and snowflake schemas in the repository as well as using the Foreign key link in the physical layer and the New complex joint key in the Business Model and Mapping layer.
• Expertise in using Alias and Dim tables so that the hierarchy and time series modeling would meet business requirements.
• Experience in using and troubleshooting the main servers: Oracle BI Server, Oracle Presentation Server and Oracle BI Scheduler.
• Experience in a Multi User Development Environment (MUDE), pulling rpd from versioning tool to common directory and making changes to meet business requirements.
• Expertise in designing and developing custom reports using BI Answers and making them available in Dashboards. Implemented drill in place so that users could view data at the granular level and make effective decisions concerning the business.
• Created AQSProd connections in Discoverer and created queries against the database.
• Experience in Configuring the Oracle BI Scheduler server and creating ibots to alert users so that they can be proactive and make important business decisions quickly and at less cost.
• Expertise in managing the NQSCONFIG.INI file to manage the rpd
• Experience in Data security and administration of OBIEE
• Expertise managing the cache environment.
• Proficient in Installation, Configuration, and Administration of OBIEE 10g standalone
• Experience with Metadata and Interactive Dashboard Development with drill down capabilities.
• Experience interfacing OBI with Oracle Database.

Experience

Confidential, October 2011- Present

Oracle Business Intelligence Developer
OBI EE (Repository(.rpd Development), Dashboards, Answers, Ibots and BI Publisher)

Roles and Responsibilities

• Working closely with Business Analysts in understanding the Analytical requirements and creating the business model for generating reports as per the user requirements.
• Interacting with business analyst and sales representatives for gathering Obiee Reports, Dashboards requirements and to define business and functional specifications
• Configuring OBIEE Repository like implementation of physical data model as per requirements, importing the tables and having the physical joins/keys required and changing the physical joins/key on the existing tables.
• Modeling activities which included building star schema as per the business requirements and configuration of Logical Layer, Logical tables, dimensions and columns in Business and Mapping model layer. Establishing the logical joins/keys required to support drill-down aggregation.
• Creating dimension hierarchies and assigned levels for each level.
• Designing and Configuring Dashboards in Analytics for different groups of users to view figures across regions, products with the facility to drill down to individual customer relationship manager.
• Developing Role-Based Dashboards for Managers and Business Heads to review the Forecasts vs. Revenues and Contact Relationship Management (CRM) to analyze the financial service center statistics for different campaigns, Customized pre-built dashboards.
• Developing custom reports/Ad-hoc queries using OBI Answers and Filters.
• Implementing the delivery of iBots using OBI Delivers to alert the associated teams..
• Interfacing OBI with Oracle Database

Confidential, June 2008 to July 2011

OBIEE Analyst

Roles and Responsibilities

• Involved in preliminary source system analysis to the collected Business requirements from the BSA.
• Involved in meetings/interviews with users, BSA’s, and data analysts, and examined the business, functional and technical requirement documentation.
• Using simple to complex analytical SQL queries against the source databases to identify and analyze the authenticity of the data before importing to build the OBI repository.
• Involved in laying out a strategy with senior management and technical team for building the metadata that presents the business model to support the business requirements.
• Involved in creating POC’s (proof of concepts) for the repositories and business functionalities with the architect team and business users.
• Identifying the appropriate facts, metrics, hierarchies, and territories to structure the initial conceptual model of the business from the requirement documentation.
• Identifying the source and target schemas and the ER relationships to support the business reporting model.
• Identifying the lowest level of detail (Grain) and rollups drill mechanism.
• Creating a repository using OBI Administration tool by importing tables into the physical layer and creating the business and mapping model to incorporate the business logic.
• Adding calculated measures that involve operations on existing columns.
• Adding time series calculations (for example, percent change in a measure compared to same period in previous year).
• Creating presentation catalog which allows exposing the business model to users in Oracle BI Answers so that users can build requests to analyze the data.
• Creating presentation folders and test with Answers.
• Using the query log to verify query results and debugging issues if any.
• Creating Dashboard Pages, Creating a New Interactive Dashboard Page by using answers from presentation catalog.
• Creating Prompts to Filter Interactive Dashboard Data and Configuring Guided Navigation Links
• Working with Metadata and Interactive Dashboard Development with drill down capabilities.
• Creating Pivot tables, views, charts.
• Configuring iBots to deliver Analytics content based on schedule, automated iBot queries to obtain daily, weekly and monthly reports.

Education: Confidential

Technical Skills

Operating Systems:

Unix, Windows 2003/2000 Server, XP Professional.

Business Intelligence:

Oracle Business Applications 7.9.4, OBI EE-Dashboards, Answers,
Ibots, BI Publisher.

Databases:

Oracle 11G/10G/9.2/8i/

Database & Office: Tools

MS Office Enterprise,

Languages:

SQL