Freelancer profile translated to English.
Back to original languageAbout Rémi
When I started as an independent consultant, I expected to encounter different problems than those I knew in large corporations.
That's not what happened.
The same forecasts built on commercial intuition rather than data. The same lack of visibility on critical parameters: actual lead times, target stock levels, the impact of forecast deviations on cash flow. The same meetings where finance, sales, and operations leave without clear decisions.
The difference between a large corporation and a 40-person SME isn't the nature of the problems. It's the resources available to address them.
What I bring: the forecasting and management methods and tools I've built in demanding environments: €600M in revenue, 12 international markets, S&OP cycles under pressure; made concrete and operational for teams that don't have 50 people for support.
Specifically, I focus on:
- Structuring sales forecasts and the S&OP process
- Inventory management and the cash flow it ties up
- Building decision-making tools accessible to non-technical teams
- Aligning sales, finance, and operations
If you have growth objectives or feel your operations are losing visibility, that's exactly what I solve.
📩 📞
French
Native or bilingual
English
Native or bilingual
Portuguese
Basic
Can work on-site
Paris (up to 50km), Bordeaux (up to 50km), Tours (up to 50km), Caen (up to 50km)
Experience
- Dr Beckmann GroupFreelance - Forecasting & S&OPRETAIL (LARGE RETAILERS)March 2026 - Today (3 months)Bordeaux, FranceI designed and delivered an end-to-end by-SKU sales forecasting system for an FMCG client — from comparing algorithms to the sales teams' working file, with the aim of structuring the S&OP process on the forecasting side to support supply chain management.Specifically, this covered:
- **Modeling**: Benchmark of 5 algorithms (Holt-Winters, XGBoost, LightGBM, Croston, seasonal naive) on ~950 forecasting nodes (brand × SKU), backtesting on two holdout windows.
- **Routing Strategy**: Automatic selection of the algorithm per node based on its characteristics (volume, intermittency, history length) — WAPE improved from 64.6% to 61.7%.
- **Production Deployment**: Autonomous monthly Python script, multi-folder path management, handling of KAM entries between two snapshots.
- **User Interface**: Structured Excel file (1 sheet/brand, 3 rows/SKU, sheet protection, dynamic formulas, filters) designed for non-technical sales teams.
Concurrently, I adapted my client's data ecosystem to ensure the proper integration of this tool.- **Data Pipelines**: Creation of Extract, Transform, and Load (ETL) data flows to ensure a single source of truth for improved reliability.
- **Data Quality Monitoring**: Tracking dimension completeness (master data): Price entries, SAP code linkage to EAN code, orderer completeness, etc.
- **Forecast Visualization**: The user interface is linked to existing datasets to connect the forecast with other supply chain issues: inventory, procurement, landing, etc.
- Dr Beckmann GroupFreelance - Power BIRETAIL (LARGE RETAILERS)November 2025 - Today (7 months)Bordeaux, FranceDevelopment of a Power BI report focused on Demand Planning.For the French subsidiary of the Dr. Beckmann group, I assisted in structuring and visualizing commercial and supply chain management data in a mass-market retail model. I designed and deployed several interactive dashboards to improve visibility on sales forecasts, inventory tracking, COGS management, and net sales projections (Net Sales 3 Net).The project involved:*Building a robust datasetintegrating forecasts, orders, deliveries, commercial discounts, inventory valuation, and monthly portfolio.
- **Value analysis and stock projection**, cross-referenced with commercial needs and ongoing orders.
*Aggregations and decompositionof the forecast to quickly visualize trends and the necessary procurement.- Providing aconsolidated and updated viewto facilitate operational decision-making.
- GuerlainDEMAND PLANNERLOGISTICS AND SUPPLY CHAINNovember 2022 - Today (3 years and 7 months)Paris, FranceScope: 500 SKUs – €600M annual revenueReference for subsidiaries in China, Japan, Travel Retail, Southeast Asia/Oceania, Mexico (€500M) and guarantor of alignment between sales forecasts and budget for these regions through the supply chain-oriented S&OP process.Development of Forecast Accuracy (WAPE) reporting and user support at headquarters and subsidiaries to establish FA as a key performance indicator in the S&OP process.Improved forecast accuracy by +10% in one year.Design and structuring of custom datasets for supply chain analysis.Early adopter of Power Automate to automate key KPIs and enhance reporting usage.Monitoring and continuous improvement of Machine Learning (maintenance & evolution management).
Recommendations
Be the first to recommend Rémi
Help this freelancer shine by sharing your experience working together.
These freelancer profiles also match your criteria
Agatha Frydrych
Backend Java Software Engineer
4.7
(3)
2
Baptiste Duhen
Fullstack developer
4.6
(4)
5
Amed Hamou
Senior Lead Developer
4
(2)
7
Audrey Champion
Web developer
4.3
(3)
4
Education
- General Engineering Degree - SCOM MentionCentraleSupélec2022Mention Supply Chain & Operations Management Projets : Renault : Optimisation des flux maritimes de packaging réutilisables - Python & Excel Beckton & Dickinson : Méthodologie de la conduite de projet afin d'améliorer la tenue des deadlines et la détection des risques - Process écrit + template excel de planning Trescal : Cartographie et catégorisation des flux logistiques afin d'améliorer la priorisation et la tenue de délais - Power BI & Excel