Lin Li Email & Phone Number

Cambridge, Ma, Us

New York City, Us

Fort Mill, Sc, Us

• Consulted with clients to understand their marketing challenges, and conducted statistical analysis with SQL and Excel to provide recommendations on pre-campaign preparation and A/B testing, improving response rate by 2.42%• Designed and Developed automatic data reporting products for clients from retail and healthcare industries, developing reproducible SQL procedures and Tableau dashboards, saving data process time by 30%• Utilized data analysis techniques to identify causal effects of marketing efforts, optimized timing for promotion events, sales trends and customer purchase behavior, delivering customized reports to help clients develop effective marketing campaigns

Canton, Ma, Us

• Identified the top 3 profitable platforms that maximized member acquisition through analyzing patterns of user behaviors and campaign performance of individual channels on ROI, CTR, CPA, Conversion rate, etc.• Created a standardized simulation model for budget allocation and identified the optimal mix of marketing spending to facilitate bidding and campaigns strategies for Facebook, Google Paid Search, YouTube, Programmatic, etc.• Diagnosed churn rate issues through identifying key attributes and usage behaviors of churned members with clustering analysis to facilitate the design of member engagement strategies, improving monthly member retention by 3.8%• Improved the accuracy of member segmentation model by 15% and updated new features in 5 member segments to make recommendations on designing the CRM platform (Salesforce) and revising current policy

• Identified clients’ needs through constant feedback loops and delivered analytical insights to assist manager to provide tailored investment advices for 5 clients• Created reporting dashboards and presented finds to different stakeholders based on in-depth market research and qualitative analysis of the market size and industry trends of 15+ publicly traded companies• Delivered data-informed insights to facilitated portfolio optimization for 3 investment portfolios through analyzing financial ratios, price and trading volume of the stocks with time series analysis, increasing average return on investment by 5%

• Collaborated with the sales teams to establish periodic sales forecasts and deployed sales funnel conversion analysis to quickly respond to sales funnel friction and created ad-hoc reports that drove acquisition and monetization• Provided insights to make dynamic pricing strategy through analyzing correlations between price, supply, and buyers with multivariable regression analysis, representing an 5.5% increase of monthly revenue

• Identified potential marketing opportunity, maintained online marketing channel, and generated analysis reports each week to provide overview of the sales teams’ KPI• Identified profitable marketing channel and cooperated with the sales department to develop campaign strategy to increase annual sales by 20%• Designed follow-up customer surveys and developed customized CRM strategy for long-lasting clients

Master Of Science - Ms, Business Analytics

Bachelor Of Arts - Ba, Economics