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

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.

References

  1. Brown, M. M., Brudney, J. L. (2011, October). Achieving advanced electronic government services: An examination of obstacles and implications from an international perspective. National Public Management Research Conference.
  2. Bukhsh, F. A, Weigand, H. (2012) E-Government Controls in Service-Oriented Auditing Perspective: Beyond Single Window. Electronic Government Research, 8(4), 20p.
  3. Campos, S. R., Fernandes, A. A., de Sousa Jr., R. T., de Freitas, E. P., da Costa, J. P. C. L., Serrano, A. M. R., Rodrigues, D. C., Rodrigues, C. T. (2012). Ontologic Audit Trails Mapping for Detection of Irregularities in Payrolls. International Conference on Next Generation Web Services Practices (NWeSP 2012). São Carlos, Brazil.
  4. Cordella, A., Iannacci, F. (2010). Information systems in the public sector: The e-Government enactment framework. The Journal of Strategic Information Systems, 19(1), p. 52-66.
  5. Fernandes, A. A., Amaro, L. C., da Costa, J. P. C. L., Martins, V. A., Serrano, A. M. R., de Sousa Jr., R. T. (2012). Construction of Ontologies by using Concept Maps: a Study Case of Business Intelligence for the Federal Property Department. Proc. International Conference on Business Intelligence and Financial Engineering (BIFE'12). Lanzhou, China.
  6. Gil-Garcia, J. R., Martinez-Moyano, I. J. (2007). Understanding the evolution of e-government: The influence of systems of rules on public sector dynamics. Government Information Quarterly, v. 24, n.2, p. 266-290.
  7. Hamner, M, Negrón, M. A., Taha, D., Brahimi, S. (2012) e-Government Implementation in a Developing Country: A Case Study. Managing E-Government Projects: Concepts, Issues and Best Practices. 18p.
  8. Huacarpuma, R. C., Rodrigues, D., Serrano, A. M. R., da Costa, J. P. C. L., de Sousa Jr, R. T., & Holanda, M. T. (2013). BIG DATA: A Study Case on Data From Brazilian Ministry of Planning, Budgeting and Management. IADIS Applied Computing 2013 (AC 2013) Conference. Fort Worth, Texas, USA.
  9. Klimek, P., Yegorov, Y., Hanel, R., & Turner, S. (9 de November de 2009). Statistical detection of systematic election irregularities. Proc. National Academy of Sciences of the United States of America (PNAS), 109(41).
  10. Oracle. (2005). Oracle Database Data Warehousing Guide, 10g Release 2 (10.2), B14223-02, Copyright © 2001.
  11. Tagaris, A. K., Benetou, X., Dimakopoulos, T., Kassis, K., Athanasiadis, N., Ruping, S., Grosskreutz, H., Koutsouris, D. (2009). Integrated web services platform for the facilitation of fraud detection in health care e-government services. 9th International Conference on Information Technology and Applications in Biomedicine.
  12. United Nations. (2012). E-Government Survey 2012. United Nations. Available in: http://unpan1.un.org/ intradoc/groups/public/documents/un/unpan048065.pdf. Accessed in: May 2014.
Download


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