Overview

I designed and developed an internal web application that enables technicians to quickly scan devices, retrieve warranty information, and verify asset labels through a single, centralized interface. The system has been in production for nearly two years and is used daily by a repair team that processes thousands of devices each week.

The Challenge

Before this application was developed, technicians relied on Microsoft Excel spreadsheets or visited individual manufacturer websites to verify warranty information. This process was repetitive, time-consuming, and made it difficult to quickly identify incorrectly labeled devices during the repair process.

The Solution

I created a centralized web application backed by a custom database that allows technicians to scan a device and instantly retrieve warranty information. The application also helps identify incorrect asset labels, improving accuracy before devices continue through the repair workflow.

My Role

• Designed the application workflow and user interface.
• Created and optimized the database structure.
• Developed the front-end and back-end functionality.
• Tested the application with technicians and gathered feedback.
• Improved the user experience through multiple design iterations.
• Deployed and continue to maintain the production application.

User Experience

My primary goal was simplicity. Since technicians use the application throughout the day, I focused on minimizing clicks and creating an intuitive workflow. I observed how employees interacted with the system, refined the interface based on their feedback, and introduced numerous quality-of-life improvements before deployment.

Results

• Replaced manual spreadsheet tracking and manufacturer website lookups.
• Created a centralized source for warranty verification.
• Improved technician workflow and reduced repetitive manual tasks.
• Helped identify incorrect asset labels before devices moved through the repair process.
• Successfully adopted as part of the company's daily repair operations.

Technologies Used

• HTML5
• CSS3
• JavaScript
• PHP
• MySQL
• Bootstrap