dw/resume.html at main · GearUnclear/dw · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
<!DOCTYPE html>
<html lang="en">
<head>
  <meta charset="UTF-8">
  <meta name="viewport" content="width=device-width, initial-scale=1">
  <title>Dane Wagenhoffer - Resume</title>
  <style>
    body {
      font-family: Arial, sans-serif;
      margin: 20px;
      line-height: 1.6;
    }
    header, section {
      margin-bottom: 20px;
    }
    header h1 {
      margin: 0;
    }
    .contact a {
      margin-right: 10px;
      text-decoration: none;
      color: #0066cc;
    }
    h2 {
      border-bottom: 2px solid #000;
      padding-bottom: 5px;
    }
    ul {
      list-style-type: disc;
      margin-left: 20px;
    }
    .subsection {
      margin-top: 10px;
      margin-bottom: 10px;
    }
  </style>
</head>
<body>
  <header>
    <h1>Dane Wagenhoffer</h1>
    <p>Lake Stevens, WA - 425-750-8087 - <a href="mailto:danefrak@gmail.com">danefrak@gmail.com</a></p>
    <p class="contact">
      <a href="https://www.linkedin.com/in/dane-w-a0430751/">LinkedIn</a>
      <a href="https://github.com/GearUnclear">GitHub</a>
    </p>
  </header>

  <section>
    <h2>Summary</h2>
    <p>
      Data Specialist with a Bachelor of Science in Data Analytics from Eastern Washington University. Possesses over 7 years of hands-on experience in IT operations, database administration, and data reporting. Skilled in SQL, advanced Excel, Power BI, and Python scripting for automation, custom interfaces, and data analysis. Proven track record of streamlining workflows and generating actionable insights in small business and nonprofit environments. Currently balancing dual responsibilities as a Data Specialist and Eligibility Coordinator to support both data-driven operations and resident intake processes.
    </p>
  </section>

  <section>
    <h2>Technical Skills</h2>
    <ul>
      <li><strong>Data & Database Management:</strong> SQL, Data Warehousing, Data Modeling, Data Migration</li>
      <li><strong>Analytics & Reporting:</strong> Advanced Excel, Power BI, Data Visualization, Data Forecasting</li>
      <li><strong>Programming & Automation:</strong>
        <ul>
          <li>Python for automation (Selenium, Playwright, PyAutoGUI)</li>
          <li>Data Analysis & Visualization: pandas, NumPy, matplotlib, seaborn</li>
          <li>Statistical & Time-Series Modeling: statsmodels, Prophet</li>
          <li>Dashboarding: Jinja2 with Python/HTML for creating static dashboards</li>
        </ul>
      </li>
      <li><strong>Version Control:</strong> Git, GitHub</li>
      <li><strong>IT & Support:</strong> Hardware/Software Troubleshooting, Data Management and Administration (Apricot, Votebuilder)</li>
      <li><strong>Other:</strong> Technical Documentation, Process Improvement, Customer Service</li>
    </ul>
  </section>

  <section>
    <h2>Professional Experience</h2>

    <div class="subsection">
      <h3>Housing Hope – Everett, WA</h3>
      <p><em>January 1, 2024 – Present</em></p>
      <h4>Data Specialist</h4>
      <ul>
        <li>Design and manage local SQL databases to enhance data accuracy and accessibility.</li>
        <li>Develop Python-based GUI interfaces and automation scripts (using Selenium, Playwright, and PyAutoGUI) to streamline data entry and improve workflow efficiency.</li>
        <li>Create and maintain dynamic reports using Excel and Power BI, providing critical insights to support grants and funding efforts.</li>
        <li>Administer and optimize the Apricot CRM system to boost data processing and reporting.</li>
      </ul>
      <h4>Eligibility Coordinator</h4>
      <ul>
        <li>Oversee the resident intake process, including completing documentation and following up throughout the move-in process.</li>
        <li>Guide clients through eligibility assessments and transition procedures, ensuring a smooth and supportive experience.</li>
        <li>Collaborate with team members to maintain up-to-date resident records and assist in program evaluation.</li>
        <li>Integrate client feedback into process improvements to enhance overall service delivery.</li>
      </ul>
    </div>

    <div class="subsection">
      <h3>Field Organizer</h3>
      <p>Washington State Democrats – Everett, WA<br>
      <em>August 2022 – November 2022</em></p>
      <ul>
        <li>Coordinated volunteer recruitment and scheduling across multiple counties during a major election cycle.</li>
        <li>Utilized Votebuilder CRM to manage voter outreach and track campaign-related data.</li>
        <li>Conducted extensive outreach, including thousands of cold calls, to strengthen volunteer engagement.</li>
      </ul>
    </div>

    <div class="subsection">
      <h3>Customer Service Representative</h3>
      <p>Fully Loaded Electronics – Mill Creek, WA<br>
      <em>April 2022 – July 2022</em></p>
      <ul>
        <li>Provided technical support for specialized electronics in environments including children’s hospitals and correctional facilities.</li>
        <li>Addressed product issues efficiently, ensuring high levels of customer satisfaction during peak sales periods.</li>
      </ul>
    </div>

    <div class="subsection">
      <h3>Inside Sales Representative</h3>
      <p>Buchanan Automation – Snohomish, WA<br>
      <em>January 2022 – April 2022</em></p>
      <ul>
        <li>Managed key client accounts, including large-scale clients such as Amazon, while offering technical sales support.</li>
        <li>Collaborated with engineering teams to troubleshoot and resolve complex technical issues.</li>
        <li>Fostered strong customer relationships, contributing to client retention and repeat business.</li>
      </ul>
    </div>

    <div class="subsection">
      <h3>Database Administration Intern</h3>
      <p>Stratagraph, Inc. – Remote<br>
      <em>September 2020 – June 2021</em></p>
      <ul>
        <li>Led the transition from an Excel-based system to a robust SQL database, significantly improving data integrity and accessibility.</li>
        <li>Collaborated on migrating data to a cloud-based platform, enhancing system scalability and flexibility.</li>
        <li>Developed real-time heat map visualizations to support dynamic business decision-making.</li>
      </ul>
    </div>

    <div class="subsection">
      <h3>Senior IT Manager</h3>
      <p>Z Sport Automotive – Everett, WA<br>
      <em>February 2016 – May 2020</em></p>
      <ul>
        <li>Oversaw daily IT operations, including hardware repairs, software troubleshooting, and network maintenance across multiple sites.</li>
        <li>Deployed and upgraded computer systems and Ethernet cabling to improve overall infrastructure.</li>
        <li>Managed digital content and maintained the company website to enhance online presence.</li>
        <li>Coordinated the installation of security systems to safeguard company assets and ensure operational continuity.</li>
      </ul>
    </div>
  </section>

  <section>
    <h2>Major Projects</h2>
    <ul>
      <li><strong>Comprehensive SQLite Database for Enrollment & Developmental Metrics:</strong> Designed and implemented a scalable SQLite database to capture key performance indicators—including enrollment, developmental progress, and additional operational metrics—for the Child Development Center. This solution enhanced grant reporting accuracy and provided a flexible platform for strategic decision-making and ongoing program evaluation.</li>
      <li><strong>Annual Outcomes Reporting Initiative:</strong> Developed and maintained an Annual Outcomes Report distributed to grant funders, showcased publicly, and presented at fundraising events. This report synthesizes key performance indicators and success stories, bolstering transparency and donor engagement.</li>
      <li><strong>Resident Eligibility Coordination & Onboarding:</strong> Spearheaded the eligibility process for dozens of families during the lease-up of a new housing facility. Managed extensive intake procedures, coordinated documentation, and served as the first point of contact—building strong relationships and ensuring a seamless move-in experience.</li>
      <li><strong>Enhanced Database Architecture for Housing Unit Management:</strong> Upgraded the existing database by integrating a dedicated table for housing units and establishing relational links between families and units. This enhancement streamlined address tracking across programs and resolved recording discrepancies during transitions from shelter to permanent supportive housing.</li>
      <li><strong>Automated Assessment Data Scraper Development Using Playwright:</strong> Engineered an automated data scraper with Playwright to extract assessment data without direct API access. This saved the organization tens of thousands of dollars on additional features from our service provider. The project aims to fully automate data replication between two separate databases without requiring API access or manual input, significantly improving efficiency.</li>
      <li><strong>Dashboard Development:</strong> Developed local static dashboards using Jinja2 with Python/HTML, including a dashboard analyzing police interactions at a specific property over multiple years. Identified seasonal trends and significant patterns, enabling senior leadership to digest thousands of records and make informed decisions based on forecasts.</li>
    </ul>
  </section>

  <section>
    <h2>Education</h2>
    <p>
      <strong>Bachelor of Science in Data Analytics</strong><br>
      Eastern Washington University – Cheney, WA<br>
      <em>June 2021</em>
    </p>
  </section>
</body>
</html>