Jayson S.

Data Visualization and Advanced Spreadsheet Consultant

A current Operations Analyst of 7+ years experience in the Manufacturing and Finance industry, with a passion for problem solving by using various programs. I specialize in spreadsheet and dashboard creation, developing complex formulas, and process automation using VBA/Google App script. Throughout my professional career I have worked on various projects such as: -Create a Google Script to run on a daily basis to automatically save gmail attachments (.xlsx & .csv files) based on a query to a Google Drive Folder, then automatically import that information into an existing Google Sheet. -Create a Google Script to send out automatic emails to different accounts based on multiple criteria’s in different columns. -Modern style dashboard creation in Google Data Studio to display employee performance metrics and business goals and actuals. -Create a sales order form in Google Sheets with dynamic dropdowns and complex formulas that updates a sales order database and sends emails when submitted. -Develop an inventory system in Google Sheets that increases/decreases inventory counts automatically based off of PO receipts and shipments. -Design a job costing sheet in Google Sheets that takes into account raw material costs, production line efficiencies, and labor costs per work order. -Compile 3 months worth of shipments (30,000+ orders) for a 3PL fulfillment company and pull information from six different sources in order to accurately create client invoices in Quickbooks. I love working on new projects and having them turn out (visually and functionally) as envisioned. Thank you for considering me for your business needs.