Work
A selection of problems I've worked on, detailed deep dives, and specific client outcomes.
Modernising
Audio Medica
Replaced a sluggish WordPress CMS with a modern Next.js publishing application: custom tailored headless Sanity studio, Google Gemini AI clinical content curation pipeline, sub-50ms Algolia search, and a site-wide persistent audio player.
AI Content Curation
Gemini AI · Resend · Vercel
Launching
Saving Strays
Built a brand-new Shopify eCommerce storefront for a UK animal rescue charity: customized theme design, recurring dog sponsorships, and a zero-touch Zapier certificate automation pipeline.
Zapier Automation
Zapier · Brevo · DNS
Systems & Operations
A comprehensive record of custom infrastructure solutions, Shopify integration layers, reporting data stacks, and automation built to eliminate operational friction.
Shopify Plus + ERP Integration — Furniture Retailer
Designed and governed the integration between a Shopify Plus storefront and a custom-built ERP covering 14,000+ SKUs — order sync, stock reservation, fulfilment events, financial reconciliation, and returns processing. Replaced a daily manual reconciliation process with an automated event pipeline.
Service
Shopify & Systems Integration
Real-Time Retail Reporting — Fivetran + BigQuery + Looker Studio
Replaced a daily manual export process with a live data stack: Fivetran pulling from Shopify and ops systems into BigQuery, surfaced through Looker Studio dashboards covering trading, stock, fulfilment, and finance. Leadership went from yesterday’s numbers to live data, accessible from any device.
Service
Retail Data Foundations
Buying Operations — Airtable System Design
Replaced four overlapping spreadsheets and a shared inbox with a unified Airtable system managing buying, supplier relationships, purchase orders, and merchandising workflows. Single source of truth for the buying team for the first time.
Service
The Operating Layer
Daily Reporting Automation
Automated the generation and distribution of daily trading reports — sales, stock, and fulfilment — delivered to senior leadership at 8am. Replaced a process that took 45 minutes of manual export and formatting each morning. Built on BigQuery + Make + Google Sheets.
Service
The Operating Layer
Trustpilot Review Intelligence
Automated pipeline pulling previous day’s Trustpilot reviews, running sentiment analysis and entity extraction to identify which team member or store location each review references, and delivering a structured digest to senior leadership via email. Built on Make.com, SendGrid, and BigQuery — data retained for trend analysis over time.
Service
The Operating Layer / AI
SofaVision — AI Product Visualiser
Customer-facing tool allowing shoppers to upload a photo of their room and see a selected sofa placed within it — live on Shopify and available as an in-store tool for sales staff. Built on AWS API Gateway, Lambda, DynamoDB, and the OpenAI image generation API.
Service
AI / Shopify
Live Container Tracking — ShipsGo API in Airtable
Integrated ShipsGo’s container tracking API into the buying team’s Airtable workspace — live ETAs, vessel position, and delay flags surfaced automatically against each purchase order. Replaced a manual process of logging into carrier portals and chasing freight forwarders for updates.
Service
The Operating Layer
UUID + RFID Parts Traceability
Designed and implemented a UUID-based identification system for furniture components and warehouse stock items, with RFID tags as the physical layer. IDs are generated deterministically from product attributes — no central management system required. Gave the business reliable part-level traceability through warehouse, assembly, and dispatch for the first time.
Service
Architecture / Infrastructure
Server-Side Tracking & Consent Management
Moved analytics and marketing pixel data collection off the browser and onto a server-side layer — restoring tracking accuracy lost to ad blockers and browser privacy restrictions, and bringing the business into proper consent compliance. Reliable attribution data for the marketing team for the first time in two years.
Service
Infrastructure / Analytics
Internal Returns Management Tool
Structured returns logging tool replacing an informal process split across inboxes and a shared spreadsheet. Captures return reason, product condition, and outcome (resale, disposal, return to supplier, credit). Made return rate by product and reason visible for the first time — a direct input into buying decisions.
Service
The Operating Layer
Product Master — Cylindo Image Integration
Integrated Cylindo’s product image API into the business’s internal Airtable Product Master — pulling rendered product images directly into the relevant product record. Gave the merchandising team a single view of product data and imagery without leaving the tool or retrieving images manually.
Service
The Operating Layer / Data
Interested in working together?
No pitch, no deck — just a conversation about what you're trying to fix and whether I can help.