AI-Powered OCR · Repository Pattern Architecture
Traceability Manager: AI Edition

The Challenge
In industrial piping and welding, traceability is a legal requirement. Traditionally this process is plagued by 'Excel fatigue': thousands of manual data entries, error-prone transcription of welder IDs and heat numbers, and the painstaking manual assembly of ISO certification packages. A single mistake can invalidate an entire audit trail.
The Solution
A desktop application that replaces manual Excel workflows with an intelligent spreadsheet interface powered by AI-driven OCR. Google Cloud Vision scans handwritten weld logs directly into the database with fuzzy matching and auto-correction. Batch generation produces hundreds of individual ISO Excel files from a single master list. Non-destructive sync updates existing documents without overwriting manual input. Hours tracking with visual budgeting and automated Outlook reporting complete the project management loop.
Tech Stack
Key Features
Results
What took a day now takes minutes with AI-powered scanning
Complete traceability chain for ISO certification
Fuzzy matching handles handwritten welder IDs and heat numbers