Junru Wang Email & Phone Number

• Extracted, cleaned, and analyzed 2M+ data using SQL and Python, developed Tableau dashboards featuring 10+ KPIs on customer engagement and sales performance, presented actionable insights and recommendations to key lines of business, which were implemented to optimize strategies• Collaborated with the Marketing Operations team to tackle business challenges by analyzing historical campaign data and conducting customer segmentation analysis using K-Means clustering, proposing customized campaign strategies for different segments to enhance targeted marketing efforts, which improved response rates by 10%• Supported the design of a recommendation system by creating event tracking metrics to capture users’ historical recharge behaviour and analyzing recharge recommendation packages’ reach and usage for continuous optimization of the system, which enriched package options by 50% and increased recharge retention by 7%• Automated code and model pipelines in the cloud using Microsoft Azure services. Collaborated with senior data analysts through Git repositories to enhance code reusability and documentation, and worked with cross-functional stakeholders to define business requirements and key metrics

Montreal, Quebec, Canada

• Created an automated ETL pipeline using SQL and DBT from Databricks, leveraging Python for data mining and cleaning large, complex datasets, which improved data processing efficiency by 30%• Utilized Tableau to create visualization dashboards that monitored and optimized in-game components and analyzed player behaviors across different user cohorts, delivering actionable business insights and recommendations to executives, resulting in enhanced monetization and increased player retention• Designed, monitored, and analyzed A/B tests aimed at boosting player retention rates, including the selection of north-star metrics, retrieval, contextualization and analysis of results through a business logic lens, which increased player retention by 5% and improved customer satisfaction by 20%• Developed a Logistic Regression model to identify features impacting player engagement, achieving 70% accuracy through cross-validation and feature selection, and used odds-ratio to highlight the top important features for executive insights• Collaborated with cross-functional teams including PMs, designers, and live ops teams to understand business needs and provide data-driven solutions; utilized JIRA for issue tracking and project management, and Hansoft for Agile decision-making• Designed and presented creature ROI calculations to assist PM in planning the roadmap for the upcoming year• Enhanced the quality for raw data and structured table by data quality assurance and requesting necessary tracking

Montreal, Quebec, Canada

• Collected over 100 microeconomic factors for S&P 500 stocks from WRDS and additional macroeconomic factors from the Fred API for past 20 years, and utilized Python for data cleaning, preprocessing, and feature engineering• Developed Machine Learning models to predict future stock returns and risks, conducted hyperparameter tuning, defined important metrics, and evaluated model performance, achieving a 27% ROI• Designed a Tableau dashboard to visualize stock trends, predictions, and model performances, delivering data-driven insights to clients and enhanced decision-making processes

Nanjing, Jiangsu, China

• Recreated quantitative investment strategies based on Dongxing Securities' analysis of industry portfolio returns; collaborated with the team lead to design experimental processes and transformed report formulas into models using Python• Collected, preprocessed, and analyzed millions of rows of unstructured data from multiple sources; presented an analytics report on foreign capital flows and investment preferences, validating results and achieving a 14.12% annual return with new strategies

Master Of Management In Analytics, Gpa3.57

Bachelor Of Computing (Hons.), Computing And Mathematics, Gpa4.01

International Summer School

Senior High School

Exchange Programme