Supply Chain Planning Specialist

Earl Puzon

********@*****.*** 951-***-**** San Diego, CA

WORK EXPERIENCE

Northrop Grumman September 2019 – Present

Supply Chain Planning Specialist San Diego, CA

Developed a comprehensive understanding of supply chain management in the areas of material receipts forecasting, manufacturing, inventory management, and establishing strong communication with key internal and external stakeholders for a $300M Program.

Provided monthly material receipts forecast for material worth over $120M each month and included variance analyses that compares current and previous month forecasts; applied Earned Value Management techniques to provide cost and schedule performances on material receipts for the program.

Designed and provided a weekly material status report that identified critical-path materials used in production and displayed on-time delivery schedules of finished goods from suppliers.

Established KPI’s and dashboards using data analysis and Lean Six Sigma techniques for a Return-To-Vendor Process Improvement Project, which measured the efficiency of the project that improved the return time of non-conforming material back to suppliers from an average of 30 days to 48 hours (93% improvement).

Conducted in-depth analyses through Microsoft Excel and SAP to provide identify trends in material attrition and inventory levels; performed regular audits of material transactions and inventory used for production.

Created ad-hoc reports using advanced knowledge of Excel and analyzing large datasets to troubleshoot and provide resolutions for operational and financial concerns within the supply chain.

Collaborated with cross-functional groups such as 3PL, Engineering, Procurement, Material Planning, Warehouse, and Program Management to help suppliers resolve issues with delivering finished goods and executing projects that supports the program’s contractual requirements and financial objectives. Conservice, LLC March 2017 – December 2019

Rate Analyst San Diego, CA

Identified over $1.5M in projected annual savings opportunities for multi-family and commercial clients by interpreting complex regulatory guidelines & tariffs and developing rate audit reports that analyzed optimal utility rate models for their properties.

Individually managed over 200 utility accounts for clients that lead to clients obtaining $300K in back-credits with utility providers rectifying billing errors and $800K in annual savings for switching them to optimal utility rate schedules.

Constructed utility rate models with advanced formula developments and modelling in Excel, which identified optimal rate pricing plans & ensured billing accuracy for multi-family and commercial utility accounts.

Provided annual utility budget forecasts for over 2,000 multi-family properties, which predicted the price change in their utility bills through analysis of historical price trends and market research. EDUCATION & CERTIFICATIONS

University of California San Diego June 2017

B.S. Management Science Minor in Accounting La Jolla, CA

Relevant Coursework: Microeconomics, Econometrics, Corporate Finance, Financial Accounting, Intermediate

& Advanced Accounting, Financial Statement Analysis, Industrial Organizational Psychology. UCSD Extension September 2020

Lean Six Sigma Green Belt Certification San Diego, CA SKILLS & INTERESTS

Skills: Advanced Microsoft Excel skills using Pivot Tables, VLOOKUP, INDEX MATCH, Modelling, and Formatting. Microsoft Office and SharePoint. Python. SAP and ERP. Project Management. Lean Six Sigma Process Improvement Techniques. Supplier Relations. Adept Communication and Interpersonal Skills.

Interests: Hiking. Mountain Biking. Snowboarding. Cooking. Travelling.

Contact this candidate