[System Development Case] Equipment Management System

This is an example of revitalizing a complicated Access-based equipment management system to achieve stable operations and improve business efficiency.

◆Background The "Equipment Management System" that the customer has been operating for many years manages the lending of equipment used for construction and inspections, as well as facility usage applications. It plays a crucial role in connecting employees with the administrators who manage the equipment and facilities. However, the Access-based system has become complicated due to years of operation, resulting in a significant workload for both users and administrators. Additionally, the lack of a backup system on the operational server was also a concern. ◆Challenges - There was no backup system, raising concerns about business continuity and data preservation in the event of a failure. - The existing system had become complicated, leading to information verification and transcription tasks that increased the operational burden on administrators. - There were issues with searchability and usability, causing delays in users' application processes and resulting in verification tasks for input errors and duplicate reservations. ◆Effects of Implementation - By renewing the system infrastructure and establishing a backup system, the risks of data loss and business interruption were reduced. - By consolidating the previously scattered databases and achieving centralized information management, the burden of verification and transcription tasks on administrators was eliminated. - By web-enabling usage applications and reservation management, and improving searchability and usability, input errors and duplicate reservations were minimized, leading to enhanced operational efficiency.

Reservation Management System