Learn Data Skills
Beta

Matthew Insco

Analyst

Evident Scientific

Technologies

My Portfolio Highlights

My New Track

Power BI Fundamentals

My New Course

Introduction to Python

My New Track

Power BI Fundamentals

Data explorer, uncovering insights in the digital wilderness.

My Work

Take a look at my latest work.

course

Introduction to Power BI

course

Introduction to DAX in Power BI

course

Introduction to Python

course

Introduction to Power BI

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

Courses

Introduction to Python
Introduction to Power BI
Introduction to DAX in Power BI
Data Visualization in Power BI

My Work Experience

Where I've interned and worked during my career.

Austin Eastciders | Apr 2022 - Oct 2022

Supply Chain, Project Management, and Operations Consultant

• Remote position with frequent travel for on-site leadership • Project management of and subject matter expert for the implementation of ERP software, Ekos; including setup, training, development of SOPs, and creation of planning integrations • Performed supply chain analysis and provided recommendations for targeted margin improvements • Modeled projected revenues against variable regional COGS to identify strategic strengths and weaknesses of production and distribution plans • Assisted with R&D and provided unique ingredient insights that lead to a new product • Identified and initiated quality validation for significant COGS reduction initiatives • Advisement and resource creation for co-manufacturing partner inquiries including contract production and alternating proprietorship • Familiarized with cidery operations, processes, and cider/wine regulatory and compliance requirements with FDA • Exposed to Kosher certification manufacturing requirements
Show More

Chihuahua Cerveza | Dec 2018 - Feb 2022

Director of Brewing Operations

• Managed multiple multi-year contract partners for the production of all finished goods; including primary point of contact for all communications and lead alignment meetings, new and revised contract negotiations, new product development, change management, materials procurement (where applicable), and finished goods shipping/pickup • Performed all quality monitoring; sourcing and procurement; COGS reductions; partner relationship building; site-visits; new product development for RTD’s, beer, and hard seltzers via remote and on-site R&D; brand profile matching between facilities; new partner vetting; inventory management, and S&OP/production planning and for nine states and international sales • Developed nine brands sold through distribution channels in nine states • Won Gold Medal at GABF in 2020 for the brand Rico • Coordinated with President and V.P. of Operations on new facility acquisition, forecasting, finished goods logistics, strategic planning, contract partner negotiations, and pricing analysis • In-depth experience with Orchestrated Beer (SAP Business One) ERP software, including commissioning of production module • Project managed new product launches; including packaging materials artwork timeliness, ordering, regulatory approval, and logistics

Celis Brewery | Jul 2021 - Jan 2022

Interim Brewmaster

• Managed all production, including: scheduling and development of a team of eight; new brand development; SOP update and creation; all production personnel advertisements, interviews, and hiring (including long-term, full- time Brewmaster); forecasting; S&OP/production planning; master scheduling; sourcing & procurement; new equipment purchasing; and equipment maintenance and repairs (both hands-on and contracted) • Managed contract partnerships as primary point of contact on all communications, contract negotiations, scheduling, and new product development. Received very positive feedback from partner for quality of communications • Vetted and walked prospective contract partners through requirements and priorities of relationship • Experienced with Ekos Brewery Management software through use as primary user in all production, including utilization of customized reporting for use in custom-made supply and demand planning tools • Oversaw substantial improvement to morale and historical brand matching

Self-employed | Jul 2017 - Present

Technical Brewing, Operations, and Supply Chain Management Consultant

I offer advisement and management (both remote and on-site) on all brewery and cidery operations and programs, including: • Equipment selection and planning • Demand, supply and production planning • Technical brewing guidance • New brand development/recipe work • SOP creation and editing, and training • Project management • Client-success and satisfaction driven philosophy • ERP software management and implementation, and more

Hangar 24 Craft Brewery | Nov 2016 - Jul 2017

Brewing Subject Matter Expert

• Management of all barrel-aged products; including new product development on fourteen products, S&OP/production planning, capital expenditure sourcing and procurement, and master scheduling for a program totaling nearly 400 oaken barrels in inventory o Received an average untappd review score of 4.28 (out of five) for all barrel- aged beer released during tenure • Subject Matter Expert and in-house authority on all technical brewing questions, programs, and problem solving • Advisement, trialing, and scaling on all new product development, company- wide • Creation of production KPI's and tracking systems • Management of KPI-driven, brewery-wide efficiency improvement projects • Designed and successfully trialed PLC system of cold block • Designed, sourced, procured, and installed boil-over prevention system • Continued assistance, management, and advisement on all items below

Hangar 24 Craft Brewery | May 2015 - Nov 2016

Senior Brewer

• Interim brewhouse management, including raw materials procurement, master scheduling, and personnel management • Coordination of spent grain removal • Creation and refinement of SOP's • Management of numerous quality, efficiency, and ease of operation-related improvement projects in brewhouse and cellar, yielding: o 4% increase in wort to bright beer yield o 12% increase in wort production capacity with existing equipment o 12% increase in fermentation capacity with existing equipment • Assisted with coordination of pilot brewing, sour and spirit-barrel-aging, and recipe development • Experience with Vicinity Manufacturing software and Great Plains • Leadership and training of packaging, brewing, and cellar staff to encourage safety, quality, morale, and production efficiency • Representative of brewery at events • Analysis and receipt of raw materials, including assisting in hop lot selections

Hangar 24 Craft Brewery | Feb 2013 - May 2015

Brewer

• Wort production on 20 BBL system. 37,500 BBL’s produced in 2014 • Yeast management: harvesting, cell counts, calculation, viability measurement, and pitching • CIP of brewhouse, heat exchanger, FV, BBT, bottling, canning lines, etc.. • General cellar work: DE filtration, GEA Westfalia centrifuge clarification, dry- hopping, beer transfers, beer carbonation, packaging equipment CIP, fermentation monitoring, and general sanitation • Validated tasting panel member

Associated Youth Services | Aug 2010 - Aug 2012

Resource Development Specialist

Coordinated special events. Created email and direct-mail correspondence and appeals. Conducted all marketing operations and graphic design. Updated and designed agency website through in-depth knowledge of content management systems.

Associated Youth Services | Jul 2009 - Jul 2010

Resource Development and Marketing Specialist VISTA

Coordinated all special events. Created email and direct-mail correspondence and appeals. Conducted all marketing operations and graphic design. Updated and designed agency website through in-depth knowledge of content management systems.

Cornell University | Jan 2009 - May 2009

Development Intern

Researched and wrote grants for Project BirdSleuth. Assisted with coordination of student ornithology-themed art show.

Habitat for Humanity of Springfield, MO | Aug 2008 - Dec 2008

Grant Writer

Awarded $37,000 from first-time funder.

My Education

Take a look at my formal education

WBA International Diploma, Brewing TechnologySiebel Institute of Technology | 2012
Bachelors, WritingIthaca College | 2009
Creative Writing, Czech LiteratureCharles University in Prague | 2008

Powered by

  • Work
  • Courses
  • Experience
  • Education
  • Create Your Data Portfolio for Free