Bacancy Technology
32 Case Studies
A Bacancy Technology Case Study
The client, an EU-based insurer, faced significant reporting delays due to an overburdened legacy system. Their overnight SSIS packages running on an on-premises SQL Server could not keep up with growing data volumes, causing reports to arrive a day late and lacking the lineage required for GDPR compliance. Bacancy Technology was engaged to perform a data migration and modernization.
Bacancy Technology rebuilt 94 legacy SSIS packages as pipelines in Microsoft Fabric Data Factory, consolidating five source types into OneLake. The solution included implementing medallion architecture for data validation and Microsoft Purview for governance and lineage. This migration cut overnight processing time by approximately 55%, reduced manual reconciliation effort by 70%, and slashed report refresh latency from 1 second to 200 milliseconds.
EU-based insurer