Automation tools and custom apps I've built to eliminate errors, accelerate workflows, and boost productivity for small businesses. Each project focuses on zero-defect processes and reliable, maintainable solutions.
An automation tool that searches and filters barcodes across two different embedded Excel datasets, each containing over 100,000 rows. The application eliminates manual Excel filtering, processes barcodes individually or in bulk, and automatically generates formatted Excel output with duplicate detection. Designed to replace time-consuming, error-prone manual processes with a single, controlled workflow.
A Bill of Materials management tool that converts raw engineering data into structured JSON format, ensuring consistency with engineering standards. Features validation logic that identifies out-of-range or incorrectly formatted values before report generation. Exports clean, formatted Excel files, bridging complex nested data with readable documentation for other departments.
A tablet-based field inspection application that eliminates manual steps between field work and final documentation. Features dynamic form generation based on order types, configurable input fields, and five predefined photo categories for consistency. Automatically generates structured PDF reports combining all inspection data and photos into a single, professional document ready for review or archiving.