• Initiated development of scripted reports built to meet specific needs of executives.• Analyzed data to develop deployment plans aimed at addressing agency and industry concerns.• Conducted code reviews with programmers in different units to ensure correctness, identify alternative methods, and maintain consistency.• Analyzed data and presented findings using Excel, SQL, SSMS, Python, and R.• Developed dynamic dashboards in Tableau to visualize individual and squad effectiveness.• Oversaw the education and technical skill development of 3 employees, ensuring they effectively learned and used Excel, Python, R, SQL, and SSMS.• Optimized ad hoc reporting by more than 90% while providing cleaner results and reports, improving transparency, and reducing turnaround times.

• Established a reproducible coding framework for the unit’s Workforce Profile Report, reducing the time needed for data analysis from several months to a few hours.• Analyzed data and presented findings using Excel, SQL, and R.• Wrote layered SQL queries using complex joins, groupings, aggregation, and nested queries.• Optimized ad hoc reporting while increasing flexibility of reporting capabilities.

• Analyzed data and presented tables, charts, and dashboards using Excel, SQL, and R.• Developed a matching algorithm to match mentors and mentees during the recruitment process, thus increasing the amount of time matched pairs could talk and meet prior to the FDNY Training Academy.• Developed several models predicting the performance of FDNY Probationary Firefighters at FDNY Academy, allowing leaders to ensure adequate resources would be available.• As Open Data Coordinator, arranged for leaders in the open data community to speak with FDNY executives to guide agency’s efforts towards establishing a data governance policy.• Coordinated a Hackathon with several NYC colleges and universities to gain insight into what students and data professionals would be able to produce from a sample of FDNY data.

• Analyzed data and presented findings using Excel and STATA.• Developed analyses investigating issues of gender and ethnic discrimination in faculty salaries.• Developed analyses predicting academic outcomes of incoming students as a result of demographic characteristics.