Performance tuning for an American retailer


Client An American retail company & second-largest general retailer 
Client Requirement Performance tuning of one their business critical reporting application
Duration 60 Working Days
Client Location Cincinnati, Ohio, USA
Mode of Engagement  T & M
  • One of the business critical application was having lot of dashboards which in turn providing various stats related to business
  • These reports were directly used by higher management including CEO & CFO
  • However many of the reports were taking too much of time to load the data or sometimes it used to break
  • Hence business was not getting data in time & was unable to take proper decision on time
Test Yantra Solution
  • Redesigned the way they were storing the data without affecting the existing data storing logic
  • Identified critical data & made sure that they can be easily accessed by application
  • Created various procedures which fetches the data in most efficient way
  • Implemented various Data Structures & Algorithms in business logic to display the data in less amount time
Technologies used
  • Oracle PL/SQL
  • Java 
  • Hibernate
  • Google Guava

Leave a Reply

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