Automating a Web-based Employee Management Information System using Agile Scrum

Rafi Risqullah Putra, Evi Maria (SCOPUS ID: 57093633500)

Abstract


Effective employee management is a critical factor in enhancing operational efficiency and organizational competitiveness. PT Sekawan Sahabat Sejati has faced challenges in employee administration due to manual processes using Microsoft Excel. These challenges include payroll calculation errors, difficulty in tracking data revisions, and delays in salary processing. This study aims to design and implement a web-based employee management information system to address these issues. The Agile Scrum methodology was employed, with data collected through field observations, stakeholder interviews, and literature reviews. The system was designed using an Entity Relationship Diagram and developed with the Next.js framework, TypeScript, and PostgreSQL as the database. The results show that the system can accurately automate base salary, allowances, and tax deductions, significantly reducing manual errors and accelerating the payroll process. System testing demonstrated notable improvements: payroll report generation time was reduced from 15 minutes to 4.02 seconds, attendance processing from 2 minutes to 3.08 seconds, creation of 500 employee records from 60 seconds to 1.2 seconds, and shift configuration storage from 3 minutes to 0.81 seconds. The application has proven to enhance administrative tasks by making them more efficient, transparent, and accountable. For future development, it is recommended to add mobile features, conduct user acceptance testing, and strengthen security through multi-factor authentication.

Keywords


Agile Scrum; Employee Management Information System; Next.js; Payroll Automation; PostgreSQL

Full Text:

PDF

References


A. Safitri, J. P. Sari, and U. Bengkulu, “Perancangan Sistem Informasi Penggajian (SIPEGA) pada PT. PBI Kota Bengkulu,” Teknosia, Vol. 17, No. 1, pp. 26–37, 2023, doi: 10.33369/teknosia.v17i1.28477.

M. A. Nurul Anwar, Achmad Lutfi Fuadi, “Perancangan Aplikasi Sistem Informasi Bahan Baku Produksi berbasis Web dengan Metode Agile pada PT. Jasuindo Tiga Perkasa, TBK Unit Personalisasi Warkat - Jakarta,” Cybern. Inov., Vol. 9, No. 1, pp. 67–85, 2025.

A. P. W. W. Muhammad Ali Akbar Tanjung, “Penerapan Django dan Adminlte dalam Pengembangan Sistem Informasi Pendataan Anak Tidak Sekolah di Pemerintahan Desa Baru Kecamatan Manggar,” ZONAsi, Vol. 7, No. 1, pp. 162–175, 2025, doi: https://doi.org/10.31849/zn.v7i1.23600.

D. P. Kesuma, U. Multi, D. Palembang, and S. Indah, “Sistem Informasi Kepegawaian pada PT Musi Energi Sukses Indah,” JRSIT, Vol. 2, No. 3, pp. 852–864, 2025, doi: https://doi.org/10.70248/jrsit.v2i3.1775.

A. Zulfian et al., “Rancang Bangun Sistem Komputerisasi Absensi dan Perhitungan Bonus Karyawan pada CV Persada Ilmu,” JRAMI, Vol. 02, No. 01, pp. 52–59, 2021, doi: https://doi.org/10.30998/jrami.v2i01.740.

A. Ardiansyah and S. Aji, “Pengembangan Sistem Informasi Penjualan Handphone menggunakan Metode Waterfall,” JASIKA, Vol. 1, No. 1, pp. 54–60, 2021, doi: https://doi.org/10.31294/jasika.v1i1.386.

S. N. Oktaviani, C. F. Aziz, and B. M. Sulthon, “Analisa UI / UX Sistem Informasi Penjualan berbasis Mobile menggunakan Metode Prototype,” KLIK, Vol. 2, No. 6, pp. 225–233, 2022, doi: https://doi.org/10.30865/klik.v2i6.401.

R. S. Kevyn Junichi Baso, Yaulie D. Y. Rindengan and Teknik, “Perancangan Aplikasi Catering berbasis Mobile,” Tek. Elektro dan Komput., Vol. 9, No. 2, pp. 81–90, 2020, doi: https://doi.org/10.35793/jtek.9.2.2020.28986.

