Moatassim Bedroune

Mission to transform and digitize the logistics and financial tracking process, historically managed in Excel, in a multi-supplier environment with significant data reliability and billing control challenges.

Key achievements

Business scope and data structuring:

- Analysis of existing processes and identification of limitations (reliability, delays, Excel dependency),

- Scoping needs with business teams (logistics, finance, customer service),

- Analysis of the quality of available data and identification of anomalies,

- Interaction with suppliers to evolve the formats of data provided (files, invoices, exports),

- Definition of business rules and key performance indicators

Technical implementation and industrialization:

- Design of a data architecture in Power BI (star modeling),

- Development of Power BI dashboards (advanced DAX, logistics, financial, and customer service KPIs),

- Implementation of ETL flows via Power Query and Dataflows,

- Automation of processing with Power Automate and AI Builder,

- Multi-source connection (Excel, PDF, supplier data)

Impact & value delivered:

- Elimination of manual and risky Excel processes, replaced by automated and traceable flows.

- Securing supplier billing and reducing the risk of financial errors.

- Significant time savings for business teams, refocused on analysis rather than data production.

- Provision of a sustainable, maintainable, and scalable Power BI foundation.

Mission to transform and industrialize HR & Finance reporting and implement a reliable, governed, and usable Power BI foundation for strategic uses (monitoring, audits, CSRD).

Key achievements

Business scope and KPI structuring:

- Analysis of existing systems (Excel, SAP BO) and identification of limitations

- Facilitation of workshops with HR, Finance, and Social Control Management teams

- Structuring and harmonization of KPIs (headcount, turnover, absenteeism, payroll, training, CSRD)

- Formalization of business rules and definition of strategic indicators

- Identification and qualification of data sources (HRIS, SuccessFactors, Finance)

- Implementation of data governance principles

Technical implementation and industrialization:

- Design of a complete data architecture: (Azure Data Factory, Databricks, Power BI Dataflows)

- Star modeling in Power BI

- Development of industrialized and reusable datasets

- Creation of decision-making dashboards (advanced DAX)

- Implementation of security (RLS / OLS)

- Implementation of data quality controls

Impact & value delivered:

- Replacement of manual and heterogeneous reporting with a governed and auditable Power BI foundation.

- Increased reliability of HR & Finance indicators used for audits, group monitoring, and CSRD obligations.

- Significant reduction in reporting production time for business teams.

- Implementation of a sustainable data architecture, replicable for other HR/Finance areas.

- Strengthening team autonomy through documentation and skills development.

Mission with the Cipanguo Group (automotive parts distribution) to implement a Power BI foundation for consolidated financial monitoring across multiple subsidiaries.

• Modeling of financial indicators: Balance Sheet, P&L, Working Capital, DSO/DPO

• Consistency/completeness checks on entries & analytical dimensions

• GL-Auxiliary reconciliations, third-party de-duplication, and documented business rules.

• Application of an R2R (Record to Report) logic in a multi-currency and multi-accounting IT system environment

• Automation of Pipelines via Azure Data Factory

• Implementation of Power BI governance (RLS, monitoring, documentation)

• Delivery of a scalable foundation used by the Group CFO

Support for the hotel group Turenne Capital in implementing a Power BI foundation for multi-site financial and operational monitoring, with the integration of an automated budget preparation module.

• Design of a consolidated financial monitoring dashboard: P&L, Working Capital, hotel performance KPIs (RevPAR, occupancy rate, average revenue…)

• Structuring of the multi-hotel model with management of repositories (entity, month, key indicators)

• Implementation of an automated solution for budget collection and consolidation (Power Automate + structured Excel), significantly reducing manual exchanges

• Automatic integration of validated budgets into the main Power BI model

• Support for hotel directors and operations management in adopting the tools

• Result: Significant time savings on budget construction, improved reliability of entered data, consolidated view accessible to central teams.