Timesheet automation and workforce planning at LERMA/
- Problem
- Several people spent real time every week pulling timesheets by hand out of Webvantage/AQUA and pasting them into messy Excel. And the allocation plans built on top of that mess could only be adjusted once a year.
- System built
- Automated API ingestion of timesheets, feeding a live Metabase dashboard self-hosted on GCP with RBAC for the CFO and 1–5 department heads. I built most of it solo. A dev on my team finished the dbt modeling, which is how a team is supposed to work.
- Impact
- Agency-wide time logging for workforce planning. The CFO and I added quarterly metrics that line up logged hours against planned hours, which replaced a once-a-year spreadsheet exercise everybody dreaded.