- Maintain and ingest client's data to Cloud Database (Bigquery, Snowflake, Redshift)- Develop and improve Multi-Touch Attribution Model.- Build MMM (Marketing Mix Model) to quantify the impact of marketing activities and non-marketing factors. Recommend budget allocation based on model understanding.- Develop, improve and automate data mining process and recommendation system on a variety of platform (Google BigQuery, Snowflake). Produce performance metrics and conduct A/B test to improve the strategy.- Develop and produce weekly and monthly analyses to provide client insight and recommendations.- Combine campaign performance data, TV viewership data and user activities data from a variety of data sources and conduct TV-Attribution Model to gain insight and improve future marketing strategy.- Update and maintain database system on company's server.- Automate routine works by using python or batch to improve the working efficiency.- Build microsegmentation to better target audience and launch huge campaigns by python API on FB, Instagram.- Mentor and train new data analysts

- Design an algorithm to construct an all weather portfolio consisting of futures with 132% ROA, 1.36 Sharpe Ratio and 2.31% minimum year return (from 01/2006 to 05/2020).- Accelerate the procedure of sensitivity analysis of the algorithm by parallel computing.- Utilize sklearn to build model with Splines and filter out outliers to interpolate the volatility curve for TAIEX Option

-Taught 100 freshmen Calculus (General Mathematics) (a)(2)

- Helped students in mathematics department use 3D printer- Operated and maintained 3D printer