The Challenge
A property management company was running inspections on paper forms, then transcribing results into spreadsheets back at the office. Data arrived 2–3 days late, was riddled with errors, and gave no real-time visibility to the operations team.
Approach and Execution
I built a React Native app with a SQLite offline store and a conflict-resolution sync engine. Field workers capture photos, structured data, and free text on-device. Validation rules run locally before submission. A BigQuery pipeline aggregates results and feeds a Looker dashboard for the ops team.
Results
Key Insight
Conflict resolution for multi-user offline sync is genuinely hard. We used a last-writer-wins strategy with server-side timestamps for most fields, and a manual merge UI for the handful of fields where conflicts mattered (compliance status, severity ratings).
Outcome
The paper process was fully retired within 6 weeks of rollout. The ops team now monitors live inspection status from a central dashboard and catches compliance issues before inspectors leave the site.
React Native · SQLite · Node.js · BigQuery · Looker