| 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 |
Challenges
- 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
