Oracle OBI Consultant - OBI EE 10g/11g, Kimball, SDE, SIL, Aggregates,

London  ‐ Onsite
This project has been archived and is not accepting more applications.
Browse open projects on our job board.

Keywords

Description

Oracle OBI Consultant - OBI EE 10g/11g, Kimball, SDE, SIL, Aggregates, SCDs, DAC configuration is required by my client who is based in Farringdon, London

My client is looking for an experienced OBI consultant to join a small OBI team that is responsible for delivering a Global OBI application. The candidate must have good OBI technical knowledge, with at least 3 years OBI development/project experience (10g or 11g), including delivery of at least two significant OBI reporting projects. Demonstrable consultancy skills are a must, with the candidate ideally having a strong consulting background.
Candidate must be able to demonstrate a good technical understanding of the Siebel Sales and Service application, and related Siebel data model. Experience of the Sales and Service OBI Application is not essential, but is preferable.
The role will focus on delivering core CRM reporting concepts to end users in the form of OBI Dashboards and OBI Answers Subject Areas, but simultaneously the candidate must be able to work with/guide off-shore resources and internal resources, whom have little or no OBI knowledge. Experience with other technologies in the OBI stack is a plus, for example, BI Publisher and MS Office integration
The candidate must be able to work closely with BAs and business representatives to define, design and deliver OBI requirements. Candidate must also have experience of delivering end-user training and support end-user adoption of IT applications.

Key Responsibilities:

Driving workshops & owning relationship with business stakeholders & technical teams, such as in-country reporting Power Users or local reporting teams
o Requirements gathering & documentation of Report Requirements
Gap analysis against out of the box OBI capabilities/existing OBI build, including rapid proto-typing to demonstrate or elicit detailed report requirements
Functional design documents for OBI Reports/Dashboards/Subject Areas, following published best practices. Work with BAs and Business Representatives to agree on report deliverables
Produce technical design documents that onshore/offshore resources could build to
OBI Development, including Database DDL/DML, DAC, ETL (Informatica), RPD, Answers, Dashboards etc
Unit Testing development work & peer review configuration of other OBI developers
Support/facilitation of UAT sessions
Deliver knowledge transfer to BAU team and support end-user training activities

Technical Experience:

Minimum 3 years' experience OBI EE development (OBI EE 10g/OBI EE 11g)
Knowledge of Kimball star schemas
Experience in designing/developing Informatica mappings
o SDE, SIL, Aggregates, SCDs
DAC configuration
o Subject Areas, Execution Plans, Index management etc
Experience in designing and developing OBIEE Metadata Repository ie
o Physical Layer, Business model mapping and presentation layer for various subject areas
Experience in developing and configuring Dashboards, Answers Requests,
o Prompts, iBots/Agents and BI Publisher reports as per user requirements.
Able to assist in application performance tuning efforts creating Aggregates,
o Fragmentation, Materialized views, indexes, partitions etc.
Ability to Provide suggestions on OBIEE reports design and enhancements
Understanding of design/development/enhancements as per Oracle recommended leading practices
Ability to manage Repository rollouts to TEST, QA and PROD environments requiring merging repository with Master Repository
Experience in OBI EE administration/capacity planning Understanding of Data
Ability to install OBI EE Components in various OS environments
Experience with the following technologies is a plus:
Oracle BI Applications (Sales and Service)
Weblogic
Essbase/Oracle OLAP
Teradata
JavaSript
HTML/CSS
PL/SQL

Mercator IT Solutions provides services as an agency and an employment business

Start date
ASAP
Duration
6 months
From
Mercator IT Solutions
Published at
23.11.2013
Project ID:
631943
Contract type
Freelance
To apply to this project you must log in.
Register