About Anthony
French
Native or bilingual
English
Fluent
Experience
- Cliken WebSenior Data Analyst - Power BI Developer - Analytics EngineerCONSULTING AND AUDITSApril 2025 - Today (1 year and 2 months)Lyon, FranceContext:Cliken Web had two distinct CRMs, hosted on OVH, without a centralized data access mechanism. The lack of consolidation complicated report production and collaboration among internal Power BI designers.Objective:Implement a robust, secure, and cost-effective analytical architecture allowing multiple Power BI designers to access consolidated data.Achievements:- Audit of IT constraints and choice of a hybrid on-prem/cloud architecture optimized for Power BI Pro- Installation of the Power BI Gateway between Power BI Service and the MariaDB database- Creation of a dedicated Power BI Workspace, data ingestion with secure connections- Implementation of daily automatic refresh and production of video tutorials for report designersBenefits:✔️ Centralized, operational, scalable architecture without dependency on Premium capacity✔️ Multi-user access to consolidated datasets✔️ Reduction in infrastructure and license costs✔️ Enhanced autonomy for internal teams thanks to educational deliverablesEnvironment:- Sources (Custom CRM - MariaDB - OVH)- Datalake (MariaDB Server)- ETL (Power BI Service Dataflow)
- La Poste GroupeSenior Data Analyst - Power BI DeveloperTELECOMMUNICATIONSAugust 2023 - Today (2 years and 10 months)Paris, France**Context**:La Poste has a fleet of over 17,000 network infrastructures and more than 30,000 entities using these services. I was tasked with taking over and redesigning this internal repository.Achievements:- Development and maintenance of a reconciliation matrix between La Poste's IS and the telecom operator's IS.- Development of reports using Power BI- Implementation and execution of a bi-annual audit for optimizing the group's telecom bills.- Design of an end-to-end analytics pipeline for all team data (Sharepoint → DataFlow → SQL Datamart → Power BI)- Development and maintenance of a critical internal matrix that allows in-store smartphones to automatically identify the store.Benefits:- Quality improvement of a critical internal repository.- In-depth cleanup leading to over €5M in annual invoice savings.- Dynamic and automated Power BI interfaces.Environment:- Source Storage (Sharepoint)- Data Ingestion (Dataflow Gen1 / Power Query)- Table Storage (Azure SQL Server Datamart)- Data Viz (Power BI)- Data Analysis (Power BI / Excel)
- Pernod RicardSenior Data Analyst - Excel VBA DeveloperWINE AND SPIRITSApril 2023 - March 2024 (11 months)Paris, FranceContext:Pernod Ricard is a French spirits company present in over 85 countries, offering a portfolio of more than 200 brands. I was tasked with developing an Excel tool for internal information collection across its 80+ markets.Achievements:• Integration of business rules through advanced formulas and conditional formatting.• Management and automation of checks for correct completion and field format using VBA.• Customization of the tool according to market/user context (e.g., units, currencies...).Results:• A tool with an identical structure at the group level and local customization.• Time savings and improved collection quality with automated checks before submission.• A structure ready for analysis and integration into Power BI.Environment:• Forms & Conditional Formatting (Excel).• Data quality automation (VBA).
Reviews
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
- Python and Machine Learningemil2022Partie I : Prenez en main Python et explorez des jeux de données Les bases de Python / Manipulation de données et statistiques descriptives / Visualisation (Plotly/Facets/Kepler) Partie II : Apprivoisez le Machine Learning sur les données tabulaires Analyses prédictives (sklearn et PyCaret) / Clustering Partie III : Prédisez le futur Saisonnalité / Prédiction temporelle (Prophet et Greykite) / Détection d’anomalie Partie IV : Domptez l’univers avec vos analyses spatio-temporelles Clustering / Découpage spatial (H3) / Cooccurrence et colocalisations Partie V : Projets de fin
- Marketing & Data AutomationEmil2021Partie I : Découvrez les concepts phares de l’automation Partie II : n8n : le bon compromis entre no-code et code. Partie III: Apprenez à extraire, stocker, transformer et exploiter votre data de façon automatisée avec Fivetran & Google Cloud Partie IV : Créez vos propres scripts d’automatisation avec Python et les cloud functions. Partie V : Projet de fin : Worflow sur n8n de scrapping Linkedin via Phamtobuster + enrichissement des contacts via Dropcontact pour stockage GSheet
Certifications
- Power BI Data Analyst Associate (PL300)Microsoft2024
- Microsoft Office Specialist: Excel Expert (Office 2019)ITTA2022