Support for the financial management of a business unit within a multinational company
Context
An innovative and rapidly growing business unit within a multinational corporation, facing significant changes in its organisational structure and management approach, and in particular a lack of tools for managing production costs
Objectives
Provide analytical and technical support to the Finance and Business teams
Automate and continuously improve financial and sales reporting
Create and continuously improve the Power BI Finance and Sell-out dashboards
Support the preparation and implementation of the COGS budget
Deliverables achieved
Fully automated BI dashboards for Finance & Sales
Automated monthly reports
Template for calculating standard production costs, including a detailed analysis and breakdown by type
Structured analysis of variances between actual and standard costs
Key success factors
Excellent knowledge of the company and the sector
Close relationships with clients thanks to the on-site presence of H4 consultants
Proficiency in tools (Power Pivot, Power Query, Power BI) and financial modelling
Development of an application with a validation workflow for managing annual restatements. Finance transformation | Transformation of the finance function | Mid-cap and large group
Creation of investor reports and monitoring of valuations using Power BI. Development of Power BI dashboards | Modelling and performance analysis | Funds
Carried out a transition assignment between two FP&A directors in a mid-cap company. Financial and operational management | Outsourced FP&A | Mid-cap and large group