Sean is available for hire

Sean MacKenzie

Verified Expert in Engineering

Database Developer

Victoria, BC, Canada

Toptal member since June 16, 2020

Expertise

Data Analysis Data Science Data Migration Data Engineering Data Mining Data Visualization ERP Development Microsoft Access Development VBA Excel Development SQL ETL Snowflake Classic ASP SugarCRM Development Visual Basic

Bio

Sean is a data professional with over 25 years of experience. He has designed and architected dozens of end-to-end solutions across a wide range of technologies in mission-critical settings in industries like health, aerospace, finance, logistics, and retail. He has a master's degree in data engineering and a bachelor's in economics and was certified in data analytics at Cornell University. Sean also has a YouTube channel on data engineering techniques with 10,000+ subscribers.

Portfolio

Musi

SQL, Data Modeling, Big Data, Snowflake, Data Architecture, JavaScript...

MacKenzie & MacKenzie Consulting

Python, Python 3, SQL Server 2017, Oracle, R, YouTube, Camtasia, .NET...

Insight Spring

Python 3, BERT, LocalAI, Streamlit, Reflex, Artificial Intelligence (AI)...

Experience

ETL - 20 years
Data Wrangling - 20 years
Data Analysis - 20 years
Data Architecture - 20 years
Data Engineering - 15 years
Azure - 8 years
Python - 6 years
Snowflake - 3 years

Availability

Full-time

Preferred Environment

Windows, Python, ASP.NET, Microsoft SQL Server, Snowflake, Artificial Intelligence (AI)

The most amazing...

...thing I've designed and coded was a province-wide web portal and data warehouse for health agency consumers of 911-related reports and statistics.

Work Experience

Data Engineer

2022 - PRESENT

Musi

Architected a Snowflake warehouse and database to process billions of rows per day for a popular music app on AppStore. Designed fact and dimension tables to support analytics.
Designed and developed Snowflake stored procedures in JavaScript to facilitate data processing.
Designed and deployed operational dashboards in Power BI and Tableau.

Technologies: SQL, Data Modeling, Big Data, Snowflake, Data Architecture, JavaScript, Database Modeling, Data-driven Design, Architecture, Data Migration, Big Data Architecture, Data Strategy, Automation, Excel 365, Complex Data Analysis, Git, Dimensional Modeling, Business Analysis, Dashboards, Data Validation, Security, Data Lakes, SQL Stored Procedures

Consultant

2000 - PRESENT

MacKenzie & MacKenzie Consulting

Created a YouTube channel on technical topics, including promotion, SEO, and other factors.
Created a full SaaS solution called BillZone Systems for project management and consultant billing. The system was used by five companies over ten years.
Oversaw technical projects as developer and design lead for teams of up to ten people for over 20 years.

Technologies: Python, Python 3, SQL Server 2017, Oracle, R, YouTube, Camtasia, .NET, Microsoft Access, Visual Basic for Applications (VBA), ETL, Apache Airflow, Back-end Development, Database Design, SQL, Ubuntu, Data Architecture, Google Analytics, SaaS, Azure, Consulting, Data Modeling, Data Warehouse Design, Data Warehousing, Data Integration, Excel VBA, C#.NET WinForms, C#.NET, Snowflake, ASP.NET Web Forms, ETL Implementation & Design, Data Engineering, Data Analytics, Oracle PL/SQL, T-SQL (Transact-SQL), Windows Server, SQLite, Pandas, Data Analysis, Data Wrangling, Database Modeling, Data-driven Design, Architecture, Data Migration, Azure SQL Databases, Big Data Architecture, Data Strategy, Automation, Complex Data Analysis, SQL Server Reporting Services (SSRS), Git, Dimensional Modeling, OAuth, Business Analysis, Dashboards, Microsoft Fabric, Data Validation, Security, Artificial Intelligence (AI), Data Lakes, Java, Microsoft 365, SQL Stored Procedures, Azure Data Lake

Senior Data Engineer

2024 - 2025

Insight Spring

Developed a firewalled OpenAI environment for sensitive data based on LocalAI to harness GPT-4, LLama, Mistral, and Gemma LLM for aerospace.
Coded RAG integration with four LLM, including chunking, similarity, scoring, and fast lookups via META FAISS.
Created a database implementation for the core product in SQLite and Azure SQL to capture user requests and responses, scoring, and other information.
Deployed low-cost appliance specifications for SME or department-level AI implementations using 16Gb NVIDIA RTX 4060 and 4080 super cards.

