EKÁER Integration and Development of Goods Tracking System Data

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 Electronic Road Freight Control System (EKÁER) is a system introduced by the National Tax and Customs Administration (NAV) to monitor and regulate road freight traffic. Its primary aim is to combat invoice fraud and tax evasion, particularly in the transportation of high-value goods. EKÁER enables tax authorities to track both domestic and international freight shipments in real time, improving the transparency and efficiency of tax collection. Companies are required to report data related to their shipments, contributing to the reduction of tax evasion and ensuring fair market competition.

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

Challenge

For the successful operation of the EKÁER system, it became essential to integrate and properly manage various data sources. This includes data cleansing, normalization, and secure storage. During the data integration process, we focused on improving data quality and complying with data protection regulations according to the client's requirements, thereby ensuring the system's reliability and efficiency.

Risk management data analysis is crucial for enhancing the effectiveness of the EKÁER system. In the data analysis process, we applied checks and algorithms defined by the risk management team to identify and assess potential risks.

Data mart loading and report generation are indispensable for operating the EKÁER system. The process involves regularly updating the data, generating various types of reports, and using advanced data visualization techniques. These activities ensure that tax authority professionals and analysts have up-to-date information for decision-making and risk assessment.

How we helped?

  • Data Source Integration
  • We linked EKÁER data with other relevant databases, such as vehicle registries, company information, and tax return data, enabling a comprehensive data ecosystem.
  • Data Cleansing
  • We ensured data quality by eliminating duplicates and errors through automated processes, enhancing the accuracy and reliability of the integrated data.
  • Data Normalization
  • We standardized the format of diverse data sources into a unified structure, facilitating efficient analysis and reporting.
  • Data Warehouse and Data Mart Loading
  • We regularly updated and loaded EKÁER data into the data warehouse, ensuring up-to-date information availability. The loading processes were automated and scheduled to improve efficiency.
  • Report Generation
  • We produced various types of reports based on EKÁER data, including daily summaries, monthly trend analysis, and ad-hoc reports. These reports allowed for the analysis of high-risk EKÁER data and supported decision-making.
  • Map-based Application for Monitoring
  • We developed a map-based application that enables the tracking of shipments, displaying their location and routes to support monitoring and enforcement activities.
  • Oracle Service Bus
  • Oracle BI
  • Oracle Database