Data Project

Zoey (Ziyi) Zhao

214-***-**** *****@***.***

Summary

A graduate student with proficient data analytics skills. Strong team work and very detail oriented. A problems solver and a faster learner. Seeking career in business analytics to apply the extensive analytical skills to support business decision making.

Qualifications

- Core competencies: SQL-Server • SAS Certified Advanced Programmer for SAS 9 certification • Excel/VBA* • Excel-Modeling • Microsoft Access • Hadoop • R • SAP-Hana • Tableau • Power BI• SAP HANA• Googel Analytics •Data Mining

-Time Mangement, Multitask, Flexibility

*Advanced Excel Functions, Data Cleanssing, Excel_VBA, PowerPivot

EDUCATION

Southern Methodist University, Cox School of Business Dallas TX

Master of Science in Business Analytics May 2016

GPA: 3.7/4.0

Southern Methodist University, Dedman College Dallas,TX

Bachelor of Science in Economics for Finance Application Aug 2015

Major GPA : 3.8/4.0

WORK EXPERIENCE

Global North Texas Dallas, TX

Assistant Analyst April 2015-October 2015

Conducted database updates using Excel and Access and generated monthly project reports to effectively track the project performance.

Assisted in the preparation of meeting materials and consolidated meeting packages for the management.

Engineer Consulting Office of Hebei Institute of Architecture Design & Research Co., Ltd Shijiazhuang, China

Data Research Assistant May 2013-July 2013

Extracted and merged large size of marketing data from various systems, compeleted the data cleansing and transformed the data into the desired format for further analysis.

Assisted the project lead to analyze the consolidated data and provide findings to support the feasivlity analysis.

PROJECT

Business Intelligence ETL(SQL-Server)

•Developed ETL to extract data from data warehouse and transform and load data into new created table.

Created complex SQL queries to extract/clean/reformat transacation data of a bicycle company from the database for futher analysis, such as find the region that generate highest revenue.

Designed and developed the business dashboard/detailed reports to summarize the key findings for the management.

Dashbord Design and Customer Insight (Tableau)

•Communicated with managers of a start-up company to understand their operation processes and business needs.

•Applied advanced Excel skills to consolidate 6 months of transaction data for in-depth analysis and executive dashbords.

•Designed dashbords in Tableau present marketing insights for the manager to support decision-making for future.

•Applied a sentimental test and text-mining regression to get the parttern that can help company to better predict recall based on customers’ complains.

CD Sells Forcasting Project (R&SAS)

•Converted and manipulated 41 weeks historical sales data for analysis.

•Used four different models to evaluate historical data and generated numerical and graphical analysis.

•Chose the model that best fit the data to predict another 4 weeks sales.

LEADERSHIP

Alpha-Empowering Latino Leaders SMU Chapter Dallas, TX

Secretary Fall 2015-Present

Made connections with board members and sent important event information to all members

Assisted the president in preparing for events and connferences

Contact this candidate