Oracle Consultant

Oracle Fusion Cloud FDI OAC Reports Lead

Location:

Irvine, CA (Onsite)

Only USC and GC

We need the candidate to be in Irvine /nearby to Irvine and must be willing to come to Customer office (Irvine) every day (Mon
- Friday).

• 7+ years of experience in Oracle reporting and analytics.
• Manages the end-of-the-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.

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

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.