Projects
Here are some of the side projects I've worked on over the years.
Downwinder: Hudson River Surf Forecast
- Description: An automated system that fetches wind and tide data to forecast surfable wave conditions on the Hudson River. The forecasts are published to a Google Sheet.
- Technologies: Python, Docker, PostgreSQL, OpenWeatherMap API, NOAA Tides & Currents API, Google Sheets API.
- Status: Active (GSheet link).
- Read more about the Downwinder project »
NYC 3K Finder
- Description: A web app to help parents find NYC's 3K (early childhood education) programs. It uses scraped public data, address geocoding, and distance calculations to display nearby schools and a child's admission likelihood.
- Technologies: Python (Django), Docker, Photon API (address autocomplete), Nominatim API (geocoding).
- Status: Active (NYC3K.com).
- Read more about the NYC 3K Finder project »
Snowquery: R Package for Database Querying
- Description: An R package to simplify running SQL queries on Snowflake, Redshift, and PostgreSQL. It leverages the Snowflake Python connector under the hood for robust Snowflake access. It allows easy data querying directly from R scripts without complex setup.
- Technologies: R, Python, reticulate, DBI, RPostgres, Snowflake Python Connector.
- Status: Active (CRAN, GitHub, Website).
- Read more about the Snowquery project »
Simple dbt Runner: Self-Host dbt with GitHub Actions
- Description: An open-source project with GitHub Actions workflows to run dbt in production. I was the lead contributor, we built a cost-effective alternative to dbt Cloud for self-hosting dbt orchestration, CI/CD, and documentation.
- Technologies: dbt, GitHub Actions, Python, YAML, Shell.
- Status: Active, Open-Source (GitHub).
- Read more about the Simple dbt Runner project »