You're seeing this page as if you were . The main menu is still yours, though. Exit from immersion
Alexander OttoAO

Alexander Otto

Data Analyst Excel - VBA

300 €/jour
Basel, CH
3-7 ans

Délai de réponse moyen : 1h

À propos de Alexander

Excel Expert | Dashboards | Automation | Data Cleaning | Reporting

Do you need clean, reliable, and insightful Excel solutions that save you time and help you make better decisions? That’s exactly what I deliver.

I’m an Excel specialist with a strong focus on dashboards, automation, data analysis, and problem‑solving. Whether you’re overwhelmed with messy spreadsheets or need a professional dashboard that tells a clear story, I can help you transform your data into something powerful and easy to use.

🔧 What I can do for you

- Build interactive dashboards with slicers, charts, KPIs, and clean layouts
- Create automated Excel tools using formulas, Power Query, or VBA
- Clean, structure, and optimize messy datasets
- Design professional reports for management or clients
- Improve or fix existing spreadsheets
- Convert manual processes into efficient, automated workflows
- Provide 1:1 Excel support, troubleshooting, and training

💡 Why clients choose me
- Clear communication and fast delivery
- Clean, user‑friendly designs
- Reliable problem‑solving
- High‑quality work that saves you hours every week

📊 Tools & Skills
- Advanced Excel (Power Query, PivotTables, formulas, charts)
- Dashboard design
- VBA automation
- Data cleaning & transformation
- Reporting & visualization

🎯 My goal
To make your work easier, faster, and more efficient by creating Excel solutions that actually work for you — not against you.
If you want a professional, reliable Excel partner who delivers high‑quality results, I’d be happy to support you.
  • Allemand

    Bilingue ou natif

  • Français

    Bilingue ou natif

  • Anglais

    Capacité professionnelle complète

  • Espagnol

    Capacité professionnelle complète

En télétravail uniquement
Travaille majoritairement à distance

Expériences

  • Valora Schweiz AG
    Sustainability Analyst
    GRANDE DISTRIBUTION
    février 2024 - Aujourd'hui (2 ans et 4 mois)
    Muttenz, Suisse
    • Data management & data cleansing: Responsibility for cleansing and analysing sustainability data in the retail business; close cooperation with internal departments and external partners to ensure consistent data quality.
    • Compliance analytics: Implementation of due diligence obligations in four business areas (Switzerland, Germany, Luxembourg, Austria) through systematic data collection, supplier evaluations (EcoVadis, label queries) and preventive measures.
    • Data-focused project support: Deputy project management for the implementation of the EU regulation on deforestation, including analysis of regulatory requirements and their translation into data processes.
    • Optimisation through data analysis: Development and monitoring of food waste initiatives (Too Good To Go, 2nd Chance 2nd Day) and product range targets.
    • Key performance indicator management: Responsibility for the sustainability labelling of the own brand ok.- using Eco-Score and Nutri-Score; analysis of product data and derivation of KPIs.
    • Reporting & visualisation: Creation of presentations and dashboards (annual conference, SteerCo) for transparent communication of analysis results and project successes.
    Project Management Data visualization Reporting Microsoft Excel
  • Novartis Pharma AG
    Human Resources Assistant
    INDUSTRIE PHARMACEUTIQUE
    janvier 2021 - décembre 2021 (11 mois)
    Basel, Suisse
    • Project coordination and data analysis within the global senior HR team on various projects (cultural change, implementation of agile thinking through research and contact with various stakeholders)
    • HR Business Partnering & Operations
    Project Management Microsoft Excel Human Resources
  • Novartis Pharma AG
    Sustainability Analyst Intern
    INDUSTRIE PHARMACEUTIQUE
    juillet 2020 - décembre 2020 (5 mois)
    Basel, Suisse
    • Data management: Creating the plastics baseline within the Novartis research department by collecting, processing and analysing data and presenting the results to the Environmental Council (ES Council)
    • Finding solutions to reduce plastics
    • Bachelor's thesis on the topic ‘How big is the plastic footprint at the Novartis Institutes for BioMedical Research and how can it be reduced?’
    Microsoft Excel Data analysis Project Management

Recommandations

Soyez le premier à recommander Alexander

Contribuez à la réussite de ce freelance en partageant votre expérience de collaboration avec lui.

Ces profils de freelance correspondent également à vos critères

AgathaA

Agatha Frydrych

Backend Java Software Engineer

4.7

(3)

2

BaptisteB

Baptiste Duhen

Fullstack developer

4.6

(4)

5

AmedA

Amed Hamou

Senior Lead Developer

4

(2)

7

AudreyA

Audrey Champion

Web developer

4.3

(3)

4

Formations

  • Master's degree in ecological, economic and social sustainability
    Universitat Autònoma de Barcelona
    2023
  • Tri-national Bachelor's degree in International Business Management
    University of Applied Sciences and Arts Northwestern Switzerland
    2020
    Bachelor of Science (FHNW, Basel, Switzerland) Bachelor of Arts (DHBW, Lörrach, Germany) Licence Economie & Gestion (UHA, Colmar, France

Certifications

  • Power Query und Power Pivot für Datenanalysen in Excel
    Digicomp Academy AG
    2026
    Power Apps Microsoft Excel Power Query

Compétences

Catégories