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
Getting OAuth2 working in VBA, where the language has no built-in support for it, to pull Xero data into Excel.
How to Scrape and Analyze Instagram Engagements Data
Scraping public Instagram engagement data with Instagrapi in Python, then comparing influencer performance with confidence intervals.
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
Cleaning 3.5 million bike trips in SQL: deduplication, standardization, and validation, with the queries alongside each step.
Full archive on Medium