Warehouse Inventory App cover
All work

2023

Warehouse Inventory App

An offline-first mobile app for barcode scanning and stock counts that syncs the moment a signal returns.

Overview

Built a cross-platform app for warehouse staff who work in dead zones. The local-first data layer records every scan to on-device SQLite, resolves conflicts with a last-writer-wins-plus-audit strategy, and reconciles against the Node API when connectivity comes back. Designed the sync protocol and the backend inventory service, and tuned the scanner UI so a full count never blocks on the network.

Role & impact

My role

Full-stack engineer — sync protocol, backend service, and mobile UX.

Impact

Cut monthly stock-count time by 55% and eliminated reconciliation errors from lost updates.

Stack

React NativeTypeScriptSQLiteNode.jsPostgreSQL