o Over 13+ years of IT experience & 10+ years proven success record in working with Oracle and Hyperion.
o Having good hands on providing maximum availability for all components to ensure to have robust, reliable and performing best in class Hyperion Solution.
o Work with Business Analyst to take the requirement then implement in EPM Products (Essbase, Planning, FR, etc.)
o Work with several application to resolve complex business process and simplified them in Calculation Scripts.
o Evaluation of EPM Migration from on-prem to Oracle-based cloud solution (SAAS) and PAAS based architecture.
o Migrated On-Prem Planning to PBCS/EPBCS and FCCS.
o Requirement gathering from business and transform them into EPM application, as a part of end-to-end migration.
o Good hands-on working with backend Essbase database (outline design, member formula, Calc script, ASO and BSO storage)
o Installation, Configuration, Migration and Upgradation for most of the on-prem EPM Suite (Planning, Essbase, HFM, DRM, FR, FDMEE, FCM, ARM, etc.)
o Created Jython, Batch Scripts (powershell & bash) and automated tasks FDMEE.
o Worked with several planning application and its modules – Workforce, Capex and Reporting.
o Created several Hyperion forms, Task Lists, Menu items, data maps and Smartlist.
o PBCS Security configuration (Users) with organization Active Directory.
o Generate Audit Reports when needed for SOX compliance.
o Work with Oracle 3rd line support in case of Bugs reported by Business users.
o Research & Development on new features, create test cases and educate business users to enhance the performance.
Translate business requirements into functional design, collaborate with Developers to
ensure functional design is clearly articulated.
Collaborate with FP&A and Accounting team to ensure Hyperion Applications are
synced.
Work on business enhancements and update HFM and Planning Objects (Rules/forms).
Act as liaison with business for troubleshooting: investigate, analyze, and solve
application and user issues.
Design and develop documentation for new system functionality to cover business
processes and system functions.
Collaborate with Functional and Technical teams on testing; unit, integration, functional,
acceptance system, regression, database, analyze results, manage defects, and resolve
issues.
Create documentation and training materials and assist with organizational change
management, including training.