Hyperion Planning Consultant

We are seeking an EPM - Planning Consultant to join donyati.

Job Description:

Detailed Job Description for the Position

Key Responsibilities:

• Proven experience with large-scale implementation of Hyperion Essbase & Planning version 11 or higher.

• Develop and maintain Hyperion Planning and Essbase applications.

• Strong understanding of ASO/BSO cube development.

• Experience working on Windows and Unix/Linux platforms.

• Knowledge of writing basic SQLs.

• Experience with Smart View, web forms, reports, MXL, and Unix shell scripting.

• Oracle Relational Database experience is a plus.

• Fundamental knowledge of financial systems and business processes, especially around planning, budgeting, forecasting.

• Create, document, and implement scalable solution designs and implementation plans.

• Prepare key deliverables such as requirements documents, design documents, test plans, training materials, and solution delivery.

• Supervise, develop, and mentor junior consultants throughout project life cycles.

• Apply structural knowledge to solve problems, break down issues, and identify solutions.

Technical Skills:

• Develops and maintains an Essbase reporting environment and reports in Smart View for an Enterprise Finance Analytics environment.

• Provides technical and functional support, making necessary changes in the data layer and creating/modifying reports per user requirements.

• Assists in continuing improvements to the overall usability, scalability, reliability, and performance of the data warehousing environment.

• Utilize Best Practice BI Implementation Practices.

• At least 4-7 years of experience in designing, developing, and maintaining BI infrastructure & reports in Hyperion Essbase applications (preferably with version 11.1.2.4).

• Familiar with standard concepts, practices, and procedures within the scope of database design and database management.

• Must have experience with the latest releases of Essbase 11.1.2.2, 11.1.2.3, or 11.1.2.4.

• Experience with Hyperion Planning (ASO and BSO cubes) is a must.

• Familiar with the Hyperion Product Suite, including Essbase Administration Services (EAS), Shared Services, Essbase Studio, EPM Workspace, Financial Reporting, Hyperion Data Relationship Manager (DRM), and Smart View.

• Experience with security for Planning/Essbase users, groups, and dimensions and administer access.

• Experience with batch scripting, shell scripting in Unix, automation using MaxL, Visual Basic, and/or other scripting languages.

• Excellent analytical, problem-solving, and debugging skills.

• Demonstrated skills building and managing a reporting environment.

General Requirements:

• Meet Development Team Assignment & Project Deadline.

• Work with Team Lead to Convert Technical Specifications into Reports or Components.

• Creation of Technical, Functional & System Specifications, Development, & Documentation.

• Ensure Delivery Quality.

• Liaise with Technology and Data Support teams, DRM team, Data Integration team, & Hyperion Planning team.

• Compliance with Program Standard.

• Preparation of Weekly Project Updates for BI Technical Lead and BI Architect.

• Participate in Project Meetings, Team Workshops, and Team Training.

• Well organized and results-driven.