Automated Workforce Utilization Tracking Tool

● Challenge: The organization needed to optimize resource allocation and improve
productivity forecasting by eliminating underutilization of its workforce.
● Solution: I designed and automated workforce utilization dashboards by creating data
pipelines in BigQuery. This tool provided a clear, department-wide view of resource
allocation.
● Impact: The tool optimized workforce management, leading to a 7–10% increase in
billable utilization, which translated to over $2M in additional annualized revenue.