Li Si Xuan Email & Phone Number

Toronto, Ontario, Canada

● Utilized SQL for data cleaning and processing large datasets while integrating Python for trend analysis, enhancing the monitoring and reporting of the institute's WeChat and video account performance by creating automated, accurate reports that informed strategic decision-making.● Improved user segmentation and trend identification through k-means clustering and topic modeling techniques in Python, enabling the identification of key user behavior patterns, which directly supported green finance initiatives by refining audience targeting and improving outreach effectiveness.● Boosted user engagement by 35% by conducting detailed SQL metric analysis combined with Python-based visualizations, allowing for the identification of underperforming content and optimized release schedules, leading to significantly higher user interaction and retention.● Analyzed past social media performance using Power BI to develop interactive dashboards and applied Excel pivot tables to evaluate historical trends, resulting in over 1,500 impressions and a 20% increase in click-through rates, optimizing both content delivery and marketing focus.

Toronto, Ontario, Canada

● Designed and implemented A/B tests on TikTok content strategies while leveraging SQL to analyze key performance metrics such as follower count, likes, traffic, and click-through rates, identifying high-performing content that led to a 15% increase in click-through rates and improved the effectiveness of future content planning.● Set up automated SQL-based systems for tracking engagement metrics and created real-time Power BI dashboards, enabling the marketing team to monitor performance in real-time, optimize campaigns more effectively, and adjust content strategies based on real-time insights to enhance engagement.● Utilized Python for segmentation, cohort analysis, and predictive modeling, analyzing user behavior patterns and forecasting engagement trends to refine content strategies, which resulted in a 25% increase in user retention through targeted scheduling and personalized content delivery.● Evaluated social media performance using SQL and TikTok Analytics, integrating data to optimize content creation and marketing approaches, ultimately contributing to the studio's growth to over 1 million TikTok followers, significantly expanding audience reach and engagement.

Toronto, Ontario, Canada

● Led cross-functional meetings weekly with stakeholders and teams to ensure smooth project execution and timely delivery, coordinating efforts to align with business goals.● Utilized SQL and Python to extract, clean, and analyze large datasets related to GFL's business model, services, and financial performance, identifying critical strategies that contributed to the company’s rapid growth and operational improvements.● Conducted market research using SQL and Tableau, analyzing both quantitative and qualitative data on competitors, with a particular focus on accounts payable models, uncovering trends and providing actionable insights that enhanced GFL’s competitive edge.● Developed detailed reports and visualizations using Excel and Tableau dashboards, integrating financial and operational data to propose strategies that optimized accounts payable processes by 10%, significantly improving overall operational efficiency.

Master'S Degree, Mechanical & Industrial Engineering, Gpa: 3.87

Technical Emphasis in Analytics

Bachelor Of Science - Bs, Double Major In Economics And Statistics, Cgpa: 3.62

Minor in Mathematics