Projects
All 12, one modernization effort. Each opens with a short summary, and every summary links to its full technical write-up. The order they were built in is part of the story, told in the bigger picture.
- Data Extraction Platform (Sluice) Replacing a nightly data job that had outgrown its original infrastructure with a purpose-built extraction platform
- Residential Client Portal Replacing spreadsheets and 11 SharePoint lists with a single system of record for residential client management
- Data Warehouse (Medallion Hub) Rebuilding a nightly data warehouse pipeline as version-controlled SQL, without a single big-bang cutover
- Job Scheduler A shared scheduling application for business-process jobs, and what three silent outages taught about keeping them alive
- Application Template Turning hard-won lessons from three production applications into a starting point for the next one
- On-Premises AI Evaluation Measuring 16 local language models against real warehouse work, on the hardware we already had
- Shared AI Skills Library One repository so a team's AI working habits stay consistent, versioned, and auditable
- Legacy Ticket Archive Keeping a decade of retired ticketing history searchable after the system itself was decommissioned
- BI Platform Upgrade Planning a major reporting platform migration as a solo administrator, with vendor documentation as the primary source
- Encrypted Backup Key Rotation Keeping a vendor's encrypted nightly database backups restorable across certificate rotations
- Internal Documentation Platform The team's documents, published where a colleague can open them
- Private AI Program (RAG, MCP) Building our own RAG on our own hardware, behind one governed MCP doorway, keeping protected health information off every cloud service