kris_gamble
PROVED IN PRODUCTIONARCHITECTURE & ANALYTICS

case studies

A breakdown of system architectures, data pipelines, and subscription infrastructure built for Road Ninja and Log Ninja.


CASE STUDY 01

log ninja

DRIVER LOGBOOKS · DUAL-STREAM SUBSCRIPTIONS · AI-AUGMENTED ANALYTICS

PRODUCTION LIVE
SUBSCRIPTION STREAMS2Stripe (B2B) & RevenueCat (B2C)
DATA VALIDATION100%Runaway log timer filtering (<= 24h)
REPORTING PIPELINEAGENTICAutonomous SQL & CSV exports

The Problem & System Architecture

Log Ninja tracks legal work-time logs for commercial vehicle drivers in New Zealand. The platform needed a unified financial overview that could bridge two completely separate subscription engines: enterprise seats billed via Stripe, and individual driver mobile subscriptions billed via RevenueCat (iOS App Store & Google Play).

SYSTEM DATA PIPELINE RULES
[RULE 01]Calculate work duration from `Logs.totalWorkTime` directly (in seconds), never unfinalized `EventLogs`.
[RULE 02]Enforce hard boundary filter: `WHERE totalWorkTime <= 86400` to eliminate finalized runaway timers.
[RULE 03]Map driver billing events (Annual, Quarterly, Monthly) across iOS and Android into unified MRR reporting.

Key Outcomes

  • Architected autonomous AI skill routines to query live databases for daily subscriber snapshots, trial conversions, and cancellation cohorts.
  • Built offline revenue dashboards combining company seats with individual app subscriptions.
  • Engineered cross-platform driver overlap matching (Road Ninja ↔ Log Ninja) using driver licence numbers.

CASE STUDY 02

road ninja

FLEET COMPLIANCE · DRIVER RECRUITMENT · REAL-TIME MATCHING

PRODUCTION LIVE
PRIMARY DOMAINFLEETCommercial driver compliance
USER ROLESMULTIDrivers, Operators, Companies
DATABASE ENGINEMySQLRelational database infrastructure

Engineering & Product Leadership

Road Ninja connects qualified commercial drivers with transport operators needing certified drivers. The platform requires strict adherence to driver licence classes, endorsement verification, and location-radius filtering.

My Responsibilities

  • Architecting multi-role data structures for driver onboarding, company signups, and active trip assignments.
  • Configuring MCP tooling (Firecrawl, MySQL integrations) to automate business intelligence and market analysis.
  • Directing design tokens and brand consistency across web and mobile surfaces using strict design system guidelines.

Want to test how my AI answers technical questions about these systems?