OBIEE to OAC Migration Consultant

OBIEE to OAC Migration Specialist

8+ Months Contract

Position location: Concord, NH (Remote or Onsite/Hybrid OK)

Work Hours: 37.5

Complete Description:

JOB DESCRIPTION:

This position will be responsible for the migration of the agency's existing Oracle Business Intelligence Enterprise Edition (OBIEE) environment to Oracle Analytics Cloud (OAC). The intent is to ensure a complete, secure, and supportable migration while enabling knowledge transfer to client's staff. Candidates must have experience aligning with the responsibilities detailed in the job description below, as well as providing the types of relevant deliverables listed as well. Do not submit a candidate unless they have served as a specialist in an OBIEE to OAC migration, meeting the skills/requirements listed.

Overview:

The applicant must demonstrate hands-on experience in the following areas:

OBIEE administration and development (RPD, Catalog, Security)

Oracle Analytics Cloud (OAC) architecture and administration

Oracle Cloud Infrastructure (OCI)

Identity and Access Management (IAM), including Azure Entra ID integration

SQL and data modeling

BI migration tools and automation

Performance tuning and troubleshooting

Documentation and knowledge transfer

Responsibilities/Expectations Include:

Discovery & Assessment

Evaluate the current OBIEE environment, including:

Architecture, version, and topology

RPDs, subject areas, and metadata

Catalog content (dashboards, analyses, agents)

Customizations (JavaScript, skins, ActionFramework)

BI Publisher reports (if applicable)

Assess usage, performance metrics, and user activity

Identify external dependencies and integrations(data sources, schedulers, APIs)

Identify unsupported, deprecated, or low-usage content

Deliverables

OBIEE Assessment Report

Content Inventory and Usage Analysis

Migration Readiness and Risk Assessment

Security & Identity Management

Document current OBIEE security model:

Users, groups, application roles, and policies

Data-level(row-level) security rules

Design and implement OAC security model

Integrate OAC with Azure Entra ID for authentication

Map OBIEE application roles to OAC roles

Validate data access and role-based security post-migration

Deliverables

Security Mapping Document (OBIEE OAC)

Entra ID Integration Configuration

Security Validation Results

Functional Gap Analysis

Compare OBIEE functionality with OAC capabilities

Identify gaps, limitations, or redesign requirements, including:

OBIEE Answers vs OAC Data Visualization

Agents vs OAC scheduling

Write-back functionality

BI Publisher and pixel-perfect reporting

Custom JavaScript compatibility

Recommend mitigation or redesign strategies using OAC-native features

Deliverables

Functional Gap Analysis Report

Recommended Remediation or Redesign Plan

Migration Strategy & Planning

Define migration approach (phased vs big-bang)

Develop a detailed migration plan including:

Timelines and milestones

Resource assignments

Cutover and rollback strategy

Parallel run (if required)

Validate user access to dashboards, analyses, and data

Deliverables

Migration Plan and Schedule

Cutover and Rollback Plan

OAC & OCI Environment Setup

Provision OAC environments (Dev/Test/Prod)

Configure OCI components and networking

Configure security, roles, and access controls

Validate connectivity to on-premises and cloud data sources

Deliverables

OAC Environment Configuration Documentation

Connectivity and Access Validation Report

Backup & Risk Management

Perform full backups of OBIEE RPDs and Catalogs

Validate backup completeness

Establish version control for migrated artifacts

Deliverables

Backup Validation Report

Version Control Strategy

Data & Metadata Migration

Clean and prepare metadata for migration

Migrate RPDs to OAC and convert metadata as required

Validate:

Subject areas

Logical table sources

Aggregations and hierarchies

Session variables and initialization blocks

Migrate OBIEE Catalog to OAC

Deliverables

Migrated and Validated RPD

Migrated OAC Catalog

Metadata Validation Results

Connectivity & Integrations

Configure and validate OAC data connections

Implement on-premises data gateway if required

Configure caching and refresh strategies

Validate credential management

Deliverables

Data Source Connectivity Configuration

Refresh and Caching Strategy Document

Customizations & Extensions

Identify custom scripts and extensions

Migrate supported customizations

Redesign or replace unsupported functionality using OAC-native features

Deliverables

Customization Compatibility Assessment

Redesigned Solutions Documentation

Testing & Validation

Perform functional testing of reports and dashboards

Validate data accuracy against OBIEE

Support User Acceptance Testing (UAT)

Conduct performance testing and benchmarking

Deliverables

Test Plans and Test Results

UAT Sign-Off Documentation

Go-Live & Post-Go-Live Support

Promote OAC environment to production

Support go-live activities

Provide hypercare support

Monitor performance, usage, and errors

Deliverables

Production Go-Live Checklist

Hypercare Support Plan

Knowledge Transfer & Documentation

Deliver comprehensive technical documentation, including:

As-is and To-be architectures

Security and role management

OAC administration and operations

Conduct knowledge transfer sessions for staff

Deliverables

Complete Technical Documentation Set

Knowledge Transfer Sessions and Recordings