Ken Chan

I am a data analyst with years of experience from oil and gas, engineering, natural resources, manufacturing and construction.  I deal with SQL Server, Microsoft Access and Power BI mostly.  Much of my time was spent on cleaning data, doing ETL, generating reports and developing solutions.

Data Analyst / Database Administrator
Mountain West Services Ltd.
Feb 2018 – Apr 2025

• Designed and maintained databases using SQL Server and MS Access 
• Developed visualizations, reports and dashboards in Power BI and Tableau.
• Clean, analyze and prepare data for KPI reports and external applications.
• Business analyst for external client oil and gas applications
• Consultant for data modeling and integration projects, aligning client business needs with technical solutions for cross-functional teams.
• Provided end-user training and documentation for BI tools and database systems.

Project Scheduler (Contract)
CALC Engineering
Mar 2004 – Jan 2018

• Developed and managed complex project schedules using Microsoft Project and Primavera for EPCM projects in the oil & gas sector.
• Monitored schedules WBS hierarchies and provided detailed schedule/cost control 

Computer Instructor (Part-Time)
Metafore Corporation
Jan 2001 – Dec 2009

• Delivered professional training on Microsoft Office applications to corporate and individual clients, tailoring lessons to user needs.

Project Scheduler
General Dynamics
Jan 1995 – May 1999

• Managed project timelines and financial reporting within the Project & Financial Controls department.
• Supported data quality assurance and reporting initiatives.

Bachelor of Commerce
University of Alberta – 1991

Private Pilot License (PPL)
Sky Wings Aviation Academy – 2014