Freelancer profile translated to English.

Description

Over 10 years of experience in business intelligence, during which I have aligned solid expertise in various business and industrial fields. I have supported several companies in defining and designing an information system facilitating decision-making. From gathering requirements to implementing tailor-made IT solutions and finally carrying out audit and expertise missions.

My technical skills, advanced IT aptitudes, have greatly helped me as a technical and functional consultant, Project Manager, or BI architect.

Languages

French
Native or bilingual
English
Fluent

Workplace preferences

Can work on-site

Paris 17e Arrondissement (up to 50km), Paris (up to 10km)

Pickup Services
Senior Data Consultant
PUBLIC SECTOR
November 2022 - Today (3 years and 7 months)
Saint-Ouen, France
 La Poste Group (PickUp) - Saint Ouen From November 2022 to present

Role: Senior Data Consultant
Activity Sector: E-commerce, Logistics
Scope: Europe
Missions: Redesign of the on-premise BI platform (Sql server & MSBI) to a modern cloud-based Data Platform based on Snowflake, dbt, and PowerBI
Tasks:
Data Foundation
 Participation in the modeling of the lower layers of the Data Platform: DataVault modeling of RawVault and BusinessVault
 Star modeling of the CoreDataModel (DataMart)
 Implementation of a generic pipeline architecture based on existing or customized macros (Raw, Staging, RV, BV, and CDM)
 Implementation of data pipelines on the different lower layers (DBT)
 Development of stored procedures for populating fact tables
 Development and adaptation of existing stored procedures from SQL Server to Snowflake
 SQL query optimization
 Design of automated tests ensuring consistency control and non-regression
Power BI
 Redesign of existing DataViz to PowerBI Premium: Recommendation of data reading mode in the DataSet (POC)
 Implementation of a graphic charter
 Mock-up and design of target reports
 Data security management (RLS)
 Metadata and data translation management
 Creation of Power BI report deployment pipelines.
 User support in creating Power BI reports, based on the semantic models (datasets) implemented, through touchpoints.
 Agile Scrum/Safe work methodology (Ceremonies: Daily, refinement, planning poker, sprint planning, sprint review, retrospective)
Technical Environment: Snowflake, dbt (Datavault), Power BI, Sql Server, MSBI, Azure Devops, MongoDB, RabbitMQ, Scrum (Safe)
Candriam
Azure Data Engineer
PRIVATE EQUITY
November 2019 - November 2022 (3 years)
Paris, France
 November 2019 to November 2022 CANDRIAM
Azure Data Engineer / MS Business Intelligence Expert
Project: Migration of SR Manager to Azure cloud
Tasks:
 Migration of the SR Manager project from on-premise to Azure cloud
 Migration of SSIS flows to Azure Data Factory
 Migration of the CERBER cube (multidimensional) to Power BI datasets.
 Creation of Power BI Report Server paginated reports
 Data security management (RLS)
 Metadata and data translation management

Project: SR Manager
Context: The SR Manager project aims to consolidate and manage liability financial data for client reporting and analysis purposes (AUM tracking, client classification, risk analysis, etc.).

Work performed:

 Implementation of SSIS flows to interface with a new transfer agent (Belfius funds)
 Evolution of the SSAS cube to incorporate Belfius flows
 Evolution of the monitoring SSRS report to track Belfius flows
 Migration of all SSIS flows from version 2008 R2 to version 2012 (Redesign to the new catalog architecture)
 Optimization of the SSAS cube refresh strategy
 Packaging and delivery monitoring
Technical Environment: SQL SERVER 2008 R2 and 2012, CozyRoc, MDX, DAX, T-SQL, TFS, Visual Studio, SalesForce, PowerBI.
ANRU - Agence Nationale pour la Rénovation Urbaine
DATA Architect / Technical Referent
REAL ESTATE
March 2019 - Today (7 years and 3 months)
Project Context: Supporting the IT department through workshops involving various stakeholders to propose and define the architecture of the BI information system.
Team: 5 FTE.
 Requirements gathering.
 Proposal of the BI architecture within the ANRU IS.
 Data Warehouse design.
 SSIS: Extraction and loading of data from multiple sources (SQL Server, SharePoint Lists, Oracle, and flat files) into the DWH via staging tables.
 SSAS: Design and development of tabular cubes.
 SSRS: Development and deployment of SSRS reports based on the developed cubes using DAX queries to exploit them.
 T-SQL: Development of stored procedures to apply business rules.
 Power BI Desktop: Exploitation of cube data through PBI.
Tools/Environment: SQL Server 2016, Visual Studio 2017, SharePoint 2017, Power BI.
SSIS SSAS SQL SERVER Microsoft Power BI SSRS T-SQL