Publication Search

Public complaint services are an essential part of public service delivery in supporting the government’s rapid response to various social issues and emergency situations. In West Tanjung Jabung Regency, public complaint services are provided through the HALO USTAD 112 Call Center managed by the Department of Communication and Informatics. However, the existing service still faces several limitations, including the lack of optimal integration in complaint data management, inadequate documentation of reports based on regional classifications, and limited capabilities in storing and retrieving complaint data. This study aims to optimize the HALO USTAD 112 Call Center service through the design of a mobile-based public complaint information system, so that the processes of receiving, managing, and monitoring reports can be carried out more effectively and in a structured manner. The system development applies the Waterfall method, which consists of requirement analysis, system design, implementation, and testing stages. The designed information system includes key features such as user and admin login, complaint submission, report management and verification, report monitoring, statistical visualization of complaint data, and regional-based report recapitulation. The application is developed using the Flutter framework with the Dart programming language, while Supabase is utilized as the backend integrated with a PostgreSQL database. The results of this study are in the form of a system design and prototype that are expected to improve the quality of public complaint services and support more accurate, integrated, and efficient data management.

Flood is a frequent natural disaster in Indonesia, often exacerbated by delays in information delivery from conventional manual monitoring systems. This study aims to design and build an automatic flood early warning system based on the Internet of Things (IoT) integrated with a web dashboard and WhatsApp notifications. The system utilizes the ESP32 microcontroller and MaxBotix MB7389 ultrasonic sensor for real-time water level data acquisition. The Research and Development (R&D) method was employed, focusing on device accuracy validation and system integration. The measured data is transmitted to a .NET-based server and stored in a PostgreSQL database. Results indicate that the system functions according to design. Sensor accuracy testing demonstrated a high degree of precision (99.12% - 100%) compared to manual measurements. Furthermore, the system successfully sends timely warning notifications via WhatsApp when water levels exceed predefined thresholds, providing a more effective solution than manual monitoring to enhance community preparedness.

In line with the rapid advancement of digital technology, the need for an efficient, integrated, and technology-based financial management system has become  critical, particularly for educational institutions such as STT-NF. The manual management of financial reports, especially cash flow statements used spreadsheets continues to pose significant challenges, including the risk of data entry errors, delayed reporting, and the lack of real-time visibility into the institution's financial condition. This study aims to develop a web application for cash flow monitoring system using the waterfall methodology to address these issues. The waterfall model was selected due to its systematic and structured approach. The system was developed using ReactJS for the frontend, NodeJS for the backend, and PostgreSQL as the database management system. To verify system functionality, testing was conducted using the black box testing method. The results of the testing indicate that all developed features of the cash flow monitoring system functioned according to the specified requirements and operated optimally. Therefore, the system is expected to provide tangible benefits in supporting the performance of the Finance Department at STT-NF as well as the foundation, by enhancing real-time financial visibility and delivering accurate information to facilitate faster & more informed decision-making.

This study is dedicated to the design and implementation of a web-based inventory management platform for PT. Paramata Baraya International. replacing the manual Excel system that is ineffective and susceptible to mistakes. The Rapid Application Development (RAD) method is chosen for its quick and iterative approach to software development. The system is built using the Next.js framework and PostgreSQL as the database, with Prisma ORM for database management. Key features include item management, real-time status tracking, calibration, maintenance, equipment rental, and automatic notifications. The implementation results show a 60% increase in item search efficiency, 95% data accuracy, and an 80% reduction in manual input errors. This study is significant as a solution for companies engaged in calibration and maintenance of measuring instruments.

This research aims to develop and implement the design and front-end transition of a web-based admin dashboard to facilitate information access and support digitalization at PT Kalbe Farma Tbk, particularly in managing the weekly production schedule. The main issue faced is that the preparation of weekly production schedules at PT Kalbe Farma Tbk is still conducted manually using paper and spreadsheets, making it prone to errors and inefficiency. Established in 1966, PT Kalbe Farma Tbk has become a leader in Indonesia's pharmaceutical industry, with a strong commitment to innovation and quality. In addressing modernization challenges, the company seeks to enhance operational efficiency through advanced technology implementation. The platform was developed using the Laravel framework and Tailwind CSS, with PostgreSQL as the database. Key features of the platform include production scheduling, approval submissions, real-time schedule adjustments, and informative data visualization. This research focuses on implementing interface design, transitions, and page routing to improve employee productivity, expedite schedule approvals by production managers, and simplify schedule adjustments by warehouse staff, while reducing errors and improving information accuracy. The methodology used in this study is Rapid Application Development (RAD), which allows for rapid and flexible development with user involvement at every stage. The research also addresses system architecture, implementation processes, and the integration of key features, as well as testing to ensure the platform is accessible across various devices and browsers. The results of this research are expected to significantly contribute to improving operational efficiency and the competitiveness of PT Kalbe Farma Tbk in the pharmaceutical industry.

Databases play an essential role in modern information systems because they enable the efficient storage, management, and retrieval of structured data. This study focuses on the implementation of a simple database using two relational database management systems (RDBMS), namely MySQL and PostgreSQL. The research stages are carried out through requirements analysis, designing entity-relationship diagrams, implementing tables and their relationships, and testing the system to assess functionality. The case study used is student data recording, where both RDBMSs are tested through a series of basic CRUD (Create, Read, Update, Delete) operations. The results show that both MySQL and PostgreSQL are capable of carrying out these operations effectively while maintaining data integrity and consistency. However, PostgreSQL offers additional advantages due to its support for more complex data types, a better level of compliance with SQL standards, and advanced features that support the needs of large-scale application development. Conversely, MySQL remains superior in terms of ease of use and application to simpler needs, making it more practical for small projects or applications with standard workloads. Based on these findings, it can be concluded that both RDBMSs are equally suitable for use, but the ideal choice depends heavily on the context of the needs; PostgreSQL is more suitable for applications that demand high scalability and size, while MySQL remains relevant for lightweight and efficient implementations.