Freelancer profile translated to English.

Description

Does your BI architecture hold up? But does it still truly help in decision-making?

Slow Power BI reports. Unstable SSIS flows. Contested KPIs. Saturated backlogs. Competent BI teams, but without clear senior arbitration.

For 20 years, I have been working on demanding BI and data environments: LVMH, Sanofi, Société Générale, Total, SAGE.

My role: transforming scattered data, vague business needs, and fragile BI architectures into clear, reliable, and actionable steering systems.

I focus on three areas:

1. End-to-end BI Architecture: Sources, ingestion, transformation, modeling, reporting, business adoption.

2. BI Scoping; KPI Governance: Definition of indicators, calculation rules, sources of truth, analysis grain, validation criteria.

3. BI Tech Lead: Code review, architectural decisions, flow quality, Agile piloting, team skill development.

Stack: SQL Server · SSIS · SSAS · Power BI · Azure Data Factory · KNIME · Informatica

Are you leading a data transformation or a critical BI project?

Let's talk:

Industry field of expertise

Languages

French
Native or bilingual
Dutch
Native or bilingual
English
Fluent
Spanish
Basic

Workplace preferences

Can work on-site

Montpellier (up to 50km), Paris (up to 50km), Toulouse (up to 50km), Marseille (up to 50km), Lyon (up to 50km)

Seayard
Lead BI Consultant
TRANSPORTATION
March 2025 - Today (1 year and 4 months)
Fos-sur-Mer, France
Mission: Complete construction of a Business Intelligence environment to automate and streamline operational reporting.

Objective: Centralize the exploitation of business data by replacing 49 manual Excel reports with a modern and scalable BI solution.

Achievements:
•🔍 Analysis of business needs and mapping of existing reports.
•🧩 Design and deployment of a BI architecture from scratch (DWH + ETL + reporting).
•🔄 Complete migration of processes to Power BI with full refresh automation.
•🏗️ Implementation of a scalable Data Warehouse on SQL Server and SSIS.
•📊 Creation of interactive dashboards for port activity monitoring.
•🤝 Training and support for key users in adopting the new BI tools.

Technical Environment: Power BI, SQL Server, SSIS, Excel, Navis, SIA.
Microsoft Power BI Data Warehousing SSIS Navis SQL Server
Sanofi
Supply Chain
April 2024 - October 2024 (6 months)
Paris, France
Problem: A fragmented Power BI ecosystem, reports piled up without usage logic, and Supply Chain management unable to steer transversally.
› Audit of the existing system: mapping of the report inventory, identification of duplicates, blind spots, and unreliable metrics.
› Usage-oriented redesign: rebuilding dashboards around the decisions to be made, not the available data.
› Automation of preparation flows via KNIME: elimination of manual processing load, data available without human intervention.
→ Value created: Supply Chain management making decisions based on a unified, real-time, cross-functional vision, without data intermediaries.
› Stack: Power BI · KNIME · SQL Server · Agile
Sanofi
Supply Chain Data Consultant
HEALTH AND WELLNESS
April 2024 - November 2024 (7 months)
Neuilly-sur-Seine, France
Complete redesign and optimization of the Power BI ecosystem within the Supply Chain, significantly improving data visibility and facilitating strategic decision-making.
•Implementation of a data-driven approach aligned with the entity's operational objectives, enabling the generation of high-value insights.
•Creation of intuitive and dynamic dashboards, making complex data understandable and actionable for stakeholders.
•Development and optimization of KNIME workflows to automate data processing, reducing reporting times and manual tasks.

Technical Environment: Power BI, KNIME, SQL Server, Excel, Agile Methodology
Microsoft Power BI Knime Business Intelligence Data Migration Snowflake