Data Analytics

Xiang Li

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

EDUCATION

University of Denver, Daniels College of Business Denver, CO

Master of Science in Business Analytics, GPA 3.7 Sept. 2013-Jul. 2015

Relevant Courses: Data Warehousing, Data Mining and Visualization, Predictive Analytics, Business Statistics, Business Intelligence, Decision Processes

Tianjin University of Technology Tianjin, China

Bachelor of Science in Management, emphasis Information System Management Sept. 2009-Jul. 2013

Relevant Courses: C, C++, Database Management, C#, Information System Management

WORKING EXPERIENCE

Arrow Electronics, Inc. Corporate Audit Business Analytics Nov. 2015-Present

Extracted, Transformed and Loaded Data from a multitude of systems in a variety of formats

Developed SQL code to process data and produce reports

Used Tableau to visualize AP, AR, Manual JE, and Inventory

Analyzed Annual Inventory Coverage by using ACL

Predicted future value by using Exponential Smoothing method in R programming

Testified Benford’s Law method for Manual JE Data

Analyzed data to provide business insights and highlight anomalies

Presented findings and recommendations in a clear and concise manner to management

GlobalMindED/LifBound, Business Analytics Intern Aug. 2015-Nov.2015

Build database for 4 years Academic Coaching Evaluation

Collected and analyzed student survey data, input data into Tableau and translated the data into charts to easily interpret and shared with supervisor

Beijing Web International English, Database Developer Jun.-Aug. 2014

Managed database, entered data and data cleaning

Lenovo China, IT Intern Jun.-Aug. 2013

Collected and cleaned raw data

Lining Sports (China) Goods Co., Ltd., Data Manager Jan.-Mar. 2013

Managed information system: collected, cleaned, input and updated data

Business Analytics Projects

Capstone Project: Morris Animal Foundation Jun. 2015

Set up database in SQL with information on dogs’ health and behavior

Analyzed dogs’ health correlated with gender, age, region, training, obey, aggression, and fear

Project Management Project: Red Rocks International Music Festival Jan. 2015

Made and implemented plans for Red Rocks International Music Festival with Project 2013

Data Warehouse Project Sep. 2014

Set up a data warehouse with ETL (Visual Studio) and Tableau for crime and weather data in Denver County

Database Project: Blackjack Pizza Sept.2014

Built database with SQL server and analyzed data into a report in order to track supplier and sales

Predictive Analytics Project Sep. 2014

Designed model in SPSS to determine factors that influence the score in a basketball game

SPECIAL SKILLS

HRMS, Business Intelligence systems, SQL Server 2010, ETL, Excel, Minitab 17, Tableau, SPSS, and JMP, Google Analytics Certification, R Programming, ACL, C/C++/C#, ACL

Bilingual: English, Chinese and Mandarin Chinese

VOLUNTEER & HONORS

Denver Public Library IT department Aug. 2014

Festival of Nations Planning Board Apr. 2014

Asbury Elementary School Feb. 2014

Contact this candidate