Dave Koelle
State College,PA
Summary
Experienced financial leader with expertise in FP&A, budgeting, and strategic planning. Proven ability to manage complex budgets and optimize financial processes for large organizations. Adept at resource allocation, risk management, and implementing innovative solutions to drive growth and efficiency.
Overview
17
17
years of professional experience
Work History
Financial Officer
Penn State University, Sr VP for Research Office
University Park, PA
06.2024 - Current
- Manage a $238 million budget, ensuring efficient allocation across diverse fund categories.
- Develop top-down strategies for annual budget process to improve planning and data visibility.
- Establish reporting processes to support leadership during organizational transition.
- Design costing models to optimize resource allocation for research activities.
- Enforce financial controls and ensure compliance with policies across a complex organization.
Financial Officer
Penn State University, College of HHD
University Park, PA
07.2018 - 06.2024
- Managed $142m operating budget spanning diverse fund categories.
- Established a completely restructured annual operating budget process for all departments across organization.
- Developed resource allocation models to deliver metric-driven annual funding for college academic departments and research centers.
- Designed tailored and intricate reporting, analyses, and processes addressing organization's unique needs.
- Executed long-term, iterative modifications to college's historical financial and budgeting practices while leading financial strategic planning activities.
- Maintained proper financial controls across a large and complex organization; ensured that policy and procedures were being followed and provided interpretation of policy when necessary.
Analysis and Planning Consultant
Penn State University, Outreach & Online Education
University Park, PA
11.2016 - 07.2018
- Designed organization-wide staffing and financial analyses to enhance decision-making processes.
- Developed and managed annual budgets totaling $4 million for central Outreach units.
- Produced complex cost models for accurate distribution of central unit costs within Outreach.
- Oversaw revenue sharing process for World Campus, Continuing Education, and Conferences & Institutes.
- Delivered detailed analyses and projections on Outreach's University appropriation and carryforward funds.
Senior Accountant/Manager
Penn State University, Outreach Non-Credit Office
University Park, PA
09.2013 - 11.2016
- Oversaw daily operations for department serving over twenty units/campuses across the university.
- Managed unit accounting operations, overseeing $4-5 million in annual accounts receivable.
- Coordinated with IT staff on systems management for large-scale registration system processing 50,000 enrollments and $8 million in fees annually.
- Delivered standard and ad hoc reporting on financial data, enrollment trends, and budgetary issues.
- Served as SME for related functions and engaged in leadership roles across multiple university-wide committees and task forces.
Financial Assistant
Penn State University, Outreach Finance Office
University Park, PA
10.2010 - 09.2013
- Processed and deposited all income received through Finance Office.
- Managed accounts receivable ranging from $2 million to $3 million annually.
- Tracked audit documentation for Penn State Outreach to ensure compliance.
- Monitored WPSU gift record system, providing necessary analysis and corrections.
Staff Assistant
The Pennsylvania State University
02.2008 - 10.2010
- Managed daily operations for institute's parent education programs - processed registrations, addressed inquiries, and coordinated communication with instructors and county courts.
- Supported unit VP in all phases of institute's first international law enforcement conference, including design and development of marketing materials, management of delegate registration process, and tracking of conference expenses.
Education
M.S. - Finance and Economics
West Texas A&M University
06-2021
B.A. - Law and Society
The Pennsylvania State University
05-2013
Skills
- Financial Planning & Analysis
- Budget Management
- Strategic Business Planning
- Risk Management
- SAP, Oracle, Workday ERP Systems
- Excel: Advanced formulas (VLOOKUP, INDEX/MATCH, SUMIFS), Pivot Tables, Macros, Data Validation, Power Query, Power Pivot
- Team Leadership
- Problem Solving
Timeline
Financial Officer
Penn State University, Sr VP for Research Office
06.2024 - Current
Financial Officer
Penn State University, College of HHD
07.2018 - 06.2024
Analysis and Planning Consultant
Penn State University, Outreach & Online Education
11.2016 - 07.2018
Senior Accountant/Manager
Penn State University, Outreach Non-Credit Office
09.2013 - 11.2016
Financial Assistant
Penn State University, Outreach Finance Office
10.2010 - 09.2013
Staff Assistant
The Pennsylvania State University
02.2008 - 10.2010
M.S. - Finance and Economics
West Texas A&M University
B.A. - Law and Society
The Pennsylvania State University
Similar Profiles
Carl ShelhamerCarl Shelhamer
Receptionist at Penn State University, Office of Veterans ProgramReceptionist at Penn State University, Office of Veterans Program
Jessica RectorJessica Rector
Administrative Business Manager-Finance and HR at ERIK-Office of Research-ACUP- The Ohio State UniversityAdministrative Business Manager-Finance and HR at ERIK-Office of Research-ACUP- The Ohio State University
Philip ThamesPhilip Thames
Personal Rare Coin Investment Advisor at Gerald Weiner Sr Vp Morgan StanleyPersonal Rare Coin Investment Advisor at Gerald Weiner Sr Vp Morgan Stanley