1. / American Telecom Company Builds a Data Hub to Take on Load of 2.8 PB
Overview

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. The customer wanted a centralized hub to gather data coming in from its 54.3M customers across the US.

Problem

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

  • Lack of a centralized data hub to support all customer-telecom data analytics 
  • Lack of a solution to monitor the performance of the telecom network in real-time
  • Lack of a system to collate data from switches provided by various vendors for network capacity planning and performance monitoring
Solution

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:

  • A full-scope enterprise data warehouse-BI application with data modeling, ETL, cube, and a reporting framework.
  • 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
  • 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
  • An end-to-end ETL solution that ingests data into Hadoop as well as on landing TD tables and Splunk dashboards
  • Pushing customer and demographic services data into Snowflake cloud data warehouse, building Snowsql reports and Chartio dashboards
Impact

The comprehensive solution we created for the customer generated many benefits, such as:

  • A centralized data store which functions as a single version of the truth that helped in operational performance improvement and faster data processing
  • Capability to handle an incremental data load of 2.8 PB
  • Migration to a more scalable Teradata and Hadoop platform to meet growing data demands in a cost-efficient manner

Other Case Studies
Emergency Department – Coding Improvement

Case Studies

Emergency Department – Coding Improvement

Learn how we assisted a leading revenue cycle management services company in the United States in identifying opportunities to improve documentation while also modifying and automating its reconciliation and quality procedures.

US-based Physicians Group Improves ROI by 6X

Case Studies

Healthcare & Life Sciences
US-based Physicians Group Improves ROI by 6X

Learn how we helped a large physicians group based in the US use deep learning models to improve error identification by 3x and reduce financial leakage by 40%.

German Automaker Labels 12M Objects per Annum from Street Videos

Automotive & Manufacturing

Automotive & Manufacturing
German Automaker Labels 12M Objects per Annum from Street Videos

Discover how we helped a German engineering firm automate video labeling for their autonomous vehicle project to identify street objects and their location with over 82% accuracy.

Financial Advisor Gets Retirement Benefits Calculator to Predict Over 30 Years Ahead

Case Studies

Financial Services & Insurance
Financial Advisor Gets Retirement Benefits Calculator to Predict Over 30 Years Ahead

Discover how we helped a financial advisor offering online investment advice evaluate the feasibility of their retirement plans 30 years into the future.

Let’s head to the apex

Get in touch and let’s start a conversation!






    banner_side

    © 2021 Apexon. All Rights Reserved.