Principal Hyperion EPM Infra administrator

About The Role :

This position is for an experienced professional with a hands-on EPM infra-administration background in the Oracle Hyperion (on-prem) suite of products. Primary responsibilities include managing day-to-day operations, end-user support, and supporting project initiatives across the EPM platform. This position will partner closely with functional teams to solve complex business issues and design scalable system solutions. This is a highly visible role and will be critical in solidifying a "best-in-class" EPM solution for the company.

Ideal candidate understands not only the concepts of Hyperion but also how they apply to the day-to-day processes of a Production business environment. Responsible for supporting critical business operations. Works independently to provide quality services to multiple customer engagements. Performs varied and complex duties and tasks that need independent judgment to support Oracle products and technology to meet customer needs. Applies Oracle methodology, company procedures, and leading practices. Experience in EPM cloud is a big plus.

Career Level - IC4

Responsibilities

This position is for an experienced professional with a hands-on EPM infra administration background in the Oracle Hyperion (on-prem) suite of products. Primary responsibilities include managing day-to-day operations, end-user support, and supporting project initiatives across the EPM platform. This position will partner closely with functional teams to solve complex business issues and design scalable system solutions. This is a highly visible role and will be critical in solidifying a "best-in-class" EPM solution for the company.

Ideal candidate understands not only the concepts of Hyperion but also how they apply to the day-to-day processes of a Production business environment. Responsible for supporting critical business operations. Works independently to provide quality services to multiple customer engagements. Performs varied and complex duties and tasks that need independent judgment to support Oracle products and technology to meet customer needs. Applies Oracle methodology, company procedures, and leading practices. Experience in EPM cloud is a big plus.

Responsibilities

* Analyze functional and operational issues reported by the customer with their Oracle EPM/Hyperion environment and provide the solution or workaround on time
* Analyze user requirements to develop, implement, and support Oracles global infrastructure.
* Manage operations and end-user support of Hyperion EPM 11x platform:HFM, ERPi, FDM, Planning, Essbase, Essbase Studio, ODI, and Financial Reports
* Troubleshooting integration and data issue across various Hyperion applications and boundary systems
* Coordinate operational handover with global support teams
* Assist Business Partners With Application Issues, Configuration And Administration Issues.
* Proactively monitor and streamline tasks and procedures following company standards
* Work interdependently with technical infrastructure teams, application teams, and business units to ensure service delivery is meeting business objectives
* Establish and perform standard operational policies and procedures
* Coordinate monthly/quarterly patching activities with Infra teams
* Coordinate and perform monthly deployments/release in collaboration with functional teams
* Monitor, analyze and tune Hyperion system performance as required
* Modify/tune existing batch scripts, VB scripts, consolidation/business rules, and Essbase calc scripts
* Participate in system testing, data validations, and stress testing of new enhancements/features
* Manage daily terminations from Hyperion systems per SOX requirements
* Create technical documentation, including data flow charts, system diagrams, formulas and methods for solving business problems, incorporating infrastructure requirements and interfaces.
* Update/create end user training documents for HFM and Hyperion Planning/Essbase (including forms, grids, Smart View etc)
* Take on various roles regarding project initiatives while following strict deadlines
* Provide Business Continuity And Disaster Recovery Solutions For Hyperion Environment, Including:Disaster Recovery Testing, Backups, And Recovery Policies And Procedures.
* Responsible for improving technical process and developing new processes to improve Oracle support for customers.
* Work with Project Manager and customer implementation team to make sure Hyperion project is on track and there are no technical issues in customer Hyperion environments.
* Provide Mentoring And Cross-training To Peers And Interdependent Team Members.
* Setup new releases of Hyperion application on internal lab environment, devise architecture & standards before these release become customer ready.
* Collaborate with offshore team members and business customers globally
* Customer Management
* Ability to understand customer urgency and sensitivity of the problem
* Strong Verbal and Written communication skills
* Ability to speak confidently and communicate clearly with the customer
* Strong Adherence to Process and be process champion

Requirements :
* Knowledge of Hyperion/EPM 11.1.2.4, 11.2.x
* Experience of Hyperion EPMA, Workspace, HFM, ERPi, Hyperion Planning, Essbase (BSO/ASO), FDMEE/ODI, Essbase Studio & Smartview is a must.
* Hands-on experience with Installation of Hyperion 11.2.x/11.1.2.4 on Linux/Windows OS
* Experience with upgrade of Hyperion application from 11.1.2.3 to 11.1.2.4/11.2.x
* Experience with Migration of on-premise Planning & HFM application to OCI
* Knowledge of Oracle 12c/19c database
* Experience with setting up Hyperion application with Oracle Database and management of Oracle DB
* Knowledge of Weblogic application server
* Performance tuning with Hyperion Planning & HFM
* In-depth experience with Migration of Hyperion Planning/HFM/FDMEE from one environment to another
* Knowledge of User Management in Hyperion and Integrating them with OID, LDAP and MSAD Server
* Hands-on experience and troubleshooting performance issues with Hyperion
* Knowledge of Oracle Cloud Infrastructure (OCI) Services like LBaaS, Compute, NSGs, Security List, Gateways
* Knowledge of Ansible, Terraform & other Cloud scripting solutions is a plus
* Working Knowledge on Linux platform desirable
* Customer Support and/or consulting experience preferable
* Experience in the use of other Oracle Products
* Experience in cloud EPM solutions a big plus
* Understanding of HFM consolidation rules, data forms/grids, reports and journals
* Expertise in Essbase calc scripting and MaxL batch scripting
* Experience with Hyperion clustered environments and VM infrastructure is a plus
* Expertise with Hyperion system tools for monitoring, testing, performance tuning, and debugging.
* Strong understanding of Windows Server, Active Directory & network technologies is important
* Must have a strong desire for process improvement and automation
* Manage time efficiently with the capacity to handle multiple tasks concurrently under minimal supervision
* Experience with high levels of accountability; demonstrated initiative, innovation, and flexibility
* Excellent verbal, written, and interpersonal skills
* Must be a team player and be able to build consensus with others team members
* Hyperion certification is preferred but not required
* Ability to work well in a demanding customer environment and delight customers
* Highly motivated and work well as part of a team. Confidence to integrate yourself within an established team
* Responsible for ensuring that best practice standards and methods are applied as appropriate
* Bachelor's Degree in Computer Science, Engineering, MIS, or related experience

Skills (good to have)
Knowledge of ServiceNow, SRs, RFCs, and My Oracle Support will be a plus
Knowledge of OAC-Essbase, Essbase 19c and Essbase 21c will be a plus
Implementation experience in DRM
EPMA to DRM migration for Hyperion 11.1.2.x to 11.2.x