Freelancer profile translated to English.

Description

Senior BI & Data Consultant, I support companies in the design and industrialization of decision-support solutions, from understanding business needs to providing reliable and actionable data.

I work on modeling, reporting, multi-source integration, and BI governance, with a technical-functional approach focused on performance and decision support.

My experience in consulting firms and in end-client environments has allowed me to work in various sectors such as telecommunications, automotive, banking, cosmetics, luxury goods, and media.

Languages

French
Native or bilingual
English
Conversational

Workplace preferences

Can work on-site

Paris (up to 50km)

ORANGE
Senior BI & Data Consultant – Power BI / GCP / MSBI
TELECOMMUNICATIONS
June 2024 - Today (2 years and 1 month)
Arcueil, France
**Needs**:

Design and deployment of a decision-support BI platform under Power BI dedicated to monitoring the performance of Fiber Infrastructure Operators and the execution quality of STOC contracts, in alignment with Orange Commercial Operator's goals.

**Achievements**:

• Led the design of a Power BI decision-support platform dedicated to monitoring the performance of Fiber Infrastructure Operators and STOC execution quality for Orange Commercial Operator

• Integrated, consolidated, and leveraged data sources from several Orange departments (Local Loop, OWF, DTR, Processes…), with rationalization of existing Power BI reports

• Structured a multi-level monitoring vision enabling performance analysis by intervention unit, Infrastructure Operator, Commercial Operator, parent company, geographical area, and shared equipment

• Defined and industrialized multi-dimensional monitoring indicators for the analysis of production, maintenance (after-sales service), execution quality, network quality, and incident management

• Implemented a comparative operator evaluation logic via a maturity matrix, to identify their shortcomings based on consolidated indicators

• Documented, secured, and transferred the work carried out, contributing to the team's cross-functional data initiatives, particularly around e-intervention

**Environment**: MSBI (Power BI, SSIS, SSAS) | Google Cloud Platform (BigQuery) | Power Platform (Power Apps, Power Automate, Dataverse) | SQL, DAX, MDX, Power Query (M) | REST API
MSBI (Power BI, SSIS, SSAS) Google Cloud Platform (BigQuery) Power Platform (Power Apps, Power Automate, Dataverse) SQL, DAX, MDX, Power Query (M) REST API
KEYRUS
BI & Data Consultant
CONSULTING AND AUDITS
October 2021 - June 2024 (2 years and 8 months)
Levallois-Perret, France
**Clients**: Volkswagen Retail, Pernod Ricard, CFAO, Cartier, L’Oréal / DSI

**Context**: Engagement with several major clients on BI & Data projects with a strong technical-functional dimension, covering business scoping, data modeling, design and industrialization of decision-support solutions, data integration, and BI governance.

Achievements
• End-to-end management of BI & Data projects, from business scoping to production deployment

• Gathering and formalizing requirements, writing specifications, and contributing to the definition of decision-support architectures and data models aligned with business objectives

• Design, migration, and optimization of Power BI solutions: dashboards, reports, indicators, data feeding and preparation flows, and analytical models

• Integration, consolidation, and leveraging of multi-source data in Microsoft BI, Google Cloud Platform (BigQuery), Azure, and Snowflake environments

• Implementation of ETL flows and feeding pipelines (SSIS, Azure Data Factory), with SQL development, stored procedures, and tabular and multidimensional SSAS modeling

• Development and optimization of analytical treatments (DAX, MDX, Power Query) to ensure indicator reliability and improve performance

• Power BI administration and governance: management of workspaces, access rights, licenses, security, deployment, and distribution of reports

• Performing integration tests, user acceptance testing, documentation, functional and technical support, and evolutionary and corrective maintenance

**Environment**: MSBI (Power BI, SSIS, SSAS) | Azure Data Services (ADF, AAS, ADLS, Azure SQL, Blob Storage) | Google Cloud Platform (BigQuery) | Snowflake | Power Platform (Power Apps, Power Automate, Dataverse) | SQL, Transact-SQL, DAX, MDX, Power Query (M), Python | DAX Studio, SSMS, Azure DevOps (CI/CD) | REST API
MSBI (Power BI, SSIS, SSAS) Azure Data Services (ADF, AAS, ADLS, Azure SQL, Blob Storage) Google Cloud Platform (BigQuery) Snowflake Power Platform (Power Apps, Power Automate, Dataverse)
LINCOLN
BI & Data Consultant – MSBI
CONSULTING AND AUDITS
February 2021 - September 2021 (7 months)
Boulogne-Billancourt, France
**Clients**: L’Oréal, Engie

**Context**: Engagement with several major clients on BI & Data projects with a strong technical-functional dimension, covering the design, evolution, and industrialization of decision-support solutions.

Achievements
• Migration, optimization, and evolution of existing Power BI reports (DAX, SQL, MDX)

• Design of dashboards and structuring of data in response to business needs

• Implementation of data feeding and preparation flows to ensure the reliability and industrialization of reports

• Performance optimization, ergonomics improvement, and adherence to business standards / graphic charter

• Collaboration with business teams for scoping, prioritization, knowledge transfer, and user acceptance testing

• Performing tests, handling anomalies, corrective and evolutionary maintenance, writing user guides, and tracking business requests via Jira, Confluence, Azure DevOps (CI/CD)

**Environment**: MSBI (Power BI, SSAS) | SQL Server, Transact-SQL, SSMS | DAX, MDX, Python | Hive, Impala | SharePoint, OneDrive, Jira | PuTTY
MSBI (Power BI, SSAS) SQL Server, Transact-SQL, SSMS DAX, MDX, Python Hive, Impala SharePoint, OneDrive, Jira