Success Story Telecom

American Telecom Company Builds a Data Hub to Take on Load of 2.8 PB

Creating a Centralized Data Hub for Telecom

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 challenge

3 key areas

An initial assessment of the customer’s existing infrastructure revealed a few challenges:

Increasing Costs

Collating Data Lack of a system to collate data from switches provided by various vendors for network capacity planning and performance monitoring

Poor Engagement

Monitoring Network Performance Lack of a solution to monitor the performance of the telecom network in real-time

Centralized data hub solutions

Centralized Data Hub Lack of a centralized data hub to support all customer-telecom data analytics

The solution
5 key areas

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:

Cubes Designed & Built

Cubes Designed & Built

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

Binary Files Data Extraction

Binary Files Data Extraction

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

Customer & Demographic Services Data

Customer & Demographic Services Data

Pushing customer and demographic services data into Snowflake Cloud data warehouse, building Snowsql reports and Chartio dashboards

Full-Scope Enterprise Data Warehouse-BI Application

Full-Scope Enterprise Data Warehouse-BI Application

A full-scope enterprise data warehouse-BI application with data modeling, ETL, Cube, and a reporting framework

End-to-End ETL Solution

End-to-End ETL Solution

An end-to-end ETL solution that ingests data into Hadoop as well as on landing TD tables and Splunk dashboards