Reporting Manager · Basel, Switzerland

Turning complex data into clear, useful decisions.

I'm Lucas — a reporting and analytics professional building dashboards, automations, and reporting systems that help finance and operations teams see their work clearly and act on it with confidence.

Currently Reporting Manager, Thermo Fisher Scientific
Focus Reporting · Automation · Business Intelligence
Based in Basel, Switzerland
Scroll
01

A practical approach to reporting, built on operational understanding and clean execution.

My work sits at the intersection of business and data. I design and build reporting solutions across collections, invoicing, accounts receivable, and finance operations — using Power BI, SQL, Python, and Power Automate to reduce manual effort and improve the visibility teams have into their own performance.

I started my career in aviation as cabin crew, where I learned composure under pressure, situational awareness, and the value of calm, clear communication. After a deliberate transition through a project-based data analytics programme, I moved into a junior analyst role at a Zurich workplace-insights startup, then joined Thermo Fisher Scientific — where I've progressed from Reporting Analyst to Reporting Manager.

I'm most drawn to problems where messy, fragmented data needs to become a simple, dependable view of reality. I care about clarity, maintainability, and giving stakeholders something they actually want to use.

02

A few things I've built — each one removing manual work and making business reality easier to see.

  1. Case 01 Reporting · Automation

    Revenue & AR Reporting Automation

    Recurring revenue and accounts receivable reporting was a monthly ritual — repetitive, and slightly different every cycle. I rebuilt it end-to-end: SQL extracts feeding a Python processing layer, Power BI dashboards on top, and Power Automate handling refresh and distribution.

    What changed The close got quieter. Same logic every month, less manual work, and numbers people didn't have to reconcile by hand.
    • SQL
    • Python
    • Power BI
    • Excel
    • Power Automate
  2. Case 02 Workflow · Process

    Invoice Approval Workflow

    Invoice approvals during the monthly billing cycle were hard to see and harder to coordinate. I designed a Smartsheet workflow with clear ownership and a live view of what was pending, approved, or waiting on someone.

    What changed One place to look. Everyone could see where a given invoice sat, and who needed to move it.
    • Smartsheet
    • Process design
    • Stakeholder coordination
  3. Case 03 Reporting · Data Quality

    Collections & Finance Reporting

    Operational reporting across collections, invoicing, disputes, and accounts receivable needed a higher bar for trust — not just more charts. I tightened the dashboards, introduced validation and reporting standards, and restructured how the data was presented.

    What changed Finance and operations could act on the numbers without second-guessing them.
    • Power BI
    • SQL
    • Reporting standards
    • Data validation
03

A career built deliberately — aviation to analytics to reporting leadership.

  1. 2025 — Present

    Reporting Manager

    Thermo Fisher Scientific · Basel

    Lead reporting, automation, and process improvement across collections, invoicing, accounts receivable, and finance operations. Translate business needs into dashboards, workflows, and analytical outputs that people actually use.

    • Own reporting and automation across collections, invoicing, AR, and month-end finance.
    • Build the dashboards and workflows that make performance visible — and trusted.
    • Partner with stakeholders to turn messy asks into something maintainable.
  2. 2023 — 2025

    Reporting Analyst

    Thermo Fisher Scientific · Basel

    Focused on revenue and accounts receivable reporting, automation, and process improvement — supporting monthly billing, invoice approvals, and month-end finance.

    • Automated recurring revenue and AR reporting in Python, Power Automate, Power BI, and Excel.
    • Introduced validation so monthly numbers didn't drift between cycles.
    • Designed a Smartsheet invoice-approval workflow for the billing cycle.
  3. 2022 — 2023

    Junior Data Analyst

    Locatee — Workplace Insights · Zurich

    Startup environment focused on workplace insights and real estate utilization. Customer-facing dashboards, tailored metrics, and early data-warehouse work.

    • Built and customized Power BI dashboards on real estate utilization and user behaviour.
    • Contributed to a data warehouse — source migration, SQL development, and pipeline work.
  4. 2021 — 2022

    Career transition · Data Analyst Programme

    OpenClassrooms

    A purposeful career break to move from aviation into data. Completed a project-based programme covering Python, SQL, Excel, and Power BI — with an emphasis on real analytical problem-solving and reporting.

  5. 2015 — 2020

    Cabin Crew

    easyJet · Basel

    Five years in a fast-paced, safety-critical environment. Strengthened communication, teamwork, situational awareness, and composure under pressure — habits that still shape how I work with stakeholders and handle complex problems today.

04

Four rules I keep coming back to — a method, not a manifesto.

  1. Start with the question, not the data

    Good reporting begins with understanding what decision needs to be made. I spend time with stakeholders before tools, so the output actually changes how the work gets done.

  2. Reduce manual work, deliberately

    Automation should feel boring and reliable — not clever. I design workflows that quietly remove repetition while staying easy for the next person to maintain.

  3. Treat data quality as a feature

    Validation, standardized logic, and structured handling are part of the deliverable. A dashboard is only as useful as the trust people have in the numbers behind it.

  4. Simplify before you visualize

    The best reports show fewer things, more clearly. I work to strip away noise so that the signal — what changed, what matters, what's next — is impossible to miss.

05

The stack I actually use — chosen for the job, not the resume.

  • PBI

    Power BI

    Dashboards and models people will open twice.

  • SQL

    SQL

    Extracts, joins, and the logic underneath the view.

  • PY

    Python

    Processing, validation, and the unglamorous glue.

  • XL

    Excel

    Fast analysis — and automation when it's the right surface.

  • PA

    Power Automate

    Refresh, routing, and the boring work that used to be a person.

  • SS

    Smartsheet

    Workflows with ownership, status, and a single place to look.

How I work

  • Reporting design
  • Process improvement
  • Data validation
  • Stakeholder collaboration
  • Financial & operational analytics
06

If something here resonates — let's talk.

Always happy to talk reporting, automation, business intelligence, or just say hello. Email is fastest; LinkedIn works too.