Technologies: Python 3, BERT, LocalAI, Streamlit, Reflex, Artificial Intelligence (AI), Artificial Neural Networks (ANN), Eclipse Gemini, Mistral AI, Llama 3, OpenAI GPT-4 API, SQLite, Azure SQL, Torch AI, FAISS, NVIDIA CUDA, Azure Data Factory (ADF), SQL Stored Procedures

Data Engineer

2024 - 2024

Alcanza Clinical Research

Wrote a data pipeline in Python for Clinical Conductor data in SQL Server through Azure to Snowflake.
Converted pipeline data from highly normalized relational data to the FHIR standard in Snowflake.
Implemented HIPAA-compliant security and designed toward privacy.
Created and documented the overall data strategy and implemented it on time and budget.

Technologies: Snowflake, Microsoft SQL Server, Clinical Trials, Python, HL7 FHIR Standard, Data Migration, Azure SQL Databases, Big Data Architecture, Data Strategy, Excel 2016, Visual Basic, Automation, Excel 365, Complex Data Analysis, Git, DAX, Dimensional Modeling, OAuth, Power BI REST APIs, Business Analysis, Dashboards, Microsoft Fabric, Data Validation, Security, Data Lakes, Azure Data Factory (ADF), SQL Stored Procedures, Azure Data Lake

Data Engineer

2023 - 2024

BH Aircraft

Developed an MRP plugin to automate staff manufacturing operations.
Designed a login and encryption regime for passcards.
Designed and programmed an ASP.NET web interface designed for use with tablets and scanners.

Technologies: Misys, Manufacturing Resource Planning (MRP), ASP.NET, Data Migration, Automation, Master Data Management (MDM), Enterprise Resource Planning (ERP), Complex Data Analysis, MDM, Git, Dimensional Modeling, Industrial Automation, Business Analysis, Data Validation, Security, SQL Stored Procedures

Data Engineer

2023 - 2024

David's Cookies

Wrote a web-based manufacturing plugin for the MISys Manufacturing system, allowing bakers to split manufacturing orders into batches.
Reverse-engineered manufacturing processes so that batching could be facilitated.
Wrote a complete application in ASP.NET, led testing, and deployed it on the customer's network.

Technologies: Misys, Manufacturing Resource Planning (MRP), ASP.NET, Visual Basic, Data Migration, Automation, Master Data Management (MDM), Enterprise Resource Planning (ERP), Complex Data Analysis, MDM, SQL Server Reporting Services (SSRS), Microsoft Report Builder, SSRS Reports, Git, Dimensional Modeling, Business Analysis, Data Validation, Security, SQL Stored Procedures

Dashboard Developer

2021 - 2024

Everstell

Architected and coded a relational database system on Azure SQL to support a complex SaaS fintech application, including a data warehouse to support Power BI reporting.
Architected and designed a SaaS web application on Azure using ASP.NET and Visual Basic (.NET) to provide a user platform for processing financial data and integrated reports on Power BI published services.
Led a technology team that included data analysts, programmers, and designers. Guided the team through three successful SaaS customer onboarding experiences.

Technologies: Microsoft Power BI, Microsoft Excel, SQL, Financial Reporting Dashboards, Data Visualization, ASP.NET, Azure SQL, Visual Basic, Python 3, Database Modeling, Data-driven Design, Architecture, JavaScript, Data Migration, Azure SQL Databases, Big Data Architecture, Data Strategy, Automation, Financial Modeling, Finance, Financial Data, Excel 365, Complex Data Analysis, Git, DAX, Dimensional Modeling, OAuth, Power BI REST APIs, Business Analysis, Dashboards, Microsoft Fabric, Google Cloud Platform (GCP), Data Validation, Security, Data Lakes, Azure Data Factory (ADF), SQL Stored Procedures

Senior SQL Developer

2020 - 2021

Insurance Corporation of British Columbia

Performed complex data extracts from IBM Db2 and other databases and warehouses.
Implemented ETL on data for use with new reporting platforms (Tableau).
Conducted a report design investigation in Legacy BusinessObjects designs for SQL and architecture conversion to new reporting systems.

