À propos de Franck
☁️ Senior Data/Analytics Engineer, j'ai accompagné divers groupes (Cosmétique, Luxe..) sur leur migration vers GCP ☁️
En tant que Data/Analytics Engineer, j'ai réalisé les tâches suivantes 🧾:
♦ Construction de plusieurs entrepôts de données (logique de Data mesh)
♦ Récolte et analyse du besoin (Data Product Owner, Business Owner...)
♦ Utilisation de REST API sur des modules Cloud Run pour ingérer de la donnée
♦ Développement de la plateforme avec les technologies suivantes : BigQuery, Cloud Workflow, Cloud Scheduler, Cloud Run, Cloud Build, Cloud Storage, Pub/Sub, Firestore...
♦ Gestion de la CI/CD sur Github pour le versioning avec Cloud Build/Terraform pour déployer toute les ressources GCP
♦ Projet géré en méthodologie agile (ServiceNow/Jira)
♦ Modélisation avec dbt (Jinja), en implémentant des tests (dqtools / elementary)
👉 Si vous êtes à la recherche d'une personne autonome, proactive, à l'écoute du besoin client & spécialisé dans différents domaines (Supply, Finance, Customer, Product...), n'hésitez pas à me contacter
Français
Bilingue ou natif
Anglais
Capacité professionnelle complète
Accepte de travailler sur site
Paris (jusqu’à 50 km)
Expériences
- Saint laurentData/Analytics EngineerLUXEjuin 2023 - Aujourd'hui (3 ans)Paris, France- Setting up a Data Mesh architecture to scale data sharing across domains (Data as a Product)- Build of multiple Governed/Exposed Data Product in BigQuery
- Used in PowerBI/ToucanToco Dashboard
- As a self-service for end user (Data Analyst/Business team)
- Affiliated to the Finance (retail) & Supply domain- Collecting and analysing requirements to calculate new KPIs
- Week-to-date...year-to-date sales
- Store comparability, Traffic in store
- Stock on hand, in transit, in transfer
- Orders movement (allocated, non-allocated..)
- CI/CD through github & using Terraform to deploy GCP resources- With an ELT approach, using dbt as a tool (& as part of the CI/CD) to modelize our build/tests (SQL/Jinja)- Query optimization using build-in features in BigQuery (time/range partitioning, clustering, sharding)- Scrum agile methodology on Jira- Language: dbt (Jinja/Macro), SQL (BigQuery), Terraform (HCL), git, Python - L'OréalConsultant Data Engineer GCPMODE & COSMÉTIQUESjanvier 2021 - juin 2023 (2 ans et 5 mois)Paris, FranceData Engineer GCP for a leading beauty company Migration from SAP to full GCP managed services for serverless solutions :- Build of multiple Data Warehouses (BigQuery with views, materialized views/ Cloud Workflow/Cloud Scheduler)- CI/CD on Github with Cloud Build/Terraform for versioning and also to deploy all related GCP resources- Call from APIs on Cloud Run to retrieve data coming from different sources (event driven/REST API)- Design and implementation of multiples data pipeline with REST APIs on GCP platform- Design/build of the use-case to produce different types of Analytics PowerBI report through KPIs with input coming from the business- Other GCP services used : Cloud Storage, Cloud Pub/Sub, Cloud Tasks, Firestore, Cloud Shell, Compute Engine, IAM- Scrum agile methodology on ServiceNow/Jira- Language: SQL, Python, Terraform (HashiCorp Configuration Language), bash- IDE: Visual Studio Code (IDE implemented in VMs/Cloud Workstations)
- Allianz FranceData Analystseptembre 2019 - septembre 2020 (1 an)92400 Courbevoie, FranceProduction of KPIs for dashboards on outbound flows (SAS / Excel / VBA)- Handling of large and complex databases- Categorization of the different flows according to the insurance field (SAS - production of 6 differents dashboards) Build of data pipeline based on the publishing providers (SAS / Excel)- Analysis done through 5 dashboards- Implementation of pricing strategies with the providers Predictive analysis from the availability of stock and disparities (SAS) Automation of programs for invoice control (SAS) Capitalization and knowledge transfer to the business
Recommandations
Soyez le premier à recommander Franck
Contribuez à la réussite de ce freelance en partageant votre expérience de collaboration avec lui.
Ces profils de freelance correspondent également à vos critères
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
Formations
- Master's degree, Data ScienceUniversité Paris-Est Créteil (UPEC)2020Master's degree in Data Science
- Bachelor's degree in EconometricsUniversité Paris-Est Créteil (UPEC)2018Bachelor's degree in economy/statistics
Certifications
- Professional Data EngineerGoogle Cloud2021
- HashiCorp Certified: Terraform Associate (002)HashiCorp2022