THE BUSINESS PROCESS IMPROVEMENT OF MEDICAL SERVICES DATA MANAGEMENT IN PT. HQQ BY DESIGNING DATABASE USING SYSTEM DEVELOPMENT LIFE CYCLE (SDLC) METHODOLOGY

Abstract

PT. HQQ provides medical services for the workers. The company provides the medical services from both government (BPJS Kesehatan) and the company itself. Unfortunately, the data management of medical services member is not efficient and effective. The data regarding the medical services are managed using MS Excel manually. The manual process leads to incorrect data input and causes delay for the process of getting treatment. In some cases, the member has to pay for the treatment first so that the member can get immediate treatment. The company will reimburse the payment but the process is long and complicated. The overall reimbursement occurrences from January – August 2018 is 73 with the average of 9.125 and the total amount of money reimbursed is IDR 65,943,200 with the average of IDR 8,242,900. In addition, why-why analysis is used to determine the root cause of the problem, which is the unavailability of a system that is able to support the requirement to manage the medical services data and the disorganization of the business process. To solve the problem, database are constructed using System Development Life Cycle (SDLC) tools which consists of five phases; systems planning, systems analysis, systems design, systems implementation, and systems support and security. Business process flow diagram of current and proposed system is analyzed. After that, user requirements is determined. Data flow diagram, entity relationship diagram, and physical data model is constructed. And the system is designed based on the ERD and PDM. Finally, the system is implemented. The improvement implementation result of reimbursement occurrences from September – December 2018 is three with the average of 0.75 and the total amount of money reimbursed is IDR 1,150,000 with the average of IDR 287,500. It means that the improvement is already successfully implemented.