Improved Business Intelligence Solution with Reimbursement Tracking System for the Brazilian Ministry of Planning, Budget and Management

Antonio M. Rubio Serrano, Paulo H. B. Rodrigues, Ruben C. Huacarpuma, João Paulo C. L. da Costa, Edison Pignaton de Freitas, Vera Lopes de Assis, Ararigleno A. Fernandes, Rafael T. de Sousa Jr., Marco A. M. Marinho, Bruno H. A. Pilon

2014

Abstract

Business Intelligence (BI) systems are crucial for assisting the decision making processes of private and governmental institutions. The Human Resources Auditing Department (CGAUD) of the Brazilian Ministry of Planning, Budget and Management (MP) has been developing its own BI for auditing the payroll of all federal employees since 2010. Given that the monthly payroll is approximately 12.5 billion reais, the initial version of the proposed BI system in 2012 was able to audit approximately 1.5 billion reais. In this paper, we propose an improved BI system, which can deal with an increased volume of data, a greater amount of monitoring trails and a higher granularity of the final reports. As consequence, the total audit value has increased to approximately 5 billion reais. In addition, our new BI system has incorporated a Reimbursement Tracking System for monitoring the payroll of federal employees who have to reimburse the Brazilian government. Around 4.5 million reais are automatically monthly tracked by our new BI system. Our proposed BI system has been validated using the real environment of the MP and the results are compared to the previous BI system.

Paper Citation

in Harvard Style

M. Rubio Serrano A., H. B. Rodrigues P., C. Huacarpuma R., Paulo C. L. da Costa J., Pignaton de Freitas E., Lopes de Assis V., A. Fernandes A., T. de Sousa Jr. R., A. M. Marinho M. and H. A. Pilon B. (2014). Improved Business Intelligence Solution with Reimbursement Tracking System for the Brazilian Ministry of Planning, Budget and Management . In Proceedings of the International Conference on Knowledge Management and Information Sharing - Volume 1: KMIS, (IC3K 2014) ISBN 978-989-758-050-5, pages 434-440. DOI: 10.5220/0005169104340440

in Bibtex Style

@conference{kmis14,
author={Antonio M. Rubio Serrano and Paulo H. B. Rodrigues and Ruben C. Huacarpuma and João Paulo C. L. da Costa and Edison Pignaton de Freitas and Vera Lopes de Assis and Ararigleno A. Fernandes and Rafael T. de Sousa Jr. and Marco A. M. Marinho and Bruno H. A. Pilon},
title={Improved Business Intelligence Solution with Reimbursement Tracking System for the Brazilian Ministry of Planning, Budget and Management},
booktitle={Proceedings of the International Conference on Knowledge Management and Information Sharing - Volume 1: KMIS, (IC3K 2014)},
year={2014},
pages={434-440},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0005169104340440},
isbn={978-989-758-050-5},
}

in EndNote Style

TY - CONF
JO - Proceedings of the International Conference on Knowledge Management and Information Sharing - Volume 1: KMIS, (IC3K 2014)
TI - Improved Business Intelligence Solution with Reimbursement Tracking System for the Brazilian Ministry of Planning, Budget and Management
SN - 978-989-758-050-5
AU - M. Rubio Serrano A.
AU - H. B. Rodrigues P.
AU - C. Huacarpuma R.
AU - Paulo C. L. da Costa J.
AU - Pignaton de Freitas E.
AU - Lopes de Assis V.
AU - A. Fernandes A.
AU - T. de Sousa Jr. R.
AU - A. M. Marinho M.
AU - H. A. Pilon B.
PY - 2014
SP - 434
EP - 440
DO - 10.5220/0005169104340440