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 environment
-
Snapshots
-
Hyperion services etc.
-
Work with support team to resolve incidents and work on enhancements and defects.
-
Candidate should have good communication skill and should have experience directly working with customers/end users.