Garrin McNair
CONCORD,NC
Summary
Dedicated and analytical professional with a strong background in supply chain optimization, data analysis, and project management. Experienced in developing automation tools, implementing efficiency improvements, and collaborating across teams to drive data-driven decision-making. Skilled in Python, SQL, and advanced Excel, with a proven track record of reducing costs and improving operational performance.
Overview
3
3
years of professional experience
Work History
Network Analyst II
Coca-Cola Consolidated, Inc.
06.2024 - Current
- Engineered and implemented automated systems for PLM and SKU deletion processes, ensuring 100% accuracy in new SKU setup and reducing excess inventory costs by 15% through optimized inventory management
- Developed a Python and SQL dashboard to trace root causes of Out-of-Stock (OOS) events, while performing advanced feature engineering for machine learning models, resulting in a 20% reduction in OOS occurrences and empowering data-driven decision-making
- Led technical training initiatives in SQL, Python, VBS, Excel, and Power Query, increasing team-wide process automation by 40% and mentoring junior analysts, fostering a culture of continuous improvement and innovation
- Spearheaded cross-functional collaboration to implement predictive analytics in supply chain operations, optimizing data pipelines for real-time decision-making and presenting actionable insights to senior management
Network Analyst I
Coca-Cola Consolidated, Inc.
12.2022 - 06.2024
- Maintained critical master data integrity across network locations, ensuring accuracy in packing instructions, vendor setups, and EDI transmissions, while conducting regular audits to achieve over 99% data accuracy
- Developed and implemented VBS and Python automations, reducing time spent on redundant tasks and improving overall efficiency by 30%, while creating dynamic Excel dashboards to identify data discrepancies
- Optimized EDI transmissions and resolved IDocs failures, minimizing business disruptions, improving vendor communication, and reducing transmission errors
- Collaborated with cross-functional teams to ensure proper data setup, provided technical support and training to improve organizational data literacy, and participated in new system integrations to ensure smooth data migration
Supply Chain Fulfillment Analyst
Coca-Cola Consolidated, Inc.
08.2021 - 12.2022
- Orchestrated high-volume daily operations, managing 50-100 product loads per day across 4 Distribution Centers and 1 HUB, while optimizing supply chain efficiency using Blue Yonder and SAP planning systems
- Developed innovative tools using Excel, Python, and VBS to identify and address supply chain gaps, enhancing operational visibility and implementing strategic inventory management practices to minimize shrink risk
- Spearheaded daily communication with sales teams, delivering comprehensive supply chain health reports and streamlining cross-functional collaboration, resulting in improved forecast accuracy and customer satisfaction
- Utilized advanced analytics to continuously monitor and optimize supply chain performance, contributing to cost savings, increased operational efficiency, and improved on-time deliveries while reducing out-of-stocks
Education
Bachelor of Science - Marketing
University of North Carolina At Charlotte
12.2019
Skills
- Technical: Python, SQL, VBS, Advanced Excel, Data Analytics, Automation Development, Dashboard Creation
- Project Management: Cross-functional Collaboration, Process Improvement, Risk Management Cloud & Systems: Basic understanding of cloud computing and distributed systems
- Soft Skills: Problem-solving, Communication, Adaptability, Continuous Learning
Timeline
Network Analyst II
Coca-Cola Consolidated, Inc.
06.2024 - Current
Network Analyst I
Coca-Cola Consolidated, Inc.
12.2022 - 06.2024
Supply Chain Fulfillment Analyst
Coca-Cola Consolidated, Inc.
08.2021 - 12.2022
Bachelor of Science - Marketing
University of North Carolina At Charlotte
Similar Profiles
Shaquava BushShaquava Bush
Manager Trainee at Coca Cola ConsolidatedManager Trainee at Coca Cola Consolidated
Justin GibbsJustin Gibbs
Delivery Merchandiser at Coca Cola ConsolidatedDelivery Merchandiser at Coca Cola Consolidated
Jordan LarsonJordan Larson
Sales Representative at Coca-Cola Consolidated, Inc.Sales Representative at Coca-Cola Consolidated, Inc.
Keith A. DunlapKeith A. Dunlap
Forklift II Replenishment at Coca-Cola ConsolidatedForklift II Replenishment at Coca-Cola Consolidated
Kelvin BenjaminKelvin Benjamin
Assistant grocery manager at FoodlionAssistant grocery manager at Foodlion