Technologies: SQL Server 2017, Oracle 12c, IBM Db2, Squirrel, SQL, Python, Statistical Modeling, Statistical Analysis, Data Visualization, Database Development, Tableau, Business Intelligence (BI), Data Profiling, Databases, Database Security, ELT, Performance Tuning, Data Mining, Data Management, Microsoft SQL Server, Database Architecture, ETL, Database Design, Data Architecture, Data Modeling, Data Warehousing, Data Warehouse Design, Data Integration, Python 3, ETL Implementation & Design, Data Engineering, Data Analytics, T-SQL (Transact-SQL), Pandas, Data Analysis, Data Wrangling, Database Modeling, Data-driven Design, Architecture, Azure SQL Databases, Big Data Architecture, Data Strategy, Excel 2016, Visual Basic, Automation, Finance, Financial Data, Excel 365, Enterprise Resource Planning (ERP), Change Management, Complex Data Analysis, MDM, SQL Server Reporting Services (SSRS), Microsoft Report Builder, SSRS Reports, Git, DAX, Dimensional Modeling, OAuth, Business Analysis, Dashboards, Data Validation, Security, Data Lakes, Microsoft 365, SQL Stored Procedures

MRP Operations and Analytics Developer

2020 - 2020

Southwest Research Institute

Developed a complex ETL procedure for MRP data in SQL Server.
Wrote complex user interface for MRP assembly tree extraction and browsing in Excel and VBA.
Wrote the purchase order and manufacturing order MRP update procedures directly into Misys via ODBC, using T-SQL.

Technologies: Microsoft Excel, Visual Basic for Applications (VBA), T-SQL (Transact-SQL), SQL Server 2017, Data Visualization, Database Development, Business Intelligence (BI), Data Profiling, Databases, Database Security, Solution Architecture, Software Architecture, Performance Tuning, Data Mining, Data Management, Microsoft SQL Server, Database Architecture, ETL, Database Design, SQL, Data Architecture, Data Modeling, Data Integration, Excel VBA, Data Engineering, Data Analytics, Data Analysis, Data Wrangling, Database Modeling, Data-driven Design, Architecture, Excel 2016, Visual Basic, Automation, Excel 365, Complex Data Analysis, Git, Business Analysis, Dashboards, Data Validation, Security, Data Lakes

Freelance Senior Reporting Developer

2018 - 2020

Emergency Health Services of BC

Integrated, working as an architect of a new data warehouse, large Oracle and SQL Server systems and build data pipelines using ADO.NET with VB.NET.
Designed and built SSRS and web-reporting systems on top of the warehouse for external consumption.
Oversaw production deployment to thousands of users of portal functionality.
Performed training on technical implementations and wrote technical documentation supporting the solution.

Technologies: Python, VB.NET, ASP.NET, Oracle 12c, SQL Server 2014, Statistical Modeling, Statistical Analysis, Forecasting, Data Visualization, Database Development, Business Intelligence (BI), Data Profiling, Databases, Database Security, Solution Architecture, Software Architecture, Enterprise Architecture, ELT, Performance Tuning, Data Mining, Data Management, Microsoft SQL Server, HIPAA Compliance, Database Architecture, ETL, Back-end Development, Data Pipelines, Database Design, SQL, Data Architecture, Data Modeling, Data Warehouse Design, Data Warehousing, Data Integration, ASP.NET Web Forms, ETL Implementation & Design, Data Engineering, Data Analytics, Oracle PL/SQL, T-SQL (Transact-SQL), Windows Server, Data Analysis, Data Wrangling, Healthcare, Database Modeling, Data-driven Design, Architecture, Electronic Medical Records (EMR), Electronic Health Records (EHR), Visual Basic, Automation, Financial Data, Enterprise Resource Planning (ERP), Change Management, Complex Data Analysis, SQL Server Reporting Services (SSRS), Microsoft Report Builder, SSRS Reports, Git, DAX, Dimensional Modeling, OAuth, Business Analysis, Dashboards, Data Validation, Security, Data Lakes, Microsoft 365, SQL Stored Procedures

Freelance Senior Developer Analyst

2002 - 2020

Work Comp. Tech Ltd.

Created and managed changes to a third-party disability management system using SQL Server, .NET, and MS Access.
Designed, coded, and deployed data pipelines and overnight batch programs for data warehousing purposes.
Designed, coded, and deployed complex statistical, forecasting, and operational reporting using SQL Server, MS Access, MS Excel, and VBA.
Advised senior executive on technical direction and strategy.
Integrated other medical environments into a proprietary case management system.

