Summary
Overview
Work History
Education
Skills
Timeline
Generic

John Chen

Toronto,Canada

Summary

Data Analyst with over 2 years of experience in data analysis, automation, visualization, and ETL processes. Proven ability to drive business growth through data-driven decision-making and effective project management. Strong and positive collaborator with a commitment to continuous learning and accountability.

Overview

3
3
years of professional experience

Work History

Junior Data Analyst

Dion Strategic Consulting Group
Toronto
11.2023 - Current
  • Designed, developed, and maintained ETL (Extract, Transform, Load) processes to extract data from various sources, identified any discrepancies, and loaded it into data databases (Microsoft Fabric) boosting future project bandwidth by 80% efficiency.
  • Automated Power BI Online dashboard for quarterly updates to Fortune 500 client.
  • Collaborated with an internationally known Insurance Broker company to review and edit prior reports before sending them to the client organization partnered with 2400 associations across Canada.
  • Automated SQL queries to transform and import data into Power BI Online with over 200,000 insured data models while managing data integrity, quality, and relationships from different sources using Azure Data Factory enhancing ETL efficiency by 20%.
  • Performed ad hoc analyses in Excel to put on in a final actuarial report to a union with 1 billion in assets internationally.
  • Tested various risk modeling software for internal clients, identifying findings and action items that reduced business costs by 50%.
  • Acquired extensive knowledge of insurance industry and Business Intelligence tools at foundational level.

Geospatial and Data Intern

Canadian Environmental Law Association
09.2022 - 04.2023
  • Acquired extensive knowledge regarding the environmental sector and the effects of PFAS chemicals.
  • Conducted data analysis and published a comprehensive geospatial map detailing PFAS chemical spread on CELA’s official website.
  • Presented term findings and proposed next steps to 12 industry experts with up to 30 years+ of environmental experience.

Education

Bachelor's degree of Science - Applied Statistics

University of Toronto
Mississauga
06-2023

Skills

  • Power BI and SQL proficiency
  • Database management and ETL Processes
  • Automation and analytics
  • Excel proficiency
  • Analytical problem solving
  • Attention to detail
  • Continuous learning
  • Collaborative relationship building
  • Effective communication
  • Accountability and autonomy

Timeline

Junior Data Analyst

Dion Strategic Consulting Group
11.2023 - Current

Geospatial and Data Intern

Canadian Environmental Law Association
09.2022 - 04.2023

Bachelor's degree of Science - Applied Statistics

University of Toronto
John Chen