EVRY India was engaged in providing a solution for a retail customer, an American multinational corporation that runs a chain of large discount department stores. The customer faced issues such as dissatisfactory results obtained through BI reports, high resource consumption such as CPU & input/output, and high transaction response time.
The challenges in delivering an ideal solution to our customer involved – designing a single global Enterprise Data Warehouse design from multiple source systems’ data, enablement of multi-currency support, multi-lingual systems & spread over different geographic locations, accommodating multiple financial years of different countries in a single model, minimal support from the business team, inaccurate or non-availability of documentation, and unavailability of the engineering team during the design phase.
All the above solutions were implemented against the test database, which resulted in enhanced query response time and resource consumption. The solution implementation was complete before deploying them into the production environment. Further, the production data with test database was synchronized using Teracopy and loading utilities. Also, we identified and redesigned the PI (Primary Indexes) to reduce HOT AMP operation.
The customer benefited tremendously with our solution through better transaction response time (70% improvement in response time), up to 70% improvement in CPU & I/O utilization, quick turn-around time for its Business Intelligence reports, increase in end-user productivity & efficiency in decision making, greater acceptability in using the reports by end users in decision making, increased tasks loading capacity, augmented number of concurrent users & queries, reduced wait time for users, and decreased resource utilization, CPU consumption & I/O costs.
About the Customer
The retail customer, along with operating an extensive chain of department stores also maintains a chain of warehouse stores. The customer runs more than 8000 stores across the world. Its hassle-free merchandising division ensures that products are constantly available to consumers across all its retail outlets, primarily through planning, stocking shelves and displays.