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

Mehdi Affes

Data Analyst

€490/day
3 projects
Paris, FR
8-15 years

Average response time: 1 hour

Freelancer profile translated to English.
Back to original language

About Mehdi

🚀 Transforming data into strategic decisions

Senior Data Analyst with 9+ years of experience, specializing in reporting automation, data modeling, and BI performance optimization for the Luxury, E-commerce, and Pharma sectors.
I have supported L'Oréal, LVMH, Cdiscount, Decathlon, and Novo Nordisk in transforming data into growth levers using Power BI, Tableau, SQL, and Snowflake.

📌 Key Expertise:

✅ Automation & optimization of reporting → 90% reduction in processing time.
✅ Data reliability & model normalization → Elimination of inconsistencies & better decision-making.
✅ Market Intelligence & competitive analysis → Development of rankings & advanced customer segmentation.
✅ Cloud & BI Tools → Expertise in Power BI, Tableau, SQL, Snowflake, Google Cloud & Databricks.

💡 Available for freelance BI opportunities.

📩 Let's discuss your BI project!
  • English

    Fluent

  • French

    Fluent

  • Arabic

    Native or bilingual

Can work on-site
Paris (up to 30km)

Experience

  • L'Oréal
    Data Analyst - Report Automation
    LUXURY GOODS
    February 2024 - Today (2 years and 4 months)
    Levallois-Perret, France
    💡 Optimization and automation of reporting for Lancôme, YSL, Giorgio Armani, Mugler.

    ✅ 90% reduction in reporting generation time, enabling better strategic responsiveness.
    ✅ Implementation of a performance ranking by house, segment, category, and country.
    ✅ Optimization of Power BI and SQL model performance, improving the reliability of insights.
    ✅ Comparison of market shares vs. competitors, allowing for adaptation of marketing strategies.

    🛠 Technical environment: Power BI, Excel, Google Cloud, SQL, Redslim.
    Microsoft Power BI Microsoft Power Query Tabular Editor DAX Studio Microsoft Excel
  • DECATHLON
    Data Analyst - Dashboard Migration
    SPORTS
    June 2023 - December 2023 (7 months)
    Lille, France
    💡 Migration and optimization of the "Instore Traffic Analysis" dashboard from Quicksight to Tableau to improve in-store traffic analysis.

    ✅ Complete migration of reporting to Tableau Software, ensuring better ergonomics and increased performance.
    ✅ Optimization of SQL queries, reducing dashboard loading time by 50%.
    ✅ Implementation of a data pipeline on Redshift, allowing for real-time updates of analyses.
    ✅ Development of in-store traffic tracking indicators, facilitating decision-making for Retail teams.

    🛠 Technical environment: Tableau, SQL, Redshift, Databricks, Quicksight.
    Tableau Quicksight SQL Databricks Amazon Redshift
  • Louis Vuitton
    Data Analyst - Dashboard Conception
    LUXURY GOODS
    March 2022 - June 2023 (1 year and 3 months)
    Paris, France
    💡 Creation of dashboards and market analyses for the 5 LVMH divisions (Fashion, Distribution, Cosmetics, Jewelry, Spirits).

    ✅ Development of an NPS Score and advanced customer segmentation to track loyalty.
    ✅ Standardization of KPIs and creation of a benchmarking model to measure brand performance.
    ✅ Automation of data analyses via Power BI & SQL, reducing errors and inconsistencies.

    🛠 Technical environment: Power BI, SQL Server, Excel, Google Cloud.
    Microsoft Power BI SQL Data visualisation Data mining Data Analysis

Recommendations

Be the first to recommend Mehdi

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

  • Engineer's degree
    IT Business School
    2015

Certifications

  • Tableau Desktop Specialist
    Tableau
    2022
  • Tableau Certification: Desktop Specialist + Data Analyst
    Udemy
    2022

Skill set

Categories