With over 40 years of experience, the company is the premier post-trade market infrastructure for the global financial services industry. From operating facilities, data centers and offices in 15 countries, THE COMPANY, through its subsidiaries, automates, centralizes, and standardizes the post-trade processing of financial transactions, mitigating risk, increasing transparency and driving efficiency for thousands of broker/dealers, custodian banks and asset managers worldwide. User owned and industry governed, the firm simplifies the complexities of clearing, settlement, asset servicing, data management and information services across asset classes, bringing increased security and soundness to the financial markets. In 2013, THE COMPANY’s subsidiaries processed securities transactions valued at approximately US$1.6 quadrillion. Its depository provides custody and asset servicing for securities issues from 139 countries and territories valued at US$43 trillion. THE COMPANY’s global trade repository processes tens of millions of submissions per week.
Position Summary:
The Hyperion Planning Systems Administrator role will serve as the primary point of contact, system advocate, and subject matter expert for the Hyperion Planning and Hyperion Essbase systems implemented at THE COMPANY (v.11.1.2.3). This includes the maintenance, governance, testing, troubleshooting, and process administration functions required to support the enterprise on a daily basis. The position is expected to build and maintain effective working relationships with the Financial Reporting and FP&A teams to which they support, along with the internal and external IT resources supporting the systems in use. In addition to the daily administrative duties associated with this role, this position is also responsible for identifying enhancement opportunities to the Hyperion suite as implemented, and proactively taking the steps necessary to see them through to Production use following the complete SILC methodology in-place at THE COMPANY.
Principal Responsibilities:
Production System Support
- Serve as the primary point of contact for the Hyperion Planning and Hyperion Essbase applications.
- Support the FP&A team running the annual Budget, periodic LE, and Long-Range Forecast processes in Hyperion Planning and Essbase, run allocation processing in HPCM, and run interfaces using FDMEE.
- Backup the HFM Administrator in support of the Financial Reporting team running the monthly Close (cross-training to be provided).
- Support the annual audit processes - both internal and external audits.
- Troubleshoot Planning/Essbase/SmartView issues and coordinate issue resolution with Development, Infrastructure, and the external hosting vendor (Oracle Managed Cloud Services) using documented procedures.
- Ensure business-as-usual operation of the Production environment on a daily basis, escalating issues to Oracle Managed Cloud Services when necessary.
Systems Administration
- Setup and maintain user access within Shared Services for Hyperion Planning and Essbase. This includes creating and provisioning of user groups, filters and security profiles in alignment with the needs of the business.
- Create/modify, test and promote business rules/calc scripts in Planning/Essbase to meet the needs of the business.
- Create/modify, test and promote Planning/Essbase reports/scripts/data forms to meet the needs of the business.
- Manage and enhance application control procedures for Planning/Essbase.
- Manage migrations and promotion of all changes and upgrades to Planning/Essbase and ensure compliance with change management policies and SILC best practices.
- Manage environment migrations with the external hosting vendor, Oracle Managed Cloud Services.
- Assist with troubleshooting hardware and infrastructure issues and optimization of system performance.
- Coordinate and administer Disaster Recovery testing for the Planning/Essbase applications annually.
- Update the departmental procedures and process maps for Planning and Essbase annually.
- Assist with the administration of users in the Treasury banking applications.
- Cross-train with other members of the Financial Systems Administration team to perform basic admin tasks in MetraNet billing application and JDE ERP application to ensure business continuity.
Business Analysis and Project Support
- Is the lead system advocate and subject matter expert (SME) for the Planning and Essbase applications at THE COMPANY.
- Identify and document opportunities for improvement within the Planning/Essbase suite in alignment with the needs of the business and proactively take the steps necessary to setup, test and deploy systemic improvements in alignment with SILC best-practices.
- Initiate and manage requests for Planning/Essbase enhancements to meet the changing needs of the business. This includes hosting discovery meetings with business and technical staff, defining/documenting requirements, tracking development, performing/coordinating user acceptance testing, and promoting to Production.
- Remain current on the latest Planning/Essbase technology and release notes in anticipation of future business needs and/or to improve productivity and departmental capabilities.
- Provide application knowledge, support, and tips to users.
- Participate in cross-functional projects representing Finance as an SME for the Planning/Essbase suite.
- Coordinate IT activities with Hyperion users, ADM, Enterprise Infrastructure, Oracle product support, and Oracle Managed Cloud Services with respect to system patching, upgrades, outages, troubleshooting, code promotion, etc.
- Is a proactive risk manager for the Planning/Essbase systems and landscape implemented at THE COMPANY.
Experience:
- Minimum 5 years of experience supporting and enhancing Hyperion Planning and Essbase applications in a Production setting (v11.1+).
- Minimum 5 years of experience using Planning/Essbase to administer the annual budget, periodic LE, and Long-Range Forecast processes in a Production setting.
Knowledge and Skills Required:
- 5+ years Hyperion Planning and Essbase administration experience. Very strong preference for experience administering v11.1+.
- Excellent communication skills, both verbal and written.
- Excellent project planning and resource coordination experience.
- Excellent documentation skills required.
- Must be comfortable interacting with management of all levels.
- Able to participate in project work as both a SME and performer.
- Microsoft Office expertise, especially with Excel.
- Strong multi-tasking and time management skills.
- Disaster Recovery and Business Continuity planning experience.
- Experience with system governance to include both establishing policy and enforcing.
- Proficient in knowledge and practice of SILC methodology.
Knowledge and Skills Preferred:
- Hyperion Financial Management v11.1+.
- HPCM v11.1+.
- Hyperion FDMEE v11.1.2.3+.
- Hyperion DRM v11.1+.
- OBIEE Administration/Development (OFMA)
- UPK Development
- Six Sigma quality management tools and methods
- GAAP accounting standards
- Oracle JD Edwards v9.0+
- HP PPM Project Management
- Microsoft Project & Visio
Education, Training &/or Certification:
- Bachelor’s degree required in MIS, Accounting, Computer Science or a related field.
Advanced degree and/or IT certification a plus.
|
MENU
