T-Mobile

T-Mobile Czech Republic deploys Ontology to combine inventory information held in complex spreadsheets with Cramer Resource Inventory Management, ahead of planned migration to NetCracker.

Situation

T-Mobile Czech Republic, a subsidiary of T-Mobile International AG manages the channel planning process using a large and sophisticated collection of Excel spreadsheets in combination with information held within Cramer Resource Inventory Management. As part of a planned migration of this process to NetCracker, T-Mobile needed to correlate and synchronise the spreadsheets data with information held within Cramer whilst at the same time increasing levels of data quality and integrity.

An additional complexity for T-Mobile was that inventory configuration details had been represented by complex formatting within the spreadsheet. This meant that the migration couldn't simply deal with the spreadsheet text, but instead had to also infer the meaning of cell formatting, and align and migrate that as well.

T-Mobile's goal was to reconcile and synchronise the 20,000+ spreadsheets to an in-house version of Cramer Resource Inventory Management ahead of a planned Cramer migration to NetCracker. A key requirement was that T-Mobile must be able to continue to use their spreadsheet-based process right up until the migration to NetCracker. This meant that any migration would have to be able to be developed alongside the continually changing Channel Planning spreadsheets.

Solution

T-Mobile Czech Republic implemented an Ontology data migration solution to search and align the data in their Channel Planning spreadsheets with the Cramer-based inventory information. The project took just 12 weeks from start to finish, and was handled through a series of 2-week sprints where results were presented to T-Mobile and changes were accommodated into the next sprint period.

Throughout the development period, data quality and data alignment reports were provided to T-Mobile which allowed inconsistent and misaligned data to be adjusted in the source spreadsheets as the project progressed. In addition, Ontology provided topological views of the current and planned network infrastructure which helped T-Mobile to visualise future planned capacity in the network. At no point in the migration did the Channel Planning process have to be taken offline, and all semantic information within the spreadsheets, including cell formatting, was migrated on time and on budget in accordance with T-Mobile's specifications.

Benefits

The data migration project was part of a multi-million pound investment in NetCracker. If the migration project had not been successful, T-Mobile would have had to delay the NetCracker implementation by 12 months. The ability to search and visualise the network topology described by the 20,000+ spreadsheets, provided additional functionality that wasn't part of the original project and also helped to build great confidence in the quality and accuracy of the data. This confidence in the data will help to ensure a successful NetCracker implementation.