Microsoft Office Data

Botian Cao

720-***-**** *************@*****.*** www.linkedin.com/in/botiancao

EDUCATION

University of Denver, Daniels College of Business Denver, CO Master of Science in Business Analytics, GPA: 3.63 June 2018

• Relevant Courses: Python, Statistics, Predictive Analysis, Business Database, Data Mining, Complex Data Analytics

• Business Analytics Experiential Projects:

o Data warehousing

• Designed the DW with Visio, Word, Excel, loaded the DW with ETL (SSIS) and analyzed them with Excel pivot tables.

o Predictive Analytics

• Performed classification, association and cluster analysis using SPSS Modeler. University of Denver, Daniels College of Business Denver, CO Bachelor of Business Administration in Finance, GPA: 3.35 November 2016

• Relevant Courses: Financial Investments, Mathematics in Finance, Commercial Bank Management, Financial Modeling

SKILLS

Computer skills: Microsoft Office, SPSS Modeler, SQL Server, Python, HTML, JMP, Tableau Language skills: English, Chinese

EXPERIENCE

DMC Global 03/2018-06/2018

Business Analyst Intern

• Translated the business requirement for forecasting metal explosive cladding revenue in 1-month and 3-month advance into actionable solutions by designed, conducted and developed predictive regression models and decision tree models.

• Cleaned metal prices data and sales data, created new various predictors based on the raw indicators to improve 20% accuracy of predictive models.

• Established, tested and revised multiple regression models with different new indicators to determine the most significant indicators for regression model to forecast future revenue in advance.

• Performed data exploration and general analysis by Tableau.

• Collaborated and communicated closely with the Vice President to identify business requirements, provided a formal business report.

Shaanxi YINJI Engineering & Construction LLC

Market Analyst Intern 12/2017-01/2018

• Tracked status and prices of construction materials, including compiling data, analyzing data and creating reports for the management team.

• Performed quantitative and qualitative studies of trends, data, account receivables and policies related to real estate market.

• Coordinated with manager to provide recommendations to support decisions of new project selection. EXTRACURRICULAR ACTIVITIES

Vice-President University of Denver Chinese Student and Scholar Association 2017 Organizer Chinese student basketball competition in Denver Area 2016, 2017

Contact this candidate