You're seeing this page as if you were . The main menu is still yours, though. Exit from immersion
Louison PelletreauLP

Louison Pelletreau

🎯 Analytics Engineer specializing in Supply Chain & Automation

€500/day
Paris, FR
3-7 years

Average response time: 1 hour

Freelancer profile translated to English.
Back to original language

About Louison

🎯 Analytics Engineer specializing in Supply Chain & Automation

I help companies transform their data into strategic decisions and automate their critical cycles (S&OP, planning, inventory).

After 4 years in retail, luxury, and FMCG, I developed a rare expertise: understanding the supply chain business language + transforming it into data architectures and automated workflows.

📊 What I do:

- Design and deploy critical Power BI dashboards
(S&OP, inventory, logistics performance)
- Automate complex reporting cycles with n8n and advanced Excel
- Architect reliable data models (ETL, governance, master data)
- Collaborate with operational teams to industrialize data-driven processes

đź’» Stack: Power BI | n8n | SQL | Dbt | Big Query | Workflow Automation

🔄 Currently, I'm exploring AI agents applied to supply chain (stock anomalies, stockout alerts, forecast variance analysis).

📍 Based in Switzerland, 100% remote available. Comfortable working in French/English.

👉 Looking for someone who speaks both data AND supply chain?

Let's discuss your case.
  • French

    Native or bilingual

  • English

    Native or bilingual

Remote only
Primarily works remotely

Experience

  • Helen of Troy
    Analytics Engineer - S&OP & Inventory Optimization
    RETAIL (SMALL BUSINESS)
    March 2024 - Today (2 years and 5 months)
    Lausanne, VD, Switzerland
    Profile: "Pivot" Analytics Engineer unifying supply chain, logistics, sales, and marketing around reliable, centralized data.

    🎯 Context & Main Missions:

    Company: Helen of Troy (international retail & lifestyle group, presence in Switzerland, Europe, APAC)
    Challenge: Centralize supply chain data & optimize inventory amidst complex multi-geography flows.

    📊 Inventory & E&O Optimization:

    → Design and deployment of Power BI dashboards for safety stock management and identification of Excess & Obsolete (E&O)
    → Creation of complex stock projection models in Excel + Power BI
    → Result: Significant cash flow release through reduction of overstock
    → Automation of reporting cycles (Inventory Trackers)

    🔄 S&OP & Forecasting Management:

    → Automation of critical reporting cycles (S&OP, planning)
    → Multi-source data engineering for business KPIs (OTIF, Lead times, service level)
    → Direct decision support to Demand Planning, Supply, Logistics, and Sales teams

    🛠️ Skills Deployed:

    Power BI (complex dashboards) | SQL (multi-source data queries)
    Advanced Excel (models, VBA) | ETL | Data Governance | Master Data Management Workflow Automation | Process Improvement

    🌟 Strengths: Ability to translate complex operational needs into reliable and scalable data solutions.
    Data Governance Database Management Extract, Transform, Load (ETL) Data Visualization Workflow Automation
  • Richemont
    Data Architect - Supply Chain Digital Transformation
    CONSULTING AND AUDITS
    June 2023 - November 2023 (5 months)
    Geneva, Switzerland
    Profile: Architect of digital transformation and process automation for planning in a high-end watchmaking environment.

    🎯 Context & Missions:

    Company: Richemont (luxury group, watchmaking manufacture, Geneva)
    Challenge: Complete overhaul of planning tools + migration of manual processes to an automated model integrating production/ERP constraints.

    đź”§ Supply Chain Process Engineering:

    → Audit and complete modeling of a manufacture's planning flows
    → Translation of "high watchmaking" business specificities (complex constraints, low volume) into software management algorithms
    → Identification of bottlenecks and solution design

    🏗️ Technological & BI Revamping:

    → Lead on the total redesign of the planning infrastructure
    → Extraction and structuring of ERP data (SAP)
    → Creation of a "Single Source of Truth" to secure planner decisions via Power BI
    → Design of critical dashboards for flow management

    🤝 Change Management:

    → Technical support for teams to adopt new tools
    → User training and support during transition
    → Complexity Management: Change management + technical delivery

    🛠️ Skills Deployed:

    Process Modeling | Business Intelligence (Power BI)
    Data Architecture | ERP (SAP) | Data Integration | Project Management
    Technical Change Management | Enterprise Resource Planning (ERP)

    🌟 Strengths: Ability to transform a complex business specificity (Swiss watchmaking) into an automated and reliable process. Rare.
    Project Management Data Modeling Data Integration Enterprise Resource Planning (ERP) Data Visualization
  • GĂ©mo, groupe ERAM
    Supply Chain Automation Engineer
    RETAIL (SMALL BUSINESS)
    June 2021 - September 2022 (1 year and 3 months)
    Saint-Pierre-Montlimart, Chaudron-En-Mauges, France
    Profile: Hybrid "physical flows + data flows" profile — operational coordination and automation of distribution processes.

    🎯 Context & Missions:

    Company: Gémo, ERAM group (retail, distributed commerce)
    Challenge: Transform a reactive process into proactive management via centralization of logistics data and optimization of the distribution chain.

    🔄 End-to-End Flow Management:

    → Complete operational coordination: procurement (upstream)
    → Distribution Management and inter-departmental interfaces
    → Logistics KPI tracking (OTIF, delays, capacities)

    đź”§ Digital Transformation & Automation:

    → Design and development of a proprietary tool for automating logistics workflows
    → Centralization of packaging and transport data into a single platform
    → Shift from reactive management to proactive management
    → Optimization of warehouse storage capacity

    📊 Performance Analysis & Optimization:

    → Implementation of flow monitoring indicators (distribution KPIs)
    → Identification of bottlenecks in the chain
    → Reduction of cycle times and improvement of service rate

    🛠️ Skills Deployed:

    Advanced Excel (models, automation) | Process Automation | Digitalization
    Supply Planning & Distribution Management | Process Improvement
    Data Analysis | Operational Coordination

    🌟 Strengths: First experience "merging" operations (distribution) with data — the foundation of my Analytics Engineer career path.
    Process Automation Process Digitalization Supply Planning ETL Microsoft Power BI

Recommendations

Be the first to recommend Louison

Help this freelancer shine by sharing your experience working together.

These freelancer profiles also match your criteria

AgathaA

Agatha Frydrych

Backend Java Software Engineer

4.7

(3)

2

BaptisteB

Baptiste Duhen

Fullstack developer

4.6

(4)

5

AmedA

Amed Hamou

Senior Lead Developer

4

(2)

7

AudreyA

Audrey Champion

Web developer

4.3

(3)

4

Education

  • Master's degree
    POLIMI Graduate School of Management
    2023
    Master's degree
  • Master's degree
    IAE Pau-Bayonne
    2022
    Master's degree

Skill set

Categories