Zihan (Johnson) Ling Email & Phone Number

Irvine, CA, US

Santa Clara, California, US

(NASDAQ: EHTH) Working on LTV forecast, customer retention analysis, customer behavior analysis, etc.

Culver City, California, US

• Conduct an ad hoc analysis on shop banner by writing SQL in AWS Databricks to query player data from large datasets and building a shop conversion funnel in Tableau to support product managers in feature tuning.
• Investigated 20+ product dashboards by documenting the dashboard status in Google Sheets, initiated an improvement plan to enhance usability and data coverage, fixed data bugs and automated the dashboard daily updates.
• Redesigned monetization and retention dashboards by writing SQL in Databricks and applying LOD & parameter functions in Tableau to add player segments and aggregation levels; enhanced data coverage up to 20% and data.
• Built a player behaviors table with 100+ features by using SQL and Spark to query raw data from 6 large datasets in AWS
• Designed reusable SQL & Python scripts and automated the time updates in Databricks; improved 30% query efficiency
• Clustered player segments by applying PCA and a K-means model in Python, derived business insights and proposed actionable recommendations, and provided a 30-minute business presentation to the product and data analyst.

Purchase, New York, US

• Partnered with 4 experienced digital marketing managers, launched and implemented 100+ digital and social media projects related to all PepsiCo's beverage brands in China
• Negotiated with 30+ external agencies, coordinated with internal legal and control departments about execution plans and delivery costs; resolved 40+ internal and external conflicts and obtained 100% execution rate of.
• Automated the budget tracking and validation process by using pivot table and vlookup functions in Excel, improved the budget report frequency from weekly to daily, enhancing the tracking efficiency by 50% and report.

北京, 北京, CN

• Directed a case study on Charles Schwab to assess the feasibility and necessity of offshore banking services
• Investigated the potential competitors, financial policies, and political risks in 9 countries for offshore banking services
• Created and presented a strategy report to the president to show the feasibility of establishing offshore banking services

北京, 北京, CN

• Coordinated with multi-functional departments and leveraged SQL to integrate and clean operational data in 2019 and 2020l
• Conducted year-over-year comparison on operational data and built regression models to forecast sales trends in Excel
• Created a half-year operation report with data visualization in Tableau, proving the branch secured 10% growth in 2020

Master Of Science - Ms, Business Analytics

Bachelor Of Arts - Ba, Business Economics

Bachelor Of Arts - Ba, Film & Media Studies