Candidate should have worked 8+ years in Hyperion Techno-Functional (Oracle EPM Cloud Planning / Hyperion planning) in Oil & Gas industry, with experience in the below skills
a. Oracle EPM Cloud Planning (PBCS and EPBCS) and Hyperion Planning (On-premises)
b. Hyperion Essbase (Multi-dimensional database)
c. Data Management, FDMEE and Data Exchange – Data integration
d. Narrative Reporting (EPRCS) and Financial Reporting (FR)
e. Oracle (RDBMS) - SQL and PLSQL
Candidate should have knowledge in Oracle EPM Cloud Planning / Hyperion Planning, Hyperion application – production support, development and enhancements, application administration etc.
Build and maintain the EPM Planning business processes for Forecast, Budget and Planning:
Forecast process
Budget process
Planning process
Approval process
Task lists process etc.
Create and manage the application artifacts:
Metadata
Data
Forms
Business rules
Smart lists
Task lists
Menus
Variables
User and Substitution variables etc.
Analyze and resolve the issues with Hyperion data loads, reconciliation of data etc.
Support business users with Month end close and Year end close activities.
Well familiar with recent EPM cloud features:
Dashboards
Infolets
Sandboxes
Valid intersections
EPM automate
Data Exchange
Data maps and Data integration etc.
Managing Hyperion DBA activities:
Performance and tuning
Optimization
User
Groups
Security access
Shared services
Backup-Restore
Clone workplace
Snapshots
Hyperion services etc.
Work with support team to resolve incidents and work on enhancements and defects.
Candidate should have valuable communication skill and should have experience directly working with customers/end users.