Job-Shop Asset Manager
Section titled “Job-Shop Asset Manager”Tech Stack: SQL, MS Access, VBA
A custom asset management system built for a commercial millwork shop, replacing paper-based tracking with a digital solution.
Context
Section titled “Context”During my time as a millwork carpenter, I identified inefficiencies in how our shop tracked tools, materials, and job progress.
Solution
Section titled “Solution”Designed and built a custom database application that:
- Tracks tool inventory and maintenance schedules
- Manages material stock and reorder points
- Provides job costing and progress visibility
- Generates reports for management
Impact
Section titled “Impact”- Reduced tool loss by 40%
- Improved job costing accuracy
- Enabled data-driven purchasing decisions