Data Python

TIANHAO ZHOU

Boston, ***** 781-***-**** **************@*****.*** www.linkedin.com/in/THZ

EDUCATION

SUFFOLK UNIVERSITY Boston, MA

Master of Science in Business Analytics GPA:3.90 SAS Joint Certificate Dec 2019 THE UNIVERSITY OF NOTTINGHAM Nottingham, UK

Bachelor of Science in Electrical Engineering and Renewable Energy Systems Dec 2015 WORK EXPERIENCE

ETI SOLID STATE LIGHTING INC. Chicago, IL

Business Analyst Intern May 2019-Aug 2019

• Performed market analysis using data mining and machine learning methods in Python to efficiently investigate and cluster customers, resulting in 20% marketing savings

• Executed data preparation procedures for business performance analysis by writing complex SQL queries using joins, grouping, aggregation and subqueries to perform ETL process in data warehouse

• Converted historical data from old existing database (Fishbowl) to the Oracle Database which consists of 20 million records

• Created data visualization with Tableau and designed Dashboard based on executives’ decision-making needs

• Designed North American regional performance BI reports covering sales, inventory turnover ratio, and product performance, target-actual variances, profit margin for company headquarter SUFFOLK UNIVERSITY Boston, MA

Research Assistant Volunteer Sep 2019-Dec 2019

• Conducted research project with professor to analyze the time-series impact of advanced health Information technology (HIT), covering 60 thousand hospital records

• Utilized Python libraries, such as Numpy, Pandas, Scikit-learn to implement data integration, data validation, data profiling and data visualization process

• Designed, developed and maintained relational databases by Visio and SQL Server databases

• Performed Difference in Difference model, Fixed and Random effects model in Stata to implement statistical analysis DALIAN SHIPBUIDING INDUSTRY CO., LTD Dalian, China Operation Analyst Aug 2016-Aug 2018

• Conducted project planning for shipbuilding projects by evaluating customer specifications and project complication.

• Predicted new project time consumption, budget and team deployment by analyzing historical project performance including project delay rate, project team performance, and project efficiency

• Designed vendor scoring matrix by weighing and prioritizing different quantity and quality measurements HONORS

• Cumulative GPA 3.9 with Academic Scholarship Awarded (Top 5%)

• Suffolk University INTO International Ambassador, interviewed and video recorded by Suffolk University and video is posted on official website

• Represented Suffolk University to participate in CFA Research Competition against with top Universities around the world, such as Harvard University; concentrating on analyzing companies in NASDAQ using data modeling methods to recommend business strategies

SKILLS

Technical Skills: Python, SAS, SQL, Stata, Tableau, RStudio, Advanced Microsoft Excel, SAP, Hadoop, Access Statistical Skills: Regression, Decision Tree, K-Nearest Neighbor, Credit Scoring, Time Series, Random Forest

Contact this candidate