Professional Summary
Detail-oriented junior data analyst based in Lyon with practical expertise in SQL, Python, and Tableau, supported by prior experience in commercial operations.
Proven track record in designing automated reporting workflows, monitoring operational KPIs, and delivering clear visual analytics to support cross-functional decision-making.
Professional Experience
Veloce Logistics Solutions
Lyon, France
Junior Data Analyst
Nov 2024 – Present
- Build and maintain interactive Tableau dashboards tracking fleet delivery punctuality and fulfillment rates across 12 regional distribution hubs.
- Write optimized SQL queries in PostgreSQL to extract, clean, and aggregate multi-table operational records, reducing recurring reporting turnaround by 35%.
- Conduct exploratory data analysis using Python and pandas to identify bottlenecks in regional dispatch schedules alongside operations teams.
- Automate weekly inventory discrepancy reporting through scheduled Python scripts, saving four hours of manual spreadsheet compilation each week.
Rhône Commerce Distribution
Lyon, France
Operations and Reporting Assistant
Mar 2020 – Aug 2023
- Maintained centralized spreadsheet models and weekly sales trackers for a regional territory covering 18 account managers.
- Prepared recurring KPI summary decks in Excel and PowerPoint for department leadership, highlighting branch order variances.
- Audited inbound order files against enterprise ERP records to identify and resolve billing discrepancies before invoicing.
Education
Université Lumière Lyon 2
Master of Science · Business Analytics and Data Science · Lyon, France · Mention Bien · Sept 2023 – Oct 2024
Focused on relational database management, statistical modeling, data visualization architecture, and exploratory data analysis.
Completed a capstone project developing customer churn analytics using Python scikit-learn and deploying an interactive reporting dashboard.
Université Jean Moulin Lyon 3
Bachelor of Science · Economics and Management · Lyon, France · Honors · Sept 2015 – Jun 2018
Acquired foundational grounding in microeconomics, applied statistics, operational accounting, and quantitative business research.
Selected Projects
E-Commerce Customer Segmentation Analysis
Mar 2024 – Jun 2024
- Processed and cleaned 120,000 transaction records using Python to calculate customer recency, frequency, and monetary value indicators.
- Constructed an interactive Tableau dashboard enabling stakeholders to filter customer segments by purchase frequency and product category.
Public Transit Punctuality Tracker
Nov 2023 – Jan 2024
- Extracted regional public transit delay records via REST APIs and loaded structured records into a SQLite database.
- Built visual summary reports in Python with matplotlib and seaborn highlighting high-congestion morning routes.
Core Competencies
SQL
Python (pandas, NumPy)
Tableau
PostgreSQL
Microsoft Excel (Power Query)
Data Visualization
Exploratory Data Analysis
ETL Workflows
Git
Business Intelligence
Languages
French
C2
English
C1
Spanish
B1
Certifications
Tableau Desktop Specialist
Tableau · May 2024
PostgreSQL Fundamentals
Coursera · Nov 2023
Volunteer Experience
Lyon Digital Inclusion Collective
Lyon, France · Jan 2022 – Feb 2024
- Volunteer Digital Tutor
- Conducted bi-weekly digital literacy sessions supporting adult learners in mastering basic spreadsheet calculations and secure online tools.
- Maintained session attendance logs and summarized participant survey results across 14 workshops to improve course delivery.