Oracle Hyperion EPM Consultant

Cerebra; Hyderabad; On-site; INR 2,000,000 - 4,000,000; Full time

Job summary

Cerebra is seeking an experienced Oracle EPM consultant to design, implement and optimize Hyperion Planning and Essbase-based solutions. You will configure ARM/ARCS reconciliation workflows, support data integration with ODI/FDMEE, and deliver Smart View reports and dashboards.

The role involves requirement gathering, testing, deployments, and production support within enterprise finance environments. The ideal candidate has hands-on experience with PBCS/FCCS in EPM Cloud, financial close

Qualifications

• Experience with Oracle Hyperion Planning and Essbase for planning and budgeting.
• Strong knowledge of ARM/ARCS reconciliation workflows and auto-matching.
• Familiarity with ODI/FDMEE data integrations and EPM cloud offerings.

Responsibilities

• Design, develop, and enhance Oracle Hyperion Planning applications and Essbase cubes.
• Configure and support Oracle ARM/ARCS reconciliation workflows, auto-matching, and compliance reporting.
• Gather business requirements and translate them into Oracle EPM solutions.
• Develop and maintain Smart View reports, dashboards, and ad-hoc reports.
• Build and manage data integrations using FDMEE and ODI.
• Perform application maintenance, performance tuning, and issue resolution.
• Support month-end, quarter-end, and year-end financial close activities.
• Participate in unit testing, UAT, deployments, and production support.
• Prepare technical and functional documentation.

Tools

Oracle Hyperion Planning

Oracle Essbase

Oracle ARM / ARCS

Financial Close & Reconciliation

Smart View

ODI / FDMEE

Oracle EPM Cloud (PBCS FCCS ARCS)

Financial Statements (P&L, Balance Sheet, Cash Flow)

SDLC & Agile Methodologies

Job description

Key Responsibilities

• Design, develop, and enhance Oracle Hyperion Planning applications and Essbase cubes.
• Configure and support Oracle ARM/ARCS reconciliation workflows, auto-matching, and compliance reporting.
• Gather business requirements and translate them into Oracle EPM solutions.
• Develop and maintain Smart View reports, dashboards, and ad-hoc reports.
• Build and manage data integrations using FDMEE and ODI.
• Perform application maintenance, performance tuning, and issue resolution.
• Support month-end, quarter-end, and year-end financial close activities.
• Participate in unit testing, UAT, deployments, and production support.
• Prepare technical and functional documentation.

Required Skills

Oracle Hyperion Planning (Workforce, Capex & Financial Planning)
Oracle Essbase (BSO/ASO, Calc Scripts, Outline Design & Performance Tuning)
Oracle ARM / ARCS
Financial Close & Account Reconciliation
Smart View
Oracle Data Integrator (ODI) / FDMEE
Oracle EPM Cloud (PBCS, FCCS, ARCS)
Financial Statements (P&L, Balance Sheet & Cash Flow)
SDLC & Agile Methodologies