Freelancer profile translated to English.

Description

Data Analyst & AI with over 3 years of experience, I design analytical architectures to transform complex flows into clear decision-making levers.

TECHNICAL SKILLS

*Pipelines & Processing (ETL):Advanced SQL extraction (CTE, window functions), ETL pipelines, and data volume manipulation with Python (Pandas, NumPy).

*Modeling & Warehousing:Star schema modeling, dbt orchestration on BigQuery and Snowflake, RDBMS management (SQL Server, MySQL).

*Data Visualization:Interactive dashboards in Power BI, Metabase, and Cognos, complex DAX measures, real-time alerts and monitoring.

*Machine Learning & Automation:Scikit-learn models (classification, regression) and VBA automations for performance management.

*Cloud & DevOps:GCP environments (BigQuery, Cloud Storage) and Azure (Data Lake, Synapse), Docker containerization.

RECENT ACHIEVEMENTS

*Groupe La Poste:Real-time logistics flow management. Power BI dashboards (DAX, alerts) for punctuality monitoring. VBA automations for national reporting and SQL/SAP queries for driver tracking.

*Business Help:Exploratory Data Analysis (EDA) on BigQuery. Volumetric data cleaning (Pandas) and integration of ML models (scikit-learn) into workflows.

*DXC Technology:dbt model orchestration on BigQuery. Star schema modeling in Power BI and dashboards connected to GCP/Azure architectures.

Industry field of expertise

Languages

French
Native or bilingual
English
Fluent

Workplace preferences

Can work on-site

Paris (up to 50km)

La Poste Groupe
Data Analyst
LOGISTICS AND SUPPLY CHAIN
September 2024 - November 2025 (1 year and 2 months)
Île-de-France, France
Creation of Power BI dashboards integrating indicators, DAX measures, automatic alerts, and dynamic visualizations for punctuality monitoring and real-time delay analysis. Conducted logistics flow analysis (per second, minute, hour) with conditional formatting rules and dynamic color codes to simplify performance management. Developed VBA automations to generate national and regional reports, apply intelligent filtering, and quickly produce reliable decision-making reports. Extracted and processed SQL data via advanced queries, joins, and filters to identify late drivers and ensure accurate operational follow-up. Used SAP modules for automated mileage calculations per driver and per client, ensuring reliable financial monitoring.
Microsoft Power BI VBA SAP SQL
Société BUSINESS HELP
Data Analyst
February 2021 - July 2021 (5 months)
Imported, cleaned, and transformed CSV files with Pandas (Python) in Jupyter Notebook, enabling exploratory data analysis (EDA) and preparation of high-quality data. Explored and analyzed volumetric data via Google BigQuery, using optimized SQL queries, joins, aggregations, and advanced analytical functions. Developed and trained Machine Learning models (classification, regression, performance evaluation) with scikit-learn, integrated into analysis workflows.
DXC Technology
Data Analyst
September 2019 - February 2020 (5 months)
Collected, prepared, and transformed datasets using Python (Pandas, NumPy) and implemented ETL pipelines to ensure data flow reliability. Built and orchestrated dbt models using advanced SQL queries (CTE, window functions, optimized joins) on BigQuery. Performed analytical modeling in Power BI with star schema creation, DAX measures, and performance optimization. Designed interactive dashboards with Power BI and Metabase, leveraging GCP (BigQuery, Cloud Storage) and Azure (Data Lake, Synapse Analytics) for volumetric data analysis.