Freelancer profile translated to English.

Description

Technical and functional consultant in data and BI for about twenty years, I install and maintain Business Intelligence solutions for my clients.

I am involved, in whole or in part, alone or in a team, in every step of the solution implementation:

discussion with business departments
writing functional and technical specifications
"data lineage medalion" (Bronze, Silver, gold layers),
modeling (OLTP => OLAP, star schema, SCD)
dataviz
project management (sometimes)

Skills:

Business Intelligence: Power BI, Qlik View/Sense, MyReport, ThoughtSpot
Data: Databricks, Snowflake, Azure, SAP Hana, Big Query, Sql Server, Oracle, MySql
ETL & Orchestration: Informatica, Power Query, CTRL M, Apache Airflow
ERP & CRM: Business Central, Sage X3, People Soft, SAP, SalesForce
Project: Scrum Methodology
Project: Applications: Jira, Redmine, Github

Languages

English
Fluent
French
Native or bilingual

Workplace preferences

Can work on-site

Antony (up to 50km)

Eiffage
Data & BI Consultant
November 2024 - December 2025 (1 year and 1 month)
Hôtel de Ville, Paris, France
• - Power BI: development and maintenance of about twenty datasets and reports covering the group's "purchasing" scope (85,000 people, €23 billion in revenue)
• - Development and maintenance of about twenty datasets and reports covering the group's "purchasing" scope (85,000 people, €23 billion in revenue)
• - Performance improvement (by a factor of 16), application of "best practices" (SQL script, modeling, DAX, deployment),
Pernod Ricard
Data & BI Consultant
March 2024 - October 2024 (7 months)
Paris, France
• - 10 subsidiaries/countries in the group are migrating their ERP from Navision to Business Central. Power BI reports were redeveloped to be "plugged" into the new ERP, and "unified" (the same report becomes accessible to all countries).
• - Study of business needs, reverse engineering, functional specifications, SQL, ingestion & modeling
• - Power BI: team development of about ten reports, covering the following areas: sales, finance, purchasing, inventory, HR,
• - Project: governance, division of the project into lots (or sprints), monitoring and escalation of alerts,
• - Documentation for business departments, operations, and developers.
Boisset la Famille des Grands Vins
Data & BI Consultant - Power BI Project Manager
April 2021 - September 2023 (2 years and 5 months)
Nuits-Saint-Georges, France
• - Implementation of Power BI for France. Development of a "turnkey" commercial management application:
• * Extraction, cleaning, "warehousing" and modeling of ERP data (X3) via Dataflows,
• * Incremental refresh,
• * CI/CD: Deployment pipelines.
• - MyReport. Upgrade and maintenance.