matthew_hardy_resume.sh

Matthew Hardy

Data Engineering & Analytics  |  Full-Stack Automation  |  AWS Cloud & Security

Greater Harrisburg Area

Amazon — 3 years 6 months
Data Analyst
August 2024 – Present  |  United States
  • Spearheaded an end-to-end facility launch — from legacy decommission to full operational standup — owning capacity planning, zone configuration, and process validation with zero critical disruptions.
  • Led a full-scale infrastructure audit of a 1M+ sq ft facility, resolving over a decade of capacity misalignment — restructuring layouts, correcting system-to-physical discrepancies, and optimizing pathing to protect SLAs and associate safety.
  • Built a real-time capacity management platform with automated controls across drop zones and pick areas, eliminating overflow incidents and transforming reactive safety responses into preventive operations.
  • Developed a network-wide inventory governance platform with automated daily reporting, giving leadership visibility into revenue leakage and enabling targeted corrective actions at scale.
  • Designed a regional compliance monitoring system that surfaced real-time accountability metrics, enabling operations teams to enforce standard work consistency across a newly established network.
  • Architected automated safety reporting systems using SQL that proactively identified and rerouted high-risk packages, directly reducing workplace injuries.
  • Created executive-facing analytics using QuickSight that distilled complex operational data into decision-ready insights for senior leadership.
  • Delivered automation tools that eliminated manual pick path planning and bulk inventory processing, reclaiming associate hours and accelerating fulfillment throughput.
  • Partnered with AWS security and engineering teams to resolve critical (Sev2) vulnerabilities with rapid turnaround, maintaining system integrity under tight SLAs.
Click to collapse
Supervisor
March 2023 – August 2024  |  United States
  • Developed automation macros that reduced a 1-hour manual process to 10 minutes — an 83% efficiency gain adopted across team workflows.
  • Independently identified and built automation solutions that reclaimed significant operational hours for strategic initiatives.
Click to expand
Problem Solver / Ambassador
November 2022 – March 2023  |  United States
  • Served as Subject Matter Expert conducting audits and managing AWS programs (FC Research, GraVis, Eagle Eye) to support operational excellence.
  • Directed and coached associates, delivered training, and authored standard work procedures to improve team performance and workflow accuracy.
Click to expand
Self-Employed
Investment Analyst
June 2010 – Present  |  United States
  • Built proprietary financial analysis tools using thinkScript for rapid interpretation of chart patterns across day and swing trading strategies.
  • Automated real-time news collection via APIs for 50+ companies, augmenting fundamental analysis with comprehensive market event coverage.
  • Applied advanced technical analysis (Regression, Wyckoff Accumulation/Distribution) to enhance predictive modeling informed by macroeconomic indicators.
Click to expand
Scientific Games
Analyst
January 2014 – August 2017  |  United States
  • Enhanced lottery machine monitoring using expertise in Random Number Generators and security features, improving anomaly detection by 15%.
  • Streamlined automated machine update cycles, reducing technology deployment times by 20%.
  • Maintained stringent security clearance and protocols for systems critical to lottery integrity.
Click to expand
Languages
Python
92%
SQL
95%
VBA
88%
JavaScript
82%
HTML / CSS
85%
Analytics & Visualization
QuickSight
90%
Tableau
78%
Power BI
75%
MS Excel
96%
Cloud & Security
AWS
85%
Selenium
80%
Cybersecurity
78%
2025 – 2027

Bachelor of Science, Computer Science

Western Governors University

2024

Certification, Cybersecurity

Correlation One

2023

Honors Certification, Software Development

Correlation One

2023

Certification, Cloud Engineering

AWS Cloud Institute / Skillbuilder

🚨

Andon Monitor

Alert Tracking • Analytics Dashboard

Real-time andon monitoring with dwell time analysis (0-12h, 12-24h, 24-48h, 48h+), weekly top puller rankings, Lighthouse cycle count integration, and automated CSV exports with pivot table generation. Hidden browser operation via Win32 API.

PythonTkinterSeleniumWin32 APIExcel COM
🗺

Pick Path Generator

Aisle Sorting • Path Optimization

Automated pick path tool sorting bins by aisle, shelf, and slot with configurable snake or zig-zag patterns. Supports even/odd slot filtering, dual-aisle interleaving, 6 shelf sort modes, and 200-row configuration for full facility planning.

PythonPandasTkinterOpenPyXLCSV
🗑

Bulk Delete & Sideline Tool

Inventory Management • Browser Automation

Dual-tab automation for mass item deletion (AFT) and sidelining (Poirot). Full workflow: scan, select, confirm, log. Supports CSV bulk uploads, session reuse across runs, and structured Excel log exports with container, ASIN, and cost data.

PythonSeleniumTkinterOpenPyXLCSV
🚚

Inbound Flow Monitor

Real-Time Tracking • Web Dashboard

Web-based inbound monitoring integrated with FMC. Tracks VRIDs, pallets, units, and door assignments in real time with auto-refresh, multi-page dashboard, analytics, and multi-user credential support.

PythonFlaskHTML/CSS/JSSeleniumFMC API
📈

WAVE DPT — Damaged Inventory Tracker

Quality Monitoring • Automated Reporting

Automated scraper for FC Quality damaged inventory data. Pulls defect data via Selenium, processes through Excel macros, and generates actionable reports for inventory governance and deletion cost tracking.

PythonSeleniumExcel/VBAJSON Config
🗂

SQL Analytics

Production queries powering dashboards and safety reporting across the network
🕑

Inventory Dwell Time Analysis

Facility Audit • Inventory Intelligence

Multi-join query calculating container dwell times across an entire FC. Correlates physical positions with stow/pick activity, bin items, ASIN attributes, shelf life, and pricing. Parses bin IDs into mod/aisle/level/slot. 12+ table joins, window functions, temp tables, and pallet-nested item resolution.

SQLRedshiftWindow FunctionsCTEsTemp Tables

Overweight Package Safety Report

Safety • Automated Alerting

CTE pipeline identifying packages exceeding 50 lbs by joining containers with FCSKU → FNSKU → ASIN resolution and physical weight attributes. Feeds automated daily email alerts to safety teams, directly reducing workplace injuries through proactive rerouting.

SQLRedshiftCTEsMulti-Table JoinsAutomated Alerting
📋

Standard Work Compliance Monitor

Regional Monitoring • Accountability

Tracks dirty cage container movements across the network with dwell times in days/hours, associate-level accountability, and pattern-matched filtering. Distributed via automated daily email to regional leadership for standard work compliance visibility.

SQLRedshiftDATEDIFFPattern MatchingAutomated Distribution
🕹️ M@H Retro Arcade →