Oracle EPM Consultant

Key Responsibilities

• Administer and support Oracle EPM modules including EPBCS, Essbase, FCCS, FDMEE, ARCS, PCMCS, and EDMCS.
• Perform hands-on development in PCMCS and ARCS as needed.
• Use Oracle SQL for data management, troubleshooting, and performance support.
• Manage system configurations, metadata updates, and hierarchy maintenance.
• Diagnose and resolve technical issues across multiple Hyperion modules.
• Coordinate and monitor data integrations from ERP systems, including Oracle EBS.
• Design, develop, 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, configurations, procedures, and enhancements.
• Provide end-user training and ongoing production support.

• Experience administering multiple Oracle EPM Cloud modules (EPBCS, Essbase, FCCS, FDMEE, ARCS, PCMCS, EDMCS).
• Proficiency in Oracle SQL for data processing and troubleshooting.
• Experience coordinating ERP integrations, particularly with Oracle EBS.
• Strong understanding of metadata management, hierarchies, and configuration updates.
• Experience developing reports using Financial Reporting Studio and Smart View.
• Knowledge of SOX compliance and internal control requirements.
• Ability to troubleshoot issues across EPM and Hyperion environments.
• Strong documentation skills and ability to provide user support.

• Hands-on development experience in PCMCS and ARCS.
• Experience supporting financial close, consolidation, planning, or reconciliation processes.
• Prior experience providing training or user enablement for Oracle EPM tools.