Freelancer profile translated to English.
Back to original languageAbout Luiggi
Naturally curious and passionate about the world of Databases, I carry out my consulting work through projects centered around the MICROSOFT FABRIC platform, addressing Data Cloud computing issues by applying agile project management methods. I have several projects to my credit since 2011, notably the creation of POWER BI Dashboards related to the data platform for major clients such as AXA, BNP, Air Liquide, or even Data Marketing at Picture Organic Clothing.
I help my clients in setting up their KPIs by structuring data to facilitate quick and insightful decision-making.
French
Native or bilingual
English
Fluent
Can work on-site
Paris 9e Arrondissement (up to 50km)
Experience
- Picture Organic ClothingData Engineer Microsoft FabricE-COMMERCEFebruary 2025 - Today (1 year and 4 months)Paris, FranceData Structuring▪ Creation of data models (incoming flows managed by an external team) in PySpark
- Participation in workshops to define the target technical architecture of the Microsoft Fabric platform and its documentation
- Implementation of a multi-data source oriented architecture (Sage, Web scraping, API Funnel, Google Analytics, Meta, Facebook data)
- Recommendation of a Lakehouse orientation to host data in csv files
- Implementation of orchestration for notebooks to run automatically at a defined frequency with Airflow (Python) and Active Directory pipeline
- Manipulation of marketing and web data with DAX language by applying the Medallion architecture (Bronze, Silver, and Gold layers for datamarts) from tables in the lakehouse
- Participation with the Product Owner in business workshops to ensure that the structured data meets all the needs listed in the KPI Framework
- Application of transformations via notebooks in Python and SQL
- Implementation of datamarts for consumption in semantic models
- Creation of dashboards based on semantic models in Direct Lake/Import
- Use of advanced DAX techniques (Budget, Stock, CalculationGroup etc.)
Data Quality- Acceptance testing of raw and structured data
- Implementation of tests and alerting
- Consideration of CI/CD (Azure Devops)
- Implementation of the deployment pipeline
Documentation- Production of detailed technical documentation on the code and a more macro-level document for the Product Owner
- AxentiaConsultant Data Platform FABRIC MicrosoftREAL ESTATEApril 2024 - Today (2 years and 2 months)Paris, FranceAs part of my mission, I developed an action plan with a study and feasibility of the Microsoft Fabric solution on the client's information system. Then I configured the platform coupled with the git devops part for source code backup:
- Technical Architecture Proposal
- Implementation of the data warehouse / lakehouse with Microsoft's Fabric solution
- Development of data integration pipelines connected to an Azure storage account / SFTP
- Stored procedures for populating the DWH
- Use of Data Flow Gen 2 connecting to web API to retrieve open data
- Conducted business workshops with the client to define requirements
- Created 3 reports: Work Project Monitoring / Technical Asset Database and Strategic Asset Plan based on the Fabric data warehouse datamart
- Development of a Data Mesh oriented architecture with Fabric domain management
- Data governance and deployment of semantic models in a POWER BI workspace / implementation of data endorsement and Power BI application
- ONTEX SANTE FranceData Cloud engineerHEALTH AND WELLNESSSeptember 2022 - November 2023 (1 year and 2 months)As a data engineer on Azure technologies, I designed the architecture and then the data integration for the platform that retrieves data from an Azure PostGreSQL database to Azure Synapse Analytics.The Pioneer project is based on connected objects (IOT) that send information through a protocol indicating the saturation level of the connected diapers used by residents of partner retirement homes (Ontex). This application was developed by a team specialized in Java Spring / FrontEnd React BackEnd JavaSpring.My role was to advise the client in its implementation of a unified data environment around Azure Data Factory, Azure Data Lake Gen 2, Power BI, Spark Pool, and Azure Sql OnDemand Database technologies.This solution is part of a CI/CD approach with Devops / Secops through the Terraform platform and Azure Key Vault for secret generation. Several Dashboards were created with Power BI to study the activity of retirement homes and thus help their management to optimize the flow, guarantee the quality of service offered to patients, and be able to intervene based on the data collected daily and made available.
Reviews
Matthias
ONTEX SANTE France
Reviewed on 10/6/2023
Excellent collaboration with Luiggi!
Recommendations
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
- Degree in Information Systems EngineeringSUPINFO2011Titre international d’Ingénierie Informatique de SUPINFO International University: - Base de données /Algorithmique - Réseau (CISCO -> CCNA) - Développement d'application WEB / MOBILE - Système - ...
Certifications
- Certification DP 600: Microsoft Certified: Fabric Analytics Engineer Associatepearson vue
- Certification PL 300: Microsoft Certified: Power BI Data Analyst AssociatePearson vue