Oracle Fusion BIP & OTBI Consultant

  • Scottsdale, AZ
  • Posted 1 day ago | Updated 1 hour ago

Overview

On Site
Contract - W2
Contract - 10 Month(s)

Skills

Oracle Fusion BIP & OTBI Consultant

Job Details

Only Independent Candidates

Job description

Job Description: Oracle Fusion BIP & OTBI Consultant

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.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.