Projects

Systems built to solve real problems.

My project work spans data platforms, enterprise systems, and independent software products. Northstar provides a completely public view into my data-engineering approach, while ShimStack demonstrates product architecture and application development from initial concept through implementation.

Flagship Data ProjectIn Active Development

Northstar Data Platform

A production-style AWS data engineering platform built around a synthetic outdoor-retail company. The project demonstrates the complete lifecycle of a modern data platform rather than isolated tutorials or disconnected service demos.

Explore Northstar View GitHub Repository

Platform Scope

Batch, API, database CDC, and streaming ingestion
S3 raw, quarantine, and curated data layers
Glue, PySpark, Athena, Redshift, and dbt
Apache Iceberg lakehouse implementation
Orchestration, data quality, and observability
Terraform, Docker, CI/CD, IAM, and security
Public portfolio evidence and controlled live demo access

Independent Software

Product engineering beyond the data platform

Independent ProductIn Active Development

ShimStack

An offline-first field-service application designed for owner-operators and small service businesses. ShimStack connects estimating, jobs, visits, scheduling, materials, purchasing, expenses, payments, and business financial planning in one operational workflow.

React Native
TypeScript
Expo
Expo Router
SQLite
Mobile Application Architecture
Offline-First Design

Engineering Highlights

Designed the product architecture and end-to-end field-service workflows
Built with React Native, Expo Router, TypeScript, and local SQLite storage
Designed around offline-first, single-device reliability
Connects estimates, jobs, visits, work progress, materials, purchasing, and financial tracking
Includes cash-bucket planning for taxes, overhead, reserves, and profit
Supports field workflows such as scheduling, time tracking, mileage, photos, receipts, inventory, and purchasing
Designed for eventual commercial distribution through mobile app stores

Professional Work

Selected systems from my professional experience

These systems were developed in professional environments, so proprietary source code and client data are not published here. The descriptions focus on my role, engineering responsibilities, and the problems the systems addressed.

Professional SystemPrimary Architect & Engineer

Nessie

An automated analytics, reporting, diagnostic, and data-quality platform built to support ERP consulting engagements across financial, project-performance, operational, and compliance use cases.

Automated recurring analytics and validation work
Supported investigation of complex ERP data issues
Combined SQL, Python, PowerShell, REST APIs, and reusable tooling
Contributed to automation that saved hundreds of consultant hours annually

SQL
Python
PowerShell
REST APIs
Data Quality

Professional SystemProduct Owner & Developer

Centralist

A centralized marketing data application built on Ellucian Banner data to generate, manage, and deliver institutional marketing audiences and reporting datasets.

Built primarily with Oracle PL/SQL and Python
Operated on complex Ellucian Banner relational data
Supported marketing analytics and audience-generation workflows
Required SQL optimization, integration, validation, and production support

Oracle PL/SQL
Python
Ellucian Banner
SQL
ETL

Different systems, same engineering approach

Whether the problem is a cloud data platform, an ERP migration, an analytics system, or a mobile field-service product, my approach is consistent: understand the domain, model the workflow, make the system reliable, handle edge cases deliberately, and keep the architecture understandable.