Freelancer profile translated to English.

Description

Expert in the Microsoft data stack for 15 years, I support my clients in developing data platform solutions (DWH, Data Lake) and optimized, scalable, and user-friendly semantic models for end-users.

Strengths:

• Technical lead with functional aptitude

• Fluent English and international experience

• Facilitation of business workshops, training, and client pre-sales

• T-SQL, DAX, and data modeling optimization

• Agile Scrum methodology / Dev prioritization

• FinOps: Code and Cost Optimization

Expertise Technologies:

• Azure data services (Data Lake, Data Factory, SqlDB, Synapse Analytics, Databricks)

• Power BI / Fabric

• Databricks

• SQL Server (SSIS, SSAS, SSRS)

• Azure DevOps / Git

Expertise Languages: T-SQL, DAX, Pyspark

Known Languages: PowerShell, Python

Industry field of expertise

Languages

English
Native or bilingual

Workplace preferences

Can work on-site

Paris (up to 50km)

AXA Partners
Senior Data Engineer
BANKING AND INSURANCE
January 2020 - Today (6 years and 5 months)
Châtillon, France
2022
Implementation of a data solution and a cube for Axa Partners' Finance data from the PeopleSoft ERP
• Implementation of a Lake house (Delta Lake)
• Ingestion with Databricks
• Creation of a Tabular cube
• DevOps & CI/CD

Tech Env: Microsoft Azure (Databricks, ADLS Gen2, AAS) Azure DevOps, Git, Power BI
Language: SQL, DAX, Pyspark
Project Duration: 1 year

2020
Migration of the on-premise multi-source BI solution to Azure (Hybrid Cloud Architecture)
• Migration of the DWH to Azure Data Lake and SQLDB
• Migration of multi-source SSIS flows to Azure Data Factory
• Migration of MultiDim OLAP cubes to Tabular OLAP
• Optimization: automatic Scale Up/Down and Partitioning
• DevOps & CI/CD

Tech Env: Microsoft Azure, (ADLS Gen2, ADF, SQLDB, AAS), Azure DevOps, Git, Power BI
Language: SQL, DAX
Project Duration: 1 year
Azure Databricks Delta Lake Microsoft Power BI Azure SQL Azure Synapse Analytics Azure DevOps Git Transact-SQL DAX PySpark Azure Data Factory
CHANEL
Lead Tech Platform Data
RETAIL (SMALL BUSINESS)
January 2019 - Today (7 years and 5 months)
Paris, France
2021
Implementation of a Lakehouse to serve multiple projects (+- 20 projects to date)
Project including 8 people, 4 of whom are developers
• Integration of data from multiple sources
• Design of the global Lakehouse
• Data model design per project in Power BI
• DevOps & CI/CD

Tech Env: Microsoft Azure (Databricks, ADLS, ADF, Synapse), Azure DevOps, Git, Power BI Premium
Language: T-SQL, DAX, Pyspark

2019
Implementation of a data warehouse for monitoring sales, budget, transfers, and stocks in Europe.
Project including 15 people, 6 of whom are developers (50 sprints)
• Modeling and design of the warehouse
• Integration of data from multiple sources
• Creation of OLAP Tabular cube and Power BI reports
• DevOps & CI/CD
• Project management in Agile SCRUM

Tech Env: SQL Server 2019 (SSDB, SSIS, SSAS), Azure DevOps, Git, Power BI Premium
Language: T-SQL, DAX
Microsoft Azure Azure DevOps Azure Databricks Azure Data Lake Microsoft SQL Server Git Microsoft Power BI T-SQL DAX PySpark Python Azure Data Factory Azure Synapse Analytics
EDF
Consultant MS SQL Server BI
ENERGY AND UTILITIES
November 2016 - January 2019 (2 years and 2 months)
Paris, France
Implementation of a management and stock prediction solution for spare parts in nuclear power plants to reduce inventory.
• Modeling and implementation of the DWH
• Development of ETL and OLAP cubes
• Development of a dashboard consolidating KPIs
• Agile SCRUM project management via TFS and Visual Studio

Environment: SQL Server 2016 (SSIS, SSAS, SSRS), SharePoint 2013 , Office App, Excel online, R
Microsoft SQL Server Microsoft Visual Studio SSAS SQL Server Integration Services (SSIS) SSIS SSRS