Oracle Fusion Cloud FDI OAC Reports Lead - Independent Consultants

Role:
Oracle Fusion Cloud FDI OAC Reports Lead

Location:

US – Irvine

Candidate must be located in Irvine or nearby and be willing to come to the customer office daily (Mon‑Fri).

• 7+ years of experience in Oracle reporting and analytics.
• Manages the end‑to‑end delivery of Oracle-based analytics, data warehousing, and reporting solutions.
• Work closely with functional teams to gather, interpret, and convert business requirements into detailed technical design documentation.
• Strong hands‑on experience with BI Publisher (BIP), OTBI (Analytics, Dashboards, Subject Areas) and Fusion Data Intelligence (FDI).
• Working knowledge of Oracle Fusion duty roles, privileges, and data security.
• Securing OTBI and BIP reports using role‑based access control (RBAC).
• Performance tuning of BI extracts, OTBI queries, and custom data models.
• Lead comprehensive data validation processes to ensure dashboard metrics accurately align with source data (OTBI/BIP) while upholding security policies and data modeling best practices.

• Proficient in designing advanced report layouts using RTF, Excel, and PDF templates.
• Strong experience in building XML data models, data sets, and complex report logic.
• Skilled in configuring and managing bursting definitions for automated, rule‑based report distribution.

• Expertise in developing dashboards and analyses across various subject areas.

• Hands‑on experience with Semantic Model Extension (SME), data augmentation, and Oracle Analytics Cloud (OAC).
• Experience working within the Oracle ERP Fusion Cloud environment.
• Proficiency in SQL, XML, XSLT, and data modeling techniques.
• Strong understanding of Fusion data structures across key functional modules (FIN/SCM/HCM).
• Excellent communication, documentation, and client‑facing skills.
• Ability to communicate complex technology solutions to diverse teams namely, technical, business and management teams.
• Experience managing team size of 5‑6 would be a plus.