Oracle Business Analyst (EPM)

Role description

• Must have a complete project lifecycle experience in a Planning Budgeting Cloud
• Driving technical design of suitable metadata load solution using Outline Load Utility, EPM Automate, FDMEE
• Minimum 1-2 full life cycles implementation experiences with EPBCS modules
• Troubleshoot, analyze provide fix for Essbase/Planning/ EPBCS/PBCS/FDMEE or Data Management related issues – Proactive tuning, optimizing, and maintenance of the Hyperion Planning applications.
• Driving System Integration Testing and supporting User Acceptance Testing of the data integration solution.
• Experience on Infrastructure activities which are Hyperion application Patching, migration, upgradation.
• Be familiar with Jython scripting
• Experience in Hyperion Shared Services and security model
• Proficient in writing Business Rules and Calc scripts.
• Experience into Performance Tuning.
• Have experience creating data maps, data integration & writing MDX scripts
• Know how to implement partitioning between applications
• Have the ability to create calculations, forms, menus, task lists and run Essbase ad-hoc reports
• Possess the knowledge on how to implement process management
• Understand how to set up security for users and groups and assign access in the applications and reports
• Be able to migrate applications between multiple environments
• Have managed User Acceptance Testing (UAT) sessions and familiar with writing UAT scripts
• Have led training sessions for UAT testers and / or end users
• Possess knowledge of budgeting, forecasting, and long-range planning processes
• Possess the drive to make project deadlines using scope, resources, and time as levers
• Be comfortable working with customers, managers, and other team members
• Possess a positive attitude
• Have the ability to translate technical concepts into terminology that non-technical people can understand
• Be able to work as part of a virtual team, where team members can work all over the world
• Pay attention to detail, be conscientious and self-motivated, possess excellent organizational skills, and deliver quality end results
• Have ability to learn and leverage Oracle’s existing systems, such as DRM and OIM, to improve the current processes
• Perform varied and complex tasks that will require independent judgement as well as team consensus

Knowledge, Experience and Skills

• A graduate degree in in Information Systems, Computer Science or related field strongly preferred
• 6 – 8 Yrs. experience in Essbase, Planning, HFM, FDMEE, ARCS, PBCS/EPBCS/ARM/ARCS with strong Application Development process, Design, Functional, Technical, UAT, SIT Go-Live.
• Expertise in Hyperion System 11x for Planning, Essbase BSO, ASO, FDMEE & ODI.
• Proficiency in Hyperion EPMv11.1.2.4 HFM, Hyperion Planning, Essbase, FDMEE, DRM, EBPCS, FCCS
• Be familiar with the functionality of Oracle Data Integrator (ODI), Financial Data Quality Management Enterprise Edition (FDMEE), Data Management, EPM Automate, and other ETL tools
• Expert in Groovy Scripting
• Must have excellent communication and interpersonal skills to interact with a wide variety of internal and external customers in the business
• Excellent presentation skills, team management & motivation skills
• Knowledge of ITIL processes and certification is good to have

Essential skills

Oracle Business Analyst