Resolve day to day Production issues. Provide subject matter expertise to the FP&A and Accounting groups in order to assist with reporting cycle.  Candidate must have strong technical Experience background in Hyperion products.


Essential Duties/Responsibilities:
Experience with designing, developing, and supporting complex financial systems.
Must have expertise with Hyperion products specializing in Planning and Essbase.
Must have expertise with automating data loading and strong knowledge of calculations in Essbase cubes.
Must have expertise in EPMA.
Must have expertise in tuning Essbase calculation scripts
Must have SQL knowledge (database)
Must have practical knowledge of enterprise accounting systems (SAP preferred).
Must have implemented Oracle Hyperion Essbase Cubes and familiar with metadata
Advanced knowledge of Excel spreadsheets (macros, VBA, etc.).
Strong written and oral communication skills
Ability to interact with senior management and department heads
Ability to analyze solutions and make recommendations to management
Ability to analyze a problem with limited direction
Design, develop, maintain and enhance energy based financial application programs working within a team-oriented environment using various development toolsets.
Support SOX controls, testing and audits.
Coordinate application requests, prioritization and business communication.
Facilitate requirements gathering efforts and clearly document system requirements.
Development of prototypes/proofs of concept to validate key project assumptions prior to making significant investments.
Documentation of design specifications.
Develop new and enhanced system functionality including custom code and packaged application configuration.
Ensure the successful transition from development to operations including operations procedures and tools such as process control points, reports, and automated monitoring.
Regularly report status and raise issues/risks as appropriate. Anticipate and adjust for problems and roadblocks while eliminating roadblocks within control.
Collaborate with team members and operational groups to identify and prioritize/reprioritize work when necessary.
Develop strong working relationships with individuals at all levels of company, operations, and IT applications and infrastructure teams.
Willingness to work hours as necessary, especially during critical issue resolution and milestone time periods.
Develop string test scripts in order to test a group of related functionality.
Interact with external entities: vendors, service providers and product vendors.