Projects spanning data pipelines, data quality, warehouses, SQL tooling, and reporting.
Jun 2026 - Present
SQLTerrain is a local-first SQL workbench for semantic query analysis, cross-dialect conversion, local data profiling, and guided query building with Next.js, SQLGlot/Pyodide, and DuckDB-WASM. I tested its behavior against 10,000 Atlas benchmark cases across 12 semantic dimensions and 1,224 SQLGlot conversion tests, with explicit fallback and provenance handling.
May 2026 - Present
This local data quality platform runs against synthetic order data. It checks the warehouse, collects pipeline and lineage evidence after a failure, and prepares a report for an operator to review before approving a backfill.
Dec 2025 - Jan 2026
This stock data pipeline refreshes Yahoo Finance data and publishes new dataset versions through the Kaggle API. Full-refresh loads are idempotent, overwrites are atomic, and each run records data-quality checks in a JSON receipt.
Jun 2025 - Jul 2025
This configurable pipeline handles Yelp and weather data, including large source files and quality checks across staging, L1, and warehouse layers.
Jan 2021 - Jan 2022
Modeled raw loan-applicant records into clean warehouse tables for reporting, analysis, and dashboards.