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.

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 

Metafore Corporation

Jan 2001 – Dec 2009

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

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