Clark Rumsey

Supported statewide residential clean-energy finance initiatives through program financial models, reporting, partner coordination, and process improvements. Automated the quarterly Green Jobs Green New York status report from two days to 15 minutes using Excel/VBA.

Modeled more than $100 million in land acquisitions in the first year, helping acquisition specialists evaluate purchases and lease extensions. Automated the division-wide Q Report for due diligence and closings, saving transaction managers more than 15 hours per week.

Automated market-report preparation using Alteryx and Tableau, and presented the system at Alteryx Inspire 2014. Prepared pro formas and IRRs using supply/absorption forecasts, comparables, contractor estimates, and expense surveys.

Prepared pro formas, cost and expense budgets, waterfall models, and IRRs for mixed-use developments in a $2 billion pipeline. Created equity and debt investor packages.

Monitored banking and reconciliation for self-funded plan sponsors and automated the process, cutting daily effort by 65%. Documented month-end procedures.

Led budgeting, forecasting, and monthly variance analysis for R&D administration and field sales with annual spend of about $6 million and $10 million. Researched expenses and identified about $250,000 in FY10 division expense reductions.

Grade: GPA 3.6

Bachelor of Science in Business Finance from Brigham Young University, completed in 2007.