Case Studies

A small selection of focused, outcome-driven work across regulated and high-scale systems.

Zero-Downtime Enterprise Data Migrations

The Context

A multi-tenant betting platform operating under strict UK Gambling Commission (UKGC) and PCI-DSS regulations needed to scale their client onboarding process.

The Problem

Onboarding new clients involved migrating massive, complex third-party datasets into the platform. The process was slow, highly manual, and error-prone, creating a bottleneck for growth and risking compliance breaches.

What I Built

I architected and engineered a unified data import pipeline capable of normalizing and safely migrating millions of records across tenant-specific databases.

Stack

PHP, Laravel, Docker, MySQL.

Architecture

Designed a tenant-aware migration system that isolated client data while using a shared core codebase to ensure maintainability.

The Business Result

  • Zero downtime: migrated legacy datasets without interrupting live betting operations.
  • Accelerated growth: drastically reduced time to onboard new enterprise clients.
  • Compliance secured: built to UKGC audit standards with strong data integrity.

AWS Cloud Infrastructure & Event-Driven Microservices

The Context

An enterprise tech team needed to transition a legacy Point of Interest (POI) management tool into a centralized, single-source-of-truth microservice within a wider AWS ecosystem.

The Problem

The existing workflow was highly convoluted and developer-dependent. Updating POI data required a developer to download a local service, manually export SQL, and run imports across four separate environments (Dev, Test, UAT, Live). It was slow, risky, and blocked admin teams from making simple GUI updates.

What I Built

I engineered and deployed the new AWS-native microservice infrastructure using Infrastructure-as-Code.

Stack

Terraform, AWS Lambda, AWS EventBridge, AWS RDS/MySQL.

Architecture

Provisioned the Lambda application and database instances. Configured an AWS Event Bus and routing rules so the new service could broadcast state changes, allowing other microservices to automatically consume events and update their local states.

The Business Result

  • Eliminated Manual Ops: Completely removed the need for developer-led SQL imports across environments.
  • Enabled GUI Updates: The new microservice API allowed admin staff to update POI data directly via a user interface, drastically reducing development overhead.
  • Seamless Deployment: Successfully delivered the infrastructure into production, aligning perfectly with internal architecture conventions.

Architecting a Multi-Tenant B2B SaaS Platform

The Context

A digital agency wanted to build and launch a greenfield B2B SaaS appointment booking platform to digitize local businesses and generate recurring revenue.

The Problem

The project required a highly scalable architecture built completely from scratch. It needed to support isolated client data, cross-application user authentication, and a scalable cloud infrastructure plan to handle future traffic, alongside the ability to deploy native mobile apps quickly.

What I Built

I translated the director's business vision into a complete technical roadmap and architected the full-stack solution.

Stack

PHP, Laravel, MySQL, Ionic, Angular, AWS (EC2, Load Balancing).

Architecture

Designed a Laravel API utilizing a database-per-tenant structure for strict data isolation, paired with a centralized user table to allow seamless logins across the ecosystem.

The Business Result

  • Built for Scale: Devised and documented an AWS scaling strategy (EC2 instances, dedicated DBs, and Load Balancers) to ensure the platform could grow with client acquisition.
  • Lucrative Upsell Pipeline: Engineered a white-label Ionic hybrid app, enabling the agency to deploy standard web portals while successfully upselling native iOS and Android applications to clients.
  • Successful Delivery: Navigated changing pandemic requirements to successfully deliver, test, and deploy a market-ready SaaS product.

Ready to start a project? Email me.

Based in the UK | Available for new contract projects immediately (remote).

Built with Gatsby + Tailwind | © 2026 Sam Rook | LinkedIn / GitHub