​​ ​​​​​​

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 current 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 Fi

📌 Senior Oracle FCCS Consultant (Noida)
🏢 Topcoder
📍 Noida