Telecom Case Studies
Confronted With Latency Issues Within Their Key Infrastructure
Client: A large Telecom group with more than 170 million customers in 5 continents
Challenge
The challenge was to engineer a scalable Data Warehouse solution in a way that set the standard for all future Data Engineering initiatives and to boost the client’s ability to deliver business intelligence into the organisation.
Solution
The client mobile Data Warehouse was a brownfield site with a complex technical and organisational environment. Elait set up the architecture framework, the process framework, and an internal team of application specialists who helped create templates upfront to enable rapid development of ETL code for the warehouse application.
Elait rebuilt the interfaces, set up standards and the structure for application maintenance in terms of development processes, testing processes, standards, governance around the tools, and change control procedures.
Outcome
The scalable Data Warehouse architecture was organised to enable the customer to quickly and efficiently expand by adding more hardware.
Elait helped totally transform the speed of moving data around. A day’s worth of data now runs in a quarter of the time it used to take.
Track Customer Connections & Derive Business Intelligence For Campaigns
Client: Large Telecom corporation with more than 26 million customers
Challenge
A greenfield project where terabytes of data were migrated from one Data Warehouse to another. Re-architect data stored in earlier systems to new Data Warehouse to enable a customer-centric model.
Solution
Elait setup a new Data Warehouse, migrated data from the inherited Data Warehouse to the new one, and upgraded infrastructure and application from legacy estates to contemporary systems.
Outcome
- The data processing time was significantly improved. Report processing times we reduced from two to three days to a few hours.
- Earlier information stored in the Data Warehouse was based on the mobile phone number making it arduous to track customer contacts. The new Data Model was customer-centric, and hence the client was able to improve their campaign strategies. By establishing connections with customer contacts, the client was able to promote their brand schemes to a wider audience and improve their customer base.
- Earlier, the raw data collected from invoice data was sent to an external agency to derive Business Intelligence. Through the new model, the client was able to build his own Business Intelligence from the data, saving significantly on outsourcing expenditure.
Migration Of Current Data Integration (Primarily ETL) Code From Windows To UNIX
Client: A Telecom major from the Middle East
Challenge
Migrating large amount of data from multiple data sources, optimise memory utilisation and implementation of the appropriate aggregation approach according to complexity and data size.
Solution
The proposed architecture allowed for the recycling or exclusion of data that was deemed to be invalid or failed to meet data quality measures.
At strategic control points throughout the ETL process, audit data such as record input count the output count, and rejected count was captured and stored in audit tables to facilitate operational route cause analysis, reconciliation, and trend analysis. The Data Integration ETL collected Log information across every flow and transformed process to ensure all the graph level operational statistics are collated.
Error handling was designed to categorically explain the cause of data rejection, expedite problem resolution via comprehensive, unambiguous, and consistent information, in addition to the ability to raise alerts according to error severity.
Outcome
The architecture reduced development time and cost, had reusable components and processes that allowed the client to build once and reuse many times. This also resulted in reduced effort, decreased risk, minimal defects & incidents, and significantly fewer maintenance incidents.
Standardise Processes Across The Client's Data Engineering Estate
Client: Prominent Telecom major from Europe
Challenge
- To drive strategic direction, foster best practices and to encourage synergy between all BI projects across the account based in the Netherlands, Poland and India.
- To provide architecture, estimation, design, establish processes and technical direction along with quality assurance reviews for the cross location implementation.
Solution
- Elait led the architecture workstream and implemented process improvements for estimation, requirements gathering, design, coding, peer reviews, configuration management, testing and operational support.
- Designed ICFF (Indexed Compressed Flat Files) Data Distribution Layer to validate and publish batch and continuous flows data for multiple subscriber systems.
Outcome
- Process improvements ensured faster and better quality deliverables, reduced defects & production incidents. This resulted in significant cost benefits, improved customer satisfaction and vendor-client relations
- The Data Distribution Layer enabled code and data reusability, thereby decreasing space consumption, improving performance and reducing total cost of ownership via lower delivery costs, timescales and maintenance overhead.
- The Metadata Hub enabled end to end data lineage, reliable impact assessments, expedited support and cost reductions in project delivery.