The Execution Thesis
These studies examine operational problems, architectural decisions, and their trade-offs. Existing deployment outcomes are author-reported. New design studies are labelled explicitly and describe proposed systems or synthetic scenarios; their pages state the evidence and validation still required.
Sectors & Architecture Specializations
Designing an Operating Agreement for a Local AI Assistant
A proposed operating agreement for intended use, change, protective suspension, resumption and retirement, with unassigned responsibilities and explicit evidence requirements.
Designing a Material Balance for a Sorting Facility
An inspectable material account separating period flows, opening and closing stock, residue and unexplained differences, with a synthetic offline reference.
Designing a Review Queue for Missing and Stale Observations
Distinguishing zero, absent, stale, suspect and late telemetry at a declared decision boundary, with an offline synthetic classification reference.
Designing a Recovery Rehearsal for a Local Knowledge Assistant
A proposed method for restoring compatible model, retrieval, permissions and application releases, with explicit readiness evidence and unexecuted rehearsal scenarios.
Designing a Queue Test for a Shared Local AI Service
A proposed comparison of bounded admission policies that keeps planned arrivals, actual dispatch, completed latency and unmet demand visible under the same declared conditions.
Designing a Service-Request Agent That Can Stop Safely
A proposed maintenance-intake workflow that preserves unresolved submissions, checks replay contracts, survives restart without resetting its budget, and hands off with evidence.
Designing Retrieval for Permissions That Change
A proposed permission-aware retrieval flow and twelve synthetic evaluation scenarios covering tenant boundaries, cached answers, source links, failures, and revocation.
Designing a Collection Ledger That Can Explain Its Numbers
A proposed collection ledger that holds its denominator steady, keeps duplicate and corrected reports traceable, and reconstructs what a supervisor could know at a chosen reporting cutoff.
Designing a Fair Test for a Local AI Service
A proposed evaluation for a local knowledge assistant: separate answer quality from serving capacity, control cache conditions, preserve failures, and define the evidence required for a release decision.
Designing Waste Intelligence Before Field Data Arrives
A design study for connecting collection coverage, segregation quality, vehicle reliability, and material recovery in one operational model. It explains how synthetic scenarios can test decisions before authorised field data becomes available.
1,000-Store Agricultural Input ERP & Offline-First POS Edge Synchronization
Architected an offline-first distributed ERP synchronization engine connecting 1,000 rural agricultural supply stores across regional hubs. Over three years prior to modernization, the client documented an estimated $4.2M in cumulative inventory discrepancies; our embedded encrypted SQLite edge nodes, transactional outbox queueing, and idempotent cloud reconciliation eliminated terminal outages and transaction loss.
Statewide Public Health Outbreak Surveillance & Telemetry Stream Engine
Engineered a privacy-preserving stream analytics engine ingesting high-velocity syndromic and pharmaceutical telemetry across 10,000+ public health clinics. Based on post-incident pilot evaluations, compressed administrative outbreak detection turnaround from 10-14 days down to under 72 hours.
Industrial Manufacturing ERP Modernization & Decoupled Architecture
Engineered an incremental Strangler Fig migration to decouple a 24/7 continuous manufacturing monolithic ERP. Extracted bill-of-materials (BOM), batch scheduling, multi-warehouse inventory, and financial accounting into asynchronous cloud microservices with zero production interruption.
Delivery & Architectural Methodology
Strangler Fig Migration
Iterative, zero-downtime legacy replacement capturing database WAL events via CDC to guarantee continuous business operations.
Offline-First Outbox Sync
Embedded SQLite edge engines with local transactional outbox queues that sync asynchronously and idempotently over unstable networks.
Cryptographic Enforcement
SHA-256 previous-hash chaining, ECDSA digital signatures, and strict UBL 2.1 Schematron validation at the database boundary.