Post Job Free
Sign in

Project Analyst

Location:
Arvada, CO
Posted:
October 13, 2013

Contact this candidate

Resume:

Yuan Zhang

Denver, CO ***** . 720-***-**** . **********@*****.*** .

www.linkedin.com/in/yzhangviva

EDUCATION

University of Denver, Daniels College of Business, Denver, CO

Master of Science in Business Information and Analytics, Major GPA 3.6

08/2013

Relevant Courses: Business Statistics, Business Database, Business

Intelligence, Data Warehousing, Data Mining, Business Metrics

Relevant Projects: Business Statistics Project - Correlations between

University Rankings and Students Income Levels using Minitab

Business Intelligence Project - Business Analytics Strategic

Plan for Crocs

Data Warehousing Project - Ailments and Death Rates Research

using SSIS, SSAS, and SSRS

Data Mining Project - Comparing Classification Techniques for

Breast Cancer Diagnosis using JMP

Business Intelligence Capstone Project - Staffing Research

Software Improvement for SofTec Solutions, Inc.

University of Colorado Boulder, Leeds School of Business, Boulder, CO

Bachelor of Science in Business Administration, Area of Emphasis: Finance

08/2011

Relevant Courses: Corporate Finance, Financial Mathematics, Investment &

Portfolio Management, International Finance, Intermediate Accounting I&II,

Cost Accounting

Relevant Projects: Marketing Project - Marketing Business Plan for a Fast

Food Restaurant

Operation and Information Management Project - Business Plan

to Operate a Casino at Black Hawk

Strategic Management Project - Johnson&Johnson's Business

Strategies

EXPERIENCE

COVIDIEN, Boulder, CO, Intern, Data Analyst/Report Developer

04/2013 - 09/2013

.Supported the New Product Development Group in R&D Department by pulling

out useful data from the database

.Developed the database access reports based on SQL Server Reporting

Services (SSRS) and Minitab, and upload the standard report templates to

IntraStage for daily use within the organization

.Analyzed new products test performance and potentially find the root

causes of failure to improve the components' pass rates by 6%

China Trade Institute, Arvada, CO, Intern, Marketing Analyst

08/2012 - 01/2013

.Worked closely with entrepreneur on a project offering online classes to

Chinese students

.Established communication between curriculum planners and university

professors in China, and translated accurately and effectively

.Coordinated dissemination of information between faculty and students,

answered questions regarding courses and facilitated learning

Maxim Capital, LLC., Littleton, CO, Intern, Financial Planning Associate

03/2012 - 08/2012

.Sorted and classified client documents for a financial planning

organization using Excel, increasing efficiency of data retrieval

.Created 15 financial models in Excel and presented the quantitative

advantages of new financial products and services, resulting in 10 more

clients

Formations, LLC., Boulder, CO, Intern, Real Estate Analyst

09/2011 - 11/2011

.Voted Analyst of the Month in October 2011

.Analyzed investment opportunities for off-campus student housing market

near universities, submitted 200-page report including target markets and

analysis

.Discovered 50 potential markets for investment, saved director's time by

50% through thorough and accurate research and analysis

The Ski Lift, LLC., Denver, CO, Intern, Marketing Research Analyst

08/2011 - 11/2011

.Created 50 partnerships and raised awareness of the ridesharing service by

researching and communicating with US and Chinese ski resorts

.Managed email marketing campaign, followed up on interest and answered

questions regarding service

.Assisted in developing company website, which added 1,000 more registered

skiers, and increased revenue by 20%

SKILLS

Computer: Proficient Windows and Mac OS, SQL Server (SSIS, SSAS, SSRS),

MySQL, JMP, Tableau, Oracle Crystal Ball, Minitab, and Microsoft Office

including Access, Word, Excel, PowerPoint, Project, Outlook, and Visio,

Python, C++, R

Languages: English (fluent), Mandarin Chinese (native), Cantonese

(intermediate)

ACTIVITIES

Orientation Student Mentor, Daniels College of Business, University of

Denver (2012)

Chinese Teaching Assistant, Concordia College Exchange Program, hosted by

Hong Kong Baptist University. (2008-2009)

Volunteer Teacher, Western China Program, hosted by Hong Kong Baptist

University (2007)



Contact this candidate