Hyperion Consultant Responsibilities

• Managing Clients application within Hyperion module.
• Handling business enhancement as per business requirement
• Managing Essbase application and proposing the best solution for the customer request
• Managing Planning application and developing new changes as per rquirement
• Developed & Optimized calc scripts both in Essbase and Calculation Manager
• Created Rule files and Loading the data into Essbase Cubes
• Optimized the application to balance the calculation and retrieval performance needs
• User management
• Maintaining Essbase Analytical Server
• Creating Users and Providing Access of database to users
• Creating MAXL Script for Automation.
• Loading data, Calculating data & Clearing cube
• Assist the documentation team in preparing user guides
• Creating & Managing Outlines of referring cubes
• Writing Xwrite and Xref functions
• Backup, archive, recovery, copy, export and import of Essbase applications and database.
• Migrating Planning Application, Security, Web forms and Business rules.
• Performance tuning Essbase Outlines, Essbase Caches, Business Rules and Data Load Rules.
• ELT Tools (Extract, Load and Transform) : Oracle Data Integrator Version 10/11
• Creation of Interfaces using ODI for loading data from different legacy and accounting systems to Hyperion Essbase.
• Configure and monitor HYPERION application batch job processes.