Ryan Macks Email & Phone Number

Jerusalem District, Israel

Jerusalem, Israel

• Manage portfolio operations including data management, quarterly reporting and valuation analysis for 250+ portfolio companies
• Lead quarterly portfolio reviews with management and industry experts
• Manage relationship with portfolio companies, including funding
• Develop BI tools to improve management of the portfolio and deals, and analyze data to help decision making
• Extensive work with cap tables and financial data; database management, financial modeling, valuations and returns, comparables, and TAM analysis, and further due diligence for prospective investments
• Manage a team of 4

• Comprehensive analysis of opportunities to raise additional revenues for municipality
• Data based analysis of job and housing market in Jerusalem and Israel and strategic planning for future employment and housing needs
• Designed and implemented BI data dashboard to present wide ranging data i.e. local employment data
• Applied research on municipal finance and innovative financial tools to solve local fiscal challenges. Developed plan and model for: property taxation assessment based on fair market property value, professional city.

Bloomington, Indiana

-Graduate Assistant to Chancellor's Professor John Mikesell -Data driven research to determine how adding various services to the sales tax base would effect vertical equity; growth rate and stability measures of various government revenue sources; the tax gap and administration; effects of revenue diversification; updates to Fiscal Administration textbook

Evanston, IL

-Developed 6 month report on customer relationship management software results, identifying positive and problematic trends in service request data -Established and coordinated outreach strategy for transit survey, collecting more than 1275 responses in 4 weeks in effort to reflect community needs in cities investment in public transportation-Researched.

Bloomington, Indiana

Led in-class reviews and held office hours to facilitate the understanding of coursework for 50+ students, graded projects and exams and maintained administrative records

Lincolnwood, Illinois

-Managed daily payments from residents and kept them organized and easily attainable for audit purposes-Answered residents questions ranging from city services and events to adjudication hearings-Gained knowledge of local finance activity and day-day administrative duties

Bloomington, Indiana

Microsoft Access and Excel use in business

Skokie, IL

-Led activities for 15-30 children and helped instill team work -Earned a certification in first aid and CPR

Master Of Public Affairs, Local Government Management And Public Financial Administration

Treasurer of Local Government Management Association

Global Perspective Of Public And Private Sector Interaction

Global Perspective Of Public And Private Sector Interaction

Bachelor Of Science With High Distinction, Public Financial Management

Kelley School of Business Certificate in Business Foundations

Policy, Governance And Management In A Multi-Level World: Concepts And Applications

Summer 2013