How Hexaview Addressed Data Management Efficiency of a Telecom Company using Big Data Analytics?

About The Client

A global leader in telecommunications, with over 30 years of experience in the development of network communications solutions. The company's offerings include 2G, 3G and 4G wireless services, mobile commerce, fixed line services, high speed home broadband, DTH, enterprise services including national & international long-distance services to carriers.

Case Overview

Our client is an esteemed US-based telecom company operating in 45 states. They are one of the nation’s largest telecommunication and internet providers to residential customers and businesses. They were dealing with huge databases daily and managing them was difficult for them.

Client's Challenges

Our client was facing challenges in storing and parsing their database every day. With more than 200-300 GB of data being handled daily, this was no small task and involved a vast amount of data handling. They needed to generate and analyze accurate KPIs like Signal Strength, RSSI, RSSQ, Download KPI, Upload KPI, and the Initial connection to provide a better customer experience.

The client’s traditional data warehousing infrastructure was expensive and could not accommodate the speed or size of their telecom’s data. It was a serious challenge in terms of how to grow and scale. The need was to implement a data management and analytics platform to let the client collect the data from multiple sources and get precise insights.

Hexaview's Solution

To meet the client’s need, our data science team developed a big data analytics warehouse system utilizing Hadoop HDFS, Impala, and Spark.

Utilizing the parallel and distributed computing capability of Spark and Hadoop, our team designed an ETL system to parse and load the data in the live warehouse. Also, we leveraged the Cassandra system for Adhoc live insights by the telecom engineers.

As the client expected that the number of users would be constantly growing, the solution was to be easily scalable to store and process an ever-increasing amount of data.

Technology Stack

  • Backend: Java, Scala, Cassandra, Kafka, Spark, Hadoop, Impala  
  • Frontend: ReactJS, High Chart  
  • Libraries: Spring Boot, SparkSQL, Spark Streaming  

Amount of Data Handled

  • Around 200-300 GB of raw data from OSS is gathered & parsed. The parsed data is stored in Warehouse.  
  • One-month live insights reporting producing 2 TB live data in warehouse and petabytes of cold data in analytics warehouse.  

Impacts

  • Our solution reduced the overall data parsing and the report generation time to 14 hours.  
  • The client can now analyze the anonymized data produced by billions of networks which can provide insights into the issues being experienced by their customers and allow the operator to invest in areas that can improve the experience of customers as fast as possible.  

About Hexaview

A digital transformation firm focused on providing Technology Consulting, Development Centre, Captive as a Service with an innovative approach and latest technology. With both financial and technology insights, Hexaview Technologies endeavors to provide secure, optimal, and quality solutions to your unique business requirements.

  • Area of Specialization: Salesforce, Big Data, AI & ML, Cloud Computing, Business Intelligence.
  • Our flagship Products: ReportWa, PDF Extractor, and Video Statements enable data visualization and automation in reporting as well as data extraction.

Contact Details

hexaviewtech.com

hello@hexaviewtech.com

+1 (646) 403 4525

Cookie Preferences