Gunnar K. Email & Phone Number

Lehi, Ut

Provide Analysis for Finance, Purchasing, and Operations focusing on Materials Supply Chain and Sales. Develop many SQL (MySQL) Tables, Views and Procedures and Tableau Reports to provide ad hoc and recurring analysis to management to support business decisions. Created and tracked new KPI’s (including supplier, buyer, and warehouse performance, excess and expiring inventory tracking), and ensure the entire supply chain is efficient and successful from farm to consumer. prepare comprehensive analyses, business cases, and reports to assist Global Procurement and Manufacturing with strategic initiatives and projects, including forecasting, variance analysis, regression analysis, and long-range projection and planning.

Draper, Uta

Work with the FP&A team to forecast the number of calls, texts, chats, and emails to projectheadcount and plan out hiring for Customer Support and Marketplace Trust&Safety. Deep-diveanalysis to find correlations between volume and website activity to improve the forecastingmodel. Present model and projections to Sr Managers and Heads of Business. Work withProduct Managers to project the support impact of product changes and roll-outs in a fast-pacedenvironment. Automate real-time reporting on staffing efficiencies, service levels and forecastaccuracy using BigQuery SQL and Tableau.

Draper, Utah

Implemented metrics and weekly/monthly/yearly tracking on the performance of allCustomer Operations (Phone Support, Email, Chat, SMS, Social Media, Sales, AccountManagement, Trust & Safety, Recruiting, QA, Customer Feedback, Training, and related BusinessLevel data). Built and maintained reports starting in Google Sheets/Excel and helped transfer andautomate these first in an in-house PostgreSQL Database, second to SQL/HTML based ModeAnalytics, third to Tableau Desktop and now currently Tableau Online (working towards TableauServer). Created a repository of support data tables and views in Google Bigquery for Supportand Product Managers to correlate to Product & Business data. Deep Dive Analysis, i.e. Supportcost savings review with the Finance Team.