Matt McMonagle

United States

@mmcmon1990

Badges

Sql

Certifications

mmcmon1990 has not earned any certificates yet.

Work Experience

  • Administrative Assistant II

    Carnegie Mellon University – Computer Science Department•  October 2021 - Present•  Pittsburgh, PA

    Gather and analyze data for School of Computer Science to discern staff onboarding experience, which is utilized by the Dean’s Office to improve staff retention. Automate tasks for 7 faculty members, optimizing course budgeting and grading procedures using Excel/Google Sheets, reducing manual workload by 50%.

  • Product Supply Planner

    ABARTA Coca-Cola Beverages•  June 2021 - October 2021•  Pittsburgh, PA

    Utilized SAP software to monitor warehouse inventories and generate product orders. Optimized inventory management processes using Excel and SAP, reducing stockouts by 10%.

  • Key Account Coordinator

    ABARTA Coca-Cola Beverages•  February 2018 - June 2021•  Pittsburgh, PA

    Forecasted sales volume at grocery chains and maintained a 90% or higher on in stock items. Developed Excel dashboards for inventory forecasting, improving supply chain accuracy by 15%. Collaborated with developers to enhance forecasting tools based on user feedback.

  • Account Manager

    ABARTA Coca-Cola Beverages•  February 2015 - February 2018•  Pittsburgh, PA

  • Merchandiser

    ABARTA Coca-Cola Beverages•  February 2014 - February 2015•  Pittsburgh, PA

Education

  • Carnegie Mellon University

    Information Technology, Master of Information Technology: Business Intelligence and Data Analytics•  May 2023 - Present•  GPA: 4.19

  • Slippery Rock University of Pennsylvania

    Bachelor of Science in Business Administration•  August 2011 - December 2013•  GPA: 3.425

  • Butler County Community College

    Transfer•  August 2009 - May 2011

Skills

ETL pipelines
dbt
Oracle Data Modeler
Oracle SQL Developer
Heroku
Linux
Git
Flask
IntelliJ
Jupyter
Docker
DuckDB
Cassandra
MongoDB
Redis
Neo4j
Oracle
Python
SQL
PL/SQL
Java
R
JavaScript
YAML
C++