Nathan Sands Email & Phone Number

Verona, WI, US

Remote

Remote

Madison, Wisconsin

• Created Annual Operating Plan (AOP) and quarterly revised forecasts for operating and capital expenditures in excess of $2 billion, with a primary focus on IT and Real Estate.
• Developed and maintained a variety of financial dashboards, including: operating and capital expenditure trends, actual vs forecast variances, and Profit & Loss reporting.
• Crafted the narrative to explain why variances in actual expenses occurred compared to budgets and forecasts.
• Acted as a liaison between IT and Real Estate departments and FP&A: created key performance indicators (KPI’s) customized for each business partner’s specific needs and managed headcount projections.
• Led monthly presentations of developed dashboards and reports to a wide audience, including executive officers.
• Ad hoc project reporting and modeling across all functions in the company.

Madison, Wisconsin

• Analyzed fiscal impact of state and federal healthcare initiatives in Wisconsin’s $9+ billion Medicaid budget.
• Developed updated rates and policy for Wisconsin’s Federally Qualified Health Centers (FQHCs), one of the ten highest budgeted programs in the State’s Medicaid budget with a yearly impact of $200+ million.
• Created KPI dashboards to analyze FQHC encounters across the State for geographic and demographic insights.
• Developed training material and mentored team on new techniques and procedure for auditing FQHC encounters.
• Led analysis of fiscal and policy impacts of the Comprehensive Community Services (CCS) program, the fastest growing mental health/substance abuse program in the State’s Medicaid budget with a yearly impact of $100+.
• Authored budget paper proposal for the Department of Health for Wisconsin’s 2019-21 Biennial Budget.

Madison, Wisconsin

• Managed the University of Wisconsin-Madison’s capital equipment portfolio valued at over $700 million.
• Developed new procedures to improve upon financial reporting and database management.
• Managed capital expenditures budget requests from cost center owners.

Madison, Wisconsin

• Built and monitored models to analyze corporate investment accounts valued at over $300 million.
• Assisted in creating and reviewing $100+ million AOP and revenue projections for executive board.
• Maintained journal entries and account reconciliations in general ledger for month and quarter close process.

Madison, Wisconsin

• Analyzed complex unemployment insurance claim determinations for Wisconsin’s Unemployment Insurance Reserve Fund valued at over $200 million.
• Created VBA and macro controlled spreadsheets for my team to increase efficiency and accuracy.
• Led update and redesign of procedure to improve accuracy and efficiency for overpayment calculations and created the presentation that was shown across the state during its implementation.