quick inquiry

Telco Analyzer

Data analytics and Recommendation solution for telecom customers.

  • Development time

    18 Months

  • Resources involved

    6 Professionals

Overview

A prominent telecom company needed assistance in building their customized product for data analytics and recommendation tool using big data tools.

The primary goal of the system was to transform the existing system's data to newly developed scalable system for better analytics.

Business Goal

Consolidate the data generated from various sources using Distributed Messaging Queue.

Optimize the extraction and data loading process and stage the data in columnar database.

Perform aggregation of data from columnar database to data warehouse.

Perform analytics on top of data warehouse using distributed SQL queries.

Customize the ETL product as per requirement.

Challenges

There were multiple challenges while developing the solution like,

Collecting & processing massive amount of CDRs.

Providing fault tolerant searching solution on top of massive amount of data.

Delivering minute level in depth data analytics on top of millions of records.

Solution

The high level flow diagram of our proposed system is shown below.

System architecture

  • We provided consulting services to the client data warehousing initiative. We reviewed the data source systems, and data structure needs. Based on the client's requirement, we developed ETL product using various prominent Big data tools.
  • We administered cluster for development, testing as well as deployment and also helped the client to tune the cluster for optimized performance.
  • Tested the product with different load for stress testing and performance testing. Our staff is also responsible for performance tuning of ETL processes. We also implemented new capabilities like bulk loading the data to optimize the load in ETL processes.

Technologies

Implementation

We followed an iterative model approach to implement the solution that included the following phases:

Business requirements analysis.

Architecture design.

Developed the ETL (Extract, Transform and Load) Suit.

Road map

Requirement Analysis
  • Brainstorm
  • Innovation
  • Research
  • Resource planning
Architecture Planning
  • Architecture Design
  • System Prototyping
  • Documentation
Development
  • Back end development - Utilities for Aggregation, Transformation, Data cleansing, etc.
  • Front end development.
Quality Testing
  • Quality Assurance
  • User Acceptance Testing
Deployment
  • Production
  • Evaluation

Business Benefits

The system delivered various benefits to different teams of organization in visualizing the end to end data as well as troubleshooting various aspects from engineering, finance, technical, IT etc.

Our solution delivered performance gain upto 14% and various new features which were requested by various customers as well as in house teams.

Got idea in mind?

Let's Talk

Contact us for your business needs anytime and our support team will be available to you 24 * 7 to answer your queries.