Project Manage, Data Analysis
Resume:
SHIYU LI
***************@*****.***
Current Address: *** *. **** **., *******, IL, 60616
OBJECTIVE
Seeking a career that utilizes my knowledge.
EDUCATION
University of Wisconsin C Madison Madison, WI
Master of Industrial Engineering, expected May 2014
Focus on Decision Science and Operations Research
Linear Programming, Supply Chain & Logistics, Data Structures, Stochastic Modeling, Capital Investment
North Dakota State University Fargo, ND
Bachelor of Industrial Engineering, May 2012
Major GPA: 3.62/4.0 Cumulative GPA: 3.51/4.0
AutoCAD knowledge; Time Study and Six Sigma, Work/Station Design Measurement, Simulation
EXPERIENCE
Computer Training Institute of Chicago
Media & Business Analyst Chicago, IL 2014-
Generate weekly and monthly reports with the marketing team to reach the target goal of capturing a wider audience through web analytic.
Analysis the incoming resource data to optimize the best way of distribute investment in each social media platform.
Benchmarking the ads with other company to select best advertisement form.
UW University Bookstore Sale Database Management Project
Project Member Madison, WI 2013-
Designed and developed data models, built relational database and database architecture by using Access and SQL to create custom reports for clients, modifying and updating tables.
Collected Book requirement and annual selling data, transferred data and loaded data into system.
Analyzed historical data, used SAS to do the time serial forecasting and developed forecasting application for the bookstore.
Simulated book sale information transaction workflow and proposed future solution.
UW Health Diabetes/Endocrine Clinic Scheduling Optimization Project
Project Member Madison, WI 2013
Assisted in designing data collection forms, converted Access and Excel datasets to SAS format, conducted data cleaning and validation.
Analyzed patient visiting time sample data, used SAS to generated distribution, produced tables and graph. Got variables from the distribution and table.
Applied lean methodologies and Six Sigma to make process change. Rescheduled and redistributed doctors and nurses working process to improve clinic efficiency.
Did linear regression to analysis the relationship between variables and total visiting time to optimize proposal solution.
Trail King Industrial
Project Manager Fargo, ND Spring 2012
Warehouse management and supply chain system analysis.
Introduced an idea of a new shelf system helping reducing 4,085ft2 of footprint and increased production profit $6,400/wk.
Did information flow analysis, production flow analysis and time studied the workflow in warehouse.
Scheduled the project and assigned work to team members.
Jiangxi Ganjiang Environmental Protection Co., Ltd
Project Assistant Jiangxi, China, Summer 2009+2012
Price benchmarked the suppliers by using linear programming to build mathematical cost model, solved by MATLAB. Price optimized the objective to select best supplier.
Designed conceptualization, 3D modeling for JMC (Jiangling Motors Corporation Ltd), detailed and prepared manufacturing drawings using AutoCAD Tool. The system makes the pollution rate reduce from 10% to 2%.
PROGRAMMING PROJECT T
Implemented, and analyzed of efficient data structures and algorithms to solve problems and create app by using Java and C++, like category and manage data, create chess game and family tree search.
Used MATLAB to analysis a large data set belong to different category. Applied linear programming to a machine learning formulation to determine the authorship of the dataset and generate graph.
Applied GAMS in a train dispatching problem. Build mathematical model by linear program to optimize the total cost.
SOFTWARE SKILLS
MATLAB; GAMS; C++; Java; Pro/E; NX8.5; Arena; Minitab; SQL; ? R; ? SAS;
Microsoft Office: Access; Excel; PowerPoint; Words; Visio;
LANGUAGE SKILLS
Proficiency in both English and Chinese
CERTIFICATION
SAS Certified Base Programmer for SAS 9
HONOR
First prize, National University Student English Competition, 2009
VOLUNTEER
Pay It forward Tour 2011 volunteer activity, Fargo, ND, March, 2011
Sandbagging for Fargo flooding, ND, March, 2010
Project Homeless Connect in Fargodome, Fargo, ND, 2009
Contact this candidate