OBIEE Consultant Resume

SUMMARY

6 Years in the IT Industry, Successful and enjoy working in an integrated, cross - functional environment, where everyone is expected to be hands on. Strive to bring research and analytics to the forefront of the discussion. Have successfully completed several Business Intelligences projects. Expertise in full life cycle business intelligence project management, understanding of all aspects of end to end life cycle design, development, implementation, testing and documentation of business applications using Oracle technologies.

TECHNICAL SKILLS

Reporting Tools: OBIEE 11g, 12C

Tools: SQL Developer

RDBMS: Oracle11g, 12c, MS SQL Server 2014

Languages: SQL

Methodologies: AGILE, SDLC

PROFESSIONAL EXPERIENCE

Confidential

OBIEE Consultant

Responsibilities:

Gathered requirement and prepared functional and technical specification and analyzed the business solution requirement.
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 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.
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