Built and updated internal websites at the NYC Office of the City Clerk with new features, data pipeline improvements, and bug fixes. Changes were informed through shadowing employees and conducting in-depth requirements interviews. Any bottlenecks, inefficiencies, and frustrations that were noted were accounted for in updates.
Several changes involved the structure of the databases themselves (MongoDB and MySQL). Uncleaned, inconsistent, and poorly organized data was cleaned, normalized, and restructured to allow for the implementation of new site capabilities. Points of data entry were rebuilt to ensure improved data validation and consistency; these tasks required careful consideration regarding UI/UX so as not to interrupt established workflows.