OBIEE Consultant Resume

SUMMARY:

6 years of experience as an OBIEE Developer providing end - to-end business intelligence solutions.
Over the years have worked on OBIEE 11g.
Successfully completed projects as OBIEE Developer, have expertise in dimensional modeling design, building business models, configuring metadata, creating reports and using dashboards.
Have excellent problem solving skills with a strong technical background and good inter-personal skills.
Excellent critical thinker and strong team player with the ability to work under pressure and meet deadlines.
Well versed in interacting with Business users conducting interviews to gather, analyze and document user needs, business processes, identifying reports and Key Performance Indicators and rolling out deliverables.

TECHNICAL SUMMARY:

Business Intelligence: OBIEE- Dashboards, Answers/Analytics, Admin Tool.

Databases: Oracle 11G and 10G.

Operating Systems: Windows 2003/2000 Server, XP Professional and Linux

PROFESSIONAL EXPERIENCE:

Confidential

OBIEE Consultant

Responsibilities:

Worked 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.
Involved in meetings/interviews with users and data analysts, and examined the business, functional and technical requirement documentation.
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.
Analyzed and validated the business model in the Admin tool by performing consistency check, validating logical table sources, logical columns and also validating repository level calculations done in the business model layer.
Performed 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. Established the logical joins/keys required to support drill-down aggregation.
Created dimension hierarchies and assigned levels for each level.
Designed and Configured 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.
Used filters and customized prompts appropriately to avoid excessive data showing up on reports.
Created pivot tables allowing managers to analyze the business in different perspectives an in orderly summarized manner.
Created agents/ibots to alert users so that they can be proactive and make decisions in a timely cost effective manner.
Identified the aggregate levels for each source and created dimension sources for each level of aggregates. Involved in meetings/interviews with users and data analysts, and examined the business, functional and technical requirement documentation.

Confidential

OBIEE Consultant

Responsibilities:

Gathered requirements for the different subject areas.
Met with business representatives, business analysts and end users to understand the business models and estimating schedule for deliverables. Present the document to the BI team and implement.
Built the Physical, Business Model and Mapping and Presentation Layers of the repository.
Used BI answers to run queries, create reports and validated the repository.
Created dimensional hierarchies and level based measures, built time and calculated measures of a fact table.
Worked on various reports /Dashboards in BI Analytics with different analytics views (drill-down, dynamic, Narrative views, charts, pivot tables, column selector, and local filters.
Created groups in the repository and added user to the groups and granted privileges explicitly through group inheritance.
Verified and validated the reports, dashboards and underlying RPD / ETL.
Worked extensively on performance tuning including creating aggregate tables, caching.
Created Agents for job-critical levels and auditable differences delivered to dashboards, email and cell phones to assist process owners with timely decision making.
Worked in a Multi User Development Environment ( MUDE) check out repository, made changes, and completed the merge process

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship