QRT data validation tool

The increasing complexity and scope of regulatory reporting requirements, especially under Solvency II, have led to an urgent need for efficient and reliable data validation solutions in the insurance industry.

Zeugin, Laurent, 2023

Art der Arbeit Bachelor Thesis
Auftraggebende Baloise Group
Betreuende Dozierende Schlick, Sandra
Keywords Data validation, Python, Reporting, Pandera
Views: 44
This bachelor thesis deals with the development and implementation of a customized data validation solution to streamline the validation process, ensure compliance with and manage the growing data complexity associated with Baloise’s Group Solvency II reporting. The research conducted as part of this thesis includes an extensive literature review on data validation techniques, regulatory requirements and existing validation processes of the insurance industry.
Based on this, an efficient, user-friendly and customizable data validation tool was developed to meet the specific requirements of Baloise Group. This tool, crafted with the capability to incorporate EIOPA validation rules and user-specific validation requirements, was built using Python and Pandera, a built-in Python library. The code provides a standardized, user-friendly interface, through which the user can check the correctness of the data against the associated EIOPA validation rules.
The methodology used in this project involved a sequential, iterative process that included Analysis, Planning, Development, and Testing phases. Development focused on the use of Python and Pandera for programming data validation functions, a container environment for executing the functions and standardizing input syntax to ensure usability. The solution provides a scalable framework that can accommodate potential future enhancements and adaptations to changing regulatory requirements. This work demonstrates the effectiveness of custom data validation solutions in the insurance industry and contributes to the field by providing valuable insights and a practical, adaptable tool for improving and streamlining reporting processes.
Studiengang: Business Information Technology (Bachelor)
Vertraulichkeit: vertraulich
Art der Arbeit
Bachelor Thesis
Auftraggebende
Baloise Group
Autorinnen und Autoren
Zeugin, Laurent
Betreuende Dozierende
Schlick, Sandra
Publikationsjahr
2023
Sprache der Arbeit
Englisch
Vertraulichkeit
vertraulich
Studiengang
Business Information Technology (Bachelor)
Standort Studiengang
Basel
Keywords
Data validation, Python, Reporting, Pandera