William Willoughby Email & Phone Number

Washington DC-Baltimore Area

• Summary: conduct statistical analysis, develop reporting tools and pipelines, and manage project timelines aimed to improve agency outcomes.Design web apps, reports, data infrastructure, and automations
• Developed over a dozen recurring reports and dashboards for the agency, including tools to identify operational pain points by linking qualitative feedback with KPIs.
• Built and maintain two web apps on QuickBase to formalize data collection, tracking, and notifications of previously manual processes.
• Wrangle administrative data from structured and semi-structured sources using languages like Python and SQL.
• Design automated notifications for supervisors creating tailored, actionable content, such as nudges to complete family visits or reminders for upcoming documentation deadlines.Employ econometrics and AI/ML methods
• Conducted program evaluation using econometric techniques, including propensity score matching, to estimate the effectiveness of In-Home case management, which found the service significantly reduces the likelihood of.

• Title IV-E rate setting: conduct cost analysis of contracted residential and foster care providers to establish the state’s per diem rates for the Georgia Division of Family & Children Services and the Kentucky.
• Developed an interactive online dashboard using Python/Dash to visualize cost and time study data.
• Developed funding formula alternatives and presented policy options to the agency Commissioner regarding changes to Kentucky’s foster care rate structure, including an analysis of federal revenue impact.

Washington D.C. Metro Area

• Managed staff, schedules, client communication, and milestones for multiple student assessment reporting projects across three portfolio states.
• Designed and deployed reports on student assessment results, both on paper and online dashboards.
• Automated routine tasks, including shipment tracking and content workflow.
• Conducted rigorous quality assurance on student assessment and demographic data integrated across multiple databases.

Washington D.C. Metro Area

• Researched federal fiscal debt and deficit issues with an emphasis on Social Security solvency.
• Published blogs analyzing federal reports, fact-checking claims made by public figures, and reporting on federal budgeting events.
• Constructed a longitudinal tracker linking Congressional voting behavior to bill scores.
• Funded internship as a part of Peter G. Peterson Fiscal Internship Program, which involved joint events across participating DC think tanks and nonprofits.

• Evaluated school climate improvement pilot program for students K-3 used by the Department of Education
• Found demographic disparities in statewide student disciplinary data

2 Capitol Square SW, Atlanta, GA

• Developed budget and policy recommendations for University System of Georgia, Georgia Student Finance Commission, and the Department of Early Care and Learning - FY 2017 budgeted: $2.1B, $807M, and $414M in state.
• Presented budget recommendations annually to the Governor for development of the Governor’s budget
• Restructured the pre-K funding formula resulting in a $37M increase in funds for Georgia pre-K in FY 2017
• Projected multi-year revenue and expenditure estimates for the state lottery funded programs totaling a budgeted $1.1B in expenditures in FY 2017
• Assessed fiscal and policy impact of legislation, an average of 17 per session, for policymakers’ consideration

• Prepared Strategic Planning Evaluation and Mid-Year Strategic Status reports for state agencies
• Prepared final ARRA financial reports for the state of Georgia
• Maintained website hosting ARRA reports and substantially reduced unnecessary files hosted on website

Master In Public Affairs (Mpa) · Economics And Public Policy

Activities and Societies: Treasurer of SPIA Action Committee in 2018; Finance Committee Chair of SPIA Service Auction in 2017 Highlighted.

Bachelor Of Arts (Ba), History

Activities and Societies: Phi Beta Kappa, WUOG's Athens Journal, UGA Symphonia Graduated with honors and a minor in music

History

Studied for the Fall 2011 semester with Oxford professors in history, economics, and English.