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

Gary Bernstein
Digital Transformation Keeping up with the times is now a need for any company since the world is always changing, and this is the reason digital transformation is so important. The cloud plays a crucial ...
Ronald van Loon
Future-Proof Your Data Analytics Environment More than ever, we are seeing companies use data to make business decisions in real-time. This ubiquitous access makes it imperative for organizations to move beyond legacy architectures that can't ...
Jen Klostermann
The Fintech Landscape The Nitty Gritty Although the COVID-19 pandemic has highlighted its existence, most of us have been using fintech in some form or another for quite some time. It’s a big part of ...
Gilad David Maayan
Cloud Security Posture Management Cloud Security Posture Management (CSPM) enables you to secure cloud data and resources. You can integrate CSPM into your development process, to ensure continuous visibility. CSPM is particularly beneficial for DevOps ...
Bill Schmarzo
Mastering the Data Economic Multiplier Effect Note: this blog introduces the concept of the Marginal Propensity to Reuse which is the primary driver behind the Data Economic Multiplier Effect and the Schmarzo Economic Digital Asset Valuation Theorem. The Marginal ...
  • Plural Site


    Pluralsight provides online courses on popular programming languages and developer tools. Other courses cover fields such as IT security best practices, server infrastructure, and virtualization.

  • Isc2


    (ISC)² provides IT training, certifications, and exams that run online, on your premises, or in classrooms. Self-study resources are available. You can also train groups of 10 or more of your employees. If you want a job in cybersecurity, this is the route to take.

  • App Academy

    App Academy

    Immersive software engineering programs. No experience required. Pay $0 until you're hired. Join an online info session to learn more

  • Cybrary


    CYBRARY Open source Cyber Security learning. Free for everyone, forever. The world's largest cyber security community. Cybrary provides free IT training and paid IT certificates. Courses for beginners, intermediates, and advanced users are available.

Cloud Community Supporters

Cisco Logo

Cloud community support comes from sponsorship advertising and collaborative network partnership initiatives.

Contact us for more information on how to get involved in our flexibly priced programs!