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+ million.• Authored budget paper proposal for the Department of Health for Wisconsin’s 2019-21 Biennial Budget.• Assisted in drafting Medicaid State Plan Amendments (SPAs) to the Centers for Medicare and Medicaid Services (CMS) for federal approval on policy changes and updates in various Medicaid programs.• Represented the State in presentations throughout Wisconsin on fiscal and policy related matters to FQHC executives and CCS county directors.

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.