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