Oracle EPM Consultant

Role: Oracle EPM Consultant

Location: Tulsa, OK Onsite

Long term Contract

• 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