Resume

Sign in

Data Analyst

Location:
Jackson Heights, New York, United States
Posted:
December 04, 2017

Contact this candidate

Wei (Chrystal) Zhou

**th Street, **-**, Woodside, NY 11377

347-***-**** ac3k8u@r.postjobfree.com

https://www.linkedin.com/in/weizhouanalyst

EDUCATION

****-**** ******* **********, ******* SCHOOL OF BUSINESS New York, NY

Master of Science in Business Analytics, 12/2017, GPA 3.61

Relevant Coursework: Database Management, Data Mining, Web Analytics, Statistical

Methods and Computation 1, Explanatory Models, Big Data Analytics

Student Club Memberships: President of Fordham Business Analytics Society

Honors and Awards: Center for Digital Transformation Fellowship Award

2014-2016 FORDHAM UNIVERSITY, GABELLI SCHOOL OF BUSINESS New York, NY

Master of Science in Accounting, GPA 3.67

Honors and Awards: First Place Case Competition Award

2010-2014 ANHUI UNIVERSITY OF TECHNOLOGY Maanshan, CN

Bachelor of Management, Accounting, GPA 3.52

Honors and Awards: Certificate of Accounting Profession

PROJECTS

2016-2016 PHARMACY TRACKING DATABASE SYSTEM PROJECT New York, NY

Developed a new database tracking system to cope with the increasing number of services

provided, the new database tracking system was created using IBM Infosphere Data Architect

2017-2017 DELOITTE MARCH DATA CRUNCH MADNESS PROJECT New York, NY

Built a predictive model using logistic regression and random forest to conduct feature

selection, calculate log loss to predict the winners of the 2017 NCAA Basketball Tournament

Achieved the accuracy rate of 75.8% in predicting the final four winners

EXPERIENCE

2017- 2017 THE NATURE’S BOUNTY CO. Ronkonkoma, NY

Data Analyst, IT Department

Engaged in the SKU analysis project, extracted 80,000+ rows of data from data warehouse

using SQL queries, validated and imported data to Tableau.

Built and conducted maintenance the SKU analysis dashboard using Tableau to visualize data,

explore aggregates and trends in sales data, drilling down to the SKU-level to draw conclusions

regarding gross profit and sales.

Engaged in the Quality report project, transformed and mapped the data from excel reports with

current Tableau dashboards.

2016-2017 FORDHAM UNIVERSITY, Gabelli School of Business New York, NY

Graduate Research Assistant, 5 out of 65 MSBA students

Assisted professor in researching and analyzing the distribution and spending on chronic diseases conditions in USA with a view to suggest healthcare cost reducing measures.

Collected, merged, visualized and analyzed 46,171+ rows of chronic diseases condition data using

Tableau.

2015-2016 DOCTORS WITHOUT BORDERS New York, NY

Finance and Revenue Intern, Finance Department

Recorded the payments of donors and input vendors’ invoices to create accounting journal entries.

Ran and printed the preliminary report for review, approval, and ultimate posting by managers.

In conjunction with the implementation of the new AP accounting system, verified

that all 900+ vendors were accurately reflected in the system based upon underlying

the W8 or W9 information.

ADDITIONAL

Languages: Fluent English; Native Mandarin

Computer: Proficient with Tableau, SQL,R, Microsoft Excel-Pivot Tables, Vlookup, PowerPoint, Word, Outlook; Familiar with Google Analytics, Spotfire, IBM SPSS Modeler, Python

Certificate: Intermediate R; Watson Analytics 101, passed the BEC part of the AICPA Exam



Contact this candidate