Case Studies

Explore detailed case studies that showcase my expertise and approach to solving real-world problems with technology.

PostGIS in Action: Streamlining Fleet Operations with Geospatial Precision

Integrated PostGIS extension for PostgreSQL to optimize technician dispatch by leveraging pre-existing location data for efficient, scalable geospatial queries.

PostgreSQLPostGISGeospatialFleet ManagementOptimization

Case StudyRead Case Study

Data-Driven SEO: From Quarterly Audit to Custom Tooling and AI Agent Workflows

Built coffey.codes a repeatable SEO operation from scratch: quantitative audits via Search Console MCP, structured-data hardening across every page, a four-engine custom snapshot pipeline (GSC, GA4, Bing, Google Ads), and AI agent workflows that produce editorial reports on demand.

SEOGoogle Search ConsoleGA4Bing Webmaster ToolsGoogle Ads APIMCPClaude CodeStructured DataJSON-LDNode.js

Case StudyRead Case Study