Will Ye Email & Phone Number

Toronto, Ontario, Canada

Toronto, Ontario, Canada

• Led the end-to-end development of a comprehensive customer SaaS usage score dashboard equipped with real-time updates and meticulous tracking of score history. This instrumental tool empowered the customer success team by facilitating the identification of customers at the highest risk of churn. By promptly delivering targeted re-training and troubleshooting interventions, the team achieved a remarkable 15% reduction in churn rate compared to the previous year despite the worsened economic outlook.• Collaborated with the marketing team to establish a streamlined process for strategically curating product selections within weekly e-commerce marketing emails. Encompassed critical factors such as baseline sales volume, brand recognition, popularity trends, seasonality, and other pertinent considerations. The aim was to optimize product assortments in order to maximize sales revenue and drive exceptional results.• Utilized SQL and Python to develop and maintain a semi-automated script for tracking sales attribution derived from e-commerce marketing campaigns. Captured and analyzed critical metrics such as pre-sale intent (product page views, add to carts), sales conversions, first-time orders, and more. Leveraged these insights to conduct comprehensive reviews of past campaigns, extracting valuable learnings that informed the development of future campaigns and enhanced their effectiveness.• Directed the comprehensive data quality enhancement initiative for the e-commerce platform. Leveraging powerful web-scraping libraries including Selenium, Beautiful Soup, and Requests, successfully rectified a substantial number of marketplace products with sub-par or even absent images, descriptions, and specifications. Notably, internal A/B testing demonstrated that products with high-quality images and descriptions observed a remarkable 70% increase in click-through rate and a 25% boost in conversion rate.

Toronto, Ontario, Canada

• Consulted over 200 small to medium sized businesses in the GTA to understand their business intelligence needs, challenges, and goals. Evaluated the existing processes and improved upon them or propose new solution when necessary. Expand channels to collect, maintain, document, and analyze data. Communicating directly with key business stakeholders, developed appropriate goals, identified trends, monitored performance, and delivered insights by performing regression analysis and predictive analytics (forecasting) with Excel, Tableau, and other BI reporting tools. Designed and implemented interactive dashboard with pivot tables, KPI, and report functionality.• Provided regulatory compliance, auditing support, and tax guidance, compiled IFRS based financial statements and prepared tax returns for over 50 corporation and sole-proprietorship clients.