Looking for a job

Allen AT

@allenat

Supply chain analyst at Panasonic Avionics who cut deferred demand delays by ~30% with SQL and Power BI.

At Panasonic Avionics Corporation, I built an automated deferred demand management solution with SQL and Power BI. It gave teams real-time global KPI visibility, reduced customer-impacting delays by ~30%, and improved repair shop backlog clearance by ~70%.

I also led an air cargo business case at Panasonic Avionics Corporation, drawing on long-term plans, filings, and market trends. The initiative delivered $11M NPV and ~$5M net cash flow improvement.

At Panasonic Avionics Corporation, I optimized forecasting and provisioning with GAINS and strengthened inventory controls in Oracle EBS. This work sustained 99% service levels and achieved 98% inventory accuracy.

Previously, at PPG Aerospace, I led research into COVID-19 raw material risks and supported mitigation planning. As a Transportation Planner, I used GIS and traffic modeling tools to improve route coverage, connectivity, safety, and corridor traffic flow.

Experience

Work history, roles, and key accomplishments

Sr Supply Chain Analyst

Panasonic Avionics Corporation

Jan 2022 - Jan 2025 (3 years)

Built automated deferred demand management solution using SQL and Power BI, reducing customer-impacting delays by ~30% and improving repair shop backlog clearance by ~70%. Led commercial logistics business case delivering $11M NPV and ~$5M net cash flow improvement.

SQL Power BI GAINS Oracle EBS Ramco Forecasting Inventory Control Cycle Counts Root Cause Analysis KPI Design Business cases NPV Net Cash

Supply Chain Analyst

PPG Aerospace

Jan 2021 - Jan 2022 (1 year)

Led Decision Tree Based Risk Management research to evaluate COVID-19 raw material risks, identifying cost and availability as top risk drivers and supporting mitigation strategies. Forecasted and planned material requirements, managed inventory and order fulfillment.

Risk Management Decision Trees Forecasting Inventory Management ERP Oracle EBS Root Cause Analysis Data Analysis

Transportation Planner

Various Transportation Consulting Companies

Jan 2016 - Jan 2020 (4 years)

Optimized school bus routes and stops using ArcGIS, analyzed parking demand, planned bicycle network expansions, identified high-risk collision locations, refined signal timing, and redesigned intersection geometry.