At Allstate India, I developed an Excel-based demand and capacity planning model to improve workload allocation. It accounts for employee availability, working hours, process demand, and workload requirements.
I designed data-driven allocation logic to balance work against available capacity and process-level needs while supporting SLA adherence. I also tracked availability, service times, and service-level requirements using VBA Macros.
By automating capacity calculations with XLOOKUP, SUMIFS, and Pivot Tables, I helped identify workload gaps and imbalances. This work contributed to a 12% reduction in processing time and a 10% improvement in efficiency.
I bring experience in operational reporting and performance monitoring, along with data analysis training through the Advanced Certificate Program in Data Science at IIIT Bangalore & upGrad.

