Work
A selection of problems I've worked on and how I approached them. Names and identifying details are omitted by default — if a client has agreed to be named, they are.
Trustpilot Review Intelligence — Automated Sentiment Analysis & Daily Digest
Built an automated pipeline that pulls the previous day’s Trustpilot reviews each morning, runs sentiment analysis and entity extraction to identify which team member or store location each review references, then compiles and delivers a structured digest to senior leadership via email. No manual reading, no missed feedback, no spreadsheet in between. Built on Make.com, SendGrid, and BigQuery — data retained for trend analysis over time.
Service
The Operating Layer
Tags
Real-Time Retail Reporting — Looker Studio Dashboard on BigQuery via Fivetran
Built a real-time reporting layer for a retail business — Fivetran pipelines pulling data from Shopify, ops systems, and finance into a BigQuery data warehouse, surfaced through Looker Studio dashboards for leadership and department heads. Replaced a patchwork of exported spreadsheets and end-of-day manual reports with live data accessible to the right people at the right time. Trading, stock, fulfilment, and finance visible in one place.
Service
Shopify & Systems Integration
Tags
AI Product Visualiser — “See It In Your Home” Sofa Configurator
Built an AI-powered product visualiser allowing customers to see selected sofas placed in their own room — live on the Shopify storefront and available as a showroom tool for in-store staff. Customers upload a photo of their room; the system generates a realistic image of the chosen sofa in that space. Built on AWS API Gateway, Lambda, and DynamoDB — with image generation via the OpenAI API. Reduced purchase hesitation for high-consideration furniture decisions.
Service
Shopify & Systems Integration
Tags
Parts Traceability — UUID Generation & RFID Tagging for Furniture Components
Designed and implemented a UUID-based parts identification system for furniture components and warehouse stock items, with RFID tags as the physical layer. Each part receives a UUID at the point of creation — generated deterministically from product, batch, and variant attributes — and tagged for scanning throughout the warehouse and assembly process. No central management system required; the ID is self-describing. Gave the business reliable part-level traceability for the first time.
Service
Architecture Clarity Sprint
Tags
Server-Side Tracking & Consent Management Implementation
Implemented server-side tracking and a consent management platform for a Shopify-based retail business — moving analytics and marketing pixel data collection off the browser and onto a server-side layer. Restored tracking accuracy lost to ad blockers and browser privacy restrictions, brought the business into proper consent compliance, and gave the marketing team reliable attribution data for the first time in two years.
Service
Shopify & Systems Integration
Tags
Internal Returns Management Tool — Logging Returns and Outcomes
Built an internal returns management tool to replace an informal, inconsistent process for logging customer returns and recording their outcomes. Previously, returns were tracked across inboxes, spreadsheets, and verbal handoffs — with no reliable record of what was returned, why, or what happened to it. The tool gave the ops team a single place to log each return, capture the reason and condition, and record the outcome: resale, disposal, return to supplier, or credit issued. Clean data meant the business could, for the first time, see return rates by product, reason, and period.
Service
The Operating Layer
Tags
Live Container Tracking — ShipsGo API Integration in Airtable
Integrated ShipsGo’s container tracking API directly into the buying team’s Airtable workspace, giving them live ETA and delay visibility on inbound shipments without leaving the tool they already worked in. Previously, tracking meant logging into carrier portals individually, cross-referencing manually, and chasing freight forwarders for updates. The integration surfaces vessel position, estimated arrival, and delay flags automatically against each purchase order — so the buying team knows immediately when a shipment is running late and can act on it.
Service
The Operating Layer
Tags
Product Master — Cylindo Image Integration for Internal Merchandising
Integrated Cylindo’s product image API into the business’s internal Product Master — an Airtable-based merchandising tool holding the canonical product record for the range. Previously, product images existed in Cylindo but were disconnected from the operational product data the merchandising team worked with daily. The integration pulls rendered product images directly into the relevant Airtable record, giving merchandisers a single view of product data and imagery in one place — without leaving the tool or hunting across systems.
Service
The Operating Layer
Tags
Interested in working together?
No pitch, no deck — just a conversation about what you're trying to fix and whether I can help.