Said H.

Vilareo, an SME specializing in short-chain beverage distribution, wanted to consolidate and automate the monitoring of sales and deliveries to its customers. Sales data was scattered across Excel files for orders, invoices, and inventory, making real-time management, performance tracking, and demand forecasting difficult.

Manage and supervise commercial and logistics performance, track sales, deliveries, and inventory, harmonize indicators between operations and management, and implement time series-based sales forecasts.

Scoping of needs and definition of commercial and operational KPIs

Import and transformation of Excel files (orders, invoices, inventory) via Power Query

Consolidation and cleaning of data to ensure reliable analysis

Star schema modeling optimized for performance

Development of DAX measures for tracking sales, margins, and delivery times

Application of time series models to forecast demand and optimize inventory

Design of multi-level dashboards for Management, Sales, and Operations

Deployment on Power BI Service with RLS security and automated updates

Elimination of manual Excel reporting

Automatic consolidation of sales, deliveries, and inventory

Accurate tracking of commercial and logistics performance

Reliable sales forecasts and inventory optimization

Harmonization of indicators between operations and management

Rapid adoption by teams

Within the Business Excellence Department, there was no consolidated view of budget management for SAP evolutions. Data, scattered between ServiceNow and SAP HANA, was tracked manually in Excel, leading to uncontrolled discrepancies and a lack of reliability for decision-making.

Manage and supervise the adjusted budget for SAP evolutions, track financial variances, prioritize IT requests, harmonize indicators between Finance and IT, and implement budget forecasts based on time series.

Scoping of needs and definition of financial and operational KPIs

Connection to ServiceNow data via API and SAP HANA via SQL

Data transformation and consolidation with Power Query

Star schema modeling optimized for performance

Development of DAX measures for tracking and managing the adjusted budget

Application of time series models to forecast budget evolution

Design of multi-level dashboards for Management, Managers, and Controllers

Deployment on Power BI Service with RLS security and automated refresh

Elimination of manual Excel reporting

Automatic consolidation of SAP and ServiceNow data

Effective supervision of the adjusted budget for SAP evolutions

Reliable budget forecasts thanks to time series

Harmonization of indicators between Finance and IT

Rapid adoption by teams

The TotalEnergies group wanted to revamp the procurement process workflow in SAP, from the request for need to invoice payment. Existing processes were manual, unreliable, and led to risks of double payment, lost documents, and uncontrolled delays.

As Business Process Owner, my mission was to define and optimize procurement and accounting processes, ensure payment reliability, simplify the prescriber/buyer/accountant journey, and coordinate business, IT, and external service provider teams.

Gathering user needs and functional specifications

Defining target processes and associated management rules

Writing functional documentation

Facilitating discussions between internal teams and external developers (Accenture)

Functional management of SAP evolutions and validation of deliverables

Supervising functional tests and conformity checks

Agile Scrum method with short sprints (2 per week)

Prioritization of evolutions and tracking of dependencies between business and IT teams

Supporting key users in mastering new workflows

Improved fluidity and reliability of procurement processes in SAP

Reduced risk of double payment and document loss

Enhanced compliance with contractual and regulatory deadlines

Complete and centralized traceability of operations

Rapid adoption by key users through support and documentation