About Marco
English
Fluent
French
Native or bilingual
Experience
- GO7Data Engineering MissionAVIATION AND AEROSPACENovember 2024 - Today (1 year and 7 months)
- Development of a scraping script in python (site protected by authentication system)
- Implementation of a docker container in snowflake containing the scraping script, daily execution of the script and loading of data into a snowflake table
- Creation of data pipeline in snowflake (cleaning, transformation and export of tables containing +20M lines)
- Creation of professional dashboard in Qlik sense and ThoughtSpot
- Naveo consultingData analysis ı Dashboard Power Bi with integration of a Python scriptAVIATION AND AEROSPACEMay 2024 - May 2024Londres, United KingdomDevelopment of an interactive Dashboard with Power BI and automation of data scraping via Python- Automated retrieval of data from a secure website requiring authentication, using a Python script to regularly download the latest updated data.- Integration of the Python script into Power BI allowing automatic retrieval of the latest versions of the data directly into the dashboard.- Cleaning and transformation of customer data in Power BI to ensure its quality and relevance for analysis.- Creation of an interactive and intuitive dashboard in Power BI, specially designed to be easily usable by novice users.- Saving cleaned data in Google BigQuery
- Naveo consultingData analyst ı Data analysis (several million lines)AVIATION AND AEROSPACEJune 2024 - June 2024 (1 month)Londres, United KingdomAnalysis of a vast dataset (several million) to identify the factors influencing the retirement of airliners- Import and aggregation of data from multiple sources (API, web scraping), allowing the creation of a complete database of several million lines on the aeronautical industry.- Rigorous data cleaning, including the management of outliers and missing values, to ensure a reliable basis for subsequent analysis.- Feature engineering: creation of new relevant variables to enrich the analysis and reveal hidden trends.- In-depth data analysis, including exploration of distributions, search for significant correlations and application of survival analysis to understand the dynamics of aircraft retirement.- Writing and presentation of a detailed report, summarizing key insights and providing strategic recommendations based on the results of the analysis.
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
- Training in Data Science / Data AnalysisLe Wagon2022- Collecte (API, scraping) et nettoyage de données - Exploration de datasets et analyse de données - Utilisation des différents modèles de machine learning (Logistic Regression, Random Forest, XGboost, SVM, KNN...) - Construction de pipelines avec preprocessing et modèle de machine Learning - Construction et entrainement de réseaux de neurones (computer vision, RNN, NLP) - Entrainement de modèles dans Google Cloud Platform - Création et mise en production d'une API sur GCP avec Docker - Utilisation des librairies suivantes : Python, Pandas, numpy, SciPy, Matplotlib, Seaborn, scikit learn, Tensorflow, docker, Google Cloud Platform, Streamlit
- MSc Financial AnalysisEDHEC Business School2018