Lumen Technologies Division · Technology · Denver, CO · 26 weeks
9 legacy reporting systems consolidated into one
A regional telecom had nine reporting systems from years of acquisitions. Their monthly close took 18 days because of manual reconciliation across these systems. We merged all data into one Snowflake platform, cutting the close process to 3 days and saving $3.1 million each year.
Challenge
The company had 9 reporting systems, each inherited from separate acquisitions. They operated on different databases, used inconsistent metric definitions, and were managed by separate teams. Closing the books took 18 days and required 14 analysts to manually reconcile data. Maintaining these systems cost $3.1 million annually.
Outcome
We consolidated nine systems in week 26, cutting annual infrastructure costs from $3.1 million to $480,000. The monthly close cycle shrank from 18 days to just 3. This freed up a 14-person reconciliation team, who we reassigned to strategic analytics projects.
Results
- $3.1M Annual infrastructure savings
- 18 days to 3 days Monthly close cycle
- 9 to 1 Reporting systems consolidated
- 26 wks Full consolidation timeline
We were tied to those nine systems for 12 years because nobody wanted to deal with them. Thinklytics pulled everything together in 26 weeks, and we cut our monthly close from 18 days down to 3. Now, the team that used to handle reconciliation is focused on analysis.
Related case studies
- We merged seven warehouse systems into a single platform, slashing logistics costs by $2.2 million a year and cutting order fulfillment from 3.1 days to 18 hours.
- We identified inconsistencies across six revenue metrics and created one certified ARR definition, resolving a $1.4M reporting gap between finance and sales.