Andrea McCoy
Prologis
Denver,Colorado
9
years of professional experience
Procurement process expert experienced in product research, sourcing, category management, pricing negotiations, contracts, requisitions, requests for quotes, purchase orders, logistical error resolution and invoice reconciliation
Work History
Procurement Analyst
1 Year 4 Months- Uses Excel to model and compare vendor bids, providing actionable insights for contract decision making
- Translates analysis into data-driven conclusions to cross-functional teams and recommends strategies to improve procurement efficiency, mitigate risks, and save an average of 10% across all categories
- Ensures contracts are accurate and actionable
Buyer II
2 Years- Led procurement of fabricated automation parts and large external systems
- Served as key user and super user during SAP S/4HANA transition
- Wrote a detailed procurement user guide
- Trained procurement staff
- Built and executed reports and scripts within SAP
- Updated master data insuring accuracy
- Developed and maintained Excel and Power BI forecasting models based on lean principles to make sound inventory decisions
- Created pricing analysis tools to evaluate vendor quotes and identify cost-saving opportunities
- Negotiated multimillion-dollar contracts with both international and domestic suppliers for large external systems (feeders, lasers, tray handers, etc.) resulting in an average savings of 5% on each machine
Buyer
2 Years 9 Months- Processed and managed RFQs, POs, confirmations, and delivery schedules for globally sourced mechanical parts and equipment
- Acted as bridge between Logistics, Accounting, Engineering, Development, and Quality Assurance teams
- Implemented strategies to meet project deadlines by procuring long lead time items early in the project lifecycle
- Vetted and monitored performance of new and existing suppliers according to ISO 9000 standards
Fleet Purchasing Agent
3 Years 3 Months- Oversaw procurement of parts and services for 40 ambulance and fire engine fleet facilities
- Used Excel to monitor spending, track orders, and reconcile invoices
- Facilitated digital literacy training for mechanical teams
Education
Bachelor of Science in Business Administration - International Business
Skills
Power BI
Supplier negotiatons
Copilot AI
SAP/4HANA
Data analysis and reporting
Cross-functional collaboration
Problem solving
Advanced Excel
Timeline
Procurement Analyst
Prologis
06.2025 - CurrentRead More
Buyer II
Mikron Automation
06.2023 - 06.2025Read More
Buyer
Mikron Automation
09.2020 - 06.2023Read More
Fleet Purchasing Agent
American Medical Response
06.2017 - 09.2020Read More
University of Southern Mississippi
Bachelor of Science in Business Administration from International Business
Read More