Freelancer profile translated to English.
Back to original languageAbout Yves
Data Consultant for over 10 years, I advise and implement projects for companies on Azure and On-Premise architectures.
I can be involved during the audit or scoping phase up to implementation, going through the design/architecture and PoC phases.
I have been responsible for setting up complete decision-making solutions (design, data loading, sizing, and administration) on architectures:
• On Premise: SQL Server, MDM, SSAS (Multidimensional and Tabular), SSIS, and SSRS
• Azure: SqlDB, Synapse, AzureDW, Power BI, AzureDataLake, Azure Data Factory, ...
English
Conversational
French
Native or bilingual
Can work on-site
Paris (up to 10km)
Experience
- Air Liquide ITAzure Data Platform Consultant | Technical LeadRAW MATERIALS INDUSTRYFebruary 2023 - Today (3 years and 4 months)Paris, France
Mission Context:
Technical leadership of a squad of 12 members (including 6 Data developers) managing a portfolio of 10 strategic projects.Mission Objective:
Leadership and Architecture:- Azure Cloud Cost Review and Optimization (AWS included)- Definition of robust and scalable architectures (Azure best practices)- Technical support: mentoring, code reviews, team upskillingData Platform Development:- Azure Data Factory Pipelines: data ingestion and transformation- Tabular Modeling (Azure Analysis Services / Power BI Premium): design, development, optimization (DAX Studio)Power BI Premium Migration:- Migration from Azure Analysis Services to Power BI Premium: planning, execution, performance impact analysis- CI/CD Pipeline Update (Azure DevOps): automated deployment to Power BI Premium (REST API, PowerShell)- Azure Analysis Services Decommissioning (cost reduction)- Change Management: user support (migration from Excel to Google Sheets)Portfolio Management:- Management of 10 strategic projects: HR (headcount, compensation), Finance (P&L, budget, forecast), Market Share, Group Referential Data (customers, products, organizations, sites), etc.Technical Environment:Azure Synapse, Azure Analysis Services, Azure Data Factory, Azure DevOps, Power BI Premium, DAX, AWS - Action Logement ServicesData Platform Consultant | Technical LeadPUBLIC SECTORAugust 2021 - January 2023 (1 year and 6 months)Paris, France
Mission Context:
Cloud Migration and industrialization of a BI platform: creation of an Azure Data Lake as a single data source for all Group BI projectsProjects delivered: Polaris, ONV, Activity Report.Mission Objective:
Data Lake Architecture (Azure Synapse Analytics):- Comparative study of SQL Pool vs SQL Serverless and technological arbitration- Medallion Architecture Design: Landing → Raw → Curated (+ Rejected)- ADF Pipelines for automated data processing between Data Lake zones- Data merge automation (SQL Serverless procedures)- Advanced monitoring of loads with traceabilityDatamart and Consumption:- Populating datamarts via optimized SQL procedures (ADF orchestration)- Complete load audit- Power BI monitoring report for business teamsDevOps and Industrialization:- Full CI/CD: Azure DevOps pipelines (YAML) for ADF, Synapse SQL Serverless (PowerShell), and Azure SQL DB- Multi-environment deployment (DEV/TEST/PROD)- Reusable reference architecture for future BI projectsTechnical Environment:Azure Data Lake, Azure Data Factory, Azure DevOps (CI/CD), Power BI, Azure Synapse workspace, SQL Serverless, Azure SQL DB, Azure Table - JTI (Japan Tobacco International)Data Platform ConsultantCHEMICALJune 2021 - July 2021 (2 months)Paris, France
Mission Context:
POC: Design and validation of an Azure Data Platform architecture (Data Lake) for the GroupMission Objective:
- Design and implementation of an Azure data platform- Ingestion automation: SFTP monitoring via Azure Logic Apps and automatic triggering of ADF pipelines- Data processing orchestration with Azure Data Factory (complex multi-stage pipelines)- Data transformation with Mapping Data Flow (ADF): validation of business rules, business transformations- Layered architecture: generation of intermediate files in Azure Data Lake at each processing step- Traceability: logging of processing in Azure Storage Table- Data consumption and loading into Azure SQL DatabaseTechnical Environment:Azure SQL DB, Azure DataFactory, Azure Blob, Azure Key Vault, Azure DevOps (CI/CD, Scrum), Mapping Data Flow, Logic App
Recommendations
Be the first to recommend Yves
Help this freelancer shine by sharing your experience working together.
These freelancer profiles also match your criteria
Agatha Frydrych
Backend Java Software Engineer
4.7
(3)
2
Baptiste Duhen
Fullstack developer
4.6
(4)
5
Amed Hamou
Senior Lead Developer
4
(2)
7
Audrey Champion
Web developer
4.3
(3)
4
Education
- Master in Computer Science, specialization in Data Exploration and Business IntelligenceInstitut Galilée - Université Paris XIII2012
- Bachelor's DegreeUniversité Paris Nord - Paris 132010