Aplicação web para crítica de bases de dados previdenciários em fundos de pensão

Abstract

The integrity and consistency of registry databases are essential to ensure the reliability of actuarial valuations and the sustainability of benefit plans managed by Pension Funds. In this context, this study proposes a structured data review process using the R programming language, aiming to identify inconsistencies, duplications, and other issues that may compromise the quality of information used in actuarial valuations. The adopted methodology combines established market practices, also incorporating a descriptive analysis of the dataset and validation steps related to changes in participant records. In addition to the technical analysis, the study includes the automated export of results in .xlsx format and the implementation of an interactive interface via Shinyapps, with the goal of making the process accessible to users with varying levels of programming experience. The results demonstrate that automating and systematizing the data review process can significantly contribute to improving the quality of information used in actuarial valuations, promoting greater reliability and efficiency in the management of benefit plans.