About Guillaume
- Power BI: interactive dashboards and clear KPIs for quick decisions.
- Python: cleaning, analysis, and predictive modeling on all types of datasets.
- SQL: optimal extraction and manipulation of your relational databases.
French
Native or bilingual
Experience
- UMIH FormationData AnalystNovember 2023 - Today (2 years and 9 months)Montpellier, France
- Data pipeline engineering: design and optimization of SQL pipelines for data extraction, aggregation, and provisioning.
- ETL & data preprocessing: development of Python workflows for cleaning, transforming, and enriching datasets.
- Data visualization: modeling and integration in Power BI for creating interactive dashboards to facilitate KPI tracking.
- Ad hoc analytics: conducting multi-thematic analyses (sales performance, regional analyses, web/phone monitoring, operational planning).
- Data storytelling & decision support: producing reports and presentations that leverage data to guide strategic decisions for management and business units.
- Data ScientestData ScientistSPORTSMarch 2022 - July 2022 (4 months)Paris, FranceDevelopment of a prediction tool for sports betting
- Data preprocessing: cleaning, restructuring, and feature engineering to create more relevant explanatory variables.
- Data exploration: performing statistical and graphical visualizations (EDA) to identify patterns and better understand data distribution.
- Modeling: implementing supervised Machine Learning models to generate predictions and compare their performance.
- Data storytelling: daily reporting of results, critical analysis of obtained metrics, and iterations to refine models.
- Credit Agricole du LanguedocData AnalystBANKING AND INSURANCEAugust 2022 - September 2023 (1 year)Montpellier, France
- Business analysis & data-driven insights: analyzing client needs through preliminary studies and reporting results to guide strategy.
- Data management: manipulating and managing multiple large databases (big data context).
- Data querying & segmentation: writing SQL and SAS queries for customer targeting and marketing campaign activation.
- Marketing automation & multichannel: distributing and monitoring communications across all digital and traditional channels.
- Cross-functional collaboration: participating in collaborative projects with Marketing and Customer Communication teams to align data analysis with business needs.
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
- Data Scientist TrainingData Scientist - Mines ParisTech PSL2022Formation Data Analyst – Compétences et projets acquis Au cours de ma formation, j’ai développé un ensemble de compétences clés en data analytics, data engineering et machine learning : - Langages & outils data : maîtrise de Python et SQL pour le traitement et l’analyse de données, ainsi que de Power BI pour la création de dashboards interactifs et la visualisation des KPI. - Data preprocessing & exploration : nettoyage, transformation et prétraitement de datasets complexes pour extraire des informations pertinentes et structurées. - Analyse statistique & modélisation : réalisation d’analyses statistiques approfondies pour identifier des tendances et générer des insights actionnables. - Machine Learning & Deep Learning : conception, entraînement et évaluation de modèles prédictifs pour résoudre des problèmes variés, identifier des patterns et anticiper des résultats à partir de données historiques. Projet marquant : prédiction de résultats sportifs - Collecte et préparation de données sur des événements sportifs passés. - Construction d’un modèle de machine learning pour prédire les résultats futurs. - Application pratique de l’ensemble des compétences acquises en data preprocessing, modélisation et visualisation.
- Master of Science in Physics - Nanosciences and Functional MaterialsUniversity of Montpellier2021