Oracle Hyperion Lead Consultant

Responsibilities:

• Lead Hyperion support projects.
• Provide day-to-day support for Oracle Hyperion applications, including issue resolutions.
• Coordinate with business users to understand and resolve functional and technical issues.
• Stakeholder management
• Perform root cause analysis and implement corrective actions.
• Maintain documentation for configurations, processes, and procedures.
• Participate in enhancements and change requests as part of continuous improvement.
• Support financial close cycles and ensure timely resolution of issues impacting reporting and planning.
• Maintain metadata, business rules, calculation scripts, and data load processes across Planning, HFM, and Essbase.
• Manage FDMEE integrations and troubleshoot data load and mapping issues.
• Administer and maintain DRM/DRG hierarchies and workflows.
• Support Smart View users with connectivity, performance, and data retrieval issues.
• Maintain and enhance Hyperion Financial Reports (HFR) as per business requirements.
• Monitor and troubleshoot data flows between EBS and Hyperion.
• Work in Rotational shifts

Required skills and experience

• 10+ years of hands-on experience in Oracle Hyperion Planning, Oracle Hyperion Financial Management (HFM), Oracle Essbase, Oracle FDMEE,Oracle Data Relationship Management (DRM) including Data Relationship Governance (DRG), Smart View, Oracle Hyperion Financial Reporting (HFR)

Strong knowledge of Essbase, Calculation Scripts, Business Rules, and Smart View.

Required skills and experience

• Proficiency in DRM/DRG, Smart View, and Hyperion Financial Reporting.
• Experience with data integration tools (FDMEE, Data Management, ODI, etc.).
• Proficiency in troubleshooting application and performance issues.
• Well-versed in financial planning and budgeting process.
• Troubleshooting data integration and reconciliation issues between Oracle EBS and Hyperion.
• Hands on knowledge in Essbase (ASO/BSO), MaxL scripting, and performance tuning.
• Hands on knowledge of scripting (Batch/Python/Powershell)
• Automate data loads , metadata updates,and security provisioning.
• Excellent communication and documentation skills.
• Experience working in a managed services or support environment.
• Experience in participating and leading knowledge transition sessions.

Required Modules and Area:

• Oracle Hyperion Planning
• Hyperion Financial Management (HFM)
• FDMEE
• Data Relationship Management (DRM) including Data Relationship Governance (DRG)
• Smart View
• Hyperion Financial Reporting (HFR)
• Oracle E-Business Suite R12 (Integration)