Katie Schwipps Email & Phone Number

• Provided technical support to validate and troubleshoot client’s database concerns, utilizing SSMS• Served as the liaison between database developers, the sales team, and account managers to provide project scoping and management, and technical product expertise • Led the creation of a support ticket tracking system for the data and custom development team using JIRA and Excel• Oversaw set-up of new client databases and handled new user provisioning

• Served as the lead Tableau developer to build out UWCI’s first publicly facing interactive dashboard • Developed processes and documentation for annual accreditation of community partners• Assisted with collection, cleaning, and validation of impact data utilizing Excel, SQL, and Power BI• Responded to ad hoc research requests from internal and external stakeholders• Stayed up to date on federal, state, and local data sources in the areas of Housing and Transportation

• Responsible for collection and reporting of data on deaths in police custody, per federal statute• Provided analysis for data-driven implementation of Racial & Ethnic Disparities programing • Led research on Juvenile Justice data collection in Indiana as part of a federally funded research grant • Utilized multi-methodological research to complete legislatively mandated reports • Assisted in training of new Research Associates

• Provided data-driven research to assist with effective implementation of federal traffic safety grants• Assisted in the development and writing of Indiana’s Highway Safety Plan (HSP) as required by the National Highway Traffic Safety Administration • Tracked and reported on statewide progress towards meeting traffic safety goals outlined in the HSP • Collaborated with the communication team to compile timely and accurate responses to media requests• Utilized multi-methodological research to complete legislatively mandated reports

• Assisted professors in the assessment of papers and projects • Hosted lectures covering topics such as American government, state and local politics, public policy, public administration, and research methods• Led lab sections in research methods and statistics using SPSS and Excel

Master Of Arts - Ma, Politial Science

Bachelor Of Science (Bs), Political Science

Activities and Societies: Pi Sigma Alpha, Phi Sigma Tau, Stance: An International Undergraduate Philosophy Journal