Oracle EPM Consultant - ARCS & FCCS Modules

Job Title : Oracle EPM Consultant

Experience : 58 Years

Location : Bangalore, India

Employment Type : Full-time

Position Summary :

The role requires deep functional knowledge of reconciliation and consolidation processes, as well as hands-on technical expertise in data integration, automation, performance optimization, and system administration.

The consultant will be responsible for implementing, configuring, and maintaining Oracle EPM solutions to enable accurate, timely, and compliant financial close and reconciliation processes.

Core Responsibilities :

1. ARCS (Account Reconciliation Cloud Service) Implementation & Support

Module Expertise :

- Configure Auto Submit and Auto Approve rules at both Profile and Format levels to streamline reconciliation workflows.

Data Integration & Management :

- Set up pre-mapped balances/transactions to reduce reconciliation preparation time.

- Develop and manage integrations with ERP Cloud, BIP Reports, and flat-file sources.

- Ensure data validation rules are in place to maintain data integrity.

Performance & Troubleshooting :

- Perform root cause analysis (RCA) for reconciliation delays, data mismatches, or automation failures.

- Tune system configurations for optimal performance.

Process Optimization & Governance :

- Collaborate with finance and IT stakeholders to ensure reconciliation processes align with audit and compliance requirements.

Documentation & Knowledge Sharing :

- Conduct end-user training sessions to improve adoption and efficiency.

2. FCCS (Financial Consolidation and Close Service) Implementation & Support

Functional Design & Configuration :

- Define consolidation rules, calculation scripts, and data mappings for accurate financial reporting.

- Set up security roles, access rights, and approval hierarchies to meet compliance needs.

Consolidation Logic & Reporting :

- Configure Balance Sheet and P&L consolidation rules as per IFRS/GAAP standards.

- Develop custom financial reports and dashboards in Oracle Smart View and EPM Reporting Web Studio.

Testing & Validation :

- Analyze and resolve data discrepancies between FCCS, ARCS, and source systems.

Automation & Scheduling :

- Integrate FCCS with ERP systems (e.g., Oracle ERP Cloud, SAP, PeopleSoft) for seamless data flow.

Technical Skills & Tools :

Data Integration: ERP Cloud Data Extracts, BIP Reports, Flat Files, REST/SOAP APIs

Automation: EPM Automate, Shell Scripting, Batch Processing

Reporting Tools: Smart View, EPM Reporting Web Studio

Performance Monitoring: Activity Reports, Job Console Analysis, System Diagnostics

Testing Tools: Test automation frameworks for EPM Cloud (optional but preferred)

Required Qualifications :

- 58 years of hands-on experience in Oracle EPM Cloud implementations, specifically ARCS & FCCS.

- In-depth understanding of financial close cycles, reconciliations, and consolidation methodologies.

- Experience in multi-ERP environments and multi-currency reporting.

- Strong analytical and problem-solving abilities with a detail-oriented approach.

- Excellent communication and stakeholder management skills.

Preferred Qualifications :

- Exposure to Hyperion Financial Management (HFM) or on-premise EPM tools.

- Experience with Agile project delivery and DevOps practices for EPM.