Spencer Alpaugh Email & Phone Number

Directed company sales forecasting from both short-term and long-term outlook analyzing bookings, backlog, and supply chain statuses in Excel and Tableau to then present to company leadership team.

Greater Seattle Area

Ran ad-hoc reports in Salesforce and Tableau for Sales, Marketing, Compliance, Supply Chain, and Business Operations. Hosted Quarterly Business Reviews: pulled data, built data visualizations, and presented to CEO, Director of Business Operations, Directors of Sales, Director of Marketing, and others on a quarterly basis. Reduced monthly sales team forecasting by 16 hours per month by streamlining the process in Salesforce

Seattle, Washington, United States

• Reviewed and approved potential investment submissions by Market Analysts• Led collaboration with our Phoenix office in order to align and maintain standard operating processes, ensure processes were accurately documented, worked with managers to seek higher level change• Pioneered new processes adopted by the entire org, including how to handle active real estate listings in valuation process (driving improvements in analyst efficiency and valuation accuracy), and team training on the SOP and subsequent updates• Coached 1:1 with team members to create personalized plans of improving accuracy with metrics using data-driven suggestions

Greater Seattle Area

• Valued, underwrote, and analyzed potential risk of investments for Zillow Offers’s asset portfolio, using data inputs from the industry, machine learning team, and internal sources• Forecasted and predicted the value of these homes as well as remaining within service-level agreement of 90% completion within 24 hours, consistently overachieving weekly quota and goals • Pricing Analytics lead for Orange County, California working with technical teams, real estate teams, operational teams, and customer support teams to operationally improve the region’s accuracy by over 3%• Verified multiple testing environments across machine learning teams, beta tested and improved new internal tools to streamline the underwriting process and reduce it by 12 minutes • Tracked both longterm and short-term supply and demand of housing within submarket areas of our highest volume market, Phoenix, we use to improve our customer conversion rates and customer satisfaction scores• Developed a Zillow Offers pricing process presentation to educate our sales representatives on the data within our control which improved communication between teams and built inter-team cooperation

Williamstown, Ma

• Utilized RStudio to analyze a dataset of almost 100,000 hospital cancer patients around the country • Explored new strategies to learn from this hospital dataset utilizing cluster analysis to compare vastly different groups of cancer patients and see their increased likelihood of death from repeated hospital visits • Experimented with different forms of data visualization to show clusters of similar patients using Shiny in RStudio. • Tabulated over 100,000 data points into concise, easy-to-read tables for a non-data savvy audience

Greater Boston Area

• Made 200+ phone calls over the summer to collect information/data on real estate markets around the country • Analyzed the information with Excel to discover differences and trends from the previous surveys • Tracked necessary real estate data to assist executives with condensing budgets when relocating across the country• Discovered an average rent increase of 5% in Sunbelt cities through a meta-analysis of all Sunbelt cities over 4 years

Bachelor Of Arts (B.A.), Statistics, 2018

Activities and Societies: Varsity Swim & Dive, Club Water Polo, Eph Leadership Academy

Visiting Student, Statistics

Studied abroad at the University of Sydney

2014

Activities and Societies: BHS Swim & Dive (team captain 2013-2014), Bainbridge Island Swim Club (team captain 2012-2013), Academic Honor.

Statistics