Freelancer profile translated to English.
Back to original languageAbout Guillaume
I am a freelance Data Analyst focusing on reporting, KPI tracking, and automation for business and operations teams.
I help companies simplify manual Excel and reporting processes and transition them into reliable, automated analyses – using Excel, Python, and SQL.
Typical areas of application
- Automated reporting (Excel, CSV, PDF)
- KPI tracking & monitoring for operations, sales, or finance
- Data preparation & data cleaning
- Reporting automation with Python
- Dashboards & internal tools (e.g., Streamlit)
- Process automation for recurring tasks
Technical Stack
- Excel (advanced models, reporting)
- Python (scripting, automation)
- SQL
- APIs & Data Scraping
- Data Visualization & KPI Dashboards
Project Experience (Selection)
- E-commerce (DE): Automated vendor & price monitoring → better margins & decision-making basis | Stack: Python, Excel, Data Scraping, Reporting Automation
- B2B Sales (Drone Industry): Data aggregation & KPI reporting → structured sales funnel | Stack: CRM (Monday)
- Public Sector (CH): Automated file processing → significant reduction in manual work | Stack: Python, Excel
Languages
- German: B1–B2 (professional communication possible, stronger in writing than speaking)
- English: fluent (preferred project language)
French
Native or bilingual
English
Fluent
German
Fluent
Can work on-site
Berlin (up to 50km)
Experience
- Ring-ApothekenData AnalystE-COMMERCEJuly 2025 - Today (1 year and 1 month)Germany
- Automated data scraping and extraction from multiple online sources.
- AI-based processing and structuring of unstructured PDF documents into usable datasets.
- Development of an interactive dashboard to visualize, explore, and export the processed data for business use.
- Le Wagon GermanyTeaching Assistant Data Science and AI bootcampTECHNovember 2024 - Today (1 year and 9 months)Berlin, Germany
- Coaching and supporting students in Data Science
- Technical mentoring (Python, SQL)
- Simplification of complex concepts and pedagogical support
- UASolutions SàrlData AnalystAVIATION AND AEROSPACEJanuary 2025 - Today (1 year and 7 months)Lausanne, Switzerland
- Implementation of a KPI system to improve sales performance.
- Scraping and enrichment (via LLMs) of 1,200 exhibitors in the drone industry to identify high-potential prospects.
- Client support from needs identification through the start of the technical collaboration.
Reviews
Recommendations
Be the first to recommend Guillaume
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
- Data Science & AILe WagonData Science & AI
- Master of Science in Mechanical EngineeringEcole Polytechnique Fédérale de Lausanne (EPFL)2020Master in Mechanical engineering
Certifications
- The Certificate of Python ProgrammingConstructor Academy2021
- Data science & AILe Wagon Berlin2024