Project Introduction & Context
As part of my web development portfolio, I present the Shift Management System project developed for Airnav Indonesia. This system was specifically designed to digitize and automate the complex process of managing schedules and shift exchanges for Air Traffic Controller (ATC) personnel. The critical need for an efficient, transparent, and integrated system was the primary driver behind this development initiative, aiming to replace time-consuming and error-prone manual methods with a streamlined digital workflow.
Technology Stack & My Role
The development of this system fully leverages the Google Workspace ecosystem, demonstrating proficiency in building robust business solutions on a familiar cloud platform. Google Sheets (represented by .xlsx files) serves as the primary data source for personnel information and the monthly duty rosters. The core system logic, including shift exchange request validation, password management processes, and data integration between sheets, was extensively implemented using Google App Script. My responsibilities encompassed designing the data architecture within Sheets, developing all the Google App Script code for the backend functionalities, and building the responsive user interface (UI) on Google Sites using a combination of HTML, CSS, and JavaScript to ensure an intuitive user experience. The storage of system assets and important documents like digital signatures is securely managed via Google Drive.
Key Features & Functionality
This system incorporates several crucial functional modules. The Shift Exchange Module empowers personnel to digitally submit, track, and complete schedule exchange requests. This process includes automatic validation against existing schedules and detailed logging of all transaction data. An integrated electronic signature verification feature ensures the authenticity of approvals within the exchange process, robustly supported by a One-Time Password (OTP) mechanism. Additionally, the system includes a password management module for personnel account security and centralized management of personnel data and system configurations stored directly in Google Sheets, providing administrators with the necessary flexibility to adjust system parameters without needing direct code modifications.
Outcome & Impact
The successful implementation of this Shift Management System has significantly improved Airnav Indonesia’s operational efficiency in personnel schedule management. The potential for manual errors has been substantially minimized, resulting in schedule data availability that is both more accurate and real-time. Furthermore, the system provides a transparent and easily accessible platform for all personnel to view their duty rosters and actively participate in the shift exchange process. With detailed and centralized transaction logs, auditing and reporting related to schedule management have also become considerably easier and more accountable.
