Full Stack – Spencer Payne

End-to-end engineering work: scheduled ETL into a cloud data warehouse, a containerized web dashboard, and well-tested Python programs. Full source code lives alongside each write-up.

Automated ETL Pipelines with Apache Airflow

Data Engineering · Airflow 3, Docker, Snowflake, MongoDB

Scheduled Airflow pipelines that pull weather, stock, and SFTP data, clean it with pandas, and upsert it into Snowflake, with automatic backfill.

Portlight: Local Network Security Dashboard

Full Stack · Python, PowerShell, Docker, JavaScript

A read-only Windows network and security dashboard: a PowerShell collector feeds a hardened Docker container that serves an explainable review queue in the browser.

Python Programs with Unit Tests

CSE 111 · Programming with Functions

Python

pytest

Software Engineering

Modular Python programs built around small, testable functions, verified with pytest. Includes a chemical formula parser and a water-system pressure model.

Categories

Automated ETL Pipelines with Apache Airflow

Portlight: Local Network Security Dashboard

Python Programs with Unit Tests