Hyperion EPM / EPCS Consultant

Required Skills :

• Experience in Hyperion Essbase / Planning, PBCS and EPBCS
• Good working knowledge in designing, modifying and building of cubes and assigning member properties in Essbase
• Good Experience in FDMEE
• Proficient in Designing and developing Essbase applications with excellent balance of dense and sparse dimensions, developing various OLAP Models & Meta-Outlines across Block Storage (BSO)
• Optimization of Cubes while loading, retrieving and calculating using different techniques (Hourglass method, cache setting, buffer setting, Dynamic calc, Shared members, outline formula and calc script)
• Have strong knowledge in developing Business Rule and Calculation Scripts
• Exposure to writing custom Essbase calculations scripts, automated the Essbase Cubes using MAXL scripts, Batch Script
• Experience in writing automation scripts to automate the interfaces
• Experience in working with Essbase Excel Add-In and Smart View
• Involved in setting up users and groups using Shared services
• Involved in creating data forms, menus, smart list and task lists for Hyperion Planning and Essbase
• Application and security filtering on data forms in Hyperion planning
• Experienced application security process, created users / groups, security profiles and associated applications to different groups using Security filters
• Knowledge in PL / SQL and database system
• Life insurance exp is plus