Yu Lu Email & Phone Number

Montreal, Quebec, Canada

• Developed robust ETL data pipelines to integrate eIVF and Medesync EMR systems; improve data extraction and data reporting efficiency by 50%• Utilized Python for data cleaning, integration, and analysis of over 1.7 million rows of IVF data with 100+ features. • Conducted literature reviews and built machine learning model to predict IVF Live birth occurrence; performed regression analysis evaluating the impact of female and male ethnicity and age on IVF outcomes.

Montreal, Quebec, Canada

Project Objective: Enhance Engine Maintenance Efficiency with Automated Solutions• Designed an intuitive user interface for an automated system to identify key engine parts, improving user experience and operational efficiency by over 30%.• Utilized Power BI and DAX formula to create dashboards analyzing environmental factors and customer behavior on part replacement rates. These dashboards supported tailored maintenance strategies for different regions or customers.

Ottawa, Ontario, Canada

Project Objective: Capacity Planning for Surgical Service to Address the COVID-19 Surgical Backlog• Led a team of 3 using Python and Arena to model and address the surgical backlog, incorporating time-series forecasting, queuing models, and probabilistic sensitivity analysis.• Designed an interactive interface for hospital management to visualize and plan for surgical capacity needs.

Guangzhou

• Automated insightful weekly performance reports using Power BI DAX, saving 10 hours per week in manual data compilation and analysis; created complex SQL queries to extract meaningful insights from database.• Applied advanced audit data analysis skills to verify potential market values and compliance of marketing channels achieve a 100% accuracy rate in monthly audits.

Shanghai, China

• Enhanced targeted marketing strategies by analyzing daily operational and sales data using Excel function like VLOOPUP and pivot tables, increasing follow-up effectiveness by 25%. • Assured data quality by conducting regular audit, reducing reporting errors by 20%; provided essential administrative support.

Master Of Management In Analytics

• Recipient of Entrance Scholarship

Honors Bachelor Of Commerce, Healthcare Analytics

Activities and Societies: Magna Cum Laude, Dean’s Honour List 2020-2022, Merit Scholarship 2020-2022Skills: Arena Simulation Software ·.