Data Analyst Sales

*** ****** **** *, *********, PA ***** Zhenya ● (Ruby) (917)520-Xu 7458 ● ******.****.**@*****.***

SUMMARY

Passionate and detail-oriented Data/Business Analyst with 3-year experience in metrics analysis, database management, and transforming raw data into interactive visualizations, and developing business strategies. Expert knowledge in financial statistics, data evaluation, and programming. Independent thinker and self-starter with the motivation to learn and excel in a dynamic environment RELATED EXPERIENCE

Data Analyst, HiFu Services Inc., New York, NY Mar 2018 – Mar 2020

• Inspired and led the team to build a database in Microsoft Access and MySQL from scratch to dramatically improve reporting efficiency

• Developed SQL queries to obtain complex data from tables

• Tested validity, accuracy, and consistency of new and existing data

• Analyzed time series data and created over 200 insightful monthly analytical reports for global luxury fashion and jewelry clients in the U.S. and Europe, including Tiffany & Co., Max Mara, Tory Burch, and Prada

• Created interactive KPI dashboards and visualizations in Tableau to identify customers' key purchasing patterns and demographic metrics

• Proposed and launched Geo-located WeChat notification system based on the analysis of customers' preference, receiving over 70% click-through rate on Chinese New Year event

• Tracked over 45 brand campaigns in Google Analytics and optimized performance through data analysis

• Delivered research, analytical reports, and ad-hoc requests for sales and marketing team quickly and punctually

• Supported the data preparation of A/B testing

Business Analyst, New Spec Inc., Edison, NJ Mar 2017 – Feb 2018

• Performed detailed financial analysis including financial modeling, variance analysis, budgeting and forecasting to support strategic initiatives

• Collected sales and operational data and utilized statistical methodologies in R to predict future trends in cost, sales, and performance

• Maintained and updated sales database in MS-Access daily

• Identified and implemented automation tools to increase reporting productivity EDUCATION

Rutgers Master of University, Science, Financial New Brunswick, Statistics & Risk NJ Management, GPA: 3.7 Jan 2017

• Coursework in Regression, Time Series, Simulation, Data Mining, Financial Statistics, Multivariate Analysis, Portfolio and Risk Management, Java

Queens College of CUNY, Flushing, NY May 2014

Bachelor of Business Administration, Finance, minor in Mathematics, summa cum laude, GPA: 3.9

• Teaching Assistant and Tutor for Macroeconomics and Microeconomics HONORS AND CERTIFICATIONS

• CFA Level II Candidate

• Google Analytics Individual Qualification

• 2014 The Arthur D. Gayer Memorial Award, 2013 Barham Scholarship, 2012 Krell Family Scholarship SKILLS

Computer and Programming: MS-Access, MySQL, Tableau, R, Java, MS-Excel, Keynote, Google Analytics Languages: English, Mandarin, Shanghai Dialect

Contact this candidate