The challenge
Two decades of acquisitions left the company with 1,200 SSIS packages across 14 SQL Server instances, many undocumented. A previous partner estimated 11 months and 40 contractors to migrate. Leadership needed consolidated delivery margin reporting for a new fiscal year.
What we did
Loom Scout inventoried and scored every package, surfacing 212 that were obsolete. Loom Forge converted 83 percent of the remaining packages to Fabric Data Factory and Spark notebooks automatically. A Tulan pod of six engineers hardened the rest. Loom Sentinel reconciled every table nightly against source, so each of five migration waves went live with evidence rather than hope.
The outcome
The program finished in 14 weeks with a team a fraction of the size originally quoted. Margin reporting that used to reconcile in eleven business days now closes in two. The company decommissioned 14 SQL Server instances and redeployed the savings into AI initiatives.
“We budgeted for a year of pain. Tulan gave us a quarter and a parity report for every table.”
Group CIO, Corporate Functions