Return to Project Vault

Software Architect & Full-Stack Developer | SASO (2021)

Executive Summary

Architected and engineered a nationwide vehicle inspection and modification scheduling platform for the Saudi Ministry of Standards, Metrology and Quality (SASO). Delivered across three phases over three years (initial architecture, performance optimization, and headless React migration), the system resolved distributed concurrency collisions across the public web portal, state internal administration, and mobile apps competing for 15-minute inspection slots.

1. Context & Problem

  • ->Client / Domain: Saudi Ministry of Standards, Metrology and Quality (SASO)
  • ->Timeline: 2021-2024
  • ->Project Role: Software Architect & Full-Stack Developer

//The Challenge

Multi-lane vehicle testing centers across Saudi Arabia operated on rigid 15-minute appointment windows. Three independent client channels (public citizens, internal ministry staff, and mobile app users) simultaneously contested the same real-time inventory, causing booking collisions, abandoned reservation locks, and database query contention during peak business hours. Direct production access was restricted due to federal security policies.

2. Technical Stack & Systems Infrastructure

  • ->Application Framework: Drupal 8/9 backend exposing versioned REST APIs to a decoupled React frontend.
  • ->Database Architecture: MySQL combining 3NF transactional schemas with denormalized Star Schema analytical structures.
  • ->Pre-Production Testing: Synthetic load testing and environment-agnostic validation in pre-production staging environments.

3. Architectural Decisions & Engineering Challenges

  • ->Distributed State Locking & Timeout Recycling: Built a deferred reservation lock protocol that committed inventory only upon the final submission step. Implemented an automated 5-minute inactivity TTL window that recycled uncommitted reservations back to the national pool, preventing inventory lockups.
  • ->Hybrid Data Layer (3NF & Star Schema): Enforced strict 3NF database normalization on core booking tables to preserve ACID transaction safety, while creating denormalized Star Schema tables for read-heavy availability calendars to reduce query response times.
  • ->Decoupled Headless Migration: Migrated frontend interfaces to React, decoupling UI deployment lifecycles from backend business logic and providing reusable API contracts for mobile and state consumers.
  • ->Proxy Delegation Authorization: Engineered an authorization layer allowing vehicle owners to legally delegate physical inspection visits to third-party drivers while maintaining statutory compliance and owner accountability.

4. Operational & Institutional Impact

  • ->Collision-Free Concurrency: Eliminated race condition booking collisions across all three client channels.
  • ->Capacity Recovery: Recovered 100% of abandoned 15-minute reservation slots through deterministic 5-minute TTL recycling.
  • ->Query Latency: Reduced availability calendar query latency to sub-second response times under peak national concurrent load.
  • ->Deployment Stability: Achieved zero-regression handoffs to production through strict pre-production simulation and static analysis pipelines.