Case Study: Large Public Utility Company achieves successful data warehousing and 1% system reconciliation with Arbutus Software

Large Public Utility Company - Customer Case Study

Large Public Utility Company needed to build a data mart from a massive, decades‑old customer master file — an IBM variable‑length, PL/1‑updated legacy file that would have been terabytes if flattened. Prior access relied on costly, inflexible extraction routines that didn’t reconcile with production reporting, and conventional ETL proposals were impractical. The utility therefore engaged Arbutus Software and its Arbutus Analyzer to directly read and analyze the complex legacy file.

Working with Arbutus Software specialists, the team spent a three‑month Discovery Phase using Arbutus Analyzer to profile the file, create virtual columns and data models, and iteratively resolve undocumented segments and exceptions. The result was a rapid build of the required transformations and a populated data mart, reconciliation of major systems to within 1% (an order of magnitude better than previous efforts), completion in three months, and delivery at a fraction of the cost of other proposals.