Learn Data Skills
Beta
Connor Thornhill

Connor Thornhill

Data Scientist

N/A | Toronto, ON

Technologies

My Portfolio Highlights

My New Track

Intro to Statistics

My New Course

Introduction to Python

Insights conductor, orchestrating a symphony of knowledge from data melodies.

My Work

Take a look at my latest work.

course

Introduction to R

course

Introduction to Python

course

Intermediate Python

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

My Work Experience

Where I've interned and worked during my career.

Sentrex Health Solutions | Jan 2023 - Oct 2024

Data Scientist

• Led technical efforts on real-world data (RWD) and real-world evidence (RWE) projects, which involved analyzing consumer behavior related to ophthalmology dispense data. These projects generated approximately $100k to $200k in revenue per project, with the potential for scaling to larger initiatives. Tools and libraries used include PySpark, Databricks SQL, and ArcGIS. • Utilized unsupervised machine learning to support a strategic decision to continue product launches in a $1B Canadian market for a multinational pharmaceutical company. • Developed a machine learning model in Spark NLP to detect adverse events from patient communications, leveraging BERT embeddings from a pretrained BIOBERT transformer. • Created data collection and preprocessing pipelines for structured and semi-structured data in Databricks, integrating the company's SharePoint for subject matter experts to label data for machine learning projects. Tools and libraries used include Pandas, NumPy, SpaCy, Office365, and SendGrid.
Show More

Blackstone Energy Services | Apr 2020 - Jan 2023

Director, Data & Analytics

• Modeled multi-million dollar energy budgets for North American clients, taking into consideration their consumption profiles, energy price volatility, weather impact, utility rates, and carbon charges. Forecasts typically fall within a 2-5% variance compared to actual annual spend. Tools and libraries used include dplyr, lubridate, tidyr and stringr. • Collaborated with the development team to integrate third-party optical character recognition (OCR) and machine learning technologies into the central data model, automating previously manual processes. This initiative resulted in annual savings of $100k. • Mined market data from multiple sources and integrated it into an automated cleaning process that enables market analysts to present information to customers. Tools and libraries used include Python, R, SQL, Azure Functions, and SharePoint.

En-Pro International | Jul 2014 - Apr 2020

Data Analyst

• Created web scraping scripts to gather data in R and evaluate Alberta’s merit order through statistical models that forecast hourly prices. 2018 forecasts fell within 5% compared to actual prices. • Researched Canadian rate tariffs to establish utility budgets for large clients and monitor variances to create ongoing adjustments. Presented policy changes to various publicly traded companies and quantified the financial impact to the their future expenses. • Forecasted natural gas prices traded at the Henry Hub by developing a random forest model with gradient boosting. The model heavily influenced natural gas procurement decisions for the organization and its customers. Tools and libraries used include caret and xgboost. • Created multivariate linear regression models to forecast Ontario electricity prices. The models evaluated expected baseload generation, electricity demand and generation capacity; achieving an adjusted R2 of 0.94. • Modeled customer electricity and natural load profiles to support transactions of financial swaps and physical forward contracts.

My Education

Take a look at my formal education

Bachelor's of Commerce in FinanceOntario Tech | 2013

About Me

Connor Thornhill

Data professional with over 10 years of experience in multiple industries looking for my next data science opportunity!

Powered by

  • Work
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free