Job Summary
The Senior Consultant for Oracle EPM Cloud PBCS is responsible for overseeing and managing the implementation, customization, and maintenance of Oracle Enterprise Performance Management Cloud Planning and Budgeting Cloud Service (EPM Cloud PBCS). This role involves working closely with clients to gather requirements, design solutions, and provide expertise in Oracle EPM Cloud PBCS to optimize business performance.
Key Responsibilities
Key Responsibilities
1. ARCS Configuration & Development
Configure and maintain Reconciliation Compliance module including:
• Profile setup
• Format configuration
• Workflow configuration
• Approval hierarchies
Configure Transaction Matching including:
• Matching rules (1:1, 1:N, N:N)
• Data sources
• Auto-match rules
• Adjustment creation
Design and maintain reconciliation templates and dashboards.
Support period-end close activities and issue resolution.
2. Data Integration & Management
Design and manage data integrations using:
• Oracle Data Management (DM)
• EPM Integration Agent
Configure data loads from ERP systems (Oracle ERP, SAP, etc.).
Build and maintain data validation and transformation rules.
Monitor and troubleshoot data load failures and reconciliation variances.
3. Automation & Scripting
Develop and maintain EPM Automate scripts for:
• Metadata loads
• Data imports/exports
• Snapshot management
• Scheduled automation jobs
Support batch processing and scheduled reconciliation workflows.
Improve process efficiency through automation and scripting enhancements.
4. Data Validation & Troubleshooting
Use Basic SQL for:
• Data validation
• Reconciliation support
• Investigating mismatches
• Backend troubleshooting
Perform root cause analysis of reconciliation and integration issues.
Support user queries during close cycles.
5. Support & Continuous Improvement
Provide L2/L3 support for ARCS production environments.
Collaborate with FCCS and ERP teams for integrated close processes.
Recommend improvements in reconciliation processes and automation.
Ensure compliance with audit and SOX requirements.
Skill Requirements
Required Skills & Qualifications
• 4–8 years of experience in Oracle EPM / ARCS implementations or support.
• Robust hands-on experience with:
• Oracle ARCS – Reconciliation Compliance & Transaction Matching
• Data Management (DM)
• EPM Integration Agent
• EPM Automate scripting
• Working knowledge of SQL for validation and troubleshooting.
• Understanding of financial close and reconciliation processes.
• Experience integrating ARCS with ERP systems.
• Strong analytical and problem-solving skills.
Other Requirements
Preferred Qualifications
• Experience with FCCS integration.
• Exposure to EDMCS for metadata management.
• Knowledge of SOX compliance and audit controls.
• Oracle EPM certification (preferred).
• Experience working in global, multi-entity environments.