Mayoral Fellow

June 2022 - August 2022

• Consulted with three different city departments on improving oversight of regulatory requirements of private waste companies operating in Chicago

• Created Django-based web application for monitoring private waste haulers and submitting hauler reports; deployed SQL queries to extract data; was leveraged as a prototype for a larger city-wide monitoring application

• Developed analysis report on the impact of expanding Chicago's snow removal program using GIS data on streets, chloride content in waterways and budget estimates; was used to inform winter snow operation decisions

• Reported on the impact of various city initiatives and programs leveraging ArcGIS maps, built Tableau dashboard to showcase Chicago's covid recovery in comparison to other major US cities

• Prepared key recommendations for suitable database software for effective data management of tax increment financing projects in the city, by conducting in-depth discussions with three budget staff on user profiles and reporting needs