Mark Gao

Staff Data Architect @ Jobber

About

15+ years expertise of delivering end-to-end Data Engineering, Advanced Analytics and Data Visualization solutions in Big Data, Cloud and traditional Business Intelligence/Data Warehouse environments: - Enterprise Data warehouse, Data Mart, Data Lake design, modeling and implementation using Hadoop, Cloud (AWS, Azure, GCP), Oracle, MS SQL Server, MySQL - Batch and streaming data pipelines, ETL/ELT - Data visualization using Tableau, Power BI, Oracle OBIEE, SAP Business Objects, Cognos - Advanced Analytics: Data Mining, Machine Learning, Artificial Intelligence, Data Science - Possess Enhanced Security Clearance, ITIL, Big Data, Data Science certificates; Agile, PMP, TOGAF, Macroscope in practice

Country

Canada

City

Calgary

Industry

Information Technology & Services

Skill

Data Warehousing, Business Intelligence, ETL, Data Migration, Data Integration, Database Design, Requirements Gathering, Data Modeling, CRM, ITIL, Data Mining, ERP, Analytics, Business Analysis, Consulting, Machine Learning, Project Management, Extract, Transform, Load (ETL), Cloud Computing, Big Data

Experience

Staff Data Architect

Jobber

2018-6 - Present · 8 yrs 4 mos

Edmonton, Canada Area

An exciting opportunity to lead the construction of a new data platform for Data Engineering & Science in AWS and Big Data environment

Sr. Data Architect

Government of Alberta

2017-12 - 2018-6 · 7 mos

A contract project to impact 10+ ministries within GoA

Head of BI & Solutions Architect

Investopedia

2017-3 - 2017-11 · 9 mos

- Built and supported a talented team to maintain and develop a Cloud/Hadoop based Data & Analytics platform - Designed roadmaps, architecture, data pipelines and data lake to gather and integrate web traffic, eCommerce, social media and content data; tuned each component to its best performance; optimized existing architecture, procedures and processes - Identified business stakeholders and converted their data requirements into action plans

BI Solutions Delivery Lead, SME

Alberta Health Services

2012-11 - 2017-4 · 4 yrs 6 mos

Edmonton, Canada Area

Deliver BI solutions for AHS, eAccounts Program

Senior BI Solutions Architect

Wipro

2012-4 - 2012-11 · 8 mos

Edmonton, Canada Area

Provided enterprise BI solutions for clients in Oil & Gas and Utility industries

BI Architect

City of Edmonton

2011-8 - 2012-4 · 9 mos

Edmonton, Canada Area

Delivered BI applications in Transportation (traffic volume, traffic safety) and Taxation. Traffic Data Integration project received the City's "2012 IT Project Award"

Senior Consultant - SAP Conversion

ATB Financial

2010-8 - 2011-8 · 1 yr 1 mo

SAP Data Conversion, SAP CRM, BO DS, LSMW, IDOCs, SAP Core Banking. Contract.

Senior BI Consultant

Fujitsu

2008-12 - 2010-7 · 1 yr 8 mos

Full time employee. Provided end-to-end BI solutions for Fujitsu's clients in public and private sectors

SAP Data Integration Consultant - Contract

Enbridge Gas Distribution

2008-8 - 2008-11 · 4 mos

SAP Data integration. ETL. Implemented a soltion to gather and integrate external bill data into Enbridge's SAP Billing system

Technical Specialist - EDW for Anti-Money Laundering(AML) - Contract

BMO

2008-2 - 2008-8 · 7 mos

Construction of a near-real-time Enterprise Data Warehouse(EDW) for BMO's Anti-Money Laundering(AML) application

Education

Xi'an Jiaotong University

Data Mining and Its Applications to Engineering Diagnosis, Mechanical Engineering

1997 - 2000 · 3 yrs

Researched and applied Machine Learning, Artificial Intelligence and Signal Processing techniques to large volume of sensor data to discover, diagnose and predict machinery conditions