• Experience with Oracle epm cloud products, such as EDMCS, FCCS, and EPBCS and migration expertise from on-premise to EPM cloud.
• Should possess analytical and implementation/development experience on Oracle EPM Hyperion/EPM cloud Product suite
• Support on-premise migration to EPM cloud, data integrations to cloud applications.
• Familiarity with MAXL for automating the Essbase tasks and EPM automate for cloud applications
• Support EDMCS batch processing for the import and extract operations
• Participate and lead in the design, development, testing and implementation activities relating to project deliverables
• Expected to lead process improvement initiatives.
• Perform periodic maintenance such as loading, clearing and copying data in HFM
• Expertise in Data integration (Data Management, ODI, OIC) and automation of Hyperion and non-Hyperion systems
• Ability to design and troubleshoot Oracle database queries involved with Hyperion applications
• Ability to provide application production support, analyze, design, develop, code, and implement programs in support of Hyperion.
• Ability to translate business requirements to high quality set of technical requirements
• Good understanding of diverse source systems and relational databases in EPM and BI
• Experience handling the windows and Unix batch scripts and automation
• Support the EPM applications and work on enhancements in a distributed global setting
• Experience supporting the following Hyperion applications: Hyperion Financial Management, Hyperion Planning, Hyperion Financial Reports, Essbase, Hyperion Financial Data Management and EPM cloud
• Analyse and Manage the ELT process using ODI (12c) to support the Actual, Plan and Forecast processes for Sales Reporting and ensure data is available to Essbase for month end reporting.
• Define the rule files to manage the metadata and data load cube build processes using Hyperion Essbase
• Manage partitions and customized aggregations on the multidimensional Essbase cubes
• Experience handling the installation and configuration of Oracle EPM Hyperion products
• Must have excellent understanding of PSU’s and CPU’s patches in relation to the Hyperion
• Expected to assist and mentor less experienced team members.
• Expected to support and streamline daily Batch Jobs/scheduled jobs and automate the same.
• Expected to identify potential process improvement areas and suggest options and recommend approaches.
• Independent, knowledgeable, self–motivated and require minimal supervision