Oracle at SANS Consulting Services, Inc. Costa Mesa, California

Oracle Fusion Cloud FDI OAC Reports Lead

We need the candidate to be in Irvine /nearby to Irvine and must be willing to come to Customer office (Irvine) every day (Mon- Fri). Pls ensure that you get the confirmation from the candidates prior to sharing the profiles

Skills:

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

BI Publisher (BIP):

• 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

OTBI:

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

FDI:

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