Description
Well-versed in developing and implementing the databases, data collection systems, data analysis and other strategies that optimize statistical efficiency and quality. Competent in set up and maintain automated data processes, identifying, assessing, and implementation of external services and tools to support the validation of data, along with producing and monitoring the key performance indicators.- Performed Reprocessing of electrical data for 2 fast food databases to reconstruct dataset so that electrical consumption can be validated on a monthly basis
- Executed the validation of data for 183 banking stores to accumulate the data related to the electrical consumption that exceeded than ±5% from the normal range
- Executed 80% of the site onboarding into the platform in accordance with the requirements of the client
- Handled the automation of the DDL & DML PostgreSQL queries for client stores using Excel to achieve 100% efficiency
- Monitored and maintaining 2 applications, 5 fast food, 3 retail, 2 gym, 2 banking databases data availability daily, weekly, and monthly
- Implemented advanced excel text functions for producing unique Site IDs and device data for 472 fast food, 22 gym, 24 retail client stores, along with using the PostgreSQL for uploading the same into provisioning server
- Conducted User Application Testing for monitoring the data & bringing down the numbers of change request instances on monthly basis to null from an internal team while recognizing the issues before escalation from platform support
- Produced status reports on application health on a weekly basis, along with the data availability health to be conveyed to the associated shareholders and working together with the cross-functional 10+ member teams
