Position : Hyperion Planning & Essbase

Experince: 12

Location : Seattle , WA Once in a while

Duration : Long term

Hyperion Planning & Essbase resources

The desired profile will have more 12 years of IT experience and minimum 8 years of experience in the Hyperion suite of products with focus on Hyperion Planning (Version 11.x) & Essbase. FP&A with robust Hyperion skills/RDBMS & SQL skills, FDM (Financial Data Quality Management) is mandatory. Knowledge in Oracle EPM Cloud is nice to have/ beneficial.

Technical skills

• In depth knowledge in Hyperion Planning & Essbase /FP&A processes.
• Expertise in Forecasting processes of Hyperion Planning/EPM Cloud
• Expertise in BSO and ASO Essbase cubes/Hyperion Planning and Reporting
• Experience in design and development of Planning data forms, business rules, workflow and security
• Experience in design and development of Essbase outlines, load rules, calculation scripts and security
• Experience in RDBMS Skills, SQL skills and FDM
• Should be able to quickly assess the Hyperion planning landscape and work with customer to get the knowledge.
• Should be able to support Documentation of current Hyperion landscape
• Should be able to communicate with offshore team and validate their work
• Experience in setting up of test environment, writing test scripts, supporting end users in testing
• Experience in batch scripting, scheduling, ESSCMD and MAXL/EPM Automate
• Expertise in performance tuning and optimization
• Should have relevant experience in maintenance and support projects (month/quarter/year end tasks)
• Experience in Project planning starting from requirements gathering and entire project execution

Work responsibilities includes :

• Review and understand forecast pain points /enhancement requirements (including functionality managed in Excel, Power BI, and other bolt-on solutions)
• Document near-term to medium-term forecasting process/functionality requirements.
• Document the forecast operations /governance model sequence and align it with the planning calendar /security changes.
• Define/design solution options (Enhance the current Hyperion cube or build a new Hyperion cube or Other alternatives)
• Integrate new or updated data sources with Hyperion or Other solutions.
• Deploy enhanced capability (to eliminate the risk of unregulated peripheral systems affecting Hyperion's stability and jeopardizing the forecasting process).
• Review and prioritize minor enhancement and data harmonization requests, working closely with engineering teams to ensure their implementation.

Ownership:

• Completely own the Oracle EPM/Hyperion Planning & Essbase track of Client and its roadmap
• To take ownership of issues and work on issue resolution

Leadership:

• Service Delivery: Ensure all the delivery parameters are met as per defined SLAs
• Recommend procedural and/or operational improvements in SOPs and SOIs for continuous improvement
• Document new business and technical problems & resolutions assessing impact
• Maintaining up-to-date technical knowledge to resolve issues in changing technology environments.
• Ensure all the delivery parameters are met as per defined SLAs
• Ensure all the processes are audit compliant as per policies
• Solution assessments for business problems

Collaboration:

• Collaborate with Oracle for any application bug.
• Proactive and reactive management of support issues, including liaison with business users, system users, partners and 3rd party vendors.
• Interaction with multi-cultural global support teams and internal customers from various geographical regions / countries.
• Ensuring proper communication and coordination within support teams.
• Working or being 'on call' during non-working hours as project or emergency system maintenance requires.

Mentoring:

• Functional and business guidance to the team for complex and critical incidents
• Prepare and delivery of quality manuals / materials for support training

PROFESSIONAL QUALIFICATIONS/ EXPERIENCE

• Hands-on implementation / support experience in HYPERION System 9 and 11/PBCS/EPBCs/Planning Cloud
• Should have good understanding of Finance business function FP&A
• Prior experience as a Techno-functional consultant/business analyst s role with direct interaction to overseas clients.
• Ability to work in a highly structured and process oriented environment essential.