Wang Ho Chan Email & Phone Number

Hong Kong

City Of Industry, California, United States

• Conducted cohort analysis using SQL to assess the performance of marketing campaigns by comparing the retention rate and lifetime value of customers acquired through different campaigns. Delivered weekly and monthly campaign ROI reports to the marketing team, enabling them to optimize the budget allocation based on data, resulting in a 27% increase in MROI within a year.• Collaborated with marketing specialists to launch a new Facebook Ads campaign. Designed A/B tests to compare ad performance with different variations of content for continuous refinement, leading to a 38% increase in CTR and a 56% reduction in cost per lead.• Employed k-means clustering in Python to classify keywords of a search campaign, allowing the marketing team to adopt data-driven bidding strategies. This approach resulted in a 40% increase in CTR and a 33% reduction in cost per click.• Leveraged the AARRR metric framework to build and maintain 5 interactive Tableau dashboards with more than 30 KPIs, facilitating multiple cross-functional stakeholders in tracking customer behavior throughout their lifecycle.• Requested financial data from accounting and finance teams to conduct ad hoc analysis for C-level executives. Created charts and tables in Tableau to produce visualized reports for management to make data-informed decisions.• Performed competitor SWOT analysis to identify market trends. Provided actionable recommendations to product managers, assisting in prioritizing feature development and adjusting pricing to enhance market competitiveness.

Los Angeles, California, United States

• Computed TF-IDF scores in Python of each term in over 5,000 user reviews. Extracted frequently mentioned words to identify top 20% pain points of the search engines and provided recommendations to product managers for further optimization.• Defined key metrics to measure the relevance of search results. Accessed the search query log using SQL to extract user interaction data, assisting search engine algorithm designers in optimizing the ranking algorithm and evaluating its relevance.• Developed an interactive Tableau dashboard to compare the search engine performance metrics between different versions, providing visualized insights for the development team to monitor the impact of the newly launched version.• Initiated a weekly meeting series with technical stakeholders to improve cross-functional communication, allowing the analytics team to present user behavior insights and the development team to provide updates on their progress.

Torrance, California, United States

• Applied pandas library in Python to aggregate and clean raw data from over 10 sources.• Created Tableau dashboards to visualize 20+ advertising and sales KPIs to gain real-time insights.• Generated daily performance reports for marketing team to adjust campaign content and budgets.

Pasadena, California, United States

• Collected a dataset exceeding 10,000 rows in Python and transformed it for further analysis.• Utilized Python to automate part of the data cleaning process, reducing the daily preprocessing time.• Prepared documentations of EDA to help analysts identify trends and summarize data characteristics.