How Digital Service Providers (DSPs) can Leverage RPA to Accelerate Data Migration by 2X

Accelerate Data Migration by 2X

Ongoing trends in the Telco/DSP industry such as M&As, migration of the application to the cloud, and modernization of legacy applications have increased the frequency and scope of data migration. According to Gartner, 50% of the data migration initiatives will exceed their budget and timeline by 2022 due to flawed strategy and execution. Most of the DSPs adopt the traditional approach for data migration, which involves three broad steps — migration planning & preparation, establishing governance, and execution.

The execution of data migration using the traditional methods is not at par with the increasing frequency. They follow the fundamental extract, transform, load (ETL) data migration execution methodology.

Major challenges in the data migration execution using the traditional approach are lack of API access in legacy systems, higher cost & time, a lot of re-work due to minor human errors while performing migration activities, high manual efforts in resolving fallouts due to data integrity issues, and difficulty in rapidly ramping-up and ramping-down teams.

These challenges combined with the highly structured, rule-based nature of activities make a clear case for Robotic Process Automation (RPA) to automate the execution of data migration. RPA helps in performing data migration easily from legacy systems lacking API access, using UI-level integration. Ramp-up & ramp-down of bots can be done quickly and it also avoids impact on underlying systems and databases, which makes it a low-risk approach.

This article details how DSPs can adopt the RPA approach for data migration execution with key components such as smart processor, automation bot & fallout management mechanism. Here, we have taken customer account migration as a use case. However, this framework can also be adapted for other data migration use cases.


Fig: Key components of the proposed RPA based framework for data migration execution

Figure-1 illustrates how customer data migration activities are carried out seamlessly. Smart processor pulls account information from various source systems to evaluate and generate a report for automation bots with the details required to perform the migration. Automation bots utilize these reports to perform the migration of customer account and upgrade as per the customer eligibility. Smart processor and automation bots also check for data discrepancies and raise fallouts for the same. We recommend DSPs/telcos to build a mechanism for end-to-end seamless capturing of issues & their resolution. This will help them automate 60-70% of the fallouts. They can also build a dashboard to provide a 360º view of the migration related KPIs in real-time.

How to implement an RPA-based data migration framework to fast-track your data migration programs

In this section we will show you how to implement an RPA-based framework and the key components that need to be built for effective data migration execution.

1) Smart Processor

Evaluating customer data for migration manually is a painful task. Multiple teams are involved in identifying the right scenario (migration/upgrade) based on the customer eligibility, which is a time-consuming process with many iterations. Smart processor evaluates customer data for account migration and upgrades eligibility based on the account information, reducing the manual effort

It pulls account information from various source systems (CRM, billing, inventory, etc.) and evaluates to identify if the customer is eligible for any upgrade services along with account migration. It generates a report (contains account migration & service upgrade data) for automation bots.

The smart processor helps in reducing the lead time by 20% which helps DSPs in improving the customer experience. It also helps in recognizing specific customers who are eligible for a strategic upgrade and provides a customized rate plan, which leads to customer delight. We recommend DSPs to configure smart processors and automation bots to work in an agile and iterative manner that helps to perform the migration with minimal products/data.

Fig: Illustration shows smart processor pulling data, evaluating, and generating a report for automation bots

2) Automation Bots

The automation bot utilizes the report generated by smart processor to perform migration and upgradation activities. It has two different sets of bots as stated below:

Account migration bot – RPA-enabled customer account migration helps overcome the challenges in traditional approaches. Bots connect to the source systems to collect the migration-related data and verify the report data against destination systems. Then it performs the migration post examining the readiness of the destination systems. Once the migration is complete, it validates if the customer qualifies for auto-service/product upgrade, and accordingly, triggers the upgrade bots. Account migration bots reduce 90% of efforts that go into manual order tracking, task follow-ups, report generation, and audit/testing.

Service/product upgrade bot – Steps involved in the manual approach such as identifying the compatible port based on the equipment profile, DSLAM, traffic profile, etc. are complex and time-consuming. At times, negligence in releasing the old facilities or port in the logical inventory induces integrity issues of the inventory systems, which leads to fallouts. These steps can be easily automated using RPA. Bots connect to the source systems and collect the required data and then perform the customer upgrade feasibility study. It analyzes the provisioning system and identifies a compatible facility to perform upgradation and establishes the services.

Similarly, it performs product upgrade by deactivating services from an existing product, creating a new product, and assigning & activating services in the upgraded product. Automation leveraging RPA (advanced GUI & backend database search) in the identification of facilities leads to 60%-time reduction and up to 10% effort reduction by eliminating data integrity issues due to human negligence.

3) Fallout Management Mechanism

This component describes the process of capturing and resolving issues seamlessly along the migration journey. The known issues are automated wherein the bot raises the ticket to the respective team to resolve the issue (60%-70% of fallout handling can be automated). For the unknown issues, humans review the fallouts, prioritize, and work with respective business units to resolve the issues. For better governance, a dashboard should be built to provide a 360º view of the migration related KPIs in real-time.

Fig: Mechanism showcasing end-to-end seamless capturing of issues & their resolution

In Conclusion…

By leveraging the RPA approach for data migration execution with the 3 components presented in this article, DSPs can accelerate migration time by 2X, save OpEx up to 40%, achieve 100% accuracy rate using automation, and enhance the customer experience.

By Ramanan GV

Ray Meiring
Fueled by extensive demand in IT, healthcare, financial services, and telecommunication—initially spurred by the pandemic-driven frenzy to transition to remote working—managed service providers (MSPs) are busier than ever. As businesses adopt MSP services to upgrade, ...
Gary Bernstein
AI-powered identity verification Even if you don’t want to admit it, doing business online in today’s environment poses a greater risk. Criminals are constantly on the lookout for vulnerabilities to exploit, including hacking, data breaches, ...
Ronald van Loon
The increasing adoption of technology and AI in business continues to drive concerns regarding sensitive data and the protection of assets. Organizations must implement tools to protect data while also leveraging that data to identify ...
Nikolaos Nikou
The Future of Enrollment Systems Enrollment systems play a crucial role in various industries, from higher education institutions to online courses and professional certifications. These systems streamline the enrollment process, manage student data, and contribute ...
Cyber Threat Intelligence In an era of rapid digital transformation, we have witnessed a concerning evolution in the cyber threat landscape. Recent data analyses, as illustrated in the "Cyber Threat Intelligence Index: Q3 2023" report, ...
Gilad David Maayan
What Is Object Storage? Object storage, in the simplest terms, is a data storage architecture that manages data as objects, as opposed to traditional block storage or file storage architectures. These objects include the data, ...