▌ ERICK TI / swe

// project index

Selected work.

Production systems and personal builds, filterable by discipline.

01 CelLink Production Shipped
AI Systems

OTIS: Teams AI Assistant

A natural-language interface that lets non-technical staff query production databases and locate documents without leaving Microsoft Teams.

  • Python
  • FastAPI
  • Anthropic SDK
  • M365 Agents SDK
  • SQL Server
View case study →
80% fewer ad-hoc data requests
  • 500+ staff served
  • ~$115/mo runtime cost
The Millennium "Vault" landing page: a trading-card collection appraised like a financial portfolio, anchored by a live foil appraisal card.
02 Public Shipped
Product / Full-Stack

Millennium

A full-stack collection tracker for trading-card players: catalog, pricing, and deck data in one typed, containerized app.

  • 10 Django apps
  • 14 typed React screens
  • 821 automated tests
  • Django
  • Django REST Framework
  • PostgreSQL
  • Celery
  • Next.js
View case study →
The Doppel landing page: an audio-native song recommender with a replay console and a cultural-vs-audio convergence view.
03 Public Shipped
AI Systems

Audio-Native Song Recommender

A music recommendation engine built on audio embeddings. It listens to the song itself, not just its metadata.

  • Audio-native CLAP embeddings
  • 4-axis fused re-rank score
  • 8 genres live interactive demo
  • Python
  • FastAPI
  • LAION-CLAP
  • pgvector
  • PostgreSQL
View case study →
04 CelLink Production Shipped
Product / Full-Stack

CelLink Internal Tooling Platform

Fifteen-plus production internal tools for validation, reporting, and ETL, owned end to end across two sites.

  • 15+ production tools
  • 500+ users
  • 99.9% uptime
  • Python
  • FastAPI
  • C# / .NET
  • SQL Server
  • Apache NiFi
View case study →
05 CelLink Production Shipped
Data & Operations

Real-Time Telemetry Platform

Real-time telemetry at scale: 20+ event-driven ETL pipelines feeding 30+ code-generated dashboards, on a Kubernetes cluster built to stay up.

  • 30+ live dashboards
  • 20+ ETL pipelines
  • 50k+ records / day
  • Python
  • C# / .NET
  • AWS Timestream
  • MinIO
  • Kubernetes (K3s)
View case study →
06 CelLink Production Shipped
Data & Operations

Serial Traceability Engine

A recursive traceability layer over an ERP database, plus a stored-procedure rewrite that cut a key query from 11 seconds to under 500ms.

  • 11s → 0.5s query latency
  • 22× faster
  • 1.8M+ records reconciled
  • SQL Server
  • T-SQL
  • Recursive CTEs
  • Syspro ERP
View case study →
07 Concept Shipped
Developer Tools

Agentic Dev Environment

A reproducible, AI-augmented development setup: version-controlled dotfiles, custom Claude Code commands, and a multi-model workflow.

  • 6 custom Claude Code commands
  • Reproducible fresh-machine bootstrap
  • Multi-model Claude + Codex workflow
  • Claude Code
  • Bash
  • Git
  • Ghostty
  • macOS
View case study →