Supply Tracking
End-to-End Asset Lifecycle Management for Reusable Medical Equipment
Business context and structural constraints
ARC's reusable assets were operationally invisible the moment they left a facility. Shipping a cooler to a blood drive meant trusting it would come back. Receiving a delivery meant hand-counting items against a paper manifest. Investigating a missing asset meant phone calls. The system had to work in the field — on phones, tablets, and shared workstations with no installed software — with barcode scanning that worked reliably on ordinary device cameras and audit reporting that fit directly into ARC's existing XLSX-based audit workflow.
Browser-based scanning at operational reliability
ZXing's browser decoder performs inconsistently across device cameras and lighting without tuning. We built a resolution and frame-rate optimization layer inside the PWA scanning interface that improved first-scan success from ~70% to over 95% under standard field conditions.
Query performance at ARC asset dataset scale
ARC's inventory spans thousands of items across dozens of facilities with years of movement history each. EF Core-generated queries were too slow for report and history views. Key read paths were rewritten against Dapper-based stored procedures, achieving the 40% retrieval improvement.
The Solution
Architectural approach and implementation
An enterprise asset management platform that gives the American Red Cross complete, real-time visibility over every reusable item in its blood operations fleet — coolers, transport containers, collection apparatus — across dozens of facilities and blood drives nationwide. The system handles registration, shipping, delivery confirmation, return receipt, and idle detection as one continuous chain of custody, with field staff operating entirely from a Blazor WebAssembly PWA — no native app, no dedicated scanning hardware, just a phone camera and ZXing.
Unbroken chain of custody from registration to audit
New reusable asset entered with barcode ID, category, and home facility assignment
Outbound manifest generated, asset marked in-transit with timestamp and owner
Field staff confirms delivery via Blazor WASM PWA using device camera (ZXing)
Real-time state updates; idle detection flags assets that stop moving mid-cycle
Barcode-verified return receipt closes the loop and reassigns the asset home
On-demand XLSX reports exported via OpenXML — full history, user-attributed, audit-ready
PWA-First Field Access
Blazor WebAssembly PWA installs on any modern phone or tablet — no native app, no device provisioning. Camera-based barcode scanning via ZXing achieves >95% first-scan success rate under real field conditions.
Unbroken Chain of Custody
Every state transition is timestamped and user-attributed. Registration, dispatch, delivery, return, and reassignment events form a continuous audit trail that replaces manual manifest reconciliation entirely.
Idle Asset Detection
Continuous monitoring of time-since-last-scan flags equipment that stops moving mid-cycle. Facility managers see potential losses as actionable follow-ups before they become confirmed write-offs.
Query Performance at Scale
Report generation and history views bypass Entity Framework entirely — Dapper queries against optimized stored procedures deliver 40% faster retrieval on thousands of items with years of movement history.
How we turned the challenge into a solution
Each stage formalizes uncertainty into a concrete engineering outcome
Audit → Dependency Map
Inventory of 17+ disparate systems, data flow mapping, identification of critical integration points and performance bottlenecks
Map → Unified Architecture
Design of event-driven microservice architecture with multi-region data residency and zero-trust security model
Architecture → Working Prototype
Document management MVP with FIDO2 authentication, AES-256 encryption, and basic workflow engine for pilot group
Prototype → Scalable Platform
Horizontal scaling to 160+ countries, multi-tenant isolation, AI document classification with 95% accuracy
Platform → Analytics Core
MyInsights recommendation engine, predictive SLA alerts, personalized delivery of regulatory updates
Core → Continuous Compliance
Automated retention policies for 160+ jurisdictions, document integrity chain, one-click audit report generation
Full Shipping Lifecycle Workflow
Purpose-built modules cover every stage of asset movement: outbound registration with manifest generation, in-transit status, delivery confirmation, return receipt, and facility reassignment. Each transition is timestamped and user-attributed — unbroken chain of custody across the full lifecycle.
Camera-Based Barcode Scanning (PWA)
Using the ZXing browser decoder inside the Blazor WASM PWA, field staff scan asset barcodes directly with their device camera. No native app, no dedicated hardware, no device provisioning. Immediate confirmation of scan success or failure before any state change commits.
Idle Asset Detection
The system monitors time-since-last-scan for every tracked asset against expected transit and return windows. Items that stop moving are surfaced automatically to facility managers as follow-ups — before they become confirmed losses.
Audit & Reporting Engine
On-demand XLSX reports via OpenXML — by item, by facility, by time period, or by movement type. Every state transition, every user action, every timestamp included. Designed to drop straight into ARC's existing audit workflow without transformation.
Corporate SSO & RBAC
Integrated with ARC's enterprise SSO. Role-based access determines which facilities and asset categories each user can view or modify — regional staff see their operational scope, central operations teams maintain cross-facility visibility.
The Impact
Quantitative results demonstrating the real impact of implementation on operational efficiency, infrastructure reliability, and platform scalability
Asset tracking accuracy improved by 45% — barcode-confirmed chain of custody replaces manual manifest reconciliation
Asset loss reduced by 35% — idle detection surfaces missing equipment before losses are confirmed
Data retrieval speed increased by 40% — Dapper + stored procedures eliminate ORM overhead on large asset history datasets
Field staff operate entirely from PWA — zero app installations, zero dedicated hardware, camera-based scanning only
Full audit reports generated on demand in XLSX format, slotting directly into ARC's internal audit workflow
Technology Stack
Built with proven enterprise-grade technologies
Visual Journey
Screenshots and mockups from the project
Interested in a similar solution?
Discuss your project→