Automation through creation of single Dashboard – Vasudevan Iyer

Initiator: Vasudevan Iyer Problem Statement: The business was not able to identify missing files from a daily set of Finance feeds that should load into Magellan DB (LSEG’s Post Production Reporting Platform) and no alerts or notifications were provided for such missing files. Solution: A solution was provided to identify the files which are not loaded for the given day by creating a SSRS dashboard report “Magellan Audit Report”. The report gives out the status of the files based on the patterns for daily files in the “magellanloadqueue” database table, active for the given timeframe so that the file patterns are dynamic. The earlier manual activity which took around 2 hours at least to identify and fix missing files was reduced to just 5 minutes with the introduction of this dashboard report on UAT and PROD environments. This report has been successfully implemented in UAT and PROD environments. Savings: 1. The report gives out the missing files for the day which saves a lot of time in troubleshooting. 2. Helps support team to monitor and reload the files and helps minimize post production data issues. 3. Cost Savings of USD $ 36,432 / – annually. Avg No of hours per day spent in analyzing missing files manually= 2 hrs Avg No of hours in a year = 22 * 12 * 2 = 528 hrs Avg cost per hour for 1 onsite resource = USD $ 69/- Avg Savings Annually = 69 * 528 = USD $ 36,432/- https://hexaware.com/