Oracle Hyperion Planning

Cerebra; Bengaluru, Chennai District; On-site; INR 1,400,000 - 2,200,000; Full time

Job summary

Cerebra in Bengaluru is seeking an Oracle Hyperion EPM Consultant to design, build, and support Planning models, Essbase cubes, and ARM/ARCS workflows. You will work with finance to translate requirements into scalable EPM solutions, develop Smart View reports, and manage data integrations.

The role focuses on accuracy, performance, and audit compliance within Hyperion environments, and requires strong SDLC/Agile delivery experience and offshore/onshore collaboration.

Qualifications

• Experience designing, developing, and supporting Hyperion EPM solutions (Planning, Essbase).
• Strong knowledge of ARM/ARCS setup, reconciliation rules, and compliance reporting.
• Familiarity with data integration tools ODI or FDMEE and dashboard/reporting tools.

Responsibilities

• Act as a functional and technical consultant for Hyperion Planning and Essbase.
• Design, develop, and enhance Planning models, Essbase cubes, and business rules.
• Configure and support ARM ARCS including reconciliation workflows and compliance controls.
• Collaborate with finance to gather requirements and deliver EPM solutions.
• Develop and maintain Smart View reports, dashboards, and ad‑hoc analysis.
• Manage data integrations using FDMEE/ODI, including validations and reconciliations.
• Perform application maintenance, performance tuning, and issue resolution.
• Support month‑end, quarter‑end, and year‑end closes.
• Participate in testing (unit, UAT) and production support; prepare documentation.

Skills

Hyperion Planning

Essbase (BSO/ASO)

ARM/ARCS

FDMEE / ODI

Smart View

Analytics & Dashboards

SDLC & Agile

Tools

FDMEE/ODI

Smart View

EPM Cloud / ARCS

Job description

Role & responsibilities

• Act as a functional and technical consultant for Oracle Hyperion Planning and Essbase.
• Design, develop, and enhance Planning models, Essbase cubes, and business rules.
• Configure and support ARM ARCS including reconciliation workflows, auto‑matching, and compliance controls.
• Work closely with finance users to gather requirements and deliver EPM solutions aligned to business needs.
• Develop and maintain Smart View reports, dashboards, and ad‑hoc analysis.
• Manage data integrations using FDMEE ODI including validations and reconciliations.
• Perform application maintenance, performance tuning, and issue resolution.
• Support month‑end, quarter‑end, and year‑end close cycles.
• Participate in testing cycles including unit testing, UAT, and production support.
• Prepare technical and functional documentation.

Essential Skills: The Oracle Hyperion EPM Consultant will be responsible for designing, developing, and supporting Oracle Hyperion EPM solutions with a focus on Planning, Essbase, and ARMARCS. This role involves close collaboration with finance stakeholders to translate business requirements into scalable and efficient EPM solutions while ensuring accuracy, performance, and audit compliance.

Technical Expertise Requirements

• Strong hands‑on experience with Oracle Hyperion Planning (Workforce, Capex, Financial Planning).
• Strong working knowledge of Essbase BSO or ASO, outline design, calc scripts, and performance tuning.
• Experience with Oracle Account Reconciliation Manager (ARM) or ARCS including setup, matching rules, and compliance reporting.
• Experience in Financial Close Reconciliation processes.
• Knowledge of Smart View, data forms, business rules, and dashboards.
• Experience with Data Integration tools ODI or FDMEE.
• Exposure to Oracle EPM Cloud (PBCS, FCCS, ARCS) or on‑prem Hyperion environments.
• Good understanding of Financial Statements (PL, Balance Sheet, Cash Flow).
• Strong understanding of SDLC, Agile delivery models, and support processes.

Non-Technical Expertise Requirements

• Must be able to exhibit professionalism and business acumen.
• Ability to work in a fast‑paced dynamic environment with multiple competing deadlines.
• Excellent in consultation, presentation, verbal, and written communications.
• Working experience in offshore – onshore model.
• Excellent documentation skills.

Desirable Skills

Hyperion Essbase Analytics and Oracle Hyperion Planning.