John Guttman Email & Phone Number

Austin, Texas, United States

- Interacted daily with Elected and Appointed Officials and senior staff throughout Travis County regarding the creation and implementation of the Travis County Fiscal Year 2023 Budget.- Conducted independent reviews of departmental budget requests, and present findings and defend conclusions directly to Commissioners Court in a public forum.- Performed monthly review of projected annual expenditures for assigned County departments and offices in order to determine available fiscal resources for the County in Fiscal Year 2023.- Aggregated budget requests for Commissioners Court approval and prepares summary document for Commissioners Court review on a weekly basis.- Utilized SAP business enterprise software and Microsoft Suite to analyze personnel trends and budget availability.- Evaluated services provided by assigned County departments and offices in order to update performance measurement system used to determine allocation of County resources.

- Analyzed bills up for daily House floor vote and made voting recommendations for Representative Bucy, with special focus on Higher Education, International Relations & Economic Development, Urban Affairs, County Affairs, and Pensions, Investments, & Financial Services Committees.- Tracked all bills heard in the House Elections Committee to look for possible legislative vehicles for stalled, anti-voting legislation moving forward. - Prepared evaluations of online voter registration and voter roll bifurcation, including legislative history, potential obstacles to implementation, and necessary security measures to consider.- Conducted background research and prepared committee hearing materials for numerous bills filed by Representative Bucy with the House Elections Committee, among other committees.- Drafted emails sent to constituents on notable events of the legislative session, and wrap-ups on voting rights and elections.- Met with constituents and lobbyists on topics including medical scope of practice, environmentalism, and prenatal-to-3 policy.

Austin, Texas, United States

- Completed literature review and synthesized best practices for “knowledge management” into reportand PowerPoint slides as part of contract with the Texas Department of Transportation.

Austin, Texas Area

- Selected to assist with study required by Senate Bill 616 (86th Session) to develop recommendations for improving the management and operating structure of State’s driver license program, and whether the program should be administered outside of the Texas Department of Public Safety.- Aggregated and edited research from study team members on topics including customer service improvements and recent legislative history for final report submitted to the Texas Legislature.- Drafted reports of recent state agency transfers utilizing fiscal notes, bill analyses, and news clippings to inform recommendations for a potential agency transfer of State’s driver license program.- Developed legislative briefing materials including one-pagers and PowerPoint presentations on reportfindings for use in upcoming legislative session.

Austin, Texas Area

- Served as teaching assistant for Dr. Pat Wong's "Analytic Foundations for Public Policy".- Helped first-year Master's candidates with analytic problem-solving techniques such as linear programming and decision analysis, among other topics, during weekly review sessions and office hours.

Takoma Park, Maryland

- Developed original report with recommendations for new political boundaries and ranked choice voting to improve demographic representation in Houston City Council districts.- Displayed American Community Survey demographic data using QGIS and compared against Houston City Council election results to calculate rates of under-representation for Houston’s Hispanic/Latinx community. - Collected electoral data for 2018 edition of biannual “Dubious Democracy” report assessing Congressional election fairness.

Austin, Texas Area

- Analyzed bills up for daily House floor vote and made voting recommendations for the Representative, with special focus on public education and higher education policy.- Conducted background research on bills filed by the Representative with the House Elections Committee, then prepared committee hearing materials for House Bill 1852 (86th Session) on elections with unopposed candidates.- Participated in briefings on public education and higher education policy and connected with constituents and lobbyists on legislative developments.

Austin, Texas Area

- Engaged in voter outreach using various forms of media to gauge candidate support.- Compiled field reports from voter database of canvassing efforts for local political candidates.

Austin, Texas

- Mapped results of over 600 local and statewide political surveys to national voter database.

Greater New York City Area

- Created 100+ page user manual to document Company’s new international casualty insurance reserving and aggregation website. - Developed automated process for collecting international data and displaying results of varying granularity online using Oracle SQL and Excel VBA.

Austin, Texas Area

- Tutored University students in Calculus, Probability, Statistics, and Financial Mathematics.

Houston, Texas Area

- Analyzed data issues within the Company’s Reinsurance database and estimated financial impact of their correction.- Ran variable annuity calculations and increased efficiency of automated process with SAS and VBA code.

Houston, Texas Area

- Displayed long-range population and job growth forecasts for the Houston region utilizing ArcGIS.

Master'S Degree, Public Affairs

Bachelor Of Science - Bs, Actuarial Science

Activities and Societies: Longhorn Band, Kappa Kappa Psi, Risky Business Newsletter, Phi Mu Alpha