Pascal Schmidt

Data Analyst

• Investigated returns on bundle purchases by testing multiple hypotheses and recommended different price points that led to increased revenue for the analyzed bundles.
• Provided dashboards and reports to the marketing team to better understand marketing campaigns and revenue flow.
• Created an R Shiny application that serves as an index page for our data analysis reports, making it easier for various teams to get access to all reports in an easy way.

Vancouver, BC | https://lbcstudios.ca/

Data Analyst

• Deployed and dockerized a web application on AWS with R Shiny that analyzed realtime Twitter data, which led to increased productivity of employees who used the application for research purposes.
• Queried, cleaned, and visualized data with the help of pandas, NumPy, and Python plotting libraries to update teams about machine learning model performances.
• Developed automated interactive dashboards with plotly and flexdashboard to inform teams about the internal data usage and to improve the client experience by sending out quality information.

Edmonton, AB | https://www.samdesk.io/

Data Analyst (co-op)

• Developed R scripts for cleaning multiple data sets and used SQL joins to build a usable data set for analysis.
• Built an R markdown report with tables and graphs for a better understanding of why people’s addresses on administrative data match that on census data.
• Created data visualization plots in Power BI to supplement the R markdown report.
• Presented data and conclusions to my team, which used the results to gain actionable insights into the Census Program Transformation Project and improved the population coverage for admin data.

Ottawa, ON | https://www.statcan.gc.ca/eng/start

Data Scientist (co-op)

• Designed reports and conducted an explanatory data analysis, which led to a successful publication, by visualizing the key characteristics of patients with endometrial cancer.
• Produced interactive dashboards to communicate data to physicians who used my work for presentations.
• Independently researched and applied previously unknown statistical libraries for improved data representation.
• Composed a bi-annual report by cleaning, reshaping, and joining multiple unstructured data sources, working extensively with R tidyverse packages such as dplyr, ggplot, purrr, tidyr, and stringr.
• Implemented a meta-analysis of individual patient data and a cox-regression model to determine if endometrial cancer patients need additional treatment plans and to improve their quality of life.

Vancouver, BC | http://www.bccancer.bc.ca/