Back to achievements

Migration and overhaul of Essbase to EPM Cloud Planning

Practice

Data Platform Budgeting & Planning Tool Selection Finance Transformation

Team

1 project manager, 1 project leader, 1 Oracle expert, 3 developers

Technical environment

300 users

in 80 entities

Centralized

data

Time saving

thanks to new rules

CHALLENGES

Our client wanted to harmonize its functional processes, which were originally managed through several specific, non-centralized developments (notably in Excel).
The requirement covered: the exhaustive scoping of processes and the transition from Essbase to EPM Cloud Planning.
Our client wanted to gain in dynamicity while maintaining performance levels. The solution was challenged in terms of response time and data quality.
As an additional constraint, the banking sector presents complex business models, business rules and regulations.

SOLUTION

After a complete review of the existing system, we set up a group application to monitor actual and budget at different granularities (Entities, Head Office and Central).
The global model also brings together all Essbase applications and specific Excel developments (allocation calculations, IS, cost and risk distribution at several levels of granularity).
EPM Cloud Planning was used to structure the process.
The management of access security and the audit trail enabled us to meet the sector's constraints in terms of auditability and security.

BENEFITS

300 users worldwide use a single solution for different needs, saving time by standardizing processes and harmonizing bundle formats.

Overall improvement in consolidation performance and allocation calculations. Move from daily data consolidation to on-the-fly aggregation at each load or manual entry.

The switch to a standard, unified application, hosted in a publisher's Cloud, also helped reduce platform maintenance costs.