Software Testing and Quality Monitoring of a Complex Data Migration Project for an International Retailer
Business, ecommerce testing, POS Testing
September 30, 2020
Data migrations are a critical part of digital transformation projects. Business modernization imperatives drive system upgradation decisions. Situations such as the Covid-19 pandemic has forced companies to adopt online technologies that necessitate migrating data into the new systems or share with external applications. The complexity of the systems and the quantity of data impacts the degree of risk involved in such projects. Risk containment and opportunity development are at the core of system migrations.
Data migration experience in a retail business project
A fast growing retail chain with operations spread across Middle East, Asia and Far East was in the midst of a system migration and modernization project, when the Covid-19 pandemic struck and added to the implementation challenges.
Qapitol QA had the opportunity to partner with the company for its quality engineering initiatives because of our expertise in working with identical systems and prior experience in retail system migration and modernization projects. The following sections describe the quality assurance & testing challenges and the automation solutions provided.
Project Type: Data migration
Systems involved: SAP Hana, Azure SQL server, SAP Commerce Cloud, IBM Power System
Target Countries: GCC, India, Far East (Indonesia, Malaysia, Singapore)
Challenges in migrating legacy data
As part of the transformation requirements, the client had migrated a database from SAP Hana to Azure SQL Server and had also upgraded SAP Commerce Cloud CCV1 to CCV2.
QA practices were not fully established and testing was being performed in silos.
The requirement documents were ambiguous and no documentation was maintained for testing the end to end functional flows of the application.
There was limited test coverage across end to end workflows and for third party integrations such as with Payments and Vouchers apps.
The performance of the system was not validated nor was user-experience testing performed
Establishing quality engineering processes for testing and monitoring applications and databases
The Qapitol QA team gained a comprehensive understanding of the requirements and business logics by closely coordinating with client’s business development teams.
The team established a knowledge management repository by documenting comprehensive functional requirements in various formats.
Streamlined testing processes by analyzing gaps and implemented QA best practices.
Created reusable test assets such as for test strategy, test plan, test cases, checklists etc.
Performed comprehensive functional testing, UI testing, localization analysis, cross-browser testing covering the all the application modules – Order Management, Returns, Refunds, Payments, Vouchers, Stock management, Delivery models and more.
Verified functionality of mobile applications across nine Android & iOS devices.
Built region specific (GCC, India, Far East) regression test suites.
Developed and executed performance test scripts using Jmeter. JMeter is a software that can perform load test, performance-oriented business (functional) test, regression test, etc., on different protocols or technologies. (https://jmeter.apache.org/)
Conducted multiple load test runs with various load patterns (500, 1000, 1500 concurrent users) and identified baseline response times.
Identified performance bottlenecks of both web & mobile application and provided recommendations.
Business modules and system components tested
Hybris Back office
Order Management System – Search, Navigate, Product selection, Wish list, Discounts, Ratings, Cart, Checkouts
Stock Management System
Delivery Models – Click & Collect, Home Delivery, Essential Delivery