Kristen Hallock
Colchester,VT
Summary
Senior Reporting Analyst with 17 years of experience in higher education, specializing in data visualization, financial modeling, and SQL programming. Proven ability to deliver comprehensive reporting solutions that enhance decision-making processes. Strong critical thinking and problem-solving skills ensure clarity and effectiveness in all generated reports.
Overview
26
26
years of professional experience
Work History
Senior Reporting Analyst
Champlain College
Burlington, VT
06.2010 - Current
- Design and deliver dashboards and custom reports using Power BI, Excel, and SQL to support strategic decision-making by Advancement leadership, the President’s Office, and the Board of Trustees.
- Conduct data analysis and segmentation to optimize donor and alumni engagement strategies.
- Collaborate cross-functionally with Finance, Institutional Research, and other departments to ensure data consistency and support internal and external audits.
- Develop process automation solutions using Microsoft Power Apps and Power Automate, increasing reporting and reconciliation efficiency.
- Train staff on data tools and create comprehensive documentation for reporting workflows and automated systems.
- Utilize Blackbaud ReNXT and advanced database querying to streamline fundraising data operations.
Environmental Database Specialist
University of Vermont – EPSCoR
Burlington, VT
09.2008 - 06.2010
- Designed and administered relational databases for the Lake Champlain Watershed Modeling Project;
- Executed data integration using SQL across Access, MySQL, and SQL Server platforms.
- Collaborated with state agencies and UVM departments to consolidate disparate data and ensure quality control.
- Produced tailored reporting solutions and forms for academic and environmental research stakeholders.
Senior Programmer
Harmony Information Systems
Essex Junction, VT
01.2003 - 07.2008
- Led the software release cycle and consulted with customers to identify reporting needs and system improvements.
- Developed custom reports using Crystal Reports
- Executed data migrations into relational databases.
- Conducted end-user training and collaborated across development and support teams for client-facing projects.
Associate Programmer
Harmony Information Systems
Essex Junction, VT
07.2001 - 01.2003
- Supported legacy Visual Basic products and reengineered barcode software solutions for updated interfaces.
Software Engineer
Competitive Computing
Colchester, VT
07.2000 - 05.2001
- Developed e-commerce websites and internal issue tracking systems using data-driven technologies.
- Interfaced directly with clients to deliver tailored web and data solutions.
Education
Graduate Certificate - Data Science
Champlain College
Burlington, VT04-2025
Bachelor of Science - Business Administration
University of Vermont
Burlington, VTSkills
- SQL, Python and R
- JavaScript, HTML, XML, PHP
- Power BI
- Tableau
- Crystal Reports
- Microsoft Power Automate and Power Apps
- Microsoft Excel (advanced formulas, pivot tables, VBA macros)
Timeline
Senior Reporting Analyst
Champlain College
06.2010 - Current
Environmental Database Specialist
University of Vermont – EPSCoR
09.2008 - 06.2010
Senior Programmer
Harmony Information Systems
01.2003 - 07.2008
Associate Programmer
Harmony Information Systems
07.2001 - 01.2003
Software Engineer
Competitive Computing
07.2000 - 05.2001
Graduate Certificate - Data Science
Champlain College
Bachelor of Science - Business Administration
University of Vermont