Cen Yuan
Markham,ON
Summary
Results-oriented Business Analyst with 3+ years in real estate market analysis at Bay Street Group Inc. Proficient in SQL, Python, R, and Tableau for data visualization. Specialized in optimizing Google Ads campaigns, bridging marketing and IT, and providing actionable insights. Adept at complex problem-solving with a positive and proactive attitude in fast-paced environments. Proven track record in driving product development from concept to delivery, enhancing business operations for corporate growth and revenue.
Overview
4
4
years of professional experience
Work History
Business Analyst
Bay Street Group Inc.
07.2020 - Current
- Elevating company-wide decision-making with detailed reports on key performance indicators.
- Conducting in-depth analysis of real estate market trends and client behavior using SQL, ensuring data accuracy.
- Executing analytics solutions for the commercial strategy through predictive models and intuitive dashboards.
- Serving as a liaison between marketing and IT, translating business objectives into actionable insights.
- Analyzing Google Ads campaigns, optimizing performance and ensuring data quality.
- Utilizing CRM systems (HubSpot) for ongoing data analysis, enabling informed decisions and fostering business growth.
- Delivering concise, real-time reports on campaign data and KPIs to senior management using Tableau.
- Staying current on local real estate trends and regulations, providing strategic recommendations.
- Collaborating with a dynamic data analysis team to derive insights and facilitate real-time, data-driven decision-making.
Education
Master of Data Science -
University of Sydney
06.2023
Bachelor of Science - Statistics
University of Waterloo
Waterloo, ON06.2019
Skills
Proficient in data analysis tools and statistical scripting language including Python and R
Demonstrating a deep understanding of relational database concepts and the ability to use SQL Server, underscoring strong technical capabilities
Comprehensive knowledge of Tableau for reporting and data visualization, validated through successful projects implementations
Excel expertise, including advanced functions, pivot tables, and VBA modeling, capable of handling complex data manipulation tasks
Demonstrable understanding of cloud platforms in Azure systems and a data-enabler mind-set
Strong problem-solving skills, demonstrated by successfully identifying and solving complex problems and developing creative solutions in a collaborative team environment
Ability to maintain a positive and proactive attitude in fast-paced work environments, and efficiently prioritize tasks to meet tight deadlines
SAS Certified Base Programmer for SAS 9; SAS Certified Advanced Programmer for SAS 9
Languages
English
Full Professional
Chinese (Mandarin)
Native or Bilingual
Timeline
Business Analyst
Bay Street Group Inc.
07.2020 - Current
Master of Data Science -
University of Sydney
Bachelor of Science - Statistics
University of Waterloo
Similar Profiles
Hao Chu LiHao Chu Li
Real Estate Agent at Bay Street Group Inc.Real Estate Agent at Bay Street Group Inc.
Duan (James) LuDuan (James) Lu
Real Estate Broker at Bay Street Group Inc., BrokerageReal Estate Broker at Bay Street Group Inc., Brokerage
Janet TengJanet Teng
Sales at Bay Street GroupSales at Bay Street Group