Freelancer profile translated to English.

Description

🎯 Data & Business Analyst Consultant with over 15 years of experience in data management, analysis, and valorization.

I combine strong business and technical expertise, and I work across the entire data chain:

📊 Data Modeling: relational and analytical (ETL/ELT, DWH, datamarts)

⚙️ SQL Development: views, stored procedures, test automation, optimization, particularly using the dbt framework which I particularly appreciate

🔗 Data Tooling: BI reporting (Tableau, Power BI), prep (Dataiku, dbt), virtualization (Denodo), cloud computing (GCP or IBM Cloud)

💼 Results-oriented, rigorous, and attentive to business needs, I am committed to delivering reliable, well-documented solutions that meet expectations.

Industry field of expertise

Languages

French
Native or bilingual
English
Fluent

Workplace preferences

Can work on-site

Paris (up to 50km)

BNP Paribas
Business Data Analyst
BANKING AND INSURANCE
January 2022 - Today (4 years and 6 months)
Montreuil, France
Implementation of a data platform for the compliance of the BNP Paribas group. Having joined at the project launch, I supported the project manager in the design and modeling of the data platform. The complexity of this project was to meet poorly defined BI needs, handle large volumes of data, and adhere to an imposed technological stack.

- Modeling of the datalake structure for compliance data centralization
- Modeling of the Datawarehouse and Datamart in line with anticipated needs (primarily BI) and company constraints
- Specification of key business KPIs in collaboration with business teams (message filtering & case management)
- Data preparation in Python to generate dummy data
- Benchmark of models before implementation
- Publication of datasets on Tableau Server for BI use
- Monitoring through the creation of Tableau Dashboards to measure data platform performance
- POC for technical solution selection support
- Query optimization
- Creation of specific materialized views
- Test automation using dbt + stored procedures
PostgreSQL Tableau software Dataiku Python DBT
Banque de France
Business Analyst
PUBLIC SECTOR
September 2021 - December 2021 (4 months)
Paris, France
I joined the Banque de France as an IT project management support on the IT transformation program for the Directorate General of Statistics and International Studies (DGSEI). The objective of this mission is to frame the pre-project to allow the design of an IT trajectory focused on developing added value.

- Reception and analysis of needs from 8 business departments (identification of opportunities, quick-wins, or projects to launch)
- Monitoring and enrichment of the backlog (kanban)
- Design of strategic KPIs focused on value creation
- Application mapping (gathering information from experts to transcribe and capitalize knowledge)
Process improvement Key performance indicators Backlog management Functional specifications Microsoft Power BI
UFF (Union Financière de France)
IT Project Manager
BANKING AND INSURANCE
July 2020 - August 2021 (1 year and 2 months)
Boulogne-Billancourt, France
- Gathering and standardizing needs from various business departments (sales, finance, management)
- Writing functional and technical specifications
- Mock-up of screens for affected advisor tools
- Managing development and testing (monthly releases)
- Organizing project committees
Technical specifications Process improvement IT project management Regulatory compliance Big Query