Writing

Tutorials pulled straight from what I've shipped, plus notes on the journey from accounting to data science to building systems. Drafts are actively being written — the cards tell you what's landing next.

Tutorials

12 tutorials 3 published 9 in progress

Featured

More tutorials

Automation · Finance Intermediate

Automating QuickBooks IIF Generation with Python

How I eliminated 90%+ of manual QB entry with programmatic IIF files — and the anti-duplicate checks that make it safe.

You'll build A CLI that generates valid IIF files with de-duplication
PythonpandasQuickBooks Enterprise
AI · Automation Advanced

OCR Document Intelligence: Classifying Vendor Docs at Scale

Turn a PDF folder into a searchable operational feed with OCR, classification, and auto-routing.

You'll build A pipeline that reads, classifies, and routes hundreds of docs a week
EasyOCRPythonLLM classification
Data · Backend Intermediate

From Excel to SQLite: Building a Real Operational Database

How to migrate a live Excel-driven workflow to SQLite without downtime — and why it's the right step before Postgres.

You'll build A database replacing a shared spreadsheet, with Excel still readable
SQLitePythonpandas
Reporting · Finance Intermediate

Designing Dashboards That CFOs Actually Read

Pandas + openpyxl dashboards that land on page one. The one-screen rule, and why your CFO doesn't want filters.

You'll build A CFO-grade dashboard that auto-regenerates daily
pandasopenpyxlHTML
Data · SQL Intermediate

ERP Data Migration: A SQL + Excel Playbook

Extract-validate-compare workflows for an in-flight ERP migration — when you don't own the ETL.

You'll build A repeatable reconciliation playbook and discrepancy report
SQLExcelVS Code
Web · Claude Beginner Built with Claude

Scaffolding a Full-Stack App with Claude Code

Going from empty repo to a running Node/Express/MongoDB app — the path I took for my SavvyCoders capstone.

You'll build A deploy-ready full-stack scaffold and your first CRUD route
Node.jsExpressMongoDBClaude Code

Published guides

Data · Excel Intermediate

Excel Formulas for Data Migration Validation

Advanced Excel for validating migrations — XLOOKUP, IF chains, INDEX/MATCH, and date validation.

You'll build A validation-ready Excel workflow for ERP migrations
ExcelXLOOKUPINDEX/MATCH
6 min read Apr 2025
Read tutorial
Web · Dev Tools Beginner

Updating My Site with Bolt, VS Code, and GitHub

My workflow for editing this site across Bolt, VS Code, and GitHub — with clean version control.

You'll build A clean edit-test-commit-deploy loop for a personal site
BoltVS CodeGitHub
8 min read Apr 2025
Read tutorial
Dev Tools · Git Beginner

Git Basics: Cloning a Repo and Pushing to GitHub

The essential Git commands for cloning and pushing, with step-by-step examples.

You'll build Confidence cloning repos and pushing your first commit
GitGitHub
5 min read Apr 2025
Read tutorial

Notes & essays

Shorter-form posts on the journey, projects, and what I'm learning.

8 min read 05 Dec 2023

From Accounting to Data Science: My Career Transition Journey

Career

My personal journey of transitioning from a certified accountant to a data scientist, and the lessons learned along the way.

Learn More
10 min read 03 Dec 2023

Machine Learning in Finance

Machine Learning

A practical look at how ML techniques apply to financial problems — and where traditional methods still win.

Learn More
7 min read Feb 2024

Correlation and Hypothesis Testing

Statistics

Notes on correlation measures and the hypothesis tests that go with them — from the TripleTen program.

Learn More
12 min read 20 Apr 2025

Sprint 1: Python Fundamentals Review

Programming

A deep review of Sprint 1 fundamentals from the TripleTen program — data types, control flow, and early pandas.

Learn More
5 min read 09 Jan 2025

Website Improvements — Jan 2024

Development

Recent improvements to the portfolio: enhanced project cards, contact features, and expanded about section.

Learn More
4 min read Jan 2024

Project Update — Jan 2024

Development

Where things stood on the portfolio + learning roadmap at the start of the year.

Learn More
5 min read 2025

Data Analyst Role in St. Louis

Career

Notes from landing a contract data analyst role at Keeley Companies — ERP migration, SQL at scale.

Learn More