Success Story High Tech
American Telecom Company Builds a Data Hub to Take on Load of 2.8 PB
Large enterprises need better visibility into their data – it needs to be of good quality, accessible from any of their centers, and capable of being monitored in real-time.
This American Telecom company wanted a centralized hub to gather data coming in from its 54.3M customers across the US.
The comprehensive solution we created for the customer generated many benefits, such as:
An initial assessment of the customer’s existing infrastructure revealed a few challenges:
Collating Data Lack of a system to collate data from switches provided by various vendors for network capacity planning and performance monitoring
Monitoring Network Performance Lack of a solution to monitor the performance of the telecom network in real-time
Centralized Data Hub Lack of a centralized data hub to support all customer-telecom data analytics
Apexon devised an end-to-end solution to cover all bases for the customer’s data pipeline using Ab Initio, Informatica, Hadoop, Splunk, erwin Data Modeler, Tableau reporting, and more technology. The solution includes:
Various cubes designed and built with the right partition, aggregation, and caching strategies to carry out trending on capacity, performance, and compliance of network stats
Data extraction from binary files in mediation servers, checks for data gap and quality in the multi-threaded mediation and ETL stage of the data cycle
Pushing customer and demographic services data into Snowflake Cloud data warehouse, building Snowsql reports and Chartio dashboards
A full-scope enterprise data warehouse-BI application with data modeling, ETL, Cube, and a reporting framework
An end-to-end ETL solution that ingests data into Hadoop as well as on landing TD tables and Splunk dashboards
