Juhyun O. Email & Phone Number

Toronto, Ontario, Canada

•Compared and analyzed sourcing options for parts in order to figure out the best financial and timely option. •Worked directly with service technicians to provide cost estimates and service part ETAs.•Cleaned and corrected over 1000+ parts Excel data records on FSM system.•Placed over 10+ air freight orders daily as requested by the service team.

Toronto, Ontario, Canada

•Demonstrated outstanding performance which resulted in receiving a higher level year-end bonus.•Approved for a substantial raise by the CEO of Canada due to recommendation by the direct manager.•Trained and supervised 3 new hires simultaneously on data entry tasks, business systems and workflow.•Selected to learn the new ERP system and then trained the 7 other purchasing team members.•Entrusted to handle over 10+ vendors and managed the 3rd highest part cost suppliers in the department. •Identified and alerted warehouse and sales team to inventory and order fulfillment issues worth $30,000. •Represented the purchasing department along with direct manager in local branch and Canada wide meetings.•Assigned to special tasks and projects pertaining to inventory reconciliation and ERP system data update.•Generated concise and simple Excel pivot table reports for managers and vice president of Canada.•Overhauled kitchen parts and equipment sourcing process and saved approximately $100 per large shipments.•Monitored and updated inventory stock levels as well as forecasting future sales to adjust purchasing amounts.•Resolved outstanding logistical problems which shortened the delay of shipments from 2 weeks to 1 week. •Timely updated purchase order system logs with ETAs to relay information to the customer sales team.•Identified and communicated a bug in business software that caused unintended actions to the IT team.

Toronto, Ontario, Canada

•Automated a 1 hour data entry task to only 15 minutes with custom Excel spreadsheets and macros. •Converted raw data from 3rd party reports and system reports into concise and readable data.•Generated pivot table reports to figure out the top purchase amount vendors on request from management.•Retrieved required data information on request from ERP system using SQL database knowledge.•Created and improved on procedures to increase transparency on purchase order statuses.•Identified irregularities and issues by exporting system data and filtering using Excel.

Toronto, Ontario, Canada

•Transformed and compiled unstructured client data into summary document for review using Microsoft Excel.•Created easy to follow manuals and instructions for clients to provide correct documents needed.•Entered and compiled client’s information and documents into Salesforce.

Ontario College Advanced Diploma, Computer Programming/Programmer, General

Full Stack Web Development Certification, Computer Programming