Wenfei Lai

781-***-**** acvwmd@r.postjobfree.com https://www.linkedin.com/in/wenfeilai Seattle, WA Professional Summary

Experienced Project Manager with a M.S. in Engineering Management. Current objective is looking for Data Analysis/Business Analysis jobs. Proactive in finding, analyzing and solving puzzles. Enthusiastic, hardworking, detailed-oriented team player loves to work within a team.

• Proficient in SQL, Python, R programming

• Experienced in Extracting, Transforming and Loading data in database

• Project experience in Multiple Linear Regression and Factorial Design of Experiment

• Earned R Programing Certificate and Managing Big Data with MySQL Certificate Education

Northeastern University Boston, MA

M.S. in Engineering Management GPA 3.6 May 2016

Courses: Statistical Methods for Engineers, Probability and Statistics for Engineers, Engineering Project Management, Supply Chain Engineering, Deterministic Operations Research, Economic Decision Making. Shanghai University Shanghai, China

B.S. in Civil Engineering GPA 3.5 Jul 2014

Relevant courses: Concrete Structural Design, Steel Structural Design, Mechanics of Materials, Mechanics of Structures, Engineering drawing and CAD, Engineering project cost, Engineering Investigation. Technical Skills

• Software: SAS, SPSS, Tableau, MiniTab, AutoCAD 2D/3D, PKPM, SAP

• Programming Languages: SQL, R, Python, C, C++, Matlab

• Tools: MS Project, Primavera P6, Word, Excel, Access, PowerPoint Professional Experience

Shanghai HuanQiu Contracting & Engineering Corporation Shanghai, China Engineer Assistant Intern Oct 2013 - Mar 2014

Company engaged in engineering project design for chemical industry. Mainly responsibility is for structural design and construction management of Central Business District buildings and factories.

• Estimated budget, analyzed cost using Microsoft Project saved 10% cost in finished project.

• Designed construction layout plan, arranged schedule, and optimized construction progress.

• Drew structural construction 3D model using AutoCAD and PKPM, delivered to company.

• Updated daily schedule and report, assisted to coordinate project with construction manager. Academic Project

Northeastern University Boston, MA

Multiple Regression Analysis project Jan 2016 - May 2016 Asphalt quality and elemental components relationship analysis

• Collected data, ETL data in relational database, cleaned data and quality controlled in SQL.

• Built model, fitted regression model and tested hypothesis for statistical inference in R programming.

• Analyzed and selected most representative model through ANOVA in R and SAS software.

• Predicted asphalt quality value trend, summarized report, data visualization in Tableau. Factorial Design of Experiment project Jan 2016 - May 2016

• Defined experiment factors and levels, selected response variables, and experimental design model.

• Performed experiment, collected and sorted data in Excel, analyzed factors effects in R and Matlab.

• Predict response value, recommended most influential factors, and visualization report in Tableau. Electronics shopping plaza project Sep 2014 - Dec 2014

• Established project scope plan, designed Work Breakdown Structure for plan implementation.

• Planned Schedule, allocated resources in Microsoft Project and delivered to company.

• Analyzed difference with budget and in-progress cost for financial report in Excel.

Contact this candidate