Key Responsibilities
- Develop interactive dashboards and reports using OAC Data Visualization DV
- Integrate OAC with Oracle EPM Cloud PBCS EPBCS Planning etc
- Configure connections between OAC and EPM Essbase REST API Data Management
- Design and implement data models datasets and data flows in OAC
- Work with Finance and Business teams to gather reporting requirements
- Develop calculated measures hierarchies Gen1Gen4 and custom KPIs
- Implement rowlevel security and application roles
- Optimize dashboard performance and Essbase query performance
- Support environment migration DEV TEST PROD
- Troubleshoot connectivity integration and performance issues
Required Skills
- Strong experience in Oracle Analytics Cloud OAC DV
- Handson experience with Oracle EPM Cloud modules Planning FCCS etc
- Experience working with Essbase cubes
- Strong SQL knowledge
- Experience with Data Flows Data Sets and Data Blending in OAC
- Experience in creating Pivot tables hierarchical columns and drilldown reports
- Knowledge of REST API integration
- Good understanding of Financial reporting and Planning processes
Preferred Skills
- Experience with OBIEE OAC
- Experience integrating OAC with Snowflake or other cloud data platforms
- Knowledge of IDCS OCI security configuration
- Experience in crosstenancy federation between OAC and EPM
- Understanding of Financial Consolidation and Planning processes
This job is provided by Shine.com
