About Côme
English
Native or bilingual
Italian
Conversational
Experience
- Jimmy FairlyData AnalystRETAIL (SMALL BUSINESS)April 2023 - Today (3 years and 1 month)Paris, FranceJimmy Fairly, an optician offering high-end glasses at affordable prices.+ 144 stores in France, UK, Belgium, Spain & Italy.ᐉ Creation of dashboards on Looker Studio- "Retail" Dashboards for daily store monitoring (Revenue, LFL, Volumes, etc.).- "Ops" Dashboard for monitoring the manufacturing process, lead times, and deliveries.Result: + 400 sessions per dayᐉ Data cleaning & database structuring- Cleaning commercial data in DBT- Structuring models & data checks on existing tablesStack: Google BigQuery, Looker Studio (Data Studio), DBT, FivetranData Sources: Retail Software (Keyneo), Payment (Octave, Adyen), GSheets
- Brut.Data AnalystPRESS AND MEDIAFebruary 2023 - Today (3 years and 4 months)Paris, Franceᐉ Data cleaning & dashboard on Looker- Dashboard on audience data (FB, IG, TK, YT, SP)- Dashboard on follower & demographic data.ᐉ Automation of reports with GSheet, Looker (Look ML) & Looker Studio- Automation of reports for Sales & Brand teams (Backend data + GSheet to an automated report for campaign analysis).- Automation of monthly audience reports for the entire company.ᐉ Exploratory analyses:- Demographic analyses of Facebook fans- Audience projections at the end of each month.Stack: Google BigQuery, Looker / Look ML, DBT Cloud, GithubData Sources: Backend, Social Networks, Google Sheet, Lucca
- Convelio SASData AnalystIMPORT AND EXPORTSeptember 2021 - October 2022 (1 year and 1 month)Paris, Franceᐉ Analysis and visualization of data to find actionable insights:- HR team dashboards to track recruitment activity and funnel.- Dashboard (scorecard) for scoring key KPIs to monitor market health from different perspectives (Business / Clients | Team / Ops)- Analyses within the framework of a sustainable development project (carbon emission compensation for transport methods within the GLEC framework).ᐉ Exploratory analyses:- Forecasting metrics such as "Revenue Forecast" for the BD team.- Impact of seasonality on sales- NPS and eNPSᐉ Reorganization of the data warehouse structure and data flow.Stack: Google BigQuery, Data Studio, Airflow, DBT, GithubData Sources: Backend, Salesforce, Front, Lever, Lucca
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
- DUT GEA (Business and Administration Management)Université Lyon 1, Lyon2017
- L3: Bachelor's Degree in Economics and Management - Operational Diagnosis of Companies trackOstfold University College, Halden, Norway2018Licence en anglais avec des sujets comme: Marketing, Economie & Finance internationale. Par ailleurs, j'ai pu assister à des cours de communication digitale, d'entreprise et inter-culturelle.
Certifications
- HTML/CSS BootcampLe Wagon, Shanghai2019
- Intermediate SQLDataCamp2020