Back to hub
project

Oracle implementation success: enabling product data transformation for online retailer

To modernise product onboarding and meet rapidly evolving customer demand, the UK’s largest home shopping retailer implemented Oracle PIM as part of a major transformation. Roq’s expert consultants provided delivery-critical testing support, de-risking every phase- from data validation to performance testing -and ensuring a seamless launch of this complex enterprise system.

OUR CLIENT 

Our client is one of the UK’s leading online and home shopping retailers, with over £2 billion in revenue and more than 5 million active customers. With a trading history spanning more than a century, the company continues to evolve its retail technology to meet growing demands across its diverse customer base. 

THE CLIENT CHALLENGE 

The client was implementing Oracle PIM to replace legacy product information systems. Key challenges included: 

  • Legacy systems were no longer able to meet the increasing pace of product onboarding and visibility across sales channels. 

  • Existing platforms were difficult to maintain and access across core departments, such as Buying and Merchandising. 

  • The business required high confidence in data quality and interface performance across complex upstream and downstream systems. 

  • There was a need to fully test and assure both functional and non-functional performance across all business and technical layers. 

WHAT WE DELIVERED 

Roq supported the programme  with its Delivery Augmentation solution, embedding testing expertise across each phase of the implementation: 

  • Led functional testing of the new Oracle PIM interface and supporting business processes, including system, end-to-end, UAT, and regression testing. 

  • Conducted rigorous validation of data migration processes, including pre- and post-validation of seeded test environments, ensuring synchronisation across systems. 

  • Delivered Operational Acceptance Testing (OAT), designing and executing automated test scripts using Quick Test Professional, supported by performance testing using LoadRunner. 

  • Coordinated closely with business sponsors to develop reusable, scenario-based test scripts across all major business domains, including Merchandise and Insurance & Warranty. 

CLIENT IMPACT 

Roq’s embedded consultants provided the flexibility and expertise needed to support the successful delivery of a high-risk transformation: 

  • Ensured a reliable, consistent approach to functional and non-functional testing across complex, integrated systems. 

  • Reduced risk by engaging business sponsors early, enabling more accurate and reusable test design tailored to real-world processes. 

  • Delivered robust data validation processes that preserved integrity across upstream and downstream platforms. 

  • Established a structured testing foundation to support future phases and scale confidently across post-project testing. 

To find out how Roq’s Delivery Augmentation solution can support your business, contact our experts at ask@roq.co.uk

Share

Start speaking to one of our experts