Andy Alseth Email & Phone Number

Málaga, AL, ES

Bentonville, Arkansas, United States

Primary data engineer on analytics solutions team for HR reporting to executives at a Fortune 500 company.- Converted transformation pipelines to dbt- Developed "medallion" schema for database, reducing time for re-running pipelines by over 50%- Nominated by coworkers and received company-wide "Intellectual Curiosity" award in 2023

Bentonville, Arkansas, United States

Primary data engineer on analytics solutions team for HR reporting to executives at a Fortune 500 company.- Reduced monthly infrastructure spend by >50% by migrating database and ETL pipleines to Snowflake- Improved daily reporting lag during annual enrollment period from 2+ hours down to < 30 minutes by automating data ingestion pipeline

Developed DNA sequence design algorithm in Python to optimize correct growth of DNA-based algorithmic structuresProgrammatically designed DNA origami structures for nanocompuation Co-developer of STAM* and STAMR models of computational geometry; proved self-replication of 3D shapes

Interviewed 15 emergency managers to develop mathematical models of real-world disaster scenariosDeveloped novel online programming solutions to Canadian Traveler Problem with multiple agents in PythonCarried out over 100K simulations of both real-world and randomly-generated networks utilizing High-Performance Computing centers at University of Arkansas.

Generated flood prediction model to assign likelihood of road flooding using meteorological predictionsUtilized hourly flood simulations from Hurricane Harvey to develop novel flood routing algorithms which provides street-by-street flood estimation using OSMnx package

Reno, Nevada Area

Provided technical and project management support to plant operations, safety, business growth, and cost savings initiativesManaged the execution of $1MM in capital projects, keeping to cash flow and scheduling plansActed as plant steward for new packaging line installation, ensuring successful implementationOwner of plant data archiving and visualization.

Pleasanton, CA

Provided business intelligence and business analytic support to enable growth strategies throughout the Product Supply Organization (PSO)Developed spend data pipeline for all of Clorox U.S. accounts payable information in MS SQL (~$3B/year, >6MM rows of data) with fidelity down to individual purchase orders, and blended data to upload to Tableau business.

Springfield, Oregon

Utilized numerous software tools to drive adoption of statistical process control (SPC) techniques by operators, including refining process model accuracy to an r^2 value of 0.91Carried out multiple capital projects in retort and quality departments that support excellence in day to day operationsAssisted lead technicians in preventing recurring pump.

Kennesaw, GA

Managed projects at various plants within the Clorox network, including Burt's Bees, Homecare, and CleaningLearned and utilized Clorox 'One Right Way' for project managementWorked with plant operation contacts, Clorox Services Company personnel, and outside contractors to deliver quality engineered solutions to plantsServed as process engineering lead for.

Chesterfield, MO

Developed a dynamic and rigorous simulation of gold elution column for customer operator training systems (OTS)Involved in design and development of dynamic simulations of customer systems using MiMiC Simulation SoftwareDeveloped new material for MiMiC Simulation Software training classes, and created new simulation models to illustrate the functionality.

Greater St. Louis Area

Research & development on out of autoclave composite processing.Placed in charge of production of four out of autoclave parts, funded by the Office of Naval Research (ONR), to determine how producible the new material was during hand layup of complex parts. Parts produced on-time, with learning passed on to the ONR in the form of a report. Personally.

Preventative maintenance of laboratory equipment such as -80C freezers, vacuum pumps for mass spectrometers. Fabricated custom devices for researchers, such as a cover for pressure loader for capillary column

Helped teach 25+ students the basics of object oriented programming through answering questions about Java programming projectsGraded Java homework and projects

Master Of Science - Ms, Industrial Engineering

Bachelor Of Science (B.S.), Chemical Engineering

Activities and Societies: Cycling Club Vice President, Omega Chi Epsilon: Chemical Engineering Honor Society

Biomedical Engineering

Activities and Societies: Treasurer of Marquette University Biomedical Engineering Society, Co-founder of Triathlon Team of Marquette.

Education record