Konsolidasi Pelaporan Multi-Divisi pada Sistem Informasi Eksekutif Berbasis Web Menggunakan Rapid Application Development

Abstract

Executive decision making requires concise, up-to-date, and consolidated information, whereas operational reporting in energy support service companies is generally still scattered across divisions, so the information has to be collected and checked manually before it can be used. This research aims to design and build a web-based Executive Information System that consolidates the reports of four operational divisions, namely General Affair, Human Resource Development, Engineering Rig & Development, and Transport, into a single shared reporting structure and presents them as executive indicators. The system was developed using the Rapid Application Development method in four phases: requirements planning through observation, interviews, documentation, and literature study; user design producing process models, database structure, indicator mapping, and twelve interface wireframes; construction using the PHP programming language and a MySQL database iteratively through prototypes; and cutover consisting of final testing, user training, and system implementation. This research offers three contributions: (1) the design of a lightweight consolidation layer that maps the heterogeneous indicators of four divisions into a single shared reporting structure, so that the benefits of an Executive Information System can be obtained without building a data warehouse; (2) the application of Rapid Application Development in the Executive Information System domain, which has so far been dominated by sequential approaches, with the executive involved directly in every prototyping cycle; and (3) a tiered presentation pattern from summary to detail combined with role-based access control, so that inter-divisional data confidentiality is preserved when the reports are consolidated. The resulting system implements fifteen functional requirements across twelve interface pages and shortens the executive information retrieval flow from five manual cross-division steps into a single dashboard access, while reducing the number of information sources that must be opened from four divisional report files into one integrated interface, equivalent to an 80% reduction in the number of steps and a 75% reduction in the number of information sources. Black box testing of nine scenarios representing all functional requirements produced valid results in every scenario (100%), therefore the system is declared functionally valid within the tested prototype scope. The limitations of this research are that the system still runs on a local network, data updates depend on divisional user input, and advanced analytics such as trend analysis, forecasting, and anomaly detection are not yet available; these become the agenda for the further research.