Just build a desktop application that automates annual equipment inspection data management. Instead of manual copy-pasting from Word documents into Excel spreadsheets, this app automatically extracts inspection data, centralizes it in a searchable database, and tracks equipment health across multiple years.

The Problem It Solves

Manufacturing facilities conduct yearly equipment inspections. Before this tool, engineers wasted hours manually:

Copying inspection data from Word reports into local Excel files

Maintaining separate spreadsheets with no single source of truth

Dealing with conflicting edits when team members worked on the same shared drive

Searching through multiple files to find component history

Your Solution

A Windows desktop application that:

✅ Extracts inspection data automatically from Word documents using intelligent parsing

✅ Centralizes data in portable SQLite databases (one per plant)

✅ Tracks component health across inspection years in a single matrix view

✅ Handles multi-user collaboration with automatic conflict resolution for SharePoint/OneDrive teams

✅ Exports to PDF one-click landscape reports for documentation

✅ Provides audit trails — full record of who changed what and when

Technical Stack

Frontend: Electron (cross-platform desktop) + HTML/CSS/JavaScript

Backend: Python (intelligent .docx parsing via python-docx)

Database: SQLite (portable, zero-admin, SharePoint-compatible)

Key Features: IPC communication, real-time search, conflict resolution, PDF export, audit logging

Key Achievements

Production-ready application currently deployed

Handles real-world complexity: multi-language documents, varying table layouts, Wingdings encoding, corrupted data

Security: renderer sandbox, input sanitization, XSS prevention, OS-authenticated audit trail

Tested: 53+ automated test cases for parser accuracy and database integrity