Yibo Zhai
Digital, Growth Insights & Analytics
Summary
With over five years of dedicated experience in data analytics, I have honed expertise in digital analytics , business intelligence , and adept marketing analytics strategies. My professional journey showcases a consistent track record of delivering high-impact, user-centric data products through collaborative leadership with cross-functional teams. Proficient in query optimization, database management, and leveraging Machine Learning techniques, I am committed to optimizing data processes to solve intricate business challenges. My passion lies in translating complex data sets into compelling narratives that steer informed decision-making, fuel innovation, and catalyze business growth. Adept at driving actionable insights, I am poised to lead data-driven initiatives and strategies that elevate organizational performance and drive sustainable success.
Overview
6
6
years of professional experience
Work History
Manager, Digital Analytics
Tangerine
Toronto, Ontario
11.2023 - Current
- Facilitated seamless migration between Universal Analytics and Google Analytics 4 by implementing precise business conditions, ensuring accuracy in L1 Business Metrics , thereby preserving data integrity and fostering uninterrupted business continuity.
- Orchestrated the export of user data from Google Analytics 4 to BigQuery, enabling in-depth analysis and integration into existing dashboards, overcoming challenges in data validation between user and event tables for cohesive insights.
- Engineered revised definitions for prospect visits and customer metrics to harmonize GA4 data structures with historical UA data trends, devising a consistent definition while backtesting and applying multipliers for historical data adjustments, ensuring data accuracy for strategic alignment.
Senior Analyst, Product Management Insights
Loblaw Digital
Toronto, Ontario
11.2022 - 10.2023
- Orchestrated design of scalable digital behavior data pipelines using DBT & BigQuery , powering 20+ global dashboards and boosting user engagement by 30% .
- Designed and implemented an automated cumulative insights dashboard, consolidating data from multiple sources (Web Analytics, Marketing Analytics, and Business Intelligence) to empower cross-functional teams with actionable insights, fostering collaboration and informed decision-making.
- Implemented analytics dashboards for enhancing e-commerce funnels and formulating strategic plans and experiments, resulting in notable traffic and conversion rate improvements across all business lines.
- Discovered and addressed crucial customer UI/UX issues impacting key performance indicators (KPIs). This led to an ongoing strategic refinement and experimentation cycle, ensuring optimal user experiences and sustained business success.
- Achieved a 50% reduction in processing costs through strategic optimization using ELT technologies like DBT and GitLab , resulting in a 40% decrease in processing time .
- Pioneered Looker-based interactive dashboards for real-time critical business insights, enhancing stakeholder engagement by 25% .
- Collaborated with BI team to ensure seamless data integration, conducting user training and enhancing dashboard utilization, increasing user satisfaction by 20% .
- Implemented foundational alert system for PCX Grocery Team, effectively safeguarding business performance.
- Led a high-performing team, achieving a 25% increase in productivity and on-time project delivery.
Product Manager
Hongda
Shanghai, China
01.2020 - 08.2022
- Spearheaded the successful launch of a WeChat Mini Program for the shopping mall, enhancing the leasing process. Within the initial three months, the Mini Program yielded a 20% increase in rental inquiries compared to traditional channels.
- Implemented a targeted content marketing plan on the official WeChat account, showcasing the mall's unique features and exclusive offers. This initiative resulted in a 30% growth in account followers , a 25% increase in engagement , and a 15% boost in scheduled property viewings .
- Established and managed a WeChat Group Chat for tenants, fostering community engagement. The initiative increased tenant satisfaction by 25% and contributed to a 10% rise in lease renewals but also facilitated valuable networking, resulting in a 15% conversion rate of leads generated through community interactions.
- Led data integration across multiple systems and technologies, delivering five impactful, interactive, and scalable reports and dashboards using MS Power BI within one year, enabling enhanced access to critical business information and facilitating user adoption.
- Assisted the team in utilizing the most effective methods for data querying and insight generation, including SQL and Power BI(DAX) , and designed visually compelling data analysis that combined insights to support informed decision-making and compelling storytelling, successfully presenting business insights in a well-structured manner to diverse audiences.
Analyst, Insights & Credit Risk
Royal Business Bank
Los Angeles, California
06.2018 - 07.2019
- Utilized Tableau to design and develop data visualizations, dashboards, and reports that provided key insights into business performance, resulting in a 30% increase in dashboard adoption and a 25% reduction in report generation time .
- Collaborated with cross-functional teams to develop and implement new credit risk models, increasing model accuracy by 20% and improving credit decision-making for more accurate risk assessment and limit determination.
- Validated results and performed quality assurance to assess the accuracy of data.
Education
Bachelor of Arts - Economics
01.2016 - 05.2018
Skills
Digital & Marketing Analytics
SQL (BigQuery)
DBTGitlabLooker & Looker StudioPower BIAccomplishments
Loblaw Digital Analytics Enhancement Project : Developed a robust data pipeline and refined reporting models, offering insights at two granular levels (Visits and Pageviews). Integrated with Looker to create an intuitive user interface, resembling Adobe Analytics, for expedited decision-making.
Global Customer Experience Excellence Dashboard : High-level dashboard showcasing traffic, conversion, discoverability, effectiveness, customer retention, and ESAT across all business lines.
Helios Search Engine Performance Insights : Dashboard offering comprehensive performance insights for Helios Search Engine across business segments.
Ecommerce Platform Transition Monitoring Dashboard : Executive-level dashboard for real-time monitoring of e-commerce platform transition from Hybris to Helios in 4 weeks.
Shoppers Drug Mart Fulfillment Optimization Dashboard : Dashboard tracking user preferences for fulfillment types following the implementation of the Locker Pick-up service at Shoppers Drug Mart, enabling strategic adjustments.
Syte.AI-Powered Joe Fresh Visual Search Integration Evaluation : Conducted rigorous testing and iteration to enhance the integration of visual search features powered by Syte.AI within the Joe Fresh platform.
PC Express Points Redemption Analysis : Comprehensive dashboard analyzing the impact of allowing users to pay with PCO points, with a focus on user transaction behavior within PC Express.
PC Express Fulfillment Flexibility Analytics : Dashboard monitoring customer choices between pickup and delivery and preferred time slots, to guide strategic decisions for enhancing conversion rates.
PC Express Online Grocery Performance Hub : A unified platform for assessing business performance, accommodating requirements from various stakeholders, including Merchandise, Omni partners, and the product-led growth team.
PC Express Online Grocery Subscription Optimization : Analyzing customer drop-off points during the PCX pass purchase process and assessing the effectiveness of ad and marketing components to improve engagement levels.
Member-Exclusive Pricing Monitoring Dashboard : Dashboard tracking traffic, conversions, and the performance of discounted products for PCO members.
2023 Black Friday Real-Time Analytics Dashboard : A dynamic, real-time monitoring dashboard for tracking key web analytics metrics, identifying and addressing issues, and ensuring optimal performance on Black Friday across all business segments.
Timeline
Manager, Digital Analytics - Tangerine
11.2023 - Current
Senior Analyst, Product Management Insights - Loblaw Digital
11.2022 - 10.2023
Product Manager - Hongda
01.2020 - 08.2022
Analyst, Insights & Credit Risk - Royal Business Bank
06.2018 - 07.2019
Ohio State University - Bachelor of Arts, Economics
01.2016 - 05.2018