Data Powered Strategy

Every good idea needs a plan. I thrive in the implementation layer of policy and strategy. I strive to take on new challenges that require creativity, vision, and tenacity. As a leader, team member, and individual contributor I have a proven track record delivering projects for large and small clients.

I use data science to enhance institutional knowledge. My wide range of skills adapts to each client's and each project's unique needs. My most impactful project to date is leading the research team at The University of Chicago that built a financial model for the Lead Service Line Replacement and Notification Act. My team was instrumental in helping to pass this key legislation that funds the replacement of lead water infrastructure throughout the State of Illinois.

rwrcrump@gmail.com

Download Resume

Data Science

Strategic Planning

Project Management

Policy Research

EXPERIENCE

Guidehouse Inc. | 2022 - 2023

  • Delivered projects for state agencies related to process improvement, federal grants, and data analysis
  • 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 listening tour among state government agencies rolling out new accounting software
  • Assisted a State Government administer $2 billion American Rescue Plan Act (ARPA) grant within federal compliance regulations
  • Conducted federal compliance eligibility reviews for multiple clients across all ARPA expenditure categories
  • Hosted weekly meetings with state broadband office to guide grant funds disbursement process
  • Developed a data dashboard to monitor disbursements of ARPA dollars to state subrecipients

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
  • Synthesized public records on tax appeals rulings and government finances to enhance institutional knowledge base
  • Evaluated opportunities for improved intergovernmental coordination with specific actionable recommendations

Illinois State Treasurer's Office | 2020

  • Built survey of new government spending in response to the COVID-19 pandemic in Illinois
  • Designed policy for database management and identity matching for childhood savings accounts
  • Created visualizations using Census data of State congressional districts in support of outreach program
  • 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

Center for Municipal Finance | 2019 - 2020

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

Harris School of Public Policy | 2021

  • Graded policy memos for graduate level economics and political economy courses
  • Coached students on fundamentals of grammar, logical structure, and persuasive policy writing
  • 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



Work Samples

Guest Lecture Video

Applied Research Methods Econometrics at City University of New York

Simulating Traffic Data

Code Blog 3 Random Walk Method

Fatal Crashes in Austin, Texas

Code Blog 2 Aggregating Spatial Data

Budget App Project

Code Blog 1 Loops and Iteration

Chicago Covid Data Analysis

Epidemiology Regression Discontinuity Design

Chicago Police Department Budget Analysis

Public Safety Spending Single Year Deep Dive

New York City COVID-19 Data, Interactive Map

Shiny Web App Interactive Data Dashboard