Churan Yu

Bilingual Operations & Data Analyst with 3+ years of experience supporting CRM systems, marketing operations, reporting automation, and business process optimization. Experienced in leveraging SQL, Python, Salesforce, and data visualization tools to improve operational efficiency and data quality.

Canadian Permanent

Resident with professional communication skills in English, French (TCF B2), and Mandarin.

Sales & CRM Operations Analyst at BMW Group (via Vendor) (2024-07 – 2026-03)

• Improved lead management workflows and CRM automation, contributing to a 12% increase in dealership visit conversion rates.
• Managed and validated customer master data across dealership CRM systems using SQL-based quality controls, improving reporting accuracy and operational consistency.
• Developed an automated data privacy platform using Python (Django), ensuring compliance with internal data governance requirements.
• Delivered CRM troubleshooting support and created SOP documentation, reducing new-user onboarding time by 30%.

Marketing Operations & Data Analyst at Procter & Gamble (P&G) (2022-07 – 2024-06)

• Automated marketing data reconciliation processes using Python, reducing reporting discrepancies across advertising platforms.
• Built SQL-driven dashboards and KPI reports to identify campaign optimization opportunities, reducing ineffective media spend by 15%.
• Designed automated QA validation workflows for marketing campaigns, ensuring accurate tracking and deployment.
• Collaborated with business stakeholders and technical teams to translate operational requirements into scalable reporting and automation solutions.

Bachelor of Computer Science in Computer Science – South-Central Minzu University (2022)