Application notes
The long-form version of the work: data analysis and automation, written up as I go. The same pieces live on Medium; these copies stay here.
Why SFTP Still Rules the Finance World
Why legacy SFTP connections remain the backbone of bulk data exchange in B2B finance, and what building treasury software taught me about respecting boring tools.
From Accountant to Software Engineer
How I went from Big Four accounting to a remote software engineering role, and the faith that carried me through two years of rejections.
Navigating OAuth2 Authentication in VBA
A practical walkthrough of implementing OAuth2 authentication in VBA to connect Excel with the Xero API.
How to Scrape and Analyze Instagram Engagements Data
A walkthrough of scraping public Instagram engagement data with the Instagrapi library in Python and analyzing it to compare influencer performance.
Customer Data Analysis Using Python — Google's Capstone Project
An exploratory analysis of a bike-sharing company dataset in Python, using visualizations to uncover rider behavior and recommend marketing strategies.
Data Cleaning with SQL — Google's Capstone Project
A step by step SQL walkthrough for cleaning a bike trip dataset, covering deduplication, standardization, and validation of real world data.
Full archive on Medium