Freelancer profile translated to English.

Description

After a master's degree in business intelligence from the University of Lyon, I have been working for various clients in different business sectors for over 7 years.

My skill set includes various technologies such as MS BI, PowerBI, SAP BI, and GCP across the entire decision-making chain (ETL & Reporting).

Languages

French
Native or bilingual
English
Fluent

Workplace preferences

Can work on-site

Paris (up to 50km)

L'Oréal
DATA ENGINEER
LUXURY GOODS
March 2022 - Today (4 years and 3 months)
St.-Ouen, France
Exposing data from the Beauty Tech Data Platform through Power BI datasets on GCP for Research & Innovation (R&I).
Designing optimized LookML explores for generative AI, enabling enriched analyses adapted to dynamic queries. Developing interactive dashboards in Looker Studio.

Objective:
Design a GCP architecture and Power BI datasets in Direct Query for real-time integration.
Develop LookML and Looker Studio solutions combining flexibility, performance, and advanced data exploitation by generative AI.

Mission:
• Development of several GCP datasets from SDDS, with in-depth expertise in developing the GCP part.
• Construction of Power BI models in accordance with defined specifications, including configuration in "Direct Query" mode.
• Configuration of Power BI dataset security rules (Row-Level Security - RLS) to ensure data confidentiality.
• Creation of Key Performance Indicators (KPIs).
• Testing and validation phase of the created datasets, with particular attention to performance testing.
• Implementation of improvements aimed at optimizing dataset performance.
• Configuration of dataset parameters to maximize operational efficiency.
• Implementation of dataset version tracking to ensure rigorous management.
• Publication of datasets in compliance with deployment pipeline processes.
• Exhaustive documentation of applied rules and performance improvements made, ensuring clear traceability of decisions taken.
• Creation of custom LookML explores for intuitive data exploration adapted to business needs.
• Development of interactive dashboards in Looker Studio according to user requests.
• Optimization of LookML explores for better exploitation by generative AI, enabling assisted and enriched analysis.
Google Cloud Google Cloud Run Google Composer Airflow Python PowerBI PowerBI Service DAX M Language Bravo for Power BI Tabular Editor Measure Killer DAX Studio Analyze in Excel Desktop Honorable Mention LookML Looker Studio Generative AI
banque de France
Creation of a BI for the financial department
BANKING AND INSURANCE
July 2021 - February 2022 (8 months)
Gathering user requirements
Writing detailed Use Cases
Writing technical specifications (description of workflows, dataflows, and databases)
Design and development of Datamart loading Jobs with SSIS technology
Building reports with Power BI technology
Acceptance testing
SSIS Microsoft SQL Server Microsoft Power BI M Language DAX Transact-SQL
L'Oréal SA - L'Oréal France
Redesign of the BI chain: ETL, storage and modeling, reporting.
FASHION AND COSMETICS
February 2016 - June 2021 (5 years and 5 months)
Gathering user requirements
Writing technical and functional specifications
Development of data warehouse loading flows with BODS
Synchronization of the local repository with the central repository
Data quality control
Non-regression testing
Audit of existing universes and proposal for improvement
Creation of IDT and UDT universes
Translation of French/English universes using the translation management tool
Management of access rights to universes via CMC
Migration of BO reports to new universes
Creation of BO reports and management of contexts, particularly through merged variables
Acceptance testing of BO universes and reports
Development of SSAS cubes
Management of roles on SSAS cubes
Development of SQL Server agent jobs for updating roles on SSAS cubes
Creation of Power BI Desktop reports (Power Query, M language, and DAX)
Publication of Power BI reports in the Power BI service
Management of Workspaces in the Power BI service
Management of gateways in the Power BI service
Creation and sharing of Power BI applications
Creation of usage monitoring dashboards for the platforms with Lumira
Writing best practice documents and functional support for users
Leading meetings to present achievements to worldwide users
Corrective maintenance of BODS jobs, IDT UDT universes, SSAS cubes, Talend Big Data jobs, and Power BI reports
SAP Business Objects BODS 4.2 Microsoft SQL Server SSAS Power BI Oracle SQL Developer Hive Talend M Language DAX PL/SQL Transact-SQL