Louie Barela Email & Phone Number

Greater Denver Area

Denver, Colorado

Managed a team of professionals to formulate and deliver CDOT's $1.5 billion annual budget. I managed the following processes for the Department:● Annual Budgeting● Revenue Forecasting (Monthly, Quarterly, Annual, Long-Range)● Resource Allocation (Long Range Allocations)● Cash Management Strategies and Principles Definition, Leadership, and Support● CDOT Budget Formulation (Transportation Commission and Administrative Budgets)● Legislative Analysis (State and Federal)

Greater Denver Area

●Team leader and coordinator for the budget team in the Office of Financial Management and Budget●Create budget book for entire Department, allocating approximately $1.2 billion in FY2014.●Analyze proposed and recently-passed legislation for fiscal impact on CDOT.●Prepare financial and operations reports, used both internally and as official Statewide documentation.●Write and maintain all fiscal notes for the Department, giving the Colorado Legislature the Department’s official… Show more ●Team leader and coordinator for the budget team in the Office of Financial Management and Budget●Create budget book for entire Department, allocating approximately $1.2 billion in FY2014.●Analyze proposed and recently-passed legislation for fiscal impact on CDOT.●Prepare financial and operations reports, used both internally and as official Statewide documentation.●Write and maintain all fiscal notes for the Department, giving the Colorado Legislature the Department’s official position on laws and pending legislation.●Run the revenue forecast and maintain a multi-year spending plan for the Department. Show less

Colorado Department Of Transportation

●Responsible for working under strict deadlines with subject matter experts and business users to identify business needs and functionally coordinate solutions using SAP, Business Process and Simulation (BPS) and Public Budget Formulation (PBF).●Work with a team of consultants, IT personnel, and business process owners to blueprint and implement SAP’s new solution for public sector budgeting, Public Budget Formulation.●Gathered requirements from business owners and wrote the functional… Show more ●Responsible for working under strict deadlines with subject matter experts and business users to identify business needs and functionally coordinate solutions using SAP, Business Process and Simulation (BPS) and Public Budget Formulation (PBF).●Work with a team of consultants, IT personnel, and business process owners to blueprint and implement SAP’s new solution for public sector budgeting, Public Budget Formulation.●Gathered requirements from business owners and wrote the functional requirements documents for all processes in PBF.●Knowledge of different CDOT revenue sources including HUTF, SHF, FTA, etc.●Gather financial report specifications for development in SAP Business Objects.●Create, edit and manage reports used by the business, utilizing Business Designer (BEx) and Web Intelligence (WEBI).●Create testing strategies and scripts to unit test master data and business processes.●Experience with SAP Integrated Planning, including aggregation levels, filters and functions. Show less