GarageWalle
Production Automotive Service & Inventory Management Platform
Project Overview
GarageWalle is an all-in-one automotive diagnostics, mechanics bay allocation, and auto-parts inventory tracking platform built for modern vehicle service centers.
The Problem & Motivation
Independent auto workshops relied on manual paper logs, causing misplaced parts inventory, delayed service check-ins, and poor customer visibility.
System Architecture Diagram
Key Engineering Features
Real-Time Vehicle Telemetry Dashboard
OBD-II fault codes and vehicle health logs.
Track engine health, battery voltage, and diagnostic trouble codes in real-time.
Drag-and-Drop Mechanics Scheduler
Allocates workshop bays efficiently.
Assigns repair jobs to mechanics based on expertise and active bay availability.
Full Technology Stack
Technical Challenges & Engineering Solutions
Concurrent Database Transactions
Challenge: Simultaneous inventory updates by multiple mechanics during peak hours led to stock count discrepancies.
Solution: Implemented MySQL ACID transaction isolation levels and row-level locking for inventory operations.
Measurable Results & Outcomes
What I Learned
- Mastered relational database normalization, ACID transactions, and foreign key constraint safety.
- Implemented drag-and-drop interactive UI components in React.