Technologies: VB.NET, Python, Visual Basic for Applications (VBA), Microsoft Access, Microsoft SQL Server, Statistical Analysis, Data Visualization, Database Development, Electronic Health Records (EHR), Business Intelligence (BI), Data Profiling, Databases, Database Security, Solution Architecture, Software Architecture, Enterprise Architecture, ELT, Performance Tuning, Data Mining, Data Management, Database Architecture, ETL, Back-end Development, Data Pipelines, Database Design, SQL, Data Architecture, Data Modeling, Data Warehousing, Data Warehouse Design, Data Integration, Excel VBA, ETL Implementation & Design, Data Engineering, Data Analytics, T-SQL (Transact-SQL), Windows Server, Data Analysis, Data Wrangling, Database Modeling, Data-driven Design, Architecture, Electronic Medical Records (EMR), Data Migration, Excel 2016, Visual Basic, Automation, Financial Modeling, Financial Data, Excel 365, Change Management, Complex Data Analysis, SQL Server Reporting Services (SSRS), Microsoft Report Builder, SSRS Reports, Business Analysis, Dashboards, Data Validation, Security, Microsoft 365, SQL Stored Procedures

Senior Data Analyst

2016 - 2018

Mutual Fire Insurance of BC

Designed, coded, and deployed a data warehouse for P&C insurance systems.
Created, coded, and deployed SSRS reporting for users in a P&C insurance environment.
Architected, coded, and deployed Power BI online interactive reporting for executive management.
Provided technical training for junior and intermediate staff.
Wrote technical systems documentation for warehouse, SSRS, and online Power BI systems.
Developed extensive data pipelines using ADO.NET between PostgreSQL databases and SQL Server systems.

Technologies: ASP.NET, Microsoft Power BI, SQL Server Reporting Services (SSRS), Python, VB.NET, ADO.NET, PostgreSQL, Microsoft SQL Server, Statistical Modeling, Statistical Analysis, Forecasting, Data Visualization, Database Development, Tableau, Business Intelligence (BI), Data Profiling, Databases, Database Security, Solution Architecture, Software Architecture, Enterprise Architecture, APIs, ELT, SQL Server Integration Services (SSIS), Performance Tuning, Data Mining, Data Management, Database Architecture, ETL, Back-end Development, Data Pipelines, Database Design, SQL, Data Architecture, Azure, Data Modeling, Data Warehouse Design, Data Warehousing, Data Integration, Excel VBA, Python 3, ASP.NET Web Forms, ETL Implementation & Design, Data Engineering, Data Analytics, Data Governance, T-SQL (Transact-SQL), Windows Server, Data Analysis, Data Wrangling, Database Modeling, Data-driven Design, Architecture, JavaScript, Data Migration, Big Data Architecture, Data Strategy, Excel 2016, Visual Basic, Automation, Financial Modeling, Finance, Financial Data, Excel 365, Enterprise Resource Planning (ERP), Change Management, Complex Data Analysis, Microsoft Report Builder, SSRS Reports, Git, DAX, Dimensional Modeling, OAuth, Power BI REST APIs, Business Analysis, Dashboards, Data Validation, Security, Artificial Intelligence (AI), Data Lakes, SQL Stored Procedures

Freelance Senior ETL Developer

2015 - 2016

Metrie, Inc.

Led the integration development to migrate dozens of companies onto SAP.
Created loading scripts to load the materials management SAP module with products, processing and setup times, and other data.
Oversaw the loading of production systems using ETL procedures.
Composed project reports on the progress of loading as well as other successful KPIs.

Technologies: Microsoft SQL Server, Microsoft Access, Visual Basic for Applications (VBA), BAPI, SAP, Database Development, Business Intelligence (BI), Data Profiling, Databases, Database Security, APIs, ELT, Data Mining, Data Management, Database Architecture, ETL, Data Pipelines, Database Design, SQL, Data Architecture, Data Modeling, Data Warehousing, Data Warehouse Design, Data Integration, Excel VBA, Data Engineering, Data Analytics, T-SQL (Transact-SQL), Data Analysis, Data Wrangling, Database Modeling, Data-driven Design, Architecture, Excel 2016, Visual Basic, Automation, Financial Data, Excel 365, Master Data Management (MDM), SAP ERP, Enterprise Resource Planning (ERP), Complex Data Analysis, MDM, SAP Master Data Management (MDM), SQL Server Reporting Services (SSRS), Microsoft Report Builder, SSRS Reports, Dimensional Modeling, Industrial Automation, Business Analysis, Dashboards, Data Validation, Security, SQL Stored Procedures

