Oracle EPM Consultant

About the Role

Strong domain knowledge in key practices including financial consolidation, budgeting, forecasting, planning cycles, data management and more is essential for this role. This role requires strong ability to collaborate with cross-functional teams, identify defects early in the development cycle, and ensure high-quality product delivery.

Primary Skills

• Oracle EPM
• EPBCS
• Essbase
• FCCS
• FDMEE
• ARCS
• PCMCS
• EDMCS
• Oracle SQL
• Financial Reporting Studio
• Smart View

Secondary Skills

• financial consolidation
• budgeting
• forecasting
• planning cycles
• data management
• data integrations
• SOX compliance
• system architecture
• technical support

Responsibilities

• Supported FCCS close cycles including journals, intercompany eliminations, minority interest, movement analysis, and cash flow.
• Provided production support for budgeting, forecasting, and planning cycles.
• Supported PCMCS allocation models, POV management, rules execution, and data validations.
• Supported account reconciliations, transaction matching, formats, profiles, and reconciliation workflows.
• Supported environment migration and object issues during migration.
• Supported Data Management, Groovy scripts, and EPM Automate jobs.
• Supported and maintained EPM Cloud automation using EPM Automate, Groovy, and batch scripts.

Requirements

• Administer and support the Oracle EPM suite, including EPBCS, Essbase, FCCS, FDMEE, ARCS, PCMCS, and EDMCS.
• Hands-on development experience in PCMCS and ARCS is highly beneficial.
• Proficient in Oracle SQL for data management and troubleshooting.
• Manage system configurations, perform updates, and maintain metadata hierarchies.
• Diagnose and resolve technical issues across various Hyperion modules.
• Coordinate and monitor data integrations from ERP systems such as Oracle EBS.
• Design and maintain financial reports using Financial Reporting Studio and Smart View.
• Ensure data accuracy and compliance with internal controls, including SOX requirements.
• Document system architecture, configuration changes, and administrative procedures.
• Provide end-user training and ongoing technical support.