A cloud data warehouse for superior taxation services

About the client

The client offers experienced and reliable tax tracking services with nationwide capabilities. In addition, their comprehensive approach to flood determination provides their customers with unparalleled expertise in this often-complex arena.


Client requirement
  • The lack of centralization caused multiple teams to independently search for duplicate information, which was a huge drain on resources.
  • Additionally, not all manually sourced information was added to the database.
  • The client aimed to bring the data collection system into modern times, allowing for more efficient data capture and central storage.
Solution
  • PreludeSys developed and implemented a Centralized Data Acquisition (CDA) hub to enable the efficient flow of tax information.
  • An array of extendable frameworks allowed for adaptability, while custom scripts formatted data from external sources into the cloud SQL Server.
  • In addition, we constructed optimized ADF pipelines and workflows that shifted logic toward an application layer, thereby reducing overall maintenance costs.

Benefits
  • PreludeSys developed and implemented a Centralized Data Acquisition (CDA) hub to enable the efficient flow of tax information.
  • An array of extendable frameworks allowed for adaptability, while custom scripts formatted data from external sources into the cloud SQL Server.
  • In addition, we constructed optimized ADF pipelines and workflows that shifted logic toward an application layer, thereby reducing overall maintenance costs.

Technology

.Net, Power BI, Azure Data Factory, Angular