The purpose of the project was to provide a holistic view to identify top performers and to give incentives to appreciate their efforts. This required consolidating of data to 5 database repositories as per selected region, from 180 databases spread across 180 countries. A Reporting solution was created by Sagacity on top of these repositories. Generated reports from the reporting solution provided all the performance metrics to the higher management.
A leading IT company which is part of a $ 2 Billion group and specialize in providing service to Government.
Management was looking for an efficient Performance Review process to reward their top performers. The current reports being generated were not able to effectively highlight top performances based on metrics across regions. In absence of Reporting solution, reports were being shared over e-mails from various regions which was not an effective way.
We analysed all databases and studied underlying schema structure to consolidate the data into 5 repositories. Database repositories were created based on application version which was running at various data centres. Customized ETL application was developed to collect data from various databases. Reporting solution was developed using Jasper report tool as per performance metrics provided by client. Data was growing with rate 3 GB per day and processing time was critical as window for processing data was only 4 hours, so we zeroed in on using Cloud services. AWS cloud was used to ensure horizontal scalability and ease of sourcing infrastructure. File based data transfer was developed to ensure fast processing of data at file system level. This Reporting solution was available to management to pull reports at run time.
© 2019 sagacity . All Rights Reserved.