▌ERICK TI/ swe

// project index

Selected work.

Production systems and personal builds, filterable by discipline.

01CelLinkProductionShipped
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/moruntime cost
The Millennium "Vault" landing page: a trading-card collection appraised like a financial portfolio, anchored by a live foil appraisal card.
02PublicShipped
Product / Full-Stack

Millennium

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

  • 10Django apps
  • 14typed React screens
  • 821automated 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.
03PublicShipped
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-nativeCLAP embeddings
  • 4-axisfused re-rank score
  • 8 genreslive interactive demo
  • Python
  • FastAPI
  • LAION-CLAP
  • pgvector
  • PostgreSQL
View case study →
04CelLinkProductionShipped
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 →
05CelLinkProductionShipped
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 →
06CelLinkProductionShipped
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.5squery latency
  • 22×faster
  • 1.8M+records reconciled
  • SQL Server
  • T-SQL
  • Recursive CTEs
  • Syspro ERP
View case study →
07ConceptShipped
Developer Tools

Agentic Dev Environment

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

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