Data Analysis, Quantitative Analysis

Wanjie Huang

**** ****** ***., ***. **, Hoboken, NJ 07030 / *******@*******.*** / 201-***-**** / www.linkedin.com/in/wanjieh EDUCATION

Stevens Institute of Technology, Hoboken, NJ

Master of Engineering in Engineering Management/Industrial Engineering, GPA: 3.8 May 2015

• Track Representative: Data Analysis and Visualization Techniques; Data Science and Knowledge Discovery

• Certificate of Data Exploration and Visualization for Risk and Decision-Making North China Electric Power University (NCEPU), Baoding, Hebei, China Bachelor of Science in Project Costs, GPA: 3.5

July 2013

• Track Representative: Statistics, Econometrics, Engineering Cost Calculation and Control SPECIALTY

Technical Python, R, SAS, SQL, C, SPSS, Gephi, VensimPLE, Microsoft Project, Excel, Access, Glodon Project Management Suite, Adobe Audition CC, AutoCAD

Certificate SAS® Certified Base Programmer Credential for SAS® 9 WORK EXPERIENCE

Hongta Tobacco Group Co., Ltd., Yuxi, Yunnan, China Jun.-Aug. 2014 Data Analyst

• Facilitated project estimate, project auditing and field measurement using Glodon and AutoCAD

• Generated raw material quotation lists for clients that are in the contract of tobacco selling and producing

• Manipulated and processed large dataset using SQL; produced weekly and monthly descriptive analyses for client and sale reports using SPSS and SAS

Yunnan Yuxi Electric Power Design Institute, Yuxi, Yunnan, China Feb.-Apr. 2013 Analyst

• Researched on power substation and get the historical data of the substation construction for both financial expending and material quantities to help decision making for project development

• Conducted quantitative metric analysis using Excel and R to help decision making in various projects Yunnan Yuxi Municipal Water Conservancy Bureau, Yuxi, Yunnan, China Jun.-Aug. 2012 Project Analyst

• Refined data editing and standardization using Excel and SPSS

• Assisted in project estimate assessment and preliminary auditing; visualized project structure using AutoCAD PROJECT EXPERIENCE

Hollywood Relationship Network Analysis Fall 2014

• Retrieved and optimized 2000 Hollywood celebrities’ profile data extracted online using Python; visualized the network into clusters with shortest path per pair, and both 1-1 and 1-N format cliques using SPSS/R

• Developed tag clouds for clusters and each cliques; analyzed the effects for cluster/clique forming Seattle Real Time Fire 911 Calls Area-Cause Modeling and Simulation Spring 2014 / Fall 2014

• Collected and analyzed the data sources of Seattle real time fire 911 calls within two separate weeks (one random week sample and the Halloween week data) using SQL and SAS

• Built statistical models for distribution analysis and visualized analyzing results using Python/R; made efficiency-improving recommendations

Dynamic System Analysis of the Economic Development of Detroit Spring 2014

• Researched and extracted stakeholders and key elements of the complex Detroit development system

• Developed dynamic model started from 1850 and performed dynamic system simulation using VensimPLE Shared Personal Health Database System Fall 2013

• Identified stakeholders and system missions; performed QFD analysis for stakeholder requirements

• Analyzed system scenarios; generated risk assessment and mitigation strategies

• Created alternative concepts (products) for scenarios; weighted the concepts using Pugh Matrix

Contact this candidate