Case Study 001
Eliminated 12-Hour Sync Delay in Order Fulfillment Pipeline
- Before: Manual reconciliation between Trello (orders) and Sheets (production)
- After: Live sync — each order auto-updates with built quantity, delivery risk, progress rate
- Alert: Triggers if production pace falls behind deadline
- Built in: 72 hours | Trello API + Google Apps Script | No third-party tools | No training | No middleware
- Result: 0 hr lag | "Walmart order — 50,000 needed, 12,400 built, 4 days remaining"
Case Study 002
Engineered Zero-Error Worker Logging for Multilingual, Non-Literate Factory Floor
- Before: Cyrillic names misspelled → data lost → payroll errors
- After: Case-insensitive login across Latin & Cyrillic scripts | Real-time misspelling detector — flags at point of entry | One clean dashboard row per subtask, automatically split
- Form logic: 4 inputs max | plus/minus counter (no typing) | conditional branching
- Result: 100% data capture | zero training needed | same-day adoption
Case Study 003
Replaced Paper-Based Delivery Ledger with Live Inventory Immune System
- Before: Wood logs from Belarus tracked on paper — no alerts, no history
- After: Supervisor logs delivery in <30s → auto stock update | Auto deduct wood as pallets built | Low-stock email alert triggers immediately at threshold
- Records: Full delivery history — supplier, country, quantity, date
- Result: Owner receives alerts from anywhere | 11% variance → near zero
Case Study 004
Built Self-Rolling Daily Intelligence — No Manual Report Ever Needed
- Before: 58 mins/day compiling daily summary
- After: Auto-sent email at 5:30 PM — covers output, labor, inventory, variances | Embedded in existing system — no new interface
- Built in: 16 hours
- Result: 100% compliance | zero manual input | runs unattended
Case Study 005
Reconstructed Payroll Logic to Handle Variable Subtask-Based Compensation
- Before: Workers paid lump sum — subtask data buried in merged entries
- After: Each subtask tracked individually | Correct rate applied automatically based on type | One worker, multiple subtasks — split into clean rows
- Result: Accurate pay per task | audit-ready | no rework
- Ownership: Full control — no access granted
Case Study 006
Designed the Factory's First Remote Command Layer
- Before: Owner blind during travel — no visibility into payroll, production, stock
- After: Full dashboard accessible from any phone browser | Daily email summary auto-sent — no input required | Low-stock alert fires same moment threshold is hit | On-site supervisors log deliveries — zero dependency on owner | History filterable by date — review any day from London or Lagos
- Result: Owner runs operations from any country — zero maintenance needed
Case Study 007
Built a Cross-Supplier Audit System Inside the Live Factory Dashboard
- Before: Disputes over deliveries — no trail of who sent what, when
- After: Every delivery logged: supplier, country, item, quantity, timestamp | Most recent log auto-shows top of inventory screen | Full history searchable — every delivery since system live | Discrepancies traceable to entry point
- Result: No more delivery disputes | full audit chain | multi-country tracking
Case Study 008
Deployed a Silent Factory OS — Full Stack, Zero Ongoing Human Input
- Before: 6+ disconnected systems — manual sync, reconciliation, errors
- After: One unified logic layer spans: orders, labor, inventory, payments, reporting
- Built in: 74 hours across integration points | No third-party tools | No training | No app installation
- Runs: Unattended — no manual refresh, no merge, no admin
- Ownership: Full control retained — source logic private