Data Powered Strategy

I believe that data primarily serves to empower strategy. Data science can answer seemingly intractable questions by distinguishing signal from noise and quantifying obscure or esoteric. I have a proven track record in applied research that make a meaningful impact in the world. My first major achievement came during graduate school at the University of Chicago. I lead a team who built the financial model for the Lead Service Line Replacement and Notification Act.. Our work was instrumental in passing legislation that funds the replacement of lead water infrastructure throughout the State of Illinois.

My training, experience, and tenacity allow me to adapt to new challenges and deliver data products that enhance institutional knowledge.

rwrcrump@gmail.com

Data Science

Strategic Planning

Project Management

Policy Research

EXPERIENCE

Austin Police Department | 2024 - Present

  • Built capacity and response time forecasting algorithm to model and evaluate patrol staffing strategies
  • Developed and maintained ETL pipeline supporting public data assets using SQL, R, and Python
  • Designed and deployed public facing Power BI dashboard
  • Lead product development meetings presenting to executive staff and incorporated their feedback
  • Documented ETL pipelines and changelog to maintain consistency and service reliability
  • Wrote geospatial interpolation script to connect Census data with police sectors

Guidehouse Inc. | 2022 - 2023

  • Delivered projects for state agencies related to process improvement, federal grants, and data analysis
  • Assisted a State Government administer $2 billion American Rescue Plan Act (ARPA) grant within federal compliance regulations
  • Hosted weekly meetings with state broadband office to guide grant funds disbursement process
  • Built a Power BI data dashboard to monitor ARPA disbursements to state subrecipients
  • Coordinated work between teams within the company and across state agencies
  • Contributed original content, research, and document preparation to RFPs worth millions of dollars
  • Produced content for client employee survey; collected and evaluated resulting data
  • Conducted federal compliance eligibility reviews for multiple clients across all ARPA expenditure categories

The Civic Federation | 2021

  • Analyzed financial records contributing to published report on Chicago Public Schools
  • Reviewed literature and City of Chicago data on public safety and police budgeting
  • Wrote summary reports on City of Chicago local tax legislation
  • Provided production and logistics support for virtual conference

Cook County Assessor's Office | 2021

  • Wrote policy memos to construct narrative of property tax appeals process in Cook County
  • Evaluated opportunities for improved intergovernmental coordination with specific actionable recommendations
  • Synthesized public records on tax appeals rulings and government finances to enhance institutional knowledge base

Illinois State Treasurer's Office | 2020

  • Surveyed new government spending in response to the COVID-19 pandemic in Illinois
  • Designed policy for database management and identity matching for childhood savings accounts
  • Performed statistical analysis of Payment Protection Program loan data across Illinois using US Treasury data
  • Reviewed literature and federal rules to produce memos on CDFIs, culminating in the Community Development Loan Guarantee Act
  • Created visualizations using Census data of State congressional districts in support of outreach program

Center for Municipal Finance | 2019 - 2020

  • Published weekly articles synopsizing municipal bond issues for non-technical readers
  • Produced daily to municipal bond yield curve data visualization
  • Edited & revised longform article on bond audit disclosures

Harris School of Public Policy | 2021

  • Coached multi-national students on grammar, logical structure, and persuasive policy writing
  • Graded policy memos for graduate level economics and political economy courses
  • Delivered instruction to highly diverse multi-national student cohort
  • Structured tutoring around audience-first philosophy for technical writing, including resumes and cover letters

Accenture | 2017 - 2019

  • Responded to user inquiries and enforced policies related to account access for major social media client
  • Identified and developed policy to address pain points regarding name changes for transgender users
  • Presented data report and process change proposal to smooth user experience when contact support group
  • Built a meta-tagging system to track trends in user interactions, inter-departmental frictions, and pilot projects

Telenetwork Inc. | 2011 - 2016

  • Tech troubleshooting and account support via phone, chat, and social media for major telecom company
  • Invented ticket auditing system eliminating backlogs and developing trend tracking methodology
  • Composed new email correspondence templates to increase efficiency for common inquiries
  • Trained newly hired agents and helped integrate them into the team

EDUCATION

University of Chicago, Harris School of Public Policy | Class of 2021
Certificate in Municipal Finance

Graduate Courses Sample
  • Policy Lab - Managed research team supporting the Lead Service Line Replacement and Notification Act
  • GIS Foundations - Designed traffic analysis using spatial data in R and Geoda
  • Program Evaluation - Rigorous survey of econometric methods using R
  • AI for Public Policy - Developed concept for infrastructure monitoring using remote sensors

Texas State University | Class of 2008
Double Major | Dean's List Selection for Academic Excellence