Andrew Schmelzer Email & Phone Number

Seattle, Wa, Us

Seattle, Washington, United States

• Aggregated and analyzed data from multiple sources, developing reports for internal and external customers• Harnessed internal and 3rd party APIs to centralize data, accelerate workflows, and reduce costs • Governed business data, maintaining data integrity and providing visibility to operational discrepancies• Revolutionized billing processes, transitioning from monthly manual data entry to automated daily billing process• Streamlined device data management, enabling business scaling and rapid product transition and adoption

Seattle, Washington, United States

• Monitored air, ocean, and ground freight shipments, investigating and escalating anomalous behavior to ensure cargo security• Leveraged API data to analyze shipment milestones and forecast transit times for just-in-time logistics• Authored Python macro program to automate daily office tasks, completing over 37,000 operations in 9 months

St. Cloud, Minnesota Area

• Supplemented and taught math concepts through independent meetings with students in the Math Skills Center• Proctored make-up exams and scored weekly homework and extra credit assignments for 47 calculus students• Expounded on subjects surrounding statistics, calculus, and number theory on student request

St Joseph, Minnesota, United States

• Expanded on known number theory through exploration of Pythagorean triples and Pell equation solutions• Authored an 11-page report of mathematical theorems and corollaries based on my findings• Collaborated with professors and students to condense the summer’s research into 12-minute presentations• Presented findings at the annual Mathematical Association of America conference, MathFest

St Joseph, Minnesota, United States

• Coordinated with campus departments, clubs, and external clients such as Blattner Energy• Operated and troubleshot audio and video media to accommodate events and speakers• Authored and maintained a Python program to automate office tasks resulting in increased office efficiency• Practiced improvisation and adaptation when food or technical assets were unavailable to run events smoothly• Responded to overnight housing difficulties with guests from large conferences to ensure on-campus comfort

Minneapolis, Minnesota, United States

• Co-composed a letter to Gov. Walz protesting the Enbridge Line 3 Pipeline and police brutality• Recruited community members to attend MNIPL’s Climate Justice webinar featuring Senator John Marty• Edited video footage of various tribal groups' message to local lawmakers regarding Line 3• Organized an interfaith climate network in St. Cloud, MN• Completed Relational Organization training through MNIPL’s Be The Spark program