Senior Project Manager
Current- Develop sophisticated yet practical Excel-based rate modeling tools to calculate full cost-of-service, determine cost-benefit of alternatives and improve user experience through dashboards and calculators.
- Incorporate raw customer data, operating budgets, debt repayment schedules, financial policies, and capital improvement plans into multi-year cash flow forecasting models.
- Work with varying areas of local government including water, wastewater, stormwater, and ambulance utilities as well as the general fund.
- Engage with a number of different agencies in multiple states including cities, counties, ports and special districts.
- Utilize Excel and Access to manipulate, analyze, and summarize large sets of data (> 1 million records) through complex Excel formulas, Pivot Tables, Power Pivot, Power Query and VBA.
- Other areas of work include utility mergers and acquisitions using cost based, market based, and discounted cash flow methods; general governmental consulting on indirect cost allocation plans and user fees; and.