Wendy (Lingqi) Ren

Associate Marketing Analyst at Destination Ontario
  • Claim this Profile
Contact Information
us****@****om
(386) 825-5501
Location
Waterloo, Ontario, Canada, CA
Languages
  • English Full professional proficiency
  • Chinese Native or bilingual proficiency
  • Mandarin Native or bilingual proficiency
  • Shanghainese Native or bilingual proficiency
  • Cantonese Elementary proficiency
  • French Elementary proficiency

Topline Score

Topline score feature will be out soon.

Bio

Generated by
Topline AI

You need to have a working account to view this content.
Join now
You need to have a working account to view this content.
Join now

Credentials

  • COVID19 Data Analysis Using Python
    Coursera
    Jun, 2021
    - Nov, 2024
  • Python for Data Analysis: Pandas & NumPy
    Coursera
    Jun, 2021
    - Nov, 2024
  • Tools for Data Science
    Coursera
    Jan, 2021
    - Nov, 2024
  • What is Data Science?
    Coursera
    Jan, 2021
    - Nov, 2024
  • Doing More with SAS Programming
    Coursera
    Dec, 2020
    - Nov, 2024
  • Getting Started with SAS Programming
    Coursera
    Nov, 2020
    - Nov, 2024

Experience

  • Destination Ontario
    • Canada
    • Travel Arrangements
    • 1 - 100 Employee
    • Associate Marketing Analyst
      • May 2023 - Present

      - Utilized Tableau for data visualization, trend analysis, and insights generation in the tourism industry - Managed monthly reporting and dashboards with Google Looker - Solely developed a research database from scratch using Excel VBA and Power Query - Oversaw surveys and prepared consolidated presentations for board review - Utilized Tableau for data visualization, trend analysis, and insights generation in the tourism industry - Managed monthly reporting and dashboards with Google Looker - Solely developed a research database from scratch using Excel VBA and Power Query - Oversaw surveys and prepared consolidated presentations for board review

  • Scotiabank
    • Canada
    • Banking
    • 700 & Above Employee
    • Data Analyst Intern
      • Jan 2022 - Aug 2022

      - Developed and maintained a Power Pivot tool for auto-generating quarterly financial reports - Regulated routine cleaning for a massive database with Excel and Oracle - Conducted and distributed monthly financial reports in Excel, PDF and PowerPoint format - Assisted other colleagues for some data analyzing tasks - Developed and maintained a Power Pivot tool for auto-generating quarterly financial reports - Regulated routine cleaning for a massive database with Excel and Oracle - Conducted and distributed monthly financial reports in Excel, PDF and PowerPoint format - Assisted other colleagues for some data analyzing tasks

  • University of Waterloo
    • Canada
    • Higher Education
    • 700 & Above Employee
    • Undergraduate Marker
      • Sep 2021 - Dec 2021

      - Finish assigned questions promptly- Ask about, discuss on, and give feedback to professor or leading teaching assistant for potential conflicts between students’ answers and given solutions

    • Online Learning / Research Assistant
      • May 2021 - Aug 2021

      - Conducted massive data cleaning (+ 3000 rows with 15+ attributes), analyzing and visualization by Python, R, Excel and Power BI- Developed and maintained linear regression and correlation models- Prepared final reports with project introduction, functional descriptions, statistical graphics, and included insightful suggestions on the organization of the online courses- Assisted the professor with writing the paper that analyzed the drivers of online class performance

    • Undergraduate Marker
      • Jan 2021 - Apr 2021

      - Finish assigned questions promptly- Ask about, discuss on, and give feedback to professor or leading teaching assistant for potential conflicts between students’ answers and given solutions- Detect possible plagiarizing solutions- Give clear feedback for partially correct or wrong answers

  • Arc Investments and Consulting
    • Toronto, Ontario, Canada
    • Data Analyst
      • Apr 2021 - May 2021

      - Extracted, transformed, and loaded (ETL) data from multiple data sources to SAS and performed EDA (explanatory data analysis) for car accidents and road attributes. - Conducted complex calculations (DAX) and dynamic visuals using Power BI to distill complex data (+33,000 rows) into visually pleasing, actionable insights for operational and executive-level reporting. - Created interactive dashboard in Excel and assisted in the preparation of proposals, presentations, compliance inspections, engagement materials (e.g. surveys, workbooks), and reports. Show less

  • Shanghai Varnish International Trading Co. Ltd.
    • Shanghai, China
    • Marketing Assistant
      • Sep 2020 - Dec 2020

      - Coordinate with marketing team to create cases and research - Gather information and material needed for meetings - Create and work with case studies - Manage inventory - Coordinate with marketing team and give feedback to various products - Upload and update website and social media content - Coordinate with marketing team to create cases and research - Gather information and material needed for meetings - Create and work with case studies - Manage inventory - Coordinate with marketing team and give feedback to various products - Upload and update website and social media content

Education

  • University of Waterloo
    Bachelor's degree, Statistics
    2019 - 2024
  • L'Amoreaux Collegiate Institute
    2017 - 2019
  • J'Addison School
    2016 - 2017
  • Pudong Foreign Language School
    2012 - 2016

Community

You need to have a working account to view this content. Click here to join now