Pharma WMS
Warehouse management system for pharmaceutical distribution
- $200M+ annual distribution
- 1 → 4 facilities
- 98% fewer compliance incidents
- Industry
- Pharmaceutical distribution
- Status
- Shipped
- Barcode scanners
- Rails API
- PostgreSQL + Redis
- Compliance jobs
The Problem
A pharmaceutical distributor was managing warehouse operations across multiple facilities with spreadsheets and legacy tools. Compliance errors were common, inventory was unreliable, and scaling to new facilities meant duplicating manual processes.
The Approach
I replaced the spreadsheets with one real-time warehouse system: barcode-driven workflows, automated compliance checks, and inventory that stays in sync across facilities. Every movement is audited, and every temperature excursion gets flagged the moment it happens.
The Architecture
Rails API with React frontend. PostgreSQL for transactional data with Redis pub/sub for real-time updates. Background jobs handle compliance reporting, inventory reconciliation, and facility sync. The system processes thousands of transactions per hour with sub-second response times.
The Results
98% reduction in compliance incidents. 3x faster order fulfillment. Scaled from 1 to 4 facilities without architecture changes. The system handles $200M+ in annual pharmaceutical distribution. These figures come from the distributor's own numbers.
Built with Ruby on Rails, React, PostgreSQL, Redis
Running a warehouse on spreadsheets?
I build inventory and compliance systems that hold up when the auditor shows up. Tell me what you're working with.
Serving the Central Valley: Sacramento · Stockton · Modesto · Manteca, Tracy & Lathrop