End to End Automation for Retail Conglomerate

Location: Bengaluru

Contract Title : Fixed Price Project

Contract Start Date: 1 Mar 2017

Contract Duration:  2 Years

Contract Value:

Client Details:

Customer is a multinational conglomerate based in Dubai, UAE. Client caters to apparel, footwear, consumer electronics, cosmetics & beauty products, home improvement and baby products. The Client has more than 15 subsidiaries aligning to various businesses to serve their large customer base.

Project Scope:

The Client had Oracle Point of Sale (POS) application and an ecommerce portal to manage their retail business and had several scenarios to be tested. Around 10 builds (patches) were deployed every month across all stores. Manual Testing would include barcode reading of various products and validating against predefined values. Each build had to be tested thoroughly before moving into production. Due to the large number of builds and environments to be tested, owing to time constraint, complete testing was not possible. The ecommerce portal was setup with SAP Hybris with the complete order processing platform infrastructure setup as displayed here:

The requirement was to provide a seamless automation solution to reduce on the manual efforts, increase stability and consistency in the test efforts. Some of the challenges observed was:

  • Applications developed using legacy technologies
  • Multiple Enterprise platforms integrated to achieve business goals
  • Tightly integrated Applications for E2E business processes
  • Applications spread across Web, Desktop & Mobile platforms
  • Data validation is required across multiple integrated systems
  • Need to validate the functionality across multiple integrated systems to ensure the business flow
Solution Approach
  • We proposed a customized automation solution which could reduce the overall testing effort. The solution started with a POC (Pilot Project) for 5 test cases and continued on to all the test cases. This single solution catered to effective testing in multiple environments for critical business flows.
  • Automation was planned for 1800 test cases across all platforms.
  • We implemented a customized framework using JavaScript and Test Complete.
  • Framework was designed as to include all major flows.
  • Framework provided a feature to select the scenarios to be executed for every execution.
  • Integrated ADODB with framework for quick fetch of data from excel and database.
  • Implemented methods to achieve synchronization with the application speed.
  • Customized reports generation and delivery for each execution.
  • All findings were reported on an internal Defect tracking tool and the bugs were tracked by the client team.
  • Increased Maintenance Efficiency due to 1 solution covering all – POS, Front end and Back end
  • Significant reduction in overall testing effort per cycle. From 10 Days to under 12 Hours.
  • Automation of entire suite of test case which included different major work flows.
  • Solution designed to take care of test case execution from smoke till regression including functional.
  • Complete testing was achieved for every environment and every build, instead of selective testing (Based on impact of modification) due to time constraints.

Leave a Reply

Your email address will not be published. Required fields are marked *