Logo
Compunnel Inc.

Oracle Fusion BIP & OTBI Consultant

Compunnel Inc., Scottsdale, Arizona, us, 85261

Save Job

Manager- Recruitment @ Compunnel Inc. | HR Business Partnering Role: Oracle Fusion BIP & OTBI Consultant

Location



Scottsdale, AZ (Hybrid- 3 days a week Onsite)

Duration – Contract (12+Months)

Description:

Mandatory Skills:

Oracle SaaS Integration, Oracle SaaS Personalization, Oracle SaaS BI Publisher, Oracle SaaS FBDI (File Based Data Integration), Oracle SaaS Data migration, Oracle SaaS OTBI reports, Oracle Application Framework (OAF)

Core Responsibilities:

Design, develop, and maintain BIP and OTBI reports across Oracle Fusion modules (Financials, HCM, SCM).

Create custom dashboards, infolets, and formatted reports using RTF, Excel, and E-text templates.

Mandatory – Optimize existing reports for performance and standardization across business units.

Implement bursting logic for BIP reports to distribute outputs to multiple stakeholders.

Build and manage data models using SQL and PL/SQL.

Work with FBDI, HDL/HSDL for data loading and extraction.

Mandatory - Retrofit EBS report source codes into Fusion compatible source codes, especially on BIP reports while factoring customizations in the landscape.

Configure BICC offerings and identify PVOs and data elements for reporting.

Integrate reports with REST/SOAP APIs and schedule via ESS jobs.

Collaborate with cross-functional teams to gather requirements and translate them into technical specifications.

Provide post-implementation support, including troubleshooting and enhancements.

Work closely with Oracle Support for issue resolution and compliance adherence.

Maintain documentation for technical processes, report specifications, and user guides.

Participate in sprint ceremonies and daily standups to ensure timely delivery of tasks.

Required Skills & Experience

Technical Expertise

8–15 years of experience in Oracle Fusion /other implementations and support.

Proficiency in Oracle BI Publisher (BIP), Oracle Transactional Business Intelligence (OTBI), SQL, PL/SQL.

Experience with FBDI, HDL, HSDL, BICC, ESS Jobs, Sandboxes.

Knowledge of REST/SOAP APIs.

Functional Knowledge

Deep understanding of Oracle Fusion modules: Core HR, Financials (AP, AR, GL), Procurement, Compensation, Talent Management.

Familiarity with P2P and O2C cycles, WMS, OTM and their reporting requirements.

Soft Skills

Strong interpersonal and stakeholder management abilities.

Excellent communication, documentation, and problem-solving skills.

Ability to work independently and in a team across global delivery models.

Seniority level

Mid-Senior level

Employment type

Contract

Job function

Information Technology

Industries

IT Services and IT Consulting

#J-18808-Ljbffr