Sign in

Microsoft Office Data

Englewood, Colorado, United States
August 30, 2018

Contact this candidate


Botian Cao



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


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


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