Freelance Oracle Developer

2012 - 2015

Bilsland Griffiths Benefit Administrators

Supported a benefits and pension system hosting various union pensions.
Created benefits and pension system enhancements in Oracle as required.
Migrated a legacy MySQL and PHP system to newer .NET technologies.
Provided technical strategy and leadership advice to senior executives.

Technologies: PHP, MySQL, Oracle Forms, Oracle 11g, Database Development, Data Profiling, Databases, Database Security, Software Architecture, Performance Tuning, Data Mining, Data Management, HIPAA Compliance, Database Architecture, ETL, Back-end Development, Data Pipelines, Database Design, SQL, Data Architecture, Oracle SQL Data Modeler, Data Modeling, Data Warehousing, Data Warehouse Design, Data Integration, ETL Implementation & Design, Data Engineering, Data Analytics, Oracle PL/SQL, Data Governance, Data Analysis, Data Wrangling, Database Modeling, Data-driven Design, Architecture, Data Strategy, Excel 2016, Visual Basic, Automation, Finance, Business Analysis, Data Validation

Freelance Oracle Database Developer

2012 - 2015

Teamster's National Benefit Plan

Provided Oracle support work for pension systems used by TNBP.
Implemented enhancements to the Oracle pension system as required.
Created technical and support documentation for the pension systems.

Technologies: Visual Basic for Applications (VBA), Microsoft Access, Oracle Forms, Oracle 11g, Database Development, Data Profiling, Databases, Database Security, Software Architecture, Performance Tuning, Data Mining, Data Management, HIPAA Compliance, Database Architecture, ETL, Back-end Development, Data Pipelines, Database Design, SQL, Data Architecture, Oracle SQL Data Modeler, Data Modeling, Data Warehousing, Data Warehouse Design, ETL Implementation & Design, Data Engineering, Data Analytics, Oracle PL/SQL, Data Governance, Data Analysis, Data Wrangling, Database Modeling, Data-driven Design, Architecture, Automation, Financial Modeling, Finance, Business Analysis, Data Validation

Freelance Senior Database Developer

2007 - 2013

International Water-Guard Industries, Inc.

Guided and advised on the adoption of ERP and MRP systems for aerospace production manufacturing.
Created and coded several data applications for data management of sales and compliance, among others.
Provided regular user application support for system downtime.
Designed and coded system updates and user reporting as required.

Technologies: Microsoft Excel, Microsoft Access, Visual Basic for Applications (VBA), Microsoft SQL Server, Data Visualization, Database Development, Data Profiling, Databases, Database Security, Software Architecture, Performance Tuning, Data Management, Database Architecture, ETL, Back-end Development, Data Pipelines, Database Design, SQL, Data Architecture, Data Modeling, ETL Implementation & Design, Data Engineering, Data Analytics, T-SQL (Transact-SQL), Data Analysis, Data Wrangling, Database Modeling, Data-driven Design, Architecture, Automation, Master Data Management (MDM), Business Analysis, Data Validation

Freelance Mobile Systems Developer

2008 - 2012

University of British Columbia

Designed, coded, and deployed mobile data collection systems for pediatric research.
Oversaw the deployment of mobile systems for data collection and monitored data pipelines.
Integrated two very different, complex research databases.
Provided technical strategy and guidance to the leadership team.

Technologies: Visual Basic for Applications (VBA), Microsoft Access, VB.NET, SQL CE, Microsoft SQL Server, Windows Mobile, Data Visualization, Database Development, Data Profiling, Databases, Database Security, Software Architecture, APIs, Performance Tuning, Data Management, HIPAA Compliance, Database Architecture, ETL, Back-end Development, Database Design, SQL, Data Architecture, Data Modeling, ETL Implementation & Design, Data Engineering, Data Analytics, Data Analysis, Data Wrangling, Database Modeling, Data-driven Design, Architecture, Electronic Medical Records (EMR), Electronic Health Records (EHR), Automation, Business Analysis, Data Validation

