Ying Wang
Lyndhurst, NJ, ***** ac8kpc@r.postjobfree.com 201-***-****
PROFILE:
Business Data Analyst with experience assuring operational excellence in high demanding companies excels at strategizing short and long term business goals to meet the toughest corporate requirements. TECHNICAL SKILLS:
Manufacturing operations, logistics, data analytics, supply chain.
Customer Service and Business Operations, ERP software – SYSPRO.
Word, PowerPoint, Excel – VLOOKUP, Pivot table.
Proficient in SQL (MySQL), MS Power BI, Familiar with Python, Tableau. PROFESSIONAL EXPERIENCE:
ZT Systems, Secaucus NJ
Supply Chain Analyst June 2015 – Present
Served as a liaison between production, procurement, inventory management, customer operation team and logistic departments to ensure a proper flow of product through the supply chain.
Made forecast recommendations to ensure a proper level of inventory in a warehouse with >300,000 items, collaborated with cross-functional teams for materials assessment and drafted shipment plans.
Directly responsible for all Cloud account sales orders such as Amazon AWS and Microsoft Azure, partially responsible for parts sales orders.
Generate ad-hoc analysis report using complex SQL queries for upper management in order to expose variability and optimize our operations for the highest quality results.
Coordinate customer relationship activities across multiple internal departments to facilitate global
(US, EU, Asia) delivery schedule.
Monitor on hand inventory to job order ratio to maintain a cost efficient material allocation process, identified and removed > $700,000 in excess and obsolete inventory over 4 years period. E-House Holding Limited (NYSE: EJ), Shanghai China Executive Management Trainee April 2011 - May 2012
Responsible for real estate project management, market research, market planning, target customers and real estate e-business establishment.
Combined on-line potential customers with off-line marketing activities through company E-commerce systems to explore new marketing channels.
Lead a team of 5 to finalize research report and provide market research for clients. EDUCATION:
Master of Business Administration
Monroe College 2013-2015
Honors: GPA 4.0 / 4.0
Bachelor of Architectural Environment Engineering
Wuhan Textile University 2007-2011
Portfolio:
2017 Domestic requests analysis using MS Power BI with randomized data: https://www.dropbox.com/sh/w9b3yntfooa3dpl/AACEmG2DWoTpDIWX-MYDmTzfa?dl=0