About Franck
French
Native or bilingual
English
Fluent
Experience
- Saint laurentData/Analytics EngineerLUXURY GOODSJune 2023 - Today (3 years)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 GCPFASHION AND COSMETICSJanuary 2021 - June 2023 (2 years and 5 months)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 AnalystSeptember 2019 - September 2020 (1 year)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
Recommendations
Be the first to recommend Franck
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'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