Operations Grant Database
An Excel and Power Query data platform that unified fragmented grant sources into a reporting backbone with 45+ interconnected pipelines.
← Back to work projects
Grant Evaluation Workflow Automation
A Power Automate Desktop and JavaScript workflow that extracted evaluation data from a legacy web system and eliminated roughly 320 hours of manual work per run.
About this project
The situation
A legacy web process required a team of four to re-enter evaluation data over roughly two weeks.
What I built
I built a Power Automate Desktop workflow that navigated the system and used JavaScript to extract the needed data.
Why it mattered
The workflow removed the manual entry bottleneck, improved consistency, and made on-demand extraction repeatable—about 320 hours of manual work per execution.