Preston Whited

P RESTON W HITED - ♦-Business Analyst PROFESSIONAL SUMMARY Visionary and driven professional with wide-ranging, solid experience in optimizing business systems. Capable of significantly reducing administrative labor hours while decreasing process complexity and errors. Exhibit extensive experience in a variety of industries, small and large companies; collaborating at all levels of an organization, with and without enterprise resource planning (ERP). Proficient in SQL, SQL Server, VBScript, VBA, JavaScript, HTML, Microsoft Excel (Expert) and Access, Power Query, Power BI, Crystal Reports and Automation. AREAS • • • • • OF STRENGTH Demonstrated natural drive and vision by observing a process/system and envisioning how it could work better; save time, reduce stress, improve productivity and workplace experience. Driven to take on and complete projects each day. Exhibit continuous improvement by not stopping at 90% better but always thinking of ways to reach the next level. At project completion, analyze doors this opened and path to take for more improvement. Proven speed and accuracy demonstrated by paying attention to detail and performing tasks right the first time. Skilled at bridging gaps between computer/software technical world and non-technical personnel by understanding each department’s needs for creating value. Acquired a strong base of knowledge (over the years) in wide-ranging areas (for example, sales, customer service, engineering, management, etc.). Proficient in collaborating with teams; relying on the expertise of others to advise effective decisions and navigate the right path. Work well with everyone and very easy to talk to. SELECTED ACCOMPLISHMENTS National Beverage Corp. (Shasta) • Took over production scheduling duties from retiring scheduler without personal prior experience in the soda manufacturing industry and performed the duties without help from manuals, procedures, and software tools. Rapidly learned retiring scheduler’s methods and worked with Shasta’s in-house systems regarding inventory, open orders, and material purchase orders. Within a week, developed improved workflows and designed data connections into spreadsheets which automated about 50% of the work that was previously completed manually. • Developed new tools and reports to improve scheduling, enhanced accuracy of finished goods/raw materials forecasts by analyzing seasonal and promotional factors. • Revamped material ordering sheets to keep stocks lean and re-allocated the scarce warehouse space to finished goods; reducing shortage risks. • Collaborated remotely with corporate supply chain managers to improve visibility of demands nationwide and help coordinate more efficient stock transfers between plants. • Formulated improved spreadsheets for human resources (HR) that calculated current and projected paid time off and sick time automatically and accurately. • Created automated dashboards and scorecards for sales that saved roughly 20 man-hours per week and eliminated errors. Chukar Cherries • • • Created an app within one month that generated a production report in only minutes which helped prioritize the products to make; effectively eliminating the need for a full-time person to manually work on this production report. Previously, during their busiest season, it took 6 people between 10-14 hours per day to create the production report. Now with the new app, only 1 of the office personnel are required part-time to generate the necessary production reports. Updated many spreadsheets used over the years to coordinate production personnel, automated complex kit building calculations and provided visibility into sales. Connected together their various data sets and loaded them into data models for easier reporting, created automated dashboards and scorecards for customer service saving 2-4 man hours per week, and ran analysis with insights not present before. PRESTON WHITED Page 2 of 2 PROFESSIONAL EXPERIENCE Continuous Improvement Analyst – Chukar Cherries, Prosser, WA 2019 – Present • Generated tools and reports to automate management of inventory and production priorities saving 30-60 man-hours per week, reducing errors 90%, and greatly decreasing complexity of manual tasks. • Developed apps to interact with company documents and data, simplified ordering/recording processes, and managed email campaigns. • Automated data collection for temperature probes, then compared with production statistics to determine trends in output. • Integrated new software systems into production processes, trained staff on use, and created supporting apps and custom reports to improve functionality and visibility. Production Scheduler – National Beverage Corp., Tukwila, WA 2018 – 2019 • Formulated soft drink demand forecast based on coming promotions and historic sales. • Established weekly schedule based on forecast and flavor order/configuration requirements. • Redesigned tools and methods for scheduling, raw material ordering, shortage detection, and work order generation; reduced administrative overtime more than 30 hours per week. • Generated multiple reports using Microsoft Excel, VBScript, and in-house software for HR, sales, production, and management; required minimal effort to update or adjust. • Created and maintained indexes to reference products, bills of materials, configurations, inventories, etc. Production Planner – Werner Paddles, Monroe, WA 2016 – 2018 • Oversaw more than 2,000 product configurations through complex, multi-stage, and in-house production processes. • Automated more than 20 administrative hours of daily work into 1 hour or less; increasing accuracy and reducing errors. • Increased responsiveness 1-2 days for production floor to customer fulfillment (normal lead time 5 days) through ensuring clearer tracking systems and maintaining closer connections to the production floor. • Collaborated with engineering and management to facilitate obsolete old product while seamlessly introducing new product. • Created new reporting and database systems to accommodate new floor processes for planning and metric tracking purposes. Production Planner – Mold Rite, Inc., Woodinville, WA 2013 – 2016 • Set up daily priorities for production departments. • Formulated guidelines for schedule capacity and created reports for management. • Generated packaging instructions and general work instructions for production staff as well as providing input for production line design. • Coordinated personnel, raws, and equipment factors among material handling, manufacturing, secondary operations, quality, shipping, and tooling departments to meet sales/engineering test order deadlines. EDUCATION Diploma – Redmond High School, Redmond, WA