Freelancer profile translated to English.

Description

Senior Data Analyst, I support business departments in leveraging their data to produce directly usable analyses, indicators, and steering tools.

I work across the entire analytical chain: SQL extraction, data preparation and validation, exploratory and statistical analyses, Excel modeling, KPI definition, dashboards, and reporting. Excel is my primary analysis environment—advanced formulas, pivot tables, Power Query, and VBA—complemented by Python/pandas and Power BI.

I have worked for Stellantis Financial Services, TotalEnergies, Natixis, BNP Paribas, GRDF, ENI, EDF, and SUEZ on issues related to finance, risk, HR, marketing, energy, and industrial performance.

Languages

French
Native or bilingual
English
Fluent

Workplace preferences

Can work on-site

Paris (up to 50km)

EDF SA
Data Manager / Business Data Analyst
ENERGY AND UTILITIES
August 2025 - June 2026 (10 months)
Paris, France
Design and validation of Excel spreadsheets for data modeling, mapping, and lineage in a complex industrial environment.

Key achievements:
Structuring correspondence files between applications, tables, fields, and business objects;
Consolidating data from multiple systems, including PALADIN, BusinessObjects, and Base IPE;
Designing mapping and transformation tables usable by business and IT teams;
Implementing validation rules, dropdown lists, consistency checks, and repositories;
Improving the usability and readability of collaborative spreadsheets;
Producing user manuals, glossaries, and graphical representations;
Facilitating workshops and supporting users in data qualification.
Microsoft Excel MEGA HOPEX data lineage Data Quality
Stellantis Finance & Services
Data Analyst Excel
BANKING AND INSURANCE
January 2025 - July 2025 (7 months)
Poissy, France
Adaptation of regulatory reporting Excel files following the migration of financial data from SAP to OneStream.

Key achievements:
Analysis of the functioning of existing regulatory spreadsheets;
Identification of dependencies between sources, mappings, calculations, and restitutions;
Adaptation of files to the new OneStream data structures;
Updating feeding rules, formulas, and consistency checks;
Quality and completeness control of the data returned;
Securing Asset Encumbrance, Large Exposures, Leverage, and COREP reporting;
Liaising with finance, regulatory reporting, and information systems teams.
Microsoft Excel VBA Regulatory Reporting Onestream Data Analysis
TotalEnergies
Business Data Analyst HR
ENERGY AND UTILITIES
February 2023 - December 2023 (11 months)
Paris, France
Design of an Excel solution to manage and automate the group's Talent Review campaign.

Key achievements:
Gathering and formalizing the needs of the HR Performance & Data department;
Design of a master file to manage Talent Review data;
Development of VBA processes and features;
Use of Power Query to import, clean, and consolidate data;
Integration of controls to secure HR information;
Statistical and predictive analyses to identify high-potential talent;
Automation of PowerPoint report production with VBA;
Improvement of ergonomics to allow autonomous use by the HR department;
Conducting a post-campaign review and preparing for the automation of the next campaign.
HR Power Query Excel VBA Microsoft Excel Statistical Data Analysis