Oracle EPM Consultant

Vaspire Technologies Inc.; Tulsa (OK); On-site; USD 110,000 - 140,000; Full time

Job summary

Vaspire Technologies Inc. seeks an Oracle EPM administrator to support and optimize the Oracle Enterprise Performance Management suite across EPBCS, FCCS, FDMEE, ARCS, PCMCS, and EDMCS.

The role emphasizes hands-on development in PCMCS/ARCS with strong SQL skills for data management and issue resolution. Responsibilities include configuring systems, updating metadata, troubleshooting module issues, and ensuring SOX-compliant controls.

Qualifications

• Experience administering Oracle EPM suite and related modules.
• Strong development experience in PCMCS and ARCS is highly beneficial.
• Proficient in Oracle SQL for data management and troubleshooting.

Responsibilities

• Administer and support the Oracle EPM suite including EPBCS, FCCS, FDMEE, and EDMCS.
• Diagnose and resolve technical issues across Hyperion modules.
• Document system architecture, configurations, and procedures.
• Provide end-user training and ongoing technical support.
• Coordinate data integrations from ERP systems such as Oracle EBS.
• Assist with planning, budgeting, and consolidation tasks using EPBCS and FCCS.

Skills

Oracle EPM

PCMCS

ARCS

Oracle SQL

EPM Cloud

Data management

Tools

EPM Automate

Job description

• 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
• Financial Consolidation & Close Support – FCCS - Supported FCCS close cycles including journals, intercompany eliminations, minority interest, movement analysis, and cash flow. Resolved data mismatches, consolidation errors, calculation issues, and performance problems during close.
• Planning & Budgeting Support – EPBCS - Provided production support for budgeting, forecasting, and planning cycles. Supported data loads, forms, business rules, Smart View templates, user access, and resolved calculation and data intersection issues.
• Profitability & Cost Management Support – PCMCS - Supported PCMCS allocation models, POV management, rules execution, and data validations. Investigated allocation errors, performance bottlenecks, and user-reported discrepancies in profitability results.
• Account Reconciliation & Transaction Matching Support – ARCS - Supported account reconciliations, transaction matching, formats, profiles, and reconciliation workflows. Investigated breaks, matching failures, aging issues, and supported period open/close activities.
• Enterprise Performance Reporting Support – EPRCS- Supported environment migration and object issues during migration
• Data Integration & Automation Support – EPM Cloud - Supported Data Management, Groovy scripts, and EPM Automate jobs. Monitored and resolved data load failures, mapping issues, automation errors, and upstream/downstream integration defects.
• Automation Scripts -Supported and maintained EPM Cloud automation using EPM Automate, Groovy, and batch scripts. Monitored jobs, resolved failures, and made minor enhancements to ensure reliable data loads, backups, and scheduled processes.
• Data Integration & Automation Support – EPM Cloud - Supported Data Management, Groovy scripts, and EPM Automate jobs. Monitored and resolved data load failures, mapping issues, automation errors, and upstream/downstream integration defects