Client: Source8 is a leading IT company that is part of a $ 2 Billion group and specializes in providing service to the Government. The client requirement was to have an efficient Performance Review process to reward their top performers.

Solution: The challenge was Data consolidation due to varied geographies and differences in Time Zone and reports for various countries had to be based on unavailable parameters. Sagacity analyzed all databases and studied the underlying schema structure to consolidate the data into 5 repositories. Database repositories were created based on the application version which was running at various data centers. Customized ETL application was developed to collect data from various databases and a reporting solution was developed using the Jasper report tool as per performance metrics provided by the client. Data was growing with a rate of 3 GB per day and processing time was critical as a window for processing data was only 4 hours, so we zeroed in on using Cloud services. File-based data transfer was developed to ensure the fast processing of data at the file system level. This Reporting solution was available to management to pull reports at run time. The application helped to give a single view to management about the performance of individuals in various regions, Accuracy of reports increased to 99%, report generation at any given date for last one year and viewed anywhere as required, also helped in reducing the operational costs.