Dane Wagenhoffer

Technical Skills

Data & Database Management

SQL, Data Warehousing, Data Modeling, Data Migration

Analytics & Reporting

Advanced Excel, Power BI, Data Visualization, Data Forecasting

Python & Automation

Selenium, Playwright pandas, NumPy, matplotlib, seaborn statsmodels, Prophet Jinja2 Dashboarding Tkinter-based Utility Apps

Version Control

Git, GitHub

IT & Support

Hardware/Software Troubleshooting, Data Management (Apricot, Votebuilder)

Other

Technical Documentation, Process Improvement, Customer Service

Professional Experience

Housing Hope – Everett, WA

March 2023 – Present

Data Specialist

Design and manage local SQL databases to enhance data accuracy and accessibility.
Develop Python-based GUI interfaces and automation scripts to streamline data entry and improve workflow efficiency.
Create and maintain dynamic reports using Excel and Power BI, providing critical insights for grants and funding.
Administer and optimize the Apricot CRM system to boost data processing and reporting.

Eligibility Coordinator

Oversee the resident intake process, completing documentation and follow-ups throughout move-in.
Guide clients through eligibility assessments and transition procedures for a smooth experience.
Collaborate with team members to maintain accurate resident records and support program evaluation.
Incorporate client feedback into process improvements for enhanced service delivery.

Washington State Democrats – Everett, WA

August 2022 – November 2022

Field Organizer

Coordinated volunteer recruitment and scheduling across multiple counties during a major election cycle.
Utilized Votebuilder CRM for voter outreach and campaign data tracking.
Conducted extensive outreach, including thousands of cold calls, to bolster volunteer engagement.

Fully Loaded Electronics – Mill Creek, WA

April 2022 – July 2022

Customer Service Representative

Provided technical support for specialized electronics in hospitals and correctional facilities.
Addressed product issues efficiently, ensuring high levels of customer satisfaction during peak periods.

Buchanan Automation – Snohomish, WA

January 2022 – April 2022

Inside Sales Representative

Managed key client accounts, including Amazon, while offering technical sales support.
Collaborated with engineering teams to troubleshoot and resolve complex technical issues.
Fostered strong customer relationships, contributing to client retention and repeat business.

Stratagraph, Inc. – Remote

September 2020 – June 2021

Database Administration Intern

Led the transition from an Excel-based system to a robust SQL database, significantly improving data integrity.
Collaborated on migrating data to a cloud-based platform, enhancing scalability and flexibility.
Developed real-time heat map visualizations for dynamic business decision-making.

Z Sport Automotive – Everett, WA

February 2016 – May 2020

Senior IT Manager

Oversaw daily IT operations, including hardware repairs, software troubleshooting, and network maintenance.
Upgraded computer systems and Ethernet cabling to enhance overall infrastructure.
Managed digital content and maintained the company website to bolster online presence.
Coordinated installation of security systems to safeguard company assets.

Major Projects

SQLite Database for Enrollment & Developmental Metrics: Designed and implemented a scalable database to capture key performance indicators for the Child Development Center, enhancing grant reporting accuracy and strategic decision-making.
Annual Outcomes Reporting Initiative: Developed an annual report for grant funders and fundraising events, synthesizing key metrics and success stories to boost transparency.
Resident Eligibility Coordination & Onboarding: Spearheaded the eligibility process for a new housing facility, managing extensive intake procedures and ensuring a seamless move-in experience.
Enhanced Database Architecture for Housing Unit Management: Upgraded the database by integrating a dedicated table for housing units and establishing relational links, streamlining address tracking.
Automated Assessment Data Scraper with Playwright: Engineered an automated scraper to extract assessment data without API access, significantly improving efficiency and saving costs.
Dashboard Development: Created static dashboards using Jinja2 with Python/HTML, including one analyzing police interactions to identify seasonal trends and patterns.