Overview
Work History
Education
Skills
Timeline
Generic

Dhruv Tantia

Waterloo,Ontario

Overview

4
4
years of professional experience

Work History

Data Analyst (Co-op)

Reinsurance Management Associates
Toronto, ON
01.2023 - 08.2023
  • Conducted thorough Experience Studies utilizing extensive datasets in Python.
  • Conducted intricate data extractions from SQL databases with multiple tables and extensive joins
  • Designed and implemented Python scripts for advanced data analysis and visualization, leveraging data frames, matplotlib, and numpy to deliver actionable insights to management.
  • Developed regression-based data models using R, optimizing them to enhance the precision and accuracy of actuarial forecasts.
  • Authored technical documentation outlining data processes, methodologies, and analytical frameworks to ensure reproducibility and knowledge retention.
  • Collaborated with cross-functional teams to provide ad hoc data solutions, translating business needs into efficient SQL queries that supported strategic decision-making.

Actuarial Analyst, Co-op

Gore Mutual Insurance Company
Cambridge, ON
01.2022 - 08.2022
  • Built a dynamic data compiler (VBA) to collect policy-level and underwriting data from thousands of tables and summarize it.
  • Optimized macros for Maritime and Hospitality sector calculators, reducing over 20% of their runtime.
  • Assisted in building a data scraper (Python) using PyAutoGui, Mouse & Keyboard modules, and pandas data frames to later compile insurance claims data for further analysis in R and Excel.
  • Queried databases weekly using SQL to pull relevant data, according to the project's specifications.
  • Conducted regression analysis, created linear models, and GLMs using hospitality industry data to improve pricing differentials.
  • Presented the results after conducting a thorough analysis and building a detailed report on the policy-level insurance data of the Hospitality, Business, and Property sectors.

Student Researcher

RoboGenius
Gurgaon, India
06.2019 - 10.2019
  • Research report titled "New Artificially Intelligent Emergency Response System for Emerging Smart Cities"
  • Focused on improving the current Emergency Response System and reviewing features of existing ideas
  • Published report in the International Journal of Research and Analytical Reviews, ID- IJRAR19K6151

Education

Honors Mathematics - Statistics, Financial Analysis & Risk Management -

University of Waterloo
Waterloo, ON
12-2025

Skills

  • Proficient in Python Data Structures
  • Advanced Excel (XLOOKUP, OFFSET, pivot tables, dynamic/compound formulas, data analysis)
  • Advanced SQL Skills
  • Proficient in Automation Scripting/VBA
  • Intermediate Spanish
  • Advanced Skills in Linear Analysis
  • Statistical Analysis Using R
  • Predictive modelling techniques

Timeline

Data Analyst (Co-op)

Reinsurance Management Associates
01.2023 - 08.2023

Actuarial Analyst, Co-op

Gore Mutual Insurance Company
01.2022 - 08.2022

Student Researcher

RoboGenius
06.2019 - 10.2019

Honors Mathematics - Statistics, Financial Analysis & Risk Management -

University of Waterloo

Similar Profiles

CREATE PROFILE
Dhruv Tantia