Yufan Wang

Experience

• 

  Weibo Corporation

  Jul 2012 - May 2016

  Business Analyst

  Weibo is the most influential social media platform in China (similar to Twitter).• Gathered and prioritized requirements from various stakeholders, structurally solved product problems, driven execution by collaborating and communicating with cross-functional teams.• Launched key projects on schedule by deeply understanding the whole project and carefully checking before/after release.

• 

  LangTaoJin

  Aug 2016 - May 2018

  Business Data Analyst

  LangTaoJin operates Hers.com, an online shopping community in China. It is a VC-backed AI shopping technology startup that develops intelligent advertising systems, including user behavior analysis, ad channel monitoring, and internet marketing tools.• Designed the user flows and user experience for novel campaigns across mobile, H5 and social media platforms.• Designed A/B tests to optimize bounce rates, conversion rates, click rates, retention rates for campaigns.• Key Achievements: two of the campaigns went viral in Wechat. Acquired massive new users and followers, once acquired 10,000+ new downloads per day for Tashequ Android app (iOS download source was unavailable). Show less

• 

  Atlantis Healthcare

  Feb 2021 - Jun 2021

  Data Scientist Intern

  Atlantis provides data-driven personalized patient support programs to improve treatment adherence and self-management for chronic diseases.• Predicted patient’s non-adherence for a long-term injection program using textual patient notes and text mining techniques. Identified insights from predictive models and statistical analysis. Made recommendations for the program and future investigation regarding other programs.• Presented the research results to the team and AUT staff. Was awarded ‘Student Choice’ for effective communication and clear visualization.• Supported other data science projects by being involved in project meetings, reviewing reports and generating data ready for further analysis. Show less

• 

  Genesis

  Aug 2021 - Mar 2025

  Reporting Analyst

  Responsibilities• Provided end-to-end reporting and analytics solutions to support strategic and operational goals, processed 83 tickets in last 6 months.• Designed and enhanced Power BI dashboards, SSRS reports, and SSIS workflows for real-time insights. Established Power BI design and layout guidelines to standardize reporting.• Partnered with cross-functional teams to analyze and solve data issues, recommend proper metrics to measure the target. Key Achievements• Identified factors behind missing credit for re-contracted customers with SQL and Power BI and conducted automated reconciliation workflow, reducing potentially 30ish customer complaints per month.• Investigated and calculated delicate compensation credits accurately for dual fuel customers based on business rules and conditions, totally compensated 248 customers and 30k+ credits. • Identified longer billing period customers and delivered time-sensitive communications, made sure the alert come prior to the bill file to reduce customer complaints.• Conducted cohort analysis and validated no significant correlations between payment methods/price plan type and customer churn. Show less

• 

  The University of Auckland

  Apr 2025 - now

  Power BI Specialist