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

Sanjaya, Samuel Ady (2024) Design and Development of a Web-Based Inventory System Using Agile Methodology and Hybrid Databases for a Pharmaceutical Company. 11th International Conference on Information Technology, Computer, and Electrical Engineering (ICITACEE).

Text Design and Development of a Web-Based Inventory System Using Agile Methodology and Hybrid Databases for a Pharmaceutical Company.pdf Available under License Creative Commons Attribution Non-commercial No Derivatives. Download (1MB)

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.

Item Type:	Article
Keywords:	Agile, System Integration Testing, User Acceptance Test, Web App
Subjects:	000 Computer Science, Information and General Works > 000 Computer Science, Knowledge and Systems > 006 Special Computer Methods > 006.7 Multimedia Systems, Blogs, Social Media, Web Application Frameworks
Divisions:	Faculty of Engineering & Informatics > Information System
Depositing User:	Administrator UMN Library
Date Deposited:	05 Aug 2025 09:17
Last Modified:	05 Aug 2025 09:17
URI:	https://kc.umn.ac.id/id/eprint/39847

Actions (login required)

View Item