hamburger hamburger

Executive Summary

Lycamobile, one of the leading mobile virtual network operators (MVNO) in the UK with a presence in over 23 countries, sought to undertake a business transformation project. They were looking to migrate their traditional onpremises infrastructure to a cloud-native architecture to gain the benefits of scalability, flexibility, and improved cost models. Lycamobile specifically wanted to adopt a cloud-based data warehouse, which would enable them to deliver use cases much more quickly and allow their MIS teams to deliver consistent and frequent reporting.

Customer Challenge

Lycamobile’s traditional data systems operation created many technical challenges. Because of their dependency on legacy on-premises systems such as SQL server, there were limitations when handling petabyte scale data. Data from multiple disparate sources posed a difficulty to maintaining optimum data quality and a single source of truth. This led to an improper implementation of data governance and GDPR rules. Additionally, having data from multiple sources challenged them with a limited time window for processing. It was also hard to maintain the Data Catalog and Metadata management across more than fifteen global source systems.

Why did the customer choose AWS and Cloudwick?

The client chose AWS as its preferred cloud provider because of AWS’s singular capabilities supporting scalability, agility, speed of business transformation, serverless architecture, and data warehousing. Further, AWS’s extensive partner ecosystem offered a large selection of providers of managed services. Once AWS was chosen as cloud provider, Cloudwick Professional Services consulting teams engaged with Lycamobile leadership to vet the project. Cloudwick Solution Architect teams engaged with business stakeholders to scope the project and Cloudwick Engineering conducted discovery workshops for every phase of the project. Cloudwick’s competency in building AWS data analytics platforms and subject-matter expertise were critical to winning the project.

The Cloudwick Data Lake/Data Mart Solution on AWS

Cloudwick Professional Services implemented a fully operational centralized data lake and data mart solution in the AWS cloud. Cloudwick provided an endto-end cloud data solution comprising Data Ingestion, Data Modelling, Data Governance, Master Data Management, Data Security, Dashboarding, and the enablement of AWS services for predictive analysis. The solution enhanced the speed and quality of business decision-making capabilities for Lycamobile with state-of-art cloud technology.

Data governance & data security implementation was a crucial part of the whole implementation scheme. The Cloudwick team maintained industry best practices and standards to ensure data security on the AWS cloud platform. A very detailed regime of Master Data Management was a highly desired and key part of the solution to elevate ongoing business capabilities.

Cloudwick implemented the data model for the integration and aggregation layer for multiple domains to facilitate quick on-demand reporting, query, and data analysis structure. For reporting and data visualization, the customer chose to use Amazon Quicksight to build business partner reports. Cross functional reporting and data visualization with access controls on Amazon Quicksight has been a very effective tool for Lycamobile business partners from across the globe.

Lycamobile Data Architecture

Lycamobile-Data-Architecture-img
ELT-and-Analytics-xs

AWS Services Used

The Amorphic solution is deeply integrated with the AWS ecosystem, leveraging over 80 native AWS services. Some of the key AWS services used include:

ELT-and-Analytics-lg
ELT-and-Analytics-xs

Results and Benefits

  • Enhanced Business Capabilities
  • Advanced Technical Capabilities

Enhanced Business Capabilities

Cost and Revenue
Analysis

Lycamobile gained very detailed insight into their costs and revenue, while simultaneously enhancing their analytical capability.

Churn
Analysis

By migrating Lycamobile to the AWS cloud, Cloudwick Technologies Professional Services helped thecustomer gain clear and detailed insight into its churn statistics, enabling issue tracking and spurring the adoption ofsubsequent corrective business strategy.

Average Revenue Per User
(ARPU) Analysis

The resulting cloud environment allowed the customer to develop a detailed ARPU analysis based on multiple matrices across different domains.

Advanced Technical Capabilities

Reduced Average
Query time

The average query time was reduced from 4.5 hours to 5 minutes. (The average query time comprises the time required to accumulate data, to query data, and to produce data on dashboards).

Single Source of Truth / Master Data Management

Cloudwick Professional Services implemented fine-grained datamodeling to maintain ‘Single Source of Truth’ in Lycamobile’s data from multiple domains. An effective Master Data Management strategy helped in achieving this.

Enhanced Data Quality & Governance

Cloudwick enhanced Lycamobile’s data quality and governance with a fine controlled, transparent, and well-monitored data flow program managed through a centralized framework. A detailed framework of data lineage & governance worked as the key to ensure a rich data quality in the source of truth.