Zachary Pitchford

● Developed and maintained a custom CRM solution using Google Sheets and Google Apps Script to automate customer tracking, workflow management, and reporting for a small business client. ● Built a web-based interface to streamline data entry and improve usability of spreadsheet-backed business operations. ● Performed lead generation research and developed a structured lead scoring approach, including an automated lead generation workflow using Python-based modeling with XGBoost to help prioritize potential customer outreach. ● Provided contract services for local clients, including logistics, business operations, and technology projects.

● Replaced and installed 300+ residential and commercial gas meters while adhering to Duke Energy/Piedmont Natural Gas safety standards and regulatory requirements. ● Conducted leak detection, pressure testing, and meter inspections to ensure safe gas service operation, identifying hazards and red-tagging non-compliant appliances when necessary. ● Followed lockout/tagout procedures, OSHA safety practices, and company protocols, maintaining a strong safety record in customer homes and field environments. ● Utilized mobile work order systems, service maps, and technical documentation to complete installations accurately, maintain records, and meet daily service quotas. ● Delivered professional customer service during in-home visits, coordinated with dispatch and field crews, and practiced Smith System defensive driving principles while safely operating company vehicles.

● Performed routine maintenance and inspections on HVAC, electrical, plumbing, appliances, and building finishes, ensuring compliance with safety standards across a 100,000 sq ft commercial property. ● Coordinated 24/7 maintenance requests and maintained records for 500+ service activities, inspections, and inventory transactions. ● Implemented preventive maintenance schedules based on repair history analysis, extending equipment life expectancy by an average of 2–3 years. ● Facilitated renovation projects across 336 units, ensuring timely completion and compliance with project requirements. ● Executed the successful transfer of property between Southwood Realty and Stoneriver Property Management.

● Delivered 100+ packages weekly while maintaining customer satisfaction and accurate financial, mileage, and vehicle maintenance records.

● Created an automated scheduling system for bike rentals using Google Apps Script, cutting down paperwork by 25%. ● Leveraged hands-on expertise to diagnose and repair over 50 bicycles per month, ensuring all bikes met safety and performance standards. ● Administered bikes to students and faculty on a weekly basis, and taught students how to repair bikes during monthly seminars. ● Trained and supervised a team of 6 bike mechanics, improving repair turnaround time through the implementation of a structured workflow and regular performance evaluations.

● Collaborated with 16 team members to schedule front desk and twenty-four hour phone coverage to enforce consistent resident accountability. ● Developed community programs for 300 residents, increasing participation and resident satisfaction.