Dylan Guo Email & Phone Number

Toronto, Ontario, Canada

Toronto, Ontario, Canada

• Developed Python scripts for optimizing models using piecewise linear regression and ARIMA model. Applied decision trees, random forest, Adaptive Boosting, and Gradient Boosting to segment bank customers by demographics, enhancing revenue predictions with remarkable efficiency and accuracy improvements.• Conducted SQL queries and employed Alteryx and Hue for precise data preprocessing. Overcame challenges such as dataset selection, primary key joins, and data cleaning, including outlier detection and format standardization. • Built a Tableau dashboard from scratch for model monitoring, enhancing speed and accuracy. Leveraged Python for data cleaning and aggregation. Presented final dashboard to executives to aid in better decision-making. • Collaborated closely with team members and business partners to design, test, and deploy analytics solutions, including forecasting, optimization, and pricing models. Contributed significantly to improved business outcomes.• Demonstrated proactive initiative by identifying business challenges and opportunities. Developed data-driven proposals to enhance overall performance and efficiency.

Toronto, Ontario, Canada

• Built a self-service dashboard with Domo to improve productivity with enhanced efficiency of the reporting process, and empower business users to perform analytics and derive business insights from data.• Implemented R scripts to scrape data from the internet, transform the data into tidy data to build dashboards, and construct statistical models to support business decision-making.• Successfully collaborated with global stakeholders and completed specific requests such as big data queries, hypothesis testing, creating business campaign reports and website analysis.• Created multiple regular reports to support website optimization using Adobe Analytics, and efficiently presented significant findings to managers and other key stakeholders in monthly meetings.• Aggregated, visualized, and analyzed marketing data and performance metrics using Excel, R and PowerBI to construct monthly business reviews to inform the executives about the changes in company performance.• Utilized Chrome DevTools, WebPageTest, and PageSpeed Insights to analyze page load speed, and aggregated potential solutions to improve page load speed.• Investigated the correlation between webpage load speed and various marketing metrics such as revenue and website ranking, which helped validate the fast page load speed effect and support search engine optimization.

Toronto, Ontario, Canada

• Created forecasting models to predict 9+ key measures such as website traffic and lead conversion rate, supporting the implementation of business decisions and plans.• Aggregated and visualized marketing and sales data using Excel and Google Sheets and analyzed campaign performance to build weekly and monthly reports, providing insights from data. • Performed CRM data cleansing and lead filtering and identified 3,000+ opportunities with target personas to support the marketing campaigns. • Developed sales enablement collateral, training materials, and content library for the sales team.• Conducted competitive market research for content inspiration, intel, and new marketing channels. • Developed engaging content for social media and managed website chatbot to provide excellent customer experience as the first contact.

Bachelor Of Mathematics, Honours Statistics - Computing Minor, Economics Minor, Graduated With Dean'S Honours

Education record