ITAR2 Data Warehouse Integration Project

Client Description

The National Tax and Customs Administration (NAV) is a governmental organization in Hungary responsible for the collection of taxes and customs duties, as well as enforcing tax-related regulations. Its duties include tax audits, providing guidance to taxpayers, overseeing customs procedures, and detecting financial fraud. The organization aims to improve the efficiency of the tax system and ensure fair contribution to public finances.

Project General Description

The modernization of the National Tax and Customs Administration's (NAV) data warehouse, which has been in operation for over 20 years, was an exceptionally complex and critical project that impacted the foundational workings of the institution's IT systems. This large-scale undertaking involved not only technical advancements but also a complete rethinking and optimization of NAV's data management structure. The project's aim was to create an integrated, efficient, and future-proof system that meets the challenges of the 21st century and the demands of a modern tax authority. Over the course of the 2.5-year project, more than 100 experts worked to ensure its success, all while ensuring that NAV's everyday services continued to operate smoothly.

Let's talk!
Government Sector
​ / ​
Data Warehouse
​ / ​
Risk Management
​ / ​
Internal Reporting Service
​ / ​
Tax Audit Area

Challenge

During the project, over 300 TB of data had to be managed, which included approximately 20,000+ products (in the form of tables, codes, and loads), as well as several tens of thousands of interrelated objects. This massive amount of data encompassed both the previous separate databases and servers of the former Tax and Financial Control Office (APEH) and Customs and Financial Guard (VPOP), which needed to be integrated into a unified data warehouse.

During the ITAR2 project, numerous technical challenges had to be addressed. One of the most significant tasks was the standardization of a large number of previously non-standardized systems. The client had a key requirement for developing new standards and ensuring compliance. This included harmonizing various data formats, interfaces, and processes into a coherent, standardized system.

The successful implementation of the ITAR2 project required the application of sophisticated project management methods. Coordinating the work of 60-100 IT professionals, including several subcontractors, was essential during project leadership. Additionally, close collaboration with users and NAV-side experts was necessary.

How we helped?

Project Management
  • Project Initiation
  • Defining the project objectives and assembling the team.
  • Task Breakdown
  • Comprehensive division of the project into manageable task groups and product categories.
  • Resource Allocation
  • Assigning the appropriate experts to each task, taking into account their competencies and capacities.
  • Continuous Monitoring
  • Regularly checking the progress of tasks and implementing corrections if necessary.
  • Communication and Reporting
  • Regular status reports and consultations with stakeholders to ensure transparency.
  • Subcontractor Management
  • Maintaining a separate record of the status of subcontractor tasks on the supplier side. This ensured project transparency and enabled quick intervention in case of any issues.
  • Transition and Project Closure
  • Transitioning to the new system, and finalizing project documentation.
Planning and Development
  • Data Survey and Planning
  • The first step involved a detailed assessment of all existing data sets and applications, including the analysis of data structures, dependencies, and usage patterns. Based on the results of the survey, a detailed plan was developed.
  • Unifying Data Sources
  • Integrating data from the former APEH and VPOP systems into a central data warehouse, ensuring data consistency and accessibility.
  • Data Loading
  • Loading data into the new data warehouse was a complex process involving data cleansing, transformation, and validation. We developed specialized ETL (Extract, Transform, Load) processes to ensure data integrity and consistency.
  • Standardizing Processes
  • Redesigning and unifying data management and processing workflows to increase efficiency and reduce the potential for errors.
  • Complete Data Mart and Reporting
  • Preparing data mart tables, loads, and reports in standardized form from the previously separate systems.
  • Testing and Fine-tuning
  • Conducting system-level tests and performance optimization.
  • Oracle Database
  • Oracle Exadata