What are the responsibilities and job description for the Oracle Consultant position at SANS Consulting Services, Inc.?
Title: Oracle Fusion Cloud FDI OAC Reports Lead
Location: Irvine, CA (Onsite)
Only USC and GC
Description:
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.