Skip to content
Kwun Chen · Data Science
Kwun Chen

Data Science + Statistics at UC Berkeley. I build pipelines that make noisy data usable.

C:\Users\Kwun\Projects

Projects

Pipelines and tools I’ve built on my own time. Each one has a write-up on how it works.

slack_the_tape.py
Electronic stock ticker boards showing bid, offer and last prices in red and green LEDs

Slack the Tape

In progress

An LLM assistant that lets anyone ask questions about market data in Slack

A cron-scheduled ETL pipeline lands 1-minute equity bars in date-partitioned Parquet, and an MCP server lets a Slack chatbot query it in plain English.

  • Python
  • DuckDB
  • SQL
  • MCP
  • Slack
  • Linux
adsb_pipeline.py
Three F-15 Eagles flying in formation against a pale sky

Military Aircraft Activity Pipeline

Complete

Live ADS-B telemetry turned into clean, analysis-ready flight features

An end-to-end pipeline that pulls a live global ADS-B feed, validates every record with Pydantic, derives flight-activity features in Polars, and warehouses the results in DuckDB.

  • Python
  • Polars
  • Pydantic
  • DuckDB
  • Prefect