Operations Grant Database
An Excel and Power Query data platform that unified fragmented grant sources into a reporting backbone with 45+ interconnected pipelines.
A Power Query rules engine that translated federal and state policy into a repeatable Title I comparability review workflow.
A statewide federal compliance process required specialists to apply detailed policy rules across a large set of districts.
I translated federal legislation and state policy into a structured Power Query evaluation engine.
The workflow filtered out more than 70% of districts automatically and saved approximately 750 specialist hours annually, leaving experts to focus on complex cases.