Accomplished financial analyst with over 15 years experience driving business decisions in banking and local government environments. Spearheaded utility rate system development, data analysis, revenue forecasting, and devised innovative data modeling plans to forecast utility revenue.
Data Analysis/Financial Modeling
Revenue monitoring and Variance Reporting
Provide reporting solutions using Crystal Reports and Discoverer
Rate Model Development
Experienced with VBA & SQL
MS Office Suite, Pivot Tables, Advanced Charts
MUNIS Intital training
Improved water rate forecasting methods by minimizing data inaccuracies to less than .5% which proved useful in the financial planning and budgeting process.
Chosen for ERP Vendor Selection Committee for RFP Process - MUNIS selected
Chosen for Employee Benefit Vendor Committee
11/2006 to 02/2015
Utilities Financial/Data AnalystCity of Boulder － Boulder, CO
Rate Model Development to accomodate rate model methodology changes/goals.
Rate Model testing to assure accurate functionality and data
Implemented intuitive rate models to forecast long-range financial requirements with greater accuracy.
Identified operational process inefficiencies through variance reporting and recommended necessary improvements.
Maintained and updated Asset Management reports used in industry benchmark reporting
Analyzed utilization and capacity against performance goals through industry benchmark reporting.
Executed and reported revenue variance and gap analysis.
Created City Council PowerPoint presentations illustrating business performance and goals.
Performed revenue rate studies, bond and annual reporting analysis, used to update utility rate methodology.
Pulled, reconciled, and modeled utility billing data to forecast future utility revenue.
Assisted with budget development utilizing rate model analysis revenue findings
Assisted with Utility Billing system testing of version enhancements