Resume

Sign in

Data analytical skills,advanced excel, SQL, R, Tableau, prioritization

Location:
Manhasset, New York, United States
Salary:
$60000
Posted:
November 14, 2017

Contact this candidate

KATERINA XIE

*** ***** **, ********, *** York, **590 (516)-***-**** ac3bm7@r.postjobfree.com

PROFESSIONAL EXPERIENCE

Digital Marketing Analyst Intern Universal Processing Oct 2017 – Nov 2017

Collected business requirement from account managers and clients to design digital marketing campaign plans

Quantified marketing size and designed marketing assessment by analyzing competitors’ performance

Segmented and analyzed historical data to target potential customers and forecasted customer demand

Developed marketing campaign content in both Mandarin and English and deployed content to multiple social media platforms

Tracked performance of marketing campaigns and pivoted marketing strategy to ensure high customer engagement

Visualized marketing campaign results and presented ROI analysis to clients

Business Analyst Wanda Hotels & Resorts Corporation Jun 2014 – May 2015

Supported payroll and employee database administration

Generated monthly report to monitor employee performance KPI and segmented performance data to track new employee ramp up status

Completed ad-hoc request to analyze employee turnover rate, calculated employee efficiency in individual level and estimated overtime and training cost

Partnered with senior finance manager to drive cost reduction and defect correction initiatives, resulted in 12% employee efficiency increase

Collaborated with multiple cross functional team to drive reporting automation

ACADEMIC PROJECTS

Time Series Forecasting of Temperature Trend in Taiwan Hofstra University Mar 2017 –May 2017

Goal for this project is to practice multiple statistical models of Time Series Analysis to understand the best use cases of each model

Collected temperature data from multiple public resources

Set up data quality assurance procedures to clean out bad data point and remove outlier

Explored different statistical models (HoltWinters, ARIMA and Moving Average, Linear Regression and 4 simple methods) using R and observed data performance per model output

Interpreted model results and monitored key statistical index to find the most optimal solution (ARIMA Model) in processing temperature data

Presented progress updates in weekly data team meetings and provided written summaries

Analysis of Air Temperature and Micro Particles using R Hofstra University Oct 2016 –Dec 2016

Goal for this project is to find the main contributor for high temperature from micro particles compositions while practicing R

Collected air quality and temperature data from local government bureau

Cleaned and consolidated data to ensure data consistency and integrity

Practiced the concept of Residual, Correlation Statistical Significant through interpreting results from R models

EDUCATION

Hofstra University New York

M.B.A in Business Analytics, Frank G. Zarb School of Business, 3.7/4.0 Sep. 2015 – May. 2017

Guangdong Baiyun University Guangzhou, China

Bachelor of Science in Accounting, 3.2/4.0 Sep. 2010 – Jun. 2014

TECHNICAL SKILLS

• Database: SQL, MySQL, Oracle DBMS, Advanced Excel (vlookup, pivot table, formulas, solver)

• Programming Language: R (ggpolt2), Python

• Analytics: A/B Testing, Data Modeling, Forecasting, Linear Regression, Marketing Analysis, Time Series Analysis

• Data Visualization: Tableau, Google Analytics



Contact this candidate