Specialist - Package Implementation

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