General Financial Directorate: Automating Data Cleaning with Ataccama for Greater Efficiency
The General Financial Directorate (GFD) was looking for a sustainable solution that would help them handle huge amounts of taxpayer data and automate data cleaning processes.
Background
The digital age of today is accompanied by ever-increasing demands on the quantity and, more importantly, the quality of data within individual organizations.
Every company and government body has to contend with greater or smaller inconsistencies in their data and must solve this issue – either with manual checks and fixes or with a fully automated approach.
The General Financial Directorate found itself in the same situation and chose the path of automation.
Challenge
The administration of state taxes requires fast and automated data handling
The General Financial Directorate (GFD) is responsible for administering state taxes (including personal income tax, corporation tax, value added tax, road tax, immovable property tax, tax on the acquisition of immovable property, stamp duty land tax, inheritance tax, and gift tax). Consequently, the GFD handles a huge amount of taxpayer data.
GFD staff often had to solve the problems associated with a large number of taxpayers (approximately 10 million residents, nearly 500 thousand foreigners, more than 450 thousand businesses, and almost one million self-employed individuals) and a correspondingly vast amount of data.
One of these issues was the unequivocal identification of natural and legal persons together with the clear and correct assignment of individual taxes to the tax subject. The processed data needed to be updated regularly, and as quickly and automatically as possible.
The GFD manages and processes massive volumes of data with a value of tens to hundreds of millions of Czech crowns. The ADQC installation took place in a matter of days.
“ADQC is a very effective and user-friendly tool that can be implemented quickly and easily. The supplier provides extensive high-quality training, documentation, and the necessary coordination and support on-site.”
Ing. Bedřich Valigura, Director of the Tax Analytics Department, General Financial Directorate
Solution
The Ataccama Data Quality Center (ADQC) helps the financial administration process billions of data
The GFD chose a tool from the Ataccama Data Platform as the one best suited to its requirements.
The Ataccama Data Quality Center (ADQC) was thus implemented to fulfill the following functions:
- Consolidating taxpayer records from external sources for the purposes of further analysis
- Identifying and immediately rectifying duplicates
- Automatically completing and consolidating address details
- Other tasks
The data is processed in batches, allowing the combined use of ADQC and other ETL resources.
The goal of actualizing the highest-quality database for the GFD’s analytical operations is thus achieved. Furthermore, the adjustable input and output formats in ADQC make it very easy to use.
Impact
Implementation in a few days and easy management of the tool
The ADQC can be operated by the employees of the tax administration themselves. The installation of the ADQC tool at the General Financial Directorate was accomplished in a matter of days. The implementation team also included employees from the Financial Directorate, who now manage and adjust everything themselves. During the implementation, the local, Czech-speaking development and support team was much appreciated.
Aside from those already in use, the ADQC tool also offers a number of additional features that the General Financial Directorate will utilize in the future.
These will be deployed gradually in the next stages of the project, taking into account current possibilities and needs.
