Arslan Rehmani
Case Studies • Truth Gate Enforced

Systems Built for Operations That Cannot Afford Failure.

Detailed engineering breakdowns of real systems running in production. Each case study documents the client context, the real problem in their words, constraints, SVG architecture diagrams, security design, and what I would do differently.

Study 01•Textile Manufacturing

From Paper Shift Registers to an Audited Double-Entry ERP

A 27-loom textile manufacturing mill was losing visibility across yarn lots, machine allocations, and piece-rate wages across paper logs and disconnected Excel sheets.

Next.jsPostgreSQLTailwind CSSVercel
Verified Production Metrics
Looms Managed27 looms
Manual Work40+ hours
Production Uptime10+ months
Timeline: 8 weeks to live production cutover
Study 02•Finance & Accounting

Deterministic Bank-to-Ledger Matching Suite

Month-end accounting close required 3 full days of manual transcription and vlookups between CSV bank feeds and purchase invoices.

TypeScriptPostgreSQLBanking APIsDocker
Verified Production Metrics
Close Timeline3 days → 45 min
Auto-Match Rate98% auto-match
Corrupted Rows0 rows
Timeline: 4 weeks staged deployment
Study 03•Multi-Channel Ecommerce

Unified 4-Channel Operational Control Platform

Four disconnected dashboards (Shopify, Amazon, GA4, GSC) forced operators to waste hours manually compiling spreadsheets to spot stockouts and ad drag.

Next.jsShopify APIAmazon SP-APISupabase
Verified Production Metrics
Integrated Channels4 channels
Briefing ScheduleDaily 07:00
Audit Trail100% Webhook Audited
Timeline: 6 weeks
Study 04•Automated Processing Architecture

Failsafe LLM Data Staging Before Database Commit

LLMs are inherently probabilistic. Allowing them to write directly to production ledgers risks silent schema errors, bad dates, and invalid mathematical totals.

PythonPydanticPostgreSQL RLSFastAPI
Verified Production Metrics
Eval Suite Pass Rate99.4% eval pass
Run Cost$0.008 / 100 lines
Dirty Rows Committed0 rows
Timeline: 3 weeks add-on module

Have an operation running on fragile spreadsheets?

Book a 20-minute discovery call to map out a fixed-scope data audit or build.

Book a 20-minute discovery call