Multinational professional services company with specialization in IT consulting and system integration and application outsourcing. European country branch.
Project and resource management for 300+ FTEs department, including 30+ managers and team leads.
900+ data points are collected weekly.
Internal scheduling portal with poor UI/UX.
Tools: Emails, Scheduling web portal, Power BI, SharePoint, Excel
Resource management operations team: 3 FTEs
1 FTE solely for manual data requests and receiving, summarizing resources data
Lack of timely responses from managers/team leads. Need lots of reminders.
Need to process responses manually because answers are not structured.
Missing data, not timely data.
Manual data processing from emails to the database for analysis in Power BI.