Yichen Li Email & Phone Number

• Collaborated with different functional teams’ stakeholders to implement 500+ complex SQL codes daily using Snowflake to extract data from large databases for analyzing diagnostic products
• Automated dashboards with Power BI to convey analytical findings through compelling, executive-ready presentations weekly to multiple levels of management.
• Designed statistical analysis and executed Python to slice into various segmentations to identify the bottom 10% of provider performance group and provide deep insights and recommendations for training process.
• Created and modified stratification logic to provide a target members list to our clients monthly.

• Led data analysis initiatives to guide decision-making for the Editorial team such as defining ongoing weekly & monthly performance reporting data published content, identifying key viewer trends, and deep dive.
• Developed and reported performance of dashboard on 2000+ digital and mobile marketing channels around subscription acquisition and improved customer engagement/retention by 25%
• Updated weekly mobile push notification dashboard using Adobe Analytics based on campaign business goals and KPIs

San Francisco Bay Area

• Collected and analyzed online audience behavior data on social media, including Facebook, Twitter, and Instagram weekly, and established a Google BigQuery database to drive efficient data access for future social media.
• Increased subscription counts by 12% by creating targeted, data-driven advertisements and customized marketing strategies through user segmentation cohort analysis of survey data
• Optimized Google Analytics to improve the data accuracy by 80% and provided meaningful metrics for the marketing team

Lehi, Utah

• Forecasted staffing needs from customer call volume during peak and holiday seasons to reduce overtime staffing by 36%
• Automated 7 reports to assess operational performance and to guide senior leadership on methods to improve workplace efficiency by 20% and reduce workload
• Developed KPI dashboards for the Sales Department and presented weekly metrics to multiple levels of stakeholders, which surpassed the sales goal by 18%

Greater Salt Lake City Area

• Supported students and professors by analyzing grade data to provide actionable insights.
• Conducted detailed analysis of electricity usage using Python, Excel, and Tableau, identifying patterns to optimize energy consumption and reduce costs.
• Evaluated psychology course feedback through Python-based analysis, delivering key insights to the department for curriculum improvement.

Toronto, Canada Area

• Analyzed weekly transactions to flag unusual activities and abnormal large cash transactions for the fraud department
• Generated employee performance dashboard for credit card sales, number of new accounts opened, and amount of investment collected

Toronto, Canada Area

• Worked closely with cross-functional team to help project annual budget
• Developed automated charts for forecasts, revenue, gross margin, and OPEX
• Delivered professional and timely client communications regarding project updates
• Trained and led both new hires and part-time employees

Beijing City, China

• Worked closely with credit adjudicator to create an internal control assessment system that minimizes risk, improves efficiency and collaboration between internal departments
• Assisted client with a payment plan, successfully deducted the rental payment on time with an average of 50 deductions per day
• Minimized late payment by consistently monitoring customer profiles (average 10 calls per day)

Master'S Degree, Data Analytics, Gpa 3.8

- Mathematical and Statistical methods for Data Analytics - Introduction to Python - Big Tech Data (Hadoop, MapReduce, Spark, Ambari.

Sql, 4.0

- Excellent in SQL programming - Designed and created databases - Proficient in complex queries involving various joins and correlated.

Master Of Business Administration - Mba, Business Administration, Management And Operations, Gpa 4.0

Bachelor’S Degree, Economics

Activities and Societies: Laurier Global China Connection