Agile advisory,
A Trusted partner
We have been supporting more than 40 clients for almost 10
years in various sectors such as
retail, agri-food, construction, and banking and insurance.
For nearly 10 years, we have been committed to their side in managing performance.
BEFORE
- Excel solution with multiplication of files
- Consolidation and reporting evolving with numerous acquisitions
- Limited analyses
- Complex perimeter management
OUR MISSION
- Unified data model, a single platform to handle Actual, Budget, and Forecast phases
- Central and shared tool implementation
- Unified process
- Implementation of reporting and many analytical dimensions in CCH TAGETIK for in-depth analyses
- Reconciliation in the solution at different levels
- Implementation of consolidation and management reporting in CCH TAGETIK
THE RESULT
- A unified solution for the group and contributors
- A solution accessible to local and central users
- A simple solution to administer
- A single version of the truth
- 400 million euros turnover
Interested in this case study?
Gerflor asserts itself as a specialist and global leader in the field of flexible floor coverings.
The group designs, manufactures, and markets innovative, decorative, and eco-responsible solutions for flooring and its periphery. Already present in more than 100 countries, Gerflor continues its development worldwide.
PROCESS
- A multitude of reporting and consolidation tools
- Consolidation and Reporting in full evolution with the complete review of the finance data model
- Allocation of factory costs and depot costs
- Payroll management
Challenge
- Unified data model, a single platform to handle Real, Budget, and HR phases
- Implementation of reporting and many analytical dimensions in CCH TAETIK for in-depth analyses
- Reconciliation of an income statement by destination and by nature
- Implementation of consolidation and management reporting in CCH TAGETIK
- Cost allocation according to a complex model (across all analytical dimensions))
- Automatic integration of the centrally managed data model into a data warehouse in CCH TAGETIK
BENEFITS
- A unified solution for the group and contributors
- A solution accessible to local and central users
- A simple solution to administer
- A single version of the truth
- 950 million euros in turnover
Interested in this case study?
PROCESS
- Variety of application modules for reporting and consolidation
- No analytical axis available in Statutory Consolidation
- Very detailed and time-consuming to produce Management Reporting
Challenge
- Implementation of a Statutory Consolidation and Management Reporting application under a unified data model in CCH TAGETIK, allowing for the handling of Real, Budget, and Forecast phases
- Central and shared tool implementation
- MReporting and many analytical axes implementation in CCH TAGETIK under SAP HANA for indepth analyses (5 analytical axes all intersecting with one dimension including 20,000 items)
- Reconciliation directly in the solution at different levels
BENEFITS
- A unified solution for Management Reporting and Statutory Consolidation for the group
- A single version of the truth (the unique data)
- Consolidation available across all analytical axes
- A solution accessible to local and central users
- 293 million euros turnover
Interested in this case study?
KEY FACTORS
- Integration of Statutory Consolidation and Reporting applications (HFM) and integration (FDMEE) using the new HFM 11.2 and Oracle FDMEE versions in On-Premise mode.
- Implementation of Third-Party Application Maintenance (TMA) – With HFM, the administration of OCI Group’s applications is simplified. Agile Advisory has successfully implemented its comprehensive support offer, including TMA.
- Implementation of Third-Party Technical Maintenance (TMT) – Agile Advisory has an internal technical team capable of maintaining HFM servers.
CHALLENGES
- The use of the Excel SmartView Add-In in the creation of financial reporting states was greatly appreciated as it gave greater autonomy to local users in managing and presenting their reporting.
- Ensuring the reliability of local data (via FDMEE) and consolidated data (via HFM).
- Strengthening the process of reconciling intra-group data between the Group’s companies.
- Accelerating the closing process to communicate the complete consolidated accounts (report book) to the Board on a monthly basis.
RESULT
The monthly financial consolidation process and the annual report are now completely integrated into HFM. The achieved goal was to automate as many steps of the internal process as possible to reduce the risk of manual errors. In this project, FDMEE (Oracle ETL) was also implemented, allowing for the automatic loading of accounting data (instead of spreadsheet data). The intra-group reconciliation statements and automated reports such as the P&L balance sheet and the cash flow statement have had a significant impact on reducing the production times of the Group’s consolidated accounts. As a result, the financial consolidation process is now efficient and transparent due to high automation. This observation also applies to the quality of balance sheet flow entries and the management of application consistency controls. The use of the Excel SmartView Add-In in the creation of financial reporting states was greatly appreciated as it gave greater autonomy to local users in managing and presenting their reporting.Interested in this case study?
KEY FACTORS
- After being acquired by Noblelift, the Savoye Group needed to select and implement its own consolidation and reporting tool.
- Savoye required a partner who understood both the configuration of the previous application and the functional challenges of the new HFM application due to reporting oriented towards a Chinese shareholder.
- The project needed to be completed within a short timeframe and had to include a phase of system implementation in “On Premise” mode (technical installation on the Savoye Group’s servers).
Solution
Agile Advisory directed the Savoye Group towards using Oracle’s HFM consolidation and reporting system. The design and realization of the target application were based on Agile Advisory’s HFM Starter Kit. This allowed the implementation of a consolidation system according to generally observed best practices. The technical installation (with two environments) was carried out by the agile Advisory technical team, experts in this field.BENEFITS
- The Savoye Group now uses modern technology, enabling agile mode account closures and report generation. The application’s structure and the quality of the technical installation allow Savoye to benefit from very efficient calculation and consolidation times. The rapid transition time between the old and new applications, combined with Agile Advisory’s tailored team support in change management, enabled the Savoye teams to easily adapt to their new tool.
- The application’s structure and the quality of the technical installation allow Savoye to benefit from very efficient calculation and consolidation times.
- The rapid transition time between the old and new applications, combined with Agile Advisory’s tailored team support in change management, enabled the Savoye teams to easily adapt to their new tool.
Interested in this case study?
FINDINGS
Agile Advisory implemented Oracle’s HFM solution at SNF with the aim of establishing a unified platform in terms of financial consolidation and various financial reporting (revenue tracking, investment reporting, etc.). The solution was deployed alongside a new ERP, logically contributing to the integration of FDMEE, Oracle’s ETL that enables the feeding of accounting data into the consolidation tool.OBJECTIVES
- To achieve financial statement consolidation in IFRS standards with ease, including an integrated cash flow statement.
- To ensure users a simple and quick handling.
- To interface the solution with the accounting system via FDMEE.
- To benefit from agile and accurate quarterly financial reports.
BENEFITS
- Reduction of manual effort during the consolidation period
- Productivity gains and better quality in data analysis and reporting production
- An open solution for many other developments: forecast reporting, Proforma consolidation, CBCR, Tax Reporting, etc.
- Automated calculations around organic growth
Interested in this case study?
CUSTOM SOLUTION
Here are some of our references
...and they confirm it.
SNF
Orascom
strength of proposal and support,
keys to the success of our
projects.
Bandai Namco Europe
OCI Global
Marussia Beverages
Subscribe to sucess
Stay informed by receiving our newsletter directly in your mailbox every month.