AddressWhat you'll do
Monitor the Weekly, Monthly and Quarterly patches from Oracle and apply the patches on time for all non-prod and prod environments
Work with security teams to make sure all the EPM products are in compliance with the company policies
Maintain password rotation policy, weekly vulnerabilities and OS updates on all non-prod and prod environments
Perform reconciliations between HFM , Essbase and source system for financial statements like Trial Balance.
Produce consistent and accurate technical and end-user documentation of assigned applications
Understand how assigned applications/systems link with other programs/processes along with the overall system architecture and provide recommendations on how to improve existing/proposed processes.
Adhere to company change management practices.
Provide end user support on Hyperion Essbase, planning, HFM, DRM, ARM and SmartView
Supports the monthly application maintenance process and Participates in the feasibility analysis for new systems/applications.
Monitors the operating efficiency of existing application systems and provides (or arranges for) proactive maintenance.
Reviews, analyzes, and modifies applications, including coding, testing, configuring, and debugging for Hyperion applications. Maintains records to document the system and revisions
Provides technical support to address production issues and Participates in training, as appropriate, on new or revised systems/ applications.
Provides guidance to junior team members and Communicates applications changes to Technology team members
Works independently and provides guidance within technical area, applying in-depth knowledge of multiple technologies, as appropriate
What experience you need
Minimum 10 years of overall experience in Oracle EPM/ Hyperion space with 7- 8 years in Financial Consolidation and reporting Implementations.
Valid and Active Cloud Certification is Mandatory
Proficient in installing, configuring, troubleshooting, managing, upgrading, and administering of Hyperion Suite
Experience with optimizing and integrating Hyperion / Fusion Middleware products
In-depth knowledge and hands-on experience in developing/supporting HFM applications including defining metadata (accounts, entities, scenarios, custom dims, currency, etc…), consolidation methods, member lists, journals, data forms, intercompany transactions, as well as rules development (expressions, functions, variables, sub procedures, conditional / consolidation / elimination rules, string comparisons, subcubes, etc …)
Strong command of Hyperion Essbase technologies, including MaxL, MDX, calculation scripts, and outline optimization techniques.
Familiarity with Oracle Data Integrator (ODI) or similar ETL tools.
Demonstrates an advanced understanding of the following Oracle EPM products (version 11.2.x): Hyperion Essbase and Planning, Financial Data Quality Management, Enterprise Edition (FDMEE), Data Relationship Management (DRM), Financial Management (HFM), Account reconciliation Manager (ARM), SmartView VBA,PowerShell,MaxL
What could set you apart
Oracle Hyperion Certification is a plus.
Experience with Cloud applications like EPBCS,FCCS, ARCS and DataManagement
Knowledge of Oracle EBS, OBIEE, Tableau and other reporting modules
Oracle certified implementation
