Conducted in-depth business process analysis for financial services, contract administration, clinical services, and licensing using BPMN and Lean methodologies
Developed and recommended data management solutions using SQL Server and Power BI, improving data accuracy and operational efficiency
Developed scripts to categorize, convert, and test over 20,000 MS Access databases using PowerShell, SQL, and VBScript
Designed comprehensive database schemas, system diagrams, and data models, streamlining system architecture documentation and improving cross-team communication
Led a 20-member team in a statewide data conversion project impacting 32,000 databases
Facilitated stakeholder meetings to document key business processes, identify gaps in data governance, and gather business requirements
Solutions Architect and Database Developer
Safe Passage Program, Taylorville Police
12.2021 - 07.2022
Introduced technology-based solutions for staff and clients that improved internal communications. made resources more easily accessible, made assessments and the ability to track progress toward goals more efficient, and brought safety to the forefront of program interactions.
Made years of program data digitally accessible, providing key insights into performance and effectiveness and the ability to track trends from day one of the program.
Evaluated emerging technologies to stay current on industry trends, making informed decisions for technology adoption.
Developed comprehensive documentation for technical specifications, project plans, and user guides, streamlining communication across teams.
Enhanced application performance by integrating cloud technologies and microservices architecture.
Assessed business practices; designed an application to track employee time and effort and automate submission of HR and Payroll data.
Developed a secure role-based application that provided remote access to confidential program data.
Developed a cloud-based reporting dashboard for staff and program administrators to create custom data visualizations and reports, providing flexible, on-demand insights tailored to their specific needs. Developed scripts that utilized OCR technology to help streamline the input of over three years of program data.
Program Manager and Client Advocate
HOPE, Homeless Outreach
06.2020 - 09.2021
Established and managed Colorado's first safe parking program, helping 27 individuals and families obtain stable housing in its first year
Expanded program from 1 location to 3 locations, increasing program reach and participant capacity
Gained support and partnered with other congregations in surrounding areas to host future safe parking sites
Developed and implemented comprehensive program policies and standards, resulting in a 30% increase in operational efficiency and improved client satisfaction metrics
Standardized eligibility criteria and program documents, ensuring equitable service delivery across all participants
Collaborated with program participants and served as client advocate to assess needs, develop SMART goals, obtain documentation, such as social security card and driver's license, gain employment, and participate in professional development activities
80% of participants saw improvements such as gained employment, increases in pay, or learned new skills
Assessed business practices; designed an application to track employee time and effort and automate submission of HR and Payroll data
Developed a secure role-based application that provided remote access to confidential program data
Developed a cloud-based reporting dashboard for staff and program administrators to create custom data visualizations and reports, providing flexible, on-demand insights tailored to their specific needs
Developed scripts that utilized OCR technology to help streamline the input of over three years of program data
Technical Consultant
Self Employed Contractor
09.2015 - 05.2020
Associate Coordinator
Summer Session Office, Colorado State University
06.2011 - 08.2015
Program Coordinator
Special Education Data Unit, Colorado Department of Education
06.2009 - 06.2010
Co-managed daily operations for CSU's Summer Office, overseeing scheduling, resource allocation, and staffing
Published class listings, advertised new courses, analyzed and published enrollment data, and provided support to students throughout the year
Analyzed and presented enrollment data trends, contributing to the development of strategic initiatives that improved course offerings and increased enrollment
Provided enrollment projections and budget forecasts in order to optimize departmental resource allocations and drive marketing strategies
Project Lead for the development of the Special Education End of Year Student Data Collection Automated Data Exchange (ADE) System
Created business rules, Edit criteria, and Report Specifications that reduced data validation errors and increased reporting efficiency
Performed rigorous system testing to resolve issues pre-launch, ensuring high-quality submissions and reducing data processing errors
Ensured timely submission of accurate data, improved data processing timelines and secured over $10 million in federal funding
Skills
Proficiency in content management
Timeline
Project Manager and Technical Solutions Architect
Ahava Services, LLC
11.2022 - 02.2024
Solutions Architect and Database Developer
Safe Passage Program, Taylorville Police
12.2021 - 07.2022
Program Manager and Client Advocate
HOPE, Homeless Outreach
06.2020 - 09.2021
Technical Consultant
Self Employed Contractor
09.2015 - 05.2020
Associate Coordinator
Summer Session Office, Colorado State University
06.2011 - 08.2015
Program Coordinator
Special Education Data Unit, Colorado Department of Education