Freelance MRP Reporting Analyst

2008 - 2009

Viking Air

Designed and coded a drill-down tool to let users easily drill down to individual assemblies (e.g., a wing or tail assembly).
Created and coded the metrics for a drill-down tool to allow the oversight of product or lead-time shortfalls.
Drafted technical documentation and advised on how to implement the solution.

Technologies: Visual Basic for Applications (VBA), Microsoft Access, ODBC, Oracle 11g, Statistical Analysis, Data Visualization, Database Development, Business Intelligence (BI), Data Profiling, Databases, Database Security, Solution Architecture, Software Architecture, Data Mining, Data Management, Microsoft SQL Server, Database Architecture, ETL, Back-end Development, Database Design, SQL, Data Architecture, Data Modeling, Data Warehouse Design, Data Warehousing, Data Integration, Excel VBA, ETL Implementation & Design, Data Engineering, Data Analytics, Data Analysis, Data Wrangling, Database Modeling, Data-driven Design, Architecture, Data Migration, Visual Basic, Automation, Master Data Management (MDM), Enterprise Resource Planning (ERP), Complex Data Analysis, MDM, Industrial Automation, Business Analysis, Data Validation

Freelance Senior Technical Analyst

2007 - 2008

Vancouver Coastal Health Authority

Acted as a senior technical analyst on deploying an off-the-shelf bed management and logistics system at four hospitals in the Vancouver area.
Designed, coded, and deployed a plug-in solution to fill a gap in superbug (MRSA, VRE) reporting shortfalls in certain rooms in each hospital.
Composed the project technical documentation and led technical development teams.
Led vendor technical teams in the deployment of their solutions.
Guided the deployment team that was in charge of the hospital transport software deployment component.

Technologies: ODBC, Microsoft Excel, Microsoft Access, Visual Basic for Applications (VBA), Microsoft SQL Server, Forecasting, Data Visualization, Database Development, Business Intelligence (BI), Data Profiling, Databases, Database Security, Performance Tuning, Data Mining, Data Management, HIPAA Compliance, Database Architecture, Database Design, SQL, Data Architecture, Excel VBA, ETL Implementation & Design, Data Engineering, Data Analytics, Data Governance, T-SQL (Transact-SQL), Data Analysis, Data Wrangling, Healthcare, Database Modeling, Data-driven Design, Architecture, Electronic Medical Records (EMR), Electronic Health Records (EHR), Data Migration, Automation, Enterprise Resource Planning (ERP), Change Management, Complex Data Analysis, Business Analysis, Data Validation

Freelance Database Developer

2003 - 2006

Recall (now Iron Mountain)

Integrated six office locations into one system on SQL Server with minimal user disruption, using the same MS Access logistics database.
Provided ETL support and code for migration to PeopleSoft.
Drafted system documentation and provided user technical training.

Technologies: Microsoft Excel, Microsoft Access, Visual Basic for Applications (VBA), Microsoft SQL Server, Data Visualization, Database Development, Business Intelligence (BI), Data Profiling, Databases, Database Security, Solution Architecture, Software Architecture, Enterprise Architecture, Performance Tuning, Data Mining, Data Management, Database Architecture, ETL, Back-end Development, Database Design, SQL, Data Architecture, Data Modeling, Data Warehouse Design, Data Warehousing, ETL Implementation & Design, Data Engineering, Data Analytics, T-SQL (Transact-SQL), Data Analysis, Data Wrangling, Database Modeling, Data-driven Design, Architecture, Automation, Financial Data, Complex Data Analysis, Data Validation

Freelance Reporting Developer

2004 - 2004

Teleflex Canada, Inc. (now Seastar Solutions)

Designed, coded, and deployed a system to evaluate MRP master scheduling and sales histories.
Performed data analytics and forecasting for sales activities.
Drew up the project documentation and provided deployment support.

Technologies: Microsoft Excel, Microsoft Access, Visual Basic for Applications (VBA), Microsoft SQL Server, Statistical Modeling, Statistical Analysis, Forecasting, Data Visualization, Database Development, Databases, Database Security, Performance Tuning, Data Mining, Data Management, Database Architecture, ETL, Back-end Development, Database Design, SQL, Data Architecture, Data Modeling, ETL Implementation & Design, Data Engineering, Data Analytics, T-SQL (Transact-SQL), Data Analysis, Data Wrangling, Database Modeling, Data-driven Design, Automation, Master Data Management (MDM), Enterprise Resource Planning (ERP), Complex Data Analysis, MDM, Industrial Automation, Data Validation

