Andrew Kang
Toronto,ON
Summary
Solution-focused analyst prepared to deliver impactful results through robust data analysis, strategic problem-solving, and effective process improvements. Strong emphasis on team collaboration and adaptability ensures reliable contributions in dynamic environments. Proficient in leveraging technical skills such as SQL, data visualization, and business intelligence tools to drive success. Known for analytical thinking, proactive mindset, and commitment to achieving organizational goals.
Overview
17
17
years of professional experience
Work History
Customer Solutions Analyst
Nestlé Canada
12.2020 - 03.2025
- Reduced Walmart frozen refusals by more than 83% from 2022 to 2024 and further reduced it in 2025 (312 in 2022 to 54 in 2024) by setting up a system that prevented possible PO refusals due to freeze spaces.
- Collaborated cross-functionally with the Supply Chain team to identify root causes of EDI failures and implement proactive solutions to eliminate recurring transmission issues.
- Synchronized Walmart’s holiday delivery schedules within SAP to ensure EDI POs aligned with specific logistics windows, successfully preventing delivery disruption during peak periods.
- Generated weekly item shortage and refusal reports and reported to Walmart corporate to track the fill rate and refusals rate.
- Oversaw the end-to-end processing of EDI Purchase Orders (POs) for national Walmart Canada and Longo’s accounts.
- Managed EDI mapping tables to ensure all new product launches were accurately integrated into the system for seamless customer ordering.
- Conducted real-time monitoring of EDI audit reports and utilized resolution cockpit to identify and resolve failed transmissions, minimizing delays and ensuring 100% data integrity.
- Collaborated with national distribution teams at Nestlé and partnered with Walmart Corporate on the 'DOME' project to adjust delivery parameters and accommodate preferred time slots for Walmart nationally to improve logistical efficiency.
- Processed and managed high-volume mass script POs from Walmart Corporate for national promotional activities, ensuring 100% order accuracy during peak seasonal events.
- Coordinated national distributor orders for Nestlé by managing end-to-end warehouse order processing including validating and releasing purchase orders in partnership with Nestlé distribution teams and confirming release details with distributor partners.
- Participated in monthly business reviews with Walmart Corporate to analyze service levels, identify trends, and propose process enhancements.
- Participated in Daily & Monthly Operations Review meetings to maximize productivity and efficiency.
- Led and participated in GSTD (Go See Think Do) meetings to identify productivity inhibitors, implementing lean strategies that minimize waste and maximize operational efficiency.
Inside Sales Representative
Nestlé Canada
02.2008 - 12.2020
- Monitored fax-to-EDI transmissions for major retail customers including Metro, Loblaws, Food Basics, Zehrs, and T&T etc. and C-Channel accounts, ensuring all orders were integrated into the SAP system with zero errors.
- Identified, resolved, and resubmitted failed fax-to-EDI orders via the Faxinating Solutions application within SAP to maintain timely processing.
- Collaborated with Faxinating Solutions Inc. to map order forms for C-Channel customers, transitioning them from manual processes to automated fax-to-EDI ordering.
- Successfully migrated over 500 C-Channel accounts to Fax-to-EDI, significantly reducing call center volume and improving the customer experience by eliminating wait times in the queue.
- Received training in the management and processing of Vendor Managed Inventory (VMI) orders for Petro-Canada accounts, ensuring optimal stock levels.
- Processed high-volume Purchase Orders within the SAP Customer Interaction Center (CIC), ensuring strict adherence to logistical data and delivery timelines.
- Resolved complex customer inquiries regarding deliveries, shortages, and credits, consistently maintaining high satisfaction ratings.
- Participated in BOR and M0R meetings in the company.
- Executed trade show support at the KBA (Korean Business Association) Trade Show and translated promotional material into Korean to support KBA customers, co-presented marketing strategies to an audience of 250+ stakeholders.
Education
Bachelor’s Degree - Manufacturing Engineering Technology
McMaster University
Hamilton, ON06-2005
Technology Diploma - Automation & Robotics Technology Co-op Program
Centennial College Progress Campus
Scarborough, ON02-2003
Skills
- SAP
- EDI & Fax to EDI
- Microsoft Office
- Power BI
- English/Korean
Languages
English
Native or Bilingual
Korean
Native or Bilingual
Spanish
Elementary
Timeline
Customer Solutions Analyst
Nestlé Canada
12.2020 - 03.2025
Inside Sales Representative
Nestlé Canada
02.2008 - 12.2020
Technology Diploma - Automation & Robotics Technology Co-op Program
Centennial College Progress Campus
Bachelor’s Degree - Manufacturing Engineering Technology
McMaster University