Design and Development of a Web-Based Inventory System Using Agile Methodology and Hybrid Databases for a Pharmaceutical Company | IEEE Conference Publication | IEEE Xplore

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


Abstract:

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 ...Show More

Abstract:

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.
Date of Conference: 29-30 August 2024
Date Added to IEEE Xplore: 03 December 2024
ISBN Information:

ISSN Information:

Conference Location: Semarang, Indonesia

Contact IEEE to Subscribe

References

References is not available for this document.