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 enhancements.● 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 analysis on content engagement, which drove 12% increase in CTR ● 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 data analysis● 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