Sign in

Data Analyst/ Business Analyst/ Data Scientist/SAS Programmer

Columbus, Ohio, United States
January 26, 2017

Contact this candidate

Yifei Zhang • • 614-***-****

Professional knowledge in Operations Research, Mathematics, Statistical Analysis, and Programming. Strong analytical and quantitative skills. Experienced in preparing detailed documents and reports while analyzing data for driving business solution. Mastery of Design of Experiments (DOE), Simulation, Modeling and Optimization. Familiarity with Algorithm, Data Structures, Database, Network Programming, and Software Application


• Certification,SAS Certified Advanced Programmer (SAS/Macro, SAS/SQL, SAS/STAT)

• Proficiency in SQL and various statistics packages such as R and SPSS

• Strong skills in ETL, Data Manipulation/Analysis/Visualization (WEKA, RapidMiner)

• Familiarity with theory and practice of Machine Learning and Data Mining

(Classification, Clustering, Regression)

• Statistical/Mathematical Modeling and Simulation (Arena, CPLEX)

• Design of Experiments: A/B Testing, ANOVA, Regression, Time Series (Minitab)

• Optimization: Linear and Operations Research Method

• Programming(C,C++, JAVA), Comfortable with Linux/Unix/Windows System

• Experienced with inventory control, prediction and optimization based on supply chain

• MS Office Suite: Word, Excel (VBA)), Access, PowerPoint EDUCATION

The Ohio State University (OSU), Columbus, OH Aug,2016 M.S. in Industrial Engineering, Focus: Operations Research, Major GPA: 3.9/4 Nanjing University of Aeronautics and Astronautics, Nanjing, China Jun, 2013 B.S. in Industrial Engineering, GPA:3.5/4


Inventory Control Analyst Nov,2012-Jun, 2013

Disney Clothing Retailer, Shandong, China

• Gathered the related product data and analyzed the inventory problem

• Managed inventory by applying inventory control method (ABC classification)

• Applied Inventory model (GM(1,1), EOQ) to forecast product demand, aiming to optimize inventory of retailer and provide purchase strategies Production Manager Assistant (Intern) Jun-Aug, 2012 Nanjing New Power Packaging Co.,Ltd, Nanjing, China

• Assisted in monitoring and supervising daily production to ensure quality goals are met

• Set production schedule and created purchase order

• Maintenance database and keep it updated


Data Mining Algorithm Implementation Sep-Nov, 2015 Tools: R, WEKA, RapidMiner, SAS

• Implemented KNN classification algorithm on a large income dataset and predicted the income level, coding with R

• Applied multiple classification algorithms such as Decision Tree, Artificial Neural Network, SVM, Naïve Bayes, Ensemble Learner,etc. with WEKA and RapidMiner to predict the wine quality or cost overrun, evaluated the performance of these models.

• Implemented K-mean and Hierarchical Clustering algorithm on 3 large data sets, evaluating the clustering result

Giant Eagle Supermarket Checkout System Simulation, OSU Mar-May,2015 Role: Project Leader

Tools: Arena, Excel

• Led a team to observe the checkout system and collect customer-related data about inter- arrival time and processing time, conducted input analysis to gather distribution of data

• Built a conceptual model and simulated it with Arena Software,verified and validated the model in logic and by comparing system responses with real system

• Analyzed simulation output, identified the problems of current system, proposed the alternative model to optimize the efficiency of checkout system and customer satisfaction PROGRAMMING EXPERIENCE

University Database System, OSU Sep-Nov, 2015

Tools: MS SQL Server

• Established a university database system to storing information of students, employee, department and courses with E-R model and relational model, created database scheme, SQL query and trigger in Microsoft SQL Server

Network Programming - FTP Protocol Implementation, OSU Jan-Mar, 2016 Tools: C,C++, NS-3

• Implemented a TCP-like reliable transport layer protocol by the unreliable service provided by UDP with C & C++

• Implemented CRC and retransmission timer to ensure the correctness and success of packet transmission

iRehab Web Application, OSU Jan-Apr, 2016

Tools: Agile, MySQL

• Collaborated with 5 people to establish a platform which can help patient to finish the rest steps remotely at home after hospital necessary treatments, providing video conference, group support and calendar function

• Composed document, drove the whole project process with Agile method, and assisted in design and testing part


• Language, Native speaker of Mandarin Chinese

• Honors, Three times of Scholarship, 2009-2013

• Leadership, Excellent Leader of Student Union, Oct, 2010

• Volunteer, The sixth national census of China, Dec, 2010

Contact this candidate