Yuqi Cai Email & Phone Number

Oakville, Ontario, Canada

-Data Analysis and Reporting: Regularly identify and analyze data from multiple sources to generate monthly and annual ridership reports, forecast trends, monitor revenue patterns, and project passenger responses to fare and route changes. Conduct comprehensive statistical analysis for external agencies like CUTA and Stats Can.-Route and Service Planning: Assist in preparing budgets for scheduled mileage and platform hours, forecast operational requirements, and support route efficiency analysis. Evaluate the impact of community development on transit services through feasibility studies involving land use and demographic data.-Insights and Decision Support: Act as a subject matter expert in cross-functional teams to provide prescriptive and predictive analytics. Develop algorithms and employ statistical programming to discover patterns, validate analyses, and identify business and service improvement opportunities.-Visualization and Training: Define, design, and deliver effective data visualizations, develop a repository of reusable templates, and provide customized training to enhance self-serve capabilities. Assist in the development and revision of routes, including On-Demand services, and continuously improve data quality and collection procedures.

Toronto, Ontario, Canada

Developed ridership prediction models for GO Train system to decrease fare non-compliance rate. Implemented strategic resource allocation and built insightful dashboards, resulting in a 60% boost in Go Train revenue protection efficiency.• Cleaned and managed 4 data sets, including ridership, fines, and resource allocation, each containing over 2 million records using Python, Excel, and SQL, which uncovered key factors influencing revenue protection strategies.• Built and optimized machine learning models using Azure ML, leveraging Scikit-Learn and pandas to predict ridership under various conditions, facilitating effective scenario analysis, and yielding 80% model accuracy.• Developed insight-focused dashboards using Power BI to support revenue forecasting and monitoring.• Streamlined project delivery adopting agile methodologies and utilizing JIRA for task management, achieving a 98% on-time completion rate, and optimizing resource utilization.

•Analytical Database Marketing: Conducted ETL operations and feature engineering, focusing on key metrics like ROAS and ACOS to optimize marketing campaigns and product positioning. Recognized as a top 3 performer within the team in 2021.; received a recommendation letter from direct manager.•Strategic Problem-Solving & Customer Relations: Engaged with advertisers using Amazon's supply chain system. Converted business problems into project requirements, and achievable goals. Coached clients that allowed an increase in click-through rates by 85% and revenue by 30% in one month within an acceptable advertising budget.•Process Enhancement & Knowledge Sharing: Created the first Amazon Advertising Support Knowledge Center, and established knowledge-sharing projects with team members. Two months after the project was officially adopted, the customer satisfaction rate of the advertising team rose to 1st place among the global team.

Canada

•Strategic Decision Making: Developed a new financial credit product mainly for start-up companies within the shipping industry. Provided informed recommendations to effectively evaluate potential opportunities for market expansion.•Data Management: Developed metrics using SQL to evaluate market features, pricing, and customer segmentation.•Risk management: Coordinated with the team to evaluate the overall impact of COVID-19 on target industries to assess risks and provided 3 alternatives to help hedge against the risk of market instability for new products.

Master'S Degree, Management In Artificial Intelligence

Bachelor Of Commerce - Bcom, Finance, Economic

Bachelor'S Degree, Business/Commerce, General