Wilson Gu Email & Phone Number

Build and improve audits used for internal and external expeditors to identify weakness to improve uponCreate Tableau reports with business data to track losses in different warehouse procedure Lead kaizen project to improve accuracy of inventory drop-off between locations and decrease loss by 3%Research reasons for backorders for SKU and build solutions for area need of improvementWork with other distribution center to insure data is in sync and network programs is functional

Xiamen City, Fujian , Cn

• Work with online marketing team, prepare, organize, and translate company Intellectual Property documents • Design and develop online advertising strategies for US media channels, include YouTube, LinkedIn, Twitter, Facebook, in the forms of Multi-Media presentation and video• Research and track down potential clients and connect with them through email and phone calls and manage existing customer relationships and negotiations• Worked with the executive teams, evaluated legal risk of business establishment, consulted Chinese business law, prepared legal document, explore the feasibility of building a US sub-company. • Member of company incubation team, participated and helped in various areas, include: located and negotiated office facility, budgeted and purchased office equipment, established ERP mechanism to manage vendor and supply chain, built up company communication system (Ding Ding) and internal cloud storage (Ding Cloud) • Assume responsibility as online vendor and take part in negotiations, logistics and selling process for sites such as Facebook Shop and Newegg

Raleigh, Nc, Us

Hands-on business experience analyzing opportunities to improving accuracy related to shipment of products from the distribution centers to stores.● Improved accuracy of inbound product shipments from distribution centers to stores using warehouse supply data with SAS.● Reduced error purchase of oil products by identifying SKUs with incorrect restock values using SAS, Excel, and Tableau.● Enhanced logistic processes and human capital management by integrating warehouse databases from acquired companies using SQL and Excel.

● Retrieved student data from SAS database using SQL to fill specific data requests.● Created SAS templates for interns to familiarize with functions (Strings, Data Steps, Proc Steps, table creation, and combination).

● Cooperated with team to reduce equipment damage using root cause analysis and communicated with venders.● Used ERP software to manage inventory and shipping process (data cleaning, invoice management, lead time and master production schedule, adjustments, and MRO documentations).

New York, Ny, Us

● Used ArcGIS to compound data and find suitable locations that meet client demands of starting business.● Analyzed historical data for industry overview and business trends in locations to determine optimal sizes for stores.● Created pivot table and used solver in Excel to calculate holding cost and economic ordering quantity.● Analyzed economic growth indicators to determine marketability of city areas.