Optimizing Resource Utilization and Capacity

A resource utilization analysis and capacity model building project was done at a third party provider of financial services. They service multiple clients and have a mix of both onshore and offshore employees engaged in different tasks for these clients. The objectives of the project were to analyze current utilization through time sheet entries to identify inefficiencies, areas of over and under utilization and to develop a dynamic capacity planning model aligned with demand forecasts. Solutions involved collecting and analyzing historical data on staffing, time spent on different activities and demand patterns, then creating a predictive capacity model using analytics tools like Python and Power BI. The project resulted in improving resource utilization from 79% to 87% and optimizing the head count requirement for the clients leading to realization of saving of 27 FTEs.