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
Toolkit Power BI · SQL · Python · Power Automate
Scroll
01 About

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 Experience

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 scalable dashboards, workflows, and analytical outputs that strengthen day-to-day and management decision-making.

    • Lead the development and enhancement of reporting solutions across collections, invoicing, AR, and month-end finance processes.
    • Drive automation of reporting workflows in Power BI, SQL, Python, and Excel — reducing manual workload and improving consistency.
    • Improve visibility into AR, invoicing, disputes, and collections performance through dashboards and management reporting.
    • Strengthen reporting quality through better validation controls, standardized logic, and structured data handling practices.
    • Partner with stakeholders to scope and deliver reporting and automation solutions aligned to business priorities.
  2. 2023 — 2025

    Reporting Analyst

    Thermo Fisher Scientific · Basel

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

    • Streamlined revenue and AR reporting through automation in Python, Power Automate, Power BI, and Excel.
    • Developed and refined SQL-based reports and dashboards to improve visibility into revenue, AR, and operational performance.
    • Introduced data validation and quality control practices that improved reporting accuracy and reliability.
    • Built a Smartsheet-based invoice approval workflow to improve visibility, tracking, and process efficiency.
    • Delivered ad hoc analysis and management reporting to support data-driven decisions.
  3. 2022 — 2023

    Junior Data Analyst

    Locatee — Workplace Insights · Zurich

    Worked in a startup environment focused on workplace insights and real estate utilization. Built customer-facing dashboards, developed tailored metrics, and contributed to data warehouse work.

    • Built, enhanced, and customized Power BI dashboards delivering insights into real estate utilization and user behavior.
    • Developed customer-specific metrics and reporting solutions in Power BI, Python, and SQL.
    • Contributed to the design of a data warehouse — including source migration, SQL development, and pipeline optimization.
    • Helped improve internal data workflows and architecture, supporting more scalable reporting.
  4. 2021 — 2022

    Career transition · Data Analyst Programme

    OpenClassrooms

    A purposeful career break to transition out of aviation and into data. Completed a project-based programme covering Python, SQL, Excel, Power BI, and KNIME — 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.

03 Approach

A few principles that guide how I work.

i.

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.

ii.

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.

iii.

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.

iv.

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.

04 Selected Work

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 repetitive and prone to small inconsistencies between cycles. I rebuilt the pipeline end-to-end — SQL extracts feeding a Python processing layer, Power BI dashboards on top, and Power Automate flows handling refresh and distribution. The result: less manual work each month, and stronger, more trusted numbers through standardized logic and validation.

    • SQL
    • Python
    • Power BI
    • Excel
    • Power Automate
  2. Case 02 Workflow · Process

    Invoice Approval Workflow

    Invoice approvals during the monthly billing cycle were difficult to track and coordinate across stakeholders. I designed a Smartsheet-based workflow that gave the process clear ownership, real-time visibility on what was pending or approved, and a simple, transparent path through the cycle for everyone involved.

    • Smartsheet
    • Process design
    • Stakeholder coordination
  3. Case 03 Reporting · Data Quality

    Collections & Finance Reporting

    Operational reporting across collections, invoicing, disputes, and accounts receivable needed sharper visibility and a higher bar for trust. I enhanced the dashboards and reporting layer, introduced validation practices and reporting standards, and tightened how data was structured and presented — so finance and operations teams could act on the numbers without second-guessing them.

    • Power BI
    • SQL
    • Reporting standards
    • Data validation
05 Toolkit

The tools I reach for — chosen for the job, not the resume.

BI & Visualization

  • Power BI
  • Excel

Data & Querying

  • SQL
  • Python
  • KNIME

Automation & Workflow

  • Power Automate
  • Smartsheet
  • Excel automation

Strengths

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

Have a reporting problem worth solving? Let's talk.

I'm always open to thoughtful conversations about reporting, automation, business intelligence, or new opportunities. The fastest way to reach me is by email or on LinkedIn.

Email LinkedIn Download CV