K. A. Mounir Elkhatib, Abdulrahman Al Hosani, Ibrahim Al Hosani, “Agile Project Management and Project Risks Improvements : Pros and Cons,” SCI. Res. Publ., pp. 1157–1176, 2022, doi: 10.4236/me.2022.139061.

A. Yesicha Audria, Isnan Budi Sahputro, Rendi Yusuf Alfiansyah, “Pendekatan Framework Codeigniter dengan Metode Agile pada Sistem Penggajian (SIP - WEB) PT. Global Printpack Indonesia,” Infotech, Vol. 10, No. 2, pp. 270–281, 2024, doi: https://doi.org/10.31949/infotech.v10i2.11033.

M. Efniasari, A. Wantoro, and E. R. Susanto, “Pengembangan Sistem Informasi Pelayanan Kesehatan berbasis Web menggunakan Metode Scrum (Studi Kasus: Puskesmas Kisam Ilir),” JTSI, Vol. 3, No. 3, pp. 56–63, 2022, doi: https://doi.org/10.33365/jtsi.v3i3.1945.

R. Hanafi, A. Haq, and N. Agustin, “Comparison of Web Page Rendering Methods based on Next . js Framework using Page Loading Time Test,” Teknika, Vol. 13, No. 1, pp. 102–108, 2024, doi: 10.34148/teknika.v13i1.769.

A. S. A. Miftach Fakhr, Sunan Jaya Irmawan, “Perancangan Sistem Informasi Manajemen Karyawan berbasis Website dengan Metode Waterfall,” MediaTIK, Vol. 6, No. 3, pp. 35–44, 2024, doi: 10.59562/mediatik.v6i3.1456.

M. F. E. Putra, D. Trisnawarman, and T. Sutrisno, “Rancangan Sistem Operasional Perusahaan Otobus Mahendra Transport Indonesia menggunakan Metode Agile,” INTECOMS J. Inf. Technol. Comput. Sci., Vol. 7, No. 3, pp. 886–893, 2024, doi: 10.31539/intecoms.v7i3.10410.

R. B. Rita Sulis Widiyanti, “Rancang Bangun Aplikasi Sistem Informasi Manajemen Kepegawaian (SIMPEG) berbasis Web dengan menggunakan Framework Laravel,” J. Manaj. Inform., Vol. 12, No. 1, 2021, [Online]. Available: https://ejournal.unesa.ac.id/index.php/jurnal-manajemen-informatika/article/view/42641

D. N. G. G. Manacika and D. Ariyanto, “Penggunaan Sistem Informasi dan Kinerja Karyawan,” E-Jurnal Akunt., Vol. 33, No. 6, p. 1537, 2023, doi: 10.24843/eja.2023.v33.i06.p09.

F. Simanjuntak, “Perancangan dan Implementasi Aplikasi Penggajian Realtime di PT Asli Gadai Sejahtera menggunakan Kerangka Kerja Agile Scrum,” NaCosPro, Vol. 5, No. September, pp. 379–388, 2023, doi: https://doi.org/10.37253/nacospro.v5i1.8207.

A. Afriansah, F. Sembiring, R. R. Ayuningsih, S. Saepudin, S. Informasi, and U. N. Putra, “Manajemen Proyek Sistem Informasi menggunakan Framework Scrum dalam Pembuatan Website SMM Mediahome Project Management of Information System using Scrum Framework in the Development of Mediahome SMM Website,” Sistemasi, Vol. 13, pp. 2732–2739, 2024, doi: https://doi.org/10.32520/stmsi.v13i6.4764.

S. Informasi, S. Teknologi, U. I. N. Syarif, and H. Jakarta, “Standar Kelengkapan Fitur E-Learning Supply Chain Management pada Produk Backlog menggunakan Metodologi Scrum,” Vol. 9, No. September, pp. 419–434, 2020, doi: 10.32520/stmsi.v9i3.738.

D. Cohen, M. Lindvall, and P. Costa, “A State of the Art Report: Agile Software Development,” 2003, [Online]. Available: https://csiac.dtic.mil/wp-content/uploads/2021/06/Agile-Software-Development-SOAR-2.pdf




DOI: https://doi.org/10.32520/stmsi.v14i4.5301

Article Metrics

Abstract view : 43 times
PDF - 12 times

Refbacks

  • There are currently no refbacks.


Creative Commons License
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.