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.

- 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.

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.

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.

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.

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