Procurement Analytics & Process Optimization Specialist
Resume:
Megan Ayala
**********@*****.***
www.linkedin.com/in/megan-ayala-
Data-driven analyst and process improvement professional with experience spanning global Air Force logistics and metal coil-coating operations. Over 7 years of experience transforming complex operational and procurement data into actionable insights through automation, dashboarding, and performance analytics. Proven ability to design and optimize workflows, develop scalable reporting solutions, and support data-driven decision-making across cross-functional teams. Leverages deep procurement and supply chain domain knowledge to improve efficiency, cost visibility, and operational performance.
Work Experience
Procurement Analyst September 2024 - Present
AZZ Precoat Metals St. Louis, Missouri
Strategic procurement professional managing vendor portfolios across indirect materials, critical commodities, and capital projects. Provide executive level reporting, KPI tracking, and workflow coordination while leading automation, sourcing, contract negotiations, and cross functional alignment across Legal, Finance, EHS, Operations, Engineering, and Executive Leadership. Strengthen procurement processes through documentation, continuous improvement, and data driven decision making.
Managed and negotiated $45M+ in capital contracts annually, redlining commercial terms, warranties, and restructuring payment milestones in collaboration with legal and structuring milestone-based agreements that protected contractual rights and improved supplier accountability.
Served as the indirect commercial lead for multi-category capital and strategic sourcing initiatives, negotiating vendor agreements across capital equipment, critical services, EHS/safety, and MRO. Managed end-to-end contract lifecycle activities, secured volume-based pricing and favorable commercial terms, and partnered cross-functionally to improve total cost of ownership, supplier performance, and supply continuity.
Diversified critical supply chain and achieved $600K annual savings. Transformed single-vendor dependency on critical commodity by sourcing multiple qualified vendors, negotiating long-term agreements tied to market indices, and leveraging collective capacity across suppliers to secure volume incentives—delivering $600K in recurring annual savings while mitigating supply risk
Provided expert oversight on multi-site PO accuracy, serving as an escalation point for complex discrepancies, training team members, and improving PO compliance from 89% to 97% within seven months, ensuring timely payments and strong vendor relationships.
Spearheaded Integrated Business Planning initiative driving cultural transformation, applying strong leadership and the ability to facilitate meetings across departments driving cultural transformation. Led Integrated Business Planning (IBP) project that established collaborative forecasting and demand planning processes across procurement, operations, sales, and customer service—building customer trust through improved delivery predictability and securing executive buy-in for organizational change through data-driven, machine learning AI statistical tool. Utilized Lucid for process mapping, Asana for project tracking and stakeholder alignment, and Power BI for real-time dashboard reporting.
Oversaw the Oracle ERP migration as procurement POC, partnering with Solutions Architects to ensure an accurate and seamless transition. Provided cross-functional Stakeholder Engagement and utilized Change management practices while transitioning from IBM AS400 to Oracle Cloud ERP, developing new part-numbering logic, leading data validation, and reorganizing inventory for accurate tracking and smooth adoption.
Designed and piloted a risk-driven sourcing platform using Application Development and Business Insights, creating a company wide risk & RFQ automation tool that converts converts a brief questionnaire into a formal RFQ and tracks KPIs, timelines, supplier risk, documentation, supplier performance, and project milestones from initiation through post mortem.
Advanced supplier collaboration and compliance by building an outward-facing Supplier Safety & Compliance Portal that centralizes vendor document upload (W9s, COIs, certifications). Delivered clear communication, workflow coordination, and audit ready documentation to strengthen compliance turnaround and vendor relationships.
Supply Chain Specialist March 2021 - October 2024
UNITED STATES AIR FORCE Scott AFB, Illinois
Point of contact for sourcing, procuring, evaluating, redistributing, and analyzing assets for the C005 and C017 aircraft systems worldwide. Working knowledge of FARS and DFARS.
Forecasted demands and controlled redistribution for over 100K assets totaling $500M+ across 8 en-route locations globally every quarter
Sustain, track, and analyzed over $61B in inventory across 86 deployable kits
Continuous review of purchase orders, external contract terms, and asset specifications
Prepare monthly reports on mission-capable, non-mission-capable, and grounded C17/C5 aircraft utilizing Excel pivot tables and Tableau
Interpret government contracts and recommend the best course of action to customers
Monitored and sourced an average of 400 mission essential orders every reporting month for 70+ locations globally
Resolves problems with purchase orders, delivery movement, and receipting assets
Collaborate with cross-functional organizations, including Boeing, Lockheed Martin, DLA (Defense Logistics Agency), and individual contractors, to procure/source assets daily
Train, develop, and mentor supply and maintenance personnel on supply policies, processes, and procedures
Leads and identifies continuous improvement processes; led ILS-S backorder review that identified 45 expired requirements that aligned with US TRANSCOM's acquisition initiatives, saving the Air Force over $160K
Fueled the restoration of Hawaii’s water crisis by expediting 78 tons of goods to 107K local residents
Vetted the largest Noncombatant Evacuation Operation (NEO) by expediting 45 assets totaling over $550M, enabling 332 Kabul air-evacuations that moved over 124K Afghan refugees
Assistant Trainer Mar 2018 - Feb 2021
DIODORO RACING LLC Various Locations
Supervised 50–65 employees daily across a fast-paced, multi-location operation, ensuring consistent execution, and safety of employees and 75-90 racehorses.
Managed daily staffing plans, task assignments, and schedule adjustments to maintain coverage and performance during peak workload periods.
Reported directly to the company owner/head trainer, providing daily performance updates and operational status to support staffing, scheduling, and priority decisions.
Built and maintained simple KPI/scorecard tracking (labor coverage, task completion, readiness, incidents, turnaround time), highlighting trends, risks, and next actions.
Managed labor planning for 50–65 employees/day, adjusting assignments based on workload forecasts and real-time constraints to maintain coverage and execution quality.
Performed root-cause analysis on missed targets and operational disruptions; implemented corrective actions to reduce repeat issues and improve consistency across shifts/locations.
Standardized SOPs and training checklists; tracked adherence and outcomes to improve quality, safety, and repeatable execution.
Coordinated cross-functionally to resolve exceptions (staffing gaps, scheduling conflicts, resource constraints) and keep daily operations on track during peak periods
Schooled, prepared, and cared for Kentucky Derby, Breeders' Cup runner, and graded stakes winner “Keepmeinmind” during 2019-2020
Core Competencies
Analytics & Visualizations: Power BI, SQL, Excel (Advanced: Power Query, PivotTables, VBA, dynamic formulas, automated reporting, etc), Tableau, DAX, Azure
Process Optimization: Workflow design, root cause analysis, Lean Six Sigma, DMAIC, change management, governance, compliance
Systems & Automation: Oracle APEX, Power Apps, Oracle Cloud ERP, IBM AS400, Lucid, Asana
Programming: Java, JavaScript, TypeScript, React, HTML, CSS, C++
Education
Western Governors University May 2026
Bachelor of Science Business Management
Community College of the Air Force Dec 2024
Associates Logistics
Languages
English (Native Language), Spanish (Fluent), Portuguese (Advanced)
Certificates
ASCM Supply Chain Planning Certificate Jan 2025
Six Sigma Green Belt Jan 2025
DLA Logistics Operations Applications Jan 2024
Lean Six Sigma Green Belt (obtained through DOD) Jan 2022
Data Analyst nanodegree Jan 2022
US Air Force Supply Specialist Jan 2021
Contact this candidate