I make data useful.

Timmy Lu · Data Analyst & BI Developer

Timmy Lu in front of a lit grid wall with neon tubes

I bring together data analysis, business intelligence and automation: I prepare data so people can trust it, build dashboards teams make decisions with, and automate whatever repeats – more and more often with AI.

Projects

Work

Forecasting Pipeline & Monitoring App

Automated forecasts for sales data: preparing and validating the data, training and comparing time series and ML models, and surfacing deviations instantly in a monitoring app.

  • Python
  • SQL
  • Qlik
  • Time series
  • Machine learning
Go to project page

Work

AI-Assisted Product Data Analysis

An LLM workflow checks product data from several online shops for missing or incomplete attributes – an analysis that used to be done by hand now takes a fraction of the time.

  • Python
  • LLM API
  • Automation

Work

BI Dashboards

KPI cockpits for e-commerce and sales with plan and prior-year comparisons, plus a dashboard for influencer campaigns – from the first requirement to a report that is up to date every day.

  • Qlik Sense
  • SQL
  • Data modeling
  • Salesforce
Go to project page

Work

Jira Data into the Data Warehouse

Jira data flowing into the data warehouse automatically: queried via REST API and JQL, loaded incrementally, staged and merged into Exasol – as the basis for Qlik reports.

  • Python
  • Jira REST API
  • SQL
  • Exasol

Work

API Data Integration & Reporting

Connecting external data sources via REST APIs, cleaning and standardizing the data – and making it usable in ERP, data warehouse and BI reports.

  • Python
  • REST
  • SQL
  • Excel/CSV

Work

Coding Workshops with a Robot

Learning to code with a real robot: making it walk, talk, play music, blink its LEDs and adding sensors – in internal workshops and at school events like Girls’ Day.

  • Workshops
  • Robotics
  • Teaching
Go to project page
Clips from my KARL assembly tutorial

University

Bachelor’s Thesis: Graph Neural Networks

Purchase prediction with graph neural networks: customers and products as a temporal graph, link prediction with temporal GNNs and graph attention.

  • Python
  • PyTorch Geometric
  • Temporal GNN
  • Graph attention
Go to project page

University

ImmoCare

Team project

Building management software developed by a team of three. My part: user and task management – from the interface through gRPC services down to the database, including file storage, comments and a custom date picker.

  • C#
  • .NET MAUI
  • gRPC
  • Entity Framework
  • SQL Server
Go to project page
ImmoCare: “New task” form with title, status, assigned user, due date and file storageImmoCare: editing an existing task with an uploaded file to downloadImmoCare: comment section of a task
  1. .NET MAUI App
  2. gRPC
  3. ASP.NET Core
  4. SQL Server

Own projects

DealBot

Work in progress · simulation only

A trading system that tests strategies on real market data: data pipeline, backtester, paper trading bots, model tournament and web dashboard. Runs as a simulation only.

  • Python
  • FastAPI
  • React
  • TypeScript
  • Docker
Go to project page
DealBot mockup: dashboard with paper bots, equity curve against a world ETF and candle chart with trades (example data)DealBot mockup: bot detail with positions, chart, trades and decision log (example data)DealBot mockup: model tournament – models compared, ranked by risk-adjusted score (example data)DealBot mockup: scanner with candidates, reasoning and news mood (example data)

Design mockup with invented example numbers – not real results.

More projects

  • 2021

    Registration monitoring

    Analysis tool for the daily log files of a customer registration on Windows devices: counts events per device model, calculates error rates (above 1 % marked red), draws charts – with a user interface and an automatic weekly report by email.

    • Python
    • PyQt
    • Excel reports
    • Automation
  • 2022

    Battery Observer

    Test program for notebook batteries: switches Wi-Fi sockets on and off automatically so charging cycles run unattended, and records the measurements as a chart and CSV. My part: the interface with charts and dark mode, and the user guide as a web page.

    • C#
    • WPF
    • ESP8266
    • Team project
  • 2025

    Pallet space simulation

    Calculates from inbound lists how many pallets arrive at the warehouse per calendar week – including pallet factor and two-person handling, as a Python script running inside the database.

    • Python
    • pandas
    • Exasol
    • Logistics
  • 2024

    Choosing a marketplace middleware

    Market research and evaluation of marketplace middlewares as an alternative to the current provider: defining criteria, comparing providers and their marketplaces, preparing a recommendation.

    • Research
    • Evaluation
    • E-commerce
  • 2025

    Sales analysis with Google Trends

    Why do sales of a product group go up? Search interest compared with sales, traffic sources and regions analysed – and the result prepared for the business team.

    • Python
    • Google Trends
    • Analysis

Experience

  1. since 04/2026

    Own projects

    Essen

    • Working on DealBot and other projects
    • Open to new opportunities
  2. 04/2025 – 03/2026

    Junior Data Analyst

    medion GmbH, Essen

    • Designed and built Qlik reports and KPI dashboards based on business requirements
    • Provided data from the data warehouse via SQL, maintained data models and load processes
    • Validated KPIs in SAP ERP and reconciled them with the data warehouse
    • Developed and ran a forecasting pipeline for sales data in Python
    • Opened up new data sources via APIs
  3. 08/2021 – 03/2025

    Dual Study Program, Computer Science

    medion, Essen

    1. Android and software development
    2. Operation & Analysis
    3. Data warehouse team
    4. Operation & Analysis
    • Built and maintained ETL processes in a data warehouse environment (SAP context)
    • SQL transformations and quality checks in an Exasol environment
    • Statistical analyses of patterns and trends
    • Coding workshops for colleagues and schools
  4. 09/2021 – 03/2025

    B.Sc. Computer Science · Grade 1.4

    FOM University of Applied Sciences, Essen

    • Focus: big data & data science, artificial intelligence, database management, web technologies
    • Bachelor’s thesis on graph neural networks
Timmy Lu leaning against a wall with neon tubes, looking up

Skills

Core

  • SQL
  • Python
  • Qlik Sense / Qlik Cloud
  • Data warehouse & ETL
  • Exasol
  • SAP ERP
  • REST APIs

Analytics & ML

  • Forecasting & time series
  • Statistics
  • Data quality
  • Machine learning
  • PyTorch Geometric
  • LLM workflows

Automation

  • Python workflows
  • RPA (Automation Anywhere)
  • n8n
  • make
  • Zapier

Also

  • C# / .NET
  • TypeScript & React
  • Git
  • Jira & Confluence
  • Docker (basics)
  • Power BI (basics)

Ways of working

  • Scrum & Kanban
  • Requirements with business teams
  • Documentation
  • Workshops & teaching

Languages

  • German (native)
  • English (fluent)
  • Cantonese (basic)

Beyond data

  • Dance

    Hip-hop and urban dance – training, performances and competitions.

  • Music

    Piano since childhood, plus guitar and my own songs in FL Studio – somewhere between indie and bedroom pop.

  • Gaming

    Self-hosted game servers and mods on my own cloud VM.

Timmy as a silhouette in front of a large aquarium

Let’s talk.

I’m open to full-time roles in data analytics, BI and AI engineering – remote preferred, hybrid is open for discussion.

Timmy Lu in a corridor of light frames