Projects

Things I built, at work and at home. Some by hand in VBA, most by directing AI.

Indian Motors · Excel and VBA

A product-data system in a spreadsheet

The ERP didn't give a single view of each product, and barcodes were typed by hand. I built a system in Excel, VBA and Power Query, alone, that generated 20,000 barcodes, tracked real stock and checked data for errors before it reached the catalog and the ERP. I wrote every line of the VBA myself.

Indian Motors · Online catalog

An online catalog with live stock

I proposed Publitas, negotiated the contract and launched it: an online catalog with live stock and prices connected to the ERP. Order volume went up 35%.

Indian Motors · Documentation

195 guides before I left

Ten years of systems and processes, written down in 195 guides, plus an onboarding plan for the person taking over. Nothing should depend on one person.

Personal · AI and data

ERP data extraction

Moved a legacy ERP into a 2.2 GB SQLite database and built an executive sales report from 2014 on. See the diagram.

Personal · AI

A library of AI skills

73 reusable skills in my own GitHub repository: instructions that teach an AI agent how to do one job well. I use them every day.

Web

Website for an accounting practice

A React site built with AI, Google Ads setup, and an accessibility, SEO and security audit with the fixes applied.

Home · Infrastructure

A home server

A Proxmox homelab with its own documentation wiki. I tested recovery for real: 29,405 photos restored and checked.

Home · AI

PhotoRestorer

A tool that restores old photos with an AI model running locally on my own computer.