🚀 Oracle Fusion BIP & OTBI Consultant

Only Independent Candidates

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

• 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.
• 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.
• 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.