Case Study: Manufacturing System - Recovering Financial Data

Challenge: A textile manufacturer serving 200+ users faced a critical data corruption issue where order costs were desyncing, leading to financial losses.

The "Deep Dive" Debug

I identified a race condition in the cost calculation logic. Employees starting work created 0-hour logs that didn't trigger updates. I wrote custom verification scripts to recover ₹15,744 in lost billings across 18 orders.

Performance at Scale

• Bundle Reduction: Slashed initial load time by 70% (1MB → 300KB) using Route-based Lazy Loading.
• Heavy Data Handling: Implemented cursor-based pagination to handle orders with 15,000+ work logs, bypassing Supabase's 1000-row default limit.
• Audit Trails: Built a complete "Before/After" change tracking system for compliance.