FCCS Cube Split & Consolidation Re-Architecture Programme

Position Summary

Senior Oracle FCCS Consultant to lead the separation and restructuring of FCCS consolidation cubes by historical and future reporting periods. Working with Finance, Consolidation and EPM Architecture teams, the consultant will assess current application constraints, design an optimised multi-cube target architecture, and deliver it end-to-end — covering consolidation logic, ownership management, intercompany eliminations, historical data segregation, migration, performance tuning, and close-cycle continuity.

Key Responsibilities

Architecture & Cube Split Design: Analyse current FCCS constraints; define split strategy across reporting timelines, entities, scenarios and data-retention needs; design target dimensionality and consolidation boundaries; evaluate clone-and-prune vs. rebuild.
Consolidation & Close: Redesign consolidation across separated cubes, including ownership management, currency translation, intercompany matching/elimination, consolidation rules, journals and period close while maintaining reporting continuity.
Historical Data Segregation: Define cut-off dates and data boundaries, design migration and archiving for legacy periods, execute balance migration, and validate continuity and audit compliance.
Build & Configuration: Configure new applications/cubes, including metadata, entity and alternate hierarchies, custom dimensions, forms, business rules, consolidation sequences and reporting objects; execute environment migrations and deployments.
Performance Optimisation: Analyse consolidation runtimes and cube performance; tune Calculation Manager rules and member formulas; reduce close-cycle and reporting execution times.
Migration & Reconciliation: Define migration approach for metadata, balances, journals, rates, ownership and history; lead reconciliation, parallel-close validation, UAT and Finance sign-off.
Stakeholder Management: Partner with Financial Controllers, Group Reporting, Corporate Accounting, Internal Audit, IT application owners and Oracle Support; present design decisions, status and risk mitigation to leadership.

Required Experience

10+ years in Oracle EPM, including 7+ years of hands-on FCCS implementation across multiple full-lifecycle projects.
Proven delivery of FCCS application splits, carve-outs, mergers, acquisitions or legal-entity separations.
Strong grounding in consolidation accounting, multi-GAAP reporting, ownership management, foreign currency translation, intercompany eliminations and financial close.
Track record of complex historical data migrations and Oracle EPM Cloud platform administration.

Technical Skills

FCCS: Calculation Manager, consolidation rules, ownership management, translation logic, intercompany eliminations, Enterprise Journals, Smart View, Financial Reporting.
Integration & Automation: Data Management, EPM Automate, REST APIs, Oracle Integration Cloud (OIC).

Preferred Qualifications

Oracle FCCS Implementation Certification.
Experience with carve-out, divestiture, merger or legal-entity separation programmes in large global consolidation environments.
Working knowledge of IFRS and US GAAP consolidation requirements, plus Oracle Cloud release and regression management.