Rstudio,Python,Tableau,SAP,excel,VBA, and POWER BI

HO JIN LEE

* ****** ******, ******, **, ***** 973-***-****

************@*****.*** www.linkedin.com/in/lee-hojin-146359136

Education

Rutgers University, Rutgers Business School – Newark & New Brunswick, NJ Exp. Graduate Dec 2020

Master of Supply Chain Analytics (STEM) Cumulative GPA: 3.74

Rutgers University, Rutgers Business School – Newark & New Brunswick, NJ Graduated: May. 2018

Bachelor of Science, Supply Chain Management and Marketing Science & Management Information Systems

(Double Major) Cumulative GPA: 3.21

Certifications & Skills

●CPIM (Certified in Production and Inventory Management) – Part 1 certified from APCIS

●SAP certified Associate – Business Process Integration with SAP ERP 6.0(EHP6) (TERP_10_66)

●Proficient in Microsoft Excel (Pivot table, VBA, VLOOKUP), Access, Power Point, words, Python, R-Studio, SAP, Tableau and Power BI (Data Visualization tool)

●Multilingual: Korean, Chinese and English

Relevant Course

Supply Chain Industry Client Project Weekly Virtual Meeting

ADM Jan 2020 – Current

●Building Demand Forecasting model (ARIMA, ES, Decomposition, and Dynamic Regression) and Inventory calculation metric (EOQ, SS, ROP, and POQ) for MRO items by using R-shiny.

●Establishing Supply chain dashboard for MRO Items by using various R packages.

●Leading the weekly meeting with different teams as a project manager to resolve problem.

Coca-Cola Philadelphia, PA

Sep 2017 – Dec 2017

●Learned techniques of Demand Forecasting (weekly forecasting calculator made by excel)

●Monitored the flow of input and output of raw materials, work-in-process inventories, and finished goods.

●Used ABC classification strategy to organize inventory and to eliminate the unnecessary movements.

●Participated in weekly meetings as a school representative, show signs of improvement to the plant manager.

Work Experience

C&L Global Ridgefield, NJ

Logistic Coordinator Nov 2018 – June 2019

●Managed Freight Forwarding, Inland Transportation, and prepared the documents of Export & Import.

●Utilized Global Logistics ERP system to manage business processes from booking creation to account receivable.

●Communicated with clients to specify transfer requirements of their products (grain & soybeans & fruits)

●Spoke to steamship lines to identify potential risks, solve current issues, and fulfill customers’ requirements.

●Used excel to build a forecasting tool to predict the number of containers I had to reserve for my clients.

LG Electronic Englewood Cliff, NJ

Supply Chain Analyst June 2018 – Nov 2018

●Weekly updated the Supply Chain KPI including Forecasting Accuracy, Direct shipment OTD%, Cash Conversion days, Return Rate, In-Stock- Availability, and Long-Term Inventory Rate.

●Proactively engaged with PSI & S&OP managers to share issues and assisted to analyze root cause of problem.

●Worked on daily assignment which assigned from Operation & PSI managers by using excel (VBA) and Tableau.

●Assisted the order management team and direct shipment team to summarized weekly customer orders and submitted the production order to the oversea factory by using the ERP system.

South Korea Army: 23rd Division Supply & Transport Division Dong Hae, South Korea

Purchasing Assistant June 2014 – Mar 2016

●Assisted the Manager to purchase food ingredients and distribute the purchased goods to over 10,000 soldiers.

●Operated the DMIS system (Military version of ERP) to placed food orders, updated the inventory and price of food ingredients.

●Used excel formula, pivot table, and a graphic chart to summarize how much food ingredients needed every day for all soldiers in 23rd division based on the menu of the days.

●Collaborated with vendors to ensure on time deliveries of food ingredients.

Contact this candidate