Freelance Database Developer

2003 - 2003

Avcorp Industries, Inc.

Designed, coded, and deployed a database system to validate and rate aerospace suppliers.
Wrote operational and statistical reports for supplier quality initiatives.
Composed systems documentation and performed user training.
Ideated, coded, and deployed systems for data capture around engineering quality assurance.

Technologies: Microsoft Access, Visual Basic for Applications (VBA), Microsoft SQL Server, Data Visualization, Database Development, Databases, Database Security, Data Mining, Data Management, Database Architecture, ETL, Back-end Development, Database Design, SQL, Data Architecture, Data Modeling, Data Analytics, T-SQL (Transact-SQL), Data Analysis, Data Wrangling, Database Modeling, Data-driven Design, Data Migration, Automation, Master Data Management (MDM), Enterprise Resource Planning (ERP), Complex Data Analysis, Industrial Automation, Data Validation

Freelance Business and Technical Analyst

2000 - 2002

Insurance Corporation of BC

Created, coded, and deployed a system to query and display crash data for a new premium system.
Acted as a business and technical analyst on the rollout of a new insurance product.
Wrote business and technical documentation to support various projects.

Technologies: Visual Basic for Applications (VBA), Microsoft Access, Data Visualization, Database Development, Databases, Database Security, Data Management, HIPAA Compliance, Database Design, SQL, Data Architecture, Data Analytics, Data Governance, Data Analysis, Data Wrangling, Database Modeling, Data-driven Design, Automation, SAP, SAP ERP, Enterprise Resource Planning (ERP), Change Management, Complex Data Analysis, SAP Master Data Management (MDM), Data Validation

Operations Coordinator | Developer

1997 - 2002

BC Rail

Designed, coded, and developed five systems to enhance data collection in the passenger services department.
Ideated, coded, and developed an onboard point-of-sale system that utilized replication and ETL procedures for staff to use on long rail trips.
Provided strategy and decision-making support for various projects.

Technologies: Microsoft Excel, Microsoft Access, Visual Basic for Applications (VBA), Microsoft SQL Server, Database Development, Databases, Database Security, Data Mining, Data Management, Database Architecture, Database Design, SQL, Data Architecture, Data Modeling, Data Engineering, Data Analytics, T-SQL (Transact-SQL), Windows Server, Data Analysis, Data Wrangling, Automation, Enterprise Resource Planning (ERP), Complex Data Analysis, Data Validation

Experience

SaaS Project Management System with Time Collection, Invoicing, and PDF Reporting

http://mackenziemackenzie.com/what-is-billzone-systems.html

In this project, I wrote a SaaS project management and reporting system for my customers to use from 2002 to 2018. This project was based on the Microsoft stack, including ASP.NET, ASP Classic, SQL Server, and Microsoft Office components.

Being a full-featured solution, it had invoicing and statistical reporting via PDF to the desktop. It entailed a support module for HR, including vacation and sick day monitoring and pay and raise anniversary tracking. It also had a plug-in system for assisted living and home care for companies needing specialized data collection in those areas. Over its lifetime, it has supported hundreds of users who can access it from all over the world.

Click the link to see my blog page detailing BillZone's history and a pretty funny promo video created for it back in its beginnings!

Health Analytics and Reporting Portal

An ASP.NET web application for over 10,000 users, along with an SQL Server data warehouse engineered with pipelines to Oracle, SQL Server, and other RDBMS systems. The system used SSRS for health-related reports for government users in diverse government departments across British Columbia.

Taking requirements from the business, I designed and coded the entire solution end-to-end, documented it, and mentored internal staff for handoff.

Analytics and Data Warehouse Foundations

In this project, I coded an entire solution end-to-end to design and deploy a data warehouse with online and printable analytics in the insurance industry. This project pulled data from PostgreSQL operational systems in the cloud (AWS) into an SQL Server data warehouse via ETL and .NET data pipelines. ETL and advanced data preparation were also performed in Python.

Analytics was designed and deployed in Power BI for interactive analytics and SSRS for printable and automatically distributed reports (PDF to email). The solution included setting up and configuring the Power BI on-premise gateway to perform periodic updates to cloud datasets.

An on-site web portal to coordinate all of the reports was created in ASP.NET.

Education

2020 - 2022

Master's Degree in Data Engineering

Edinburgh Napier University - Edinburgh, UK

1991 - 1995

Bachelor of Arts Degree in Economics

University of British Columbia - Vancouver, BC, Canada

Certifications

MARCH 2019 - PRESENT

Data Analytics

Cornell University

Skills

Libraries/APIs

ODBC, ActiveX Data Objects (ADO), Pandas, Stanford NLP, Power BI REST APIs, Torch AI

Tools

Microsoft Access, Microsoft Power BI, Microsoft Excel, Excel 2016, Visual Studio, Microsoft Report Builder, Git, SAP Materials Management (MM), SugarCRM, Oracle 11g Forms, Oracle Forms, Squirrel, Tableau, Google Analytics, Camtasia, Apache Airflow, Oracle SQL Data Modeler, C#.NET WinForms, Intelligent Content Processing (ICP)

Languages

Visual Basic for Applications (VBA), Visual Basic .NET (VB.NET), VB.NET, T-SQL (Transact-SQL), SQL, Excel VBA, Visual Basic, Python, Snowflake, Python 3, JavaScript, HTML, PHP, R, Java, C#, C#.NET

Frameworks

ASP.NET Web Forms, ADO.NET, Classic ASP, ASP.NET, .NET, Streamlit, Eclipse Gemini

Paradigms

Database Design, ETL, ETL Implementation & Design, Business Intelligence (BI), Database Development, Data-driven Design, Automation, HIPAA Compliance, Change Management, Dimensional Modeling, DevOps, Agile, HL7 FHIR Standard

Platforms

Azure, Windows Server, Ubuntu, Oracle, Windows, Windows Mobile, Amazon Web Services (AWS), YouTube, Microsoft Fabric, Google Cloud Platform (GCP), NVIDIA CUDA

Storage

Microsoft SQL Server, Database Architecture, Database Security, Databases, Data Pipelines, Data Integration, Database Modeling, Data Validation, SQL Server 2012, SQL Server 2016, SQL Server 2008 R2, SQL Server 2017, SQL Server 2000, PL/SQL, SQL CE, SQLite, PostgreSQL, Oracle PL/SQL, SQL Server Reporting Services (SSRS), Azure SQL, Azure SQL Databases, Master Data Management (MDM), Data Lakes, SQL Stored Procedures, Oracle 11g, Oracle 12c, Oracle9i, SQL Server 2014, MySQL, IBM Db2, SQL Server Integration Services (SSIS), JSON

Industry Expertise

Healthcare

Other

Data Analysis, Data Architecture, Data Modeling, Data Engineering, Reporting, Data Analytics, Data Management, Data Mining, Software Architecture, Data Profiling, Data Visualization, Data Wrangling, Consulting, Architecture, Data Migration, Data Strategy, Excel 365, Enterprise Resource Planning (ERP), Complex Data Analysis, Business Analysis, Microsoft 365, IIS, Data Warehousing, Big Data, Data Governance, SaaS, Performance Tuning, ELT, APIs, Enterprise Architecture, Solution Architecture, Forecasting, Statistical Analysis, Back-end Development, Data Warehouse Design, Electronic Medical Records (EMR), Electronic Health Records (EHR), Artificial Intelligence (AI), Big Data Architecture, Financial Modeling, Finance, Financial Data, SSRS Reports, Industrial Automation, Dashboards, Security, DAX, PeopleSoft, ERPlite, BaaN, SAP, BAPI, Statistical Modeling, Data Science, Economics, Machine Learning, Natural Language Processing (NLP), Neural Networks, Convolutional Neural Networks (CNNs), Computer Vision, Deep Learning, Financial Reporting Dashboards, Generative Pre-trained Transformers (GPT), Clinical Trials, Misys, Manufacturing Resource Planning (MRP), SAP ERP, MDM, SAP Master Data Management (MDM), OAuth, GraphDB, BERT, LocalAI, Reflex, Artificial Neural Networks (ANN), Mistral AI, Llama 3, OpenAI GPT-4 API, FAISS, Azure Data Factory (ADF), Azure Data Lake

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring