Wenjun Li Email and Phone Number

Social Network Analysis; Customers churn prediction models; BI reporting; Growth Hacking; ETL management and Hive SQL

ID Mapping System; LTV models; AB Testings; Growth Hacker; Attribution analysis and Customer Funnel models on Adds; Building data middle platform; User Profile

• Built ARIMA times series model to forecast event-planning orders in R, and generated business solutions to improve efficiency and effectiveness in labor resource utilization through better allocating employee and reducing proportion of freelancer and union shifts • Manipulated shifts into orders, and applied K-Means clustering to classify and label orders with event types with scikit-learn package• Visualized orders data in different dimensions to find business insights and identified… Show more • Built ARIMA times series model to forecast event-planning orders in R, and generated business solutions to improve efficiency and effectiveness in labor resource utilization through better allocating employee and reducing proportion of freelancer and union shifts • Manipulated shifts into orders, and applied K-Means clustering to classify and label orders with event types with scikit-learn package• Visualized orders data in different dimensions to find business insights and identified seasonality, trend and cyclicity patterns in Tableau Show less

• Assisted on preparing curriculum to facilitate the education of participants from diverse biomedical background to data science training and enhance biomedical science curriculums through the incorporating programming tools for machine learning• Collected data and tested python code for a new textbook manuscript "Marketing Analytics with Excel" authored by Drs. Bahram Alidaee and Haibo Wang on chapter 4 and 5 about Market Segmentation and Logistical Analysis

• Manipulated and aggregated historical flight load factor data based on courses of over 3000 AA’s flights into database using Alteryx • Led team of 5 to build airline KPI dashboard in Tableau visualizing seasonality pattern and tracking real-time flight performance data• Classified flagging flights data using decision tree algorithm in R and identified reasons of unexpected variance in flight booking curve

Composed cash flow statements in Excel and Accounting reports of Yinge Industrial Group Co. Ltd of first half year of 2018. Collect information and analyzed the annual report data to provide company with insightsParticipated in asset-backed bill project of Anhe Finance Lease Co. Ltd and conducted a cash flow forecast project with time series forecasting models of the company in 2019

• Made on-site investigations in assessment of IPO listing of Hemeijia Company and Runtai Engineering Management Co. Ltd project• Produced application paper materials to realize NEEQ listing process of Hemeijia Company and Runtai Engineering Co. Ltd• Searched for information and produced weekly reports to manager, made PPTs for routine meetings and connected with clients