Design and Development of a Web-Based Inventory System Using Agile Methodology and Hybrid Databases for a Pharmaceutical Company

In this digital era, the presence of technologies such as ERP has become something important in a company's business processes inventory management being one of them. In this study, PT XYZ is a pharmaceutical company that has an ERP system for managing spare parts inventory. However, this system is divided into various modules so that there is the potential for stockouts, deadstock, or additional parts which cause high cost effects on inventory. Therefore, a web application project called ESS-BPPM based on ASP. NET was created which can manage this spare parts inventory. The development of the ESS-BPPM application uses an Agile methodology and development of the application is divided into 5 main features, namely machine part master management (Master BPPM), Machine part Inventory Monitoring (Master Inventory), Machine part management (Catalog/Cart), Machine part issue submission (Outstanding Issue), and Machine part tracking (Transaction Log/BPPM). After implementation, the resulting application will go through a QA process starting from SIT (System Integration Testing) then UAT (User Acceptance Testing) before the application can be put into production. The result of this study is a system application for issuing and monitoring spare part materials based on existing data in Oracle and SQL Server which can facilitate monitoring and control of material movement. The ESS-BPPM application will be integrated into the Intranet Portal of PT XYZ. The outcome of this research is a web application that can help the management of machine spare parts and provide real-time tracking and logging using both data from Oracle and SQL Server.