Analyzing Pension Data Process and Proposing Solutions at the Regional Financial and Asset Management Agency Office

The Regional Financial and Asset Management Agency (BPKAD), where we conducted our investigation, is one of the organizations under the mayor's jurisdiction in Palembang. Due to its manual management of employee pension data using Microsoft Excel, this organization has considerable influen...

Full description

Bibliographic Details
Main Authors: Marlindawati, ., Syavira Dyah, Harumi
Format: Article
Language:English
Published: INTI International University 2023
Subjects:
Online Access:http://eprints.intimal.edu.my/1852/
http://eprints.intimal.edu.my/1852/1/jods2023_25.pdf
_version_ 1848766852867555328
author Marlindawati, .
Syavira Dyah, Harumi
author_facet Marlindawati, .
Syavira Dyah, Harumi
author_sort Marlindawati, .
building INTI Institutional Repository
collection Online Access
description The Regional Financial and Asset Management Agency (BPKAD), where we conducted our investigation, is one of the organizations under the mayor's jurisdiction in Palembang. Due to its manual management of employee pension data using Microsoft Excel, this organization has considerable influence over the Palembang municipal government, especially in pension data gathering. Began by contacting employees when their designated retirement date was drawing near. The employee then finishes the dossier, which becomes a pension proposal. The fact that the management is still done using the Excel program presents several difficulties. For instance, when the head of finance requires pension data, the staff of the department must review each retiring employee file in the Microsoft Excel application individually, in addition to having to review multiple other files. Naturally, it takes a while because the necessary data must be manually searched individually. When the file is complete, it will be submitted to the department for approval. In this regard, we offer a solution by creating and deploying an application to streamline the pension administration procedure.
first_indexed 2025-11-14T11:57:44Z
format Article
id intimal-1852
institution INTI International University
institution_category Local University
language English
last_indexed 2025-11-14T11:57:44Z
publishDate 2023
publisher INTI International University
recordtype eprints
repository_type Digital Repository
spelling intimal-18522023-12-05T04:09:12Z http://eprints.intimal.edu.my/1852/ Analyzing Pension Data Process and Proposing Solutions at the Regional Financial and Asset Management Agency Office Marlindawati, . Syavira Dyah, Harumi Q Science (General) QA76 Computer software The Regional Financial and Asset Management Agency (BPKAD), where we conducted our investigation, is one of the organizations under the mayor's jurisdiction in Palembang. Due to its manual management of employee pension data using Microsoft Excel, this organization has considerable influence over the Palembang municipal government, especially in pension data gathering. Began by contacting employees when their designated retirement date was drawing near. The employee then finishes the dossier, which becomes a pension proposal. The fact that the management is still done using the Excel program presents several difficulties. For instance, when the head of finance requires pension data, the staff of the department must review each retiring employee file in the Microsoft Excel application individually, in addition to having to review multiple other files. Naturally, it takes a while because the necessary data must be manually searched individually. When the file is complete, it will be submitted to the department for approval. In this regard, we offer a solution by creating and deploying an application to streamline the pension administration procedure. INTI International University 2023-12 Article PeerReviewed text en cc_by_4 http://eprints.intimal.edu.my/1852/1/jods2023_25.pdf Marlindawati, . and Syavira Dyah, Harumi (2023) Analyzing Pension Data Process and Proposing Solutions at the Regional Financial and Asset Management Agency Office. Journal of Data Science, 2023 (25). pp. 1-10. ISSN 2805-5160 http://ipublishing.intimal.edu.my/jods.html
spellingShingle Q Science (General)
QA76 Computer software
Marlindawati, .
Syavira Dyah, Harumi
Analyzing Pension Data Process and Proposing Solutions at the Regional Financial and Asset Management Agency Office
title Analyzing Pension Data Process and Proposing Solutions at the Regional Financial and Asset Management Agency Office
title_full Analyzing Pension Data Process and Proposing Solutions at the Regional Financial and Asset Management Agency Office
title_fullStr Analyzing Pension Data Process and Proposing Solutions at the Regional Financial and Asset Management Agency Office
title_full_unstemmed Analyzing Pension Data Process and Proposing Solutions at the Regional Financial and Asset Management Agency Office
title_short Analyzing Pension Data Process and Proposing Solutions at the Regional Financial and Asset Management Agency Office
title_sort analyzing pension data process and proposing solutions at the regional financial and asset management agency office
topic Q Science (General)
QA76 Computer software
url http://eprints.intimal.edu.my/1852/
http://eprints.intimal.edu.my/1852/
http://eprints.intimal.edu.my/1852/1/jods2023_25.pdf