Sean is available for hire
Hire SeanSean MacKenzie
Verified Expert in Engineering
Database Developer
Victoria, BC, Canada
Toptal member since June 16, 2020
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
Beaver Dam Technologies Corporation
Proxmox, Local AI, Hypervisors, WireGuard, ZFS, Virtual Machines, Ubuntu Server...
MacKenzie & MacKenzie Consulting
Python, Python 3, SQL Server 2017, Oracle, R, YouTube, Camtasia, .NET...
Aspen Creek Wealth Strategies
Snowflake, PySpark, Python, Data Build Tool (dbt), APIs, Apache Airflow...
Experience
- Data Wrangling - 20 years
- Data Analysis - 20 years
- Data Architecture - 20 years
- ETL - 20 years
- Data Engineering - 15 years
- Python - 9 years
- Microsoft Power BI - 8 years
- Snowflake - 5 years
Work Experience
Principal
2026 - PRESENT
Beaver Dam Technologies Corporation
- Designed and deployed Proxmox clusters for production use. Deployed Windows Servers, Windows 11, Linux, and other VM.
- Designed and deployed WireGuard virtual routers for use with encapsulated customer environments.
- Designed and launched a front-end and back-end firewalled, locally running LLM for business production use. Set up and configured OpenAI endpoints and consumers.
- Scripted server automation tasks for Linux servers using Bash and Python.
- Set up and configured Proxmox Backup Server for fast incremental VM backups across clusters.
- Designed operational databases and applications using PostgreSQL, Python, and Streamlit.
Technologies: Proxmox, Local AI, Hypervisors, WireGuard, ZFS, Virtual Machines, Ubuntu Server, Open-source LLMs, Prompt Engineering, LibreChat, Python 3, Python, Bash Script, OpenAI, Proxmox Backup Server, Back-end, Data Quality, Startups, Claude, REST APIs, Large Language Models (LLMs), Metadata, Star Schema, Data Cleaning, Workflow Automation, Retrieval-augmented Generation (RAG), MySQL, Deployment, Scripting, Rollback, SugarCRM, Classic ASP, Reporting, Data Science, Datasets, Database Normalization, Microsoft Office, Flask
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 Warehousing, Data Warehouse Design, Data Integration, Excel VBA, C#.NET WinForms, C#.NET, Snowflake, ASP.NET Web Forms, ETL Implementation & Design, Data Engineering, Data Analytics, Oracle PL/SQL, Transact-SQL (T-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, Data Science, HTML, Macros, API Integration, Mobile Apps, Subscriptions, Google Ads API, Single Sign-on (SSO), ETL Development, Azure SQL Data Warehouse, Enterprise, Team Leadership, Front-end, Project Management, Solution Architecture, GIS, Amazon Web Services (AWS), Mapping, Data Extraction, Data Reconciliation, PDF, VB, Complex SQL Queries, Relational Databases, Data, Non-relational Databases, Amazon DynamoDB, Geospatial Data, GitHub, Back-end, Data Quality, Vercel, Data Build Tool (dbt), Power Query, Claude, REST APIs, Large Language Models (LLMs), Microsoft Power BI, Databricks, Medallion Architecture, Delta Lake, Metadata, Data Taxonomy, Geographic Information Systems, Star Schema, Data Cleaning, Data Transformation, Database Schema Design, Query Optimization, Workflow Automation, Node.js, MySQL, Deployment, Scripting, Version Control, SugarCRM, Classic ASP, Reporting, C#, Intelligent Content Processing (ICP), IIS, Applied Statistics, Data Labeling, Datasets, B2B, NoSQL, Database Normalization, Microsoft Office, Zoho, Data Orchestration, Agriculture, Flask, GDPR, Integration, Reverse Engineering, Data Processing
Data Engineer
2026 - 2026
Aspen Creek Wealth Strategies
- Created a financial data warehouse on Snowflake using dbt and other technologies.
- Created Tableau financial visuals using Snowflake data for users to consume.
- Performed ETL/ELT on financial data to create PySpark pipelines to a Snowflake data warehouse.
Technologies: Snowflake, PySpark, Python, Data Build Tool (dbt), APIs, Apache Airflow, Customer Data Platform (CDP), Apache Spark
Data Engineer
2026 - 2026
Searce Inc. - Main
- Created a Azure SQL Server data warehouse to receive and transform data for Power BI consumption.
- Wrote optimized stored procedures for dimension and fact tables. Improved speed for Power BI consumption, allowing the semantic layer to be populated where direct population was not possible before.
- Prepared data for LLM consumption, working with the AI team.
Technologies: Data Engineering, Data Architecture, Claude Code, GitHub, Back-end, Data Quality, GitHub Actions, Power Query, REST APIs, Large Language Models (LLMs), Microsoft Power BI, Databricks, Medallion Architecture, Delta Lake, Metadata, Data Taxonomy, RESTFul APIs, Star Schema, Role-based Access Control (RBAC), Data Cleaning, Data Transformation, Database Schema Design, Query Optimization, DevOps, Deployment, Scripting, Version Control, Rollback, Reporting, Data Labeling, Datasets, NoSQL, Database Normalization, Data Orchestration, Customer Data Platform (CDP)
Full-stack Developer
2025 - 2026
Lancaster Farm Fresh Co-op
- Performed modernization of an existing large cluster of Microsoft Access databases to use SQL Server.
- Connecting existing systems and enabling interop using Python with Flask.
- Designed and tested PySpark ETL and ELT against Databricks for agricultural datasets. Prepare data for Power BI analytics.
Technologies: SQL Server 2022, Microsoft Access, PySpark, Databricks, Flask, Python, Data Build Tool (dbt), Apache Spark
Full-stack Developer
2025 - 2026
Community Living Options
- Developed a full front-end and new features for existing systems.
- Programmed document management and file saving in SQL Server.
- Performed ETL/ELT for existing data into a new format.
Technologies: SQL Server 2022, Microsoft Access, ODBC, Azure SQL, Flask, Python
Consultant
2025 - 2026
Cathedral Square
- Advised on the migration and enhancement of a healthcare-oriented operations system. Provided guidance and mentoring regarding data normalization and best practices.
- Performed troubleshooting of complex VBA procedures.
- Assisted in the creation of complex forms for data entry and SQL reports for data analysis.
Technologies: SQL Server 2022, Microsoft Access, ODBC
Data Engineer - Process Automation
2022 - 2026
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, API Integration, Mobile Apps, Single Sign-on (SSO), ETL Development, Python, Data Warehouse Testing, Enterprise, Solution Architecture, Amazon Web Services (AWS), Data Extraction, Data Reconciliation, Complex SQL Queries, Relational Databases, Data, Non-relational Databases, Geospatial Data, Back-end, Data Quality, Startups, REST APIs, Medallion Architecture, Metadata, GIS, Star Schema, Data Cleaning, Data Transformation, Database Schema Design, Query Optimization, Workflow Automation, DevOps, Deployment, Scripting, Version Control, Rollback, Reporting, Data Labeling, Datasets, NoSQL, Database Normalization, Data Orchestration, Flask, GDPR
Data Engineer
2025 - 2025
Nyrstar Tennessee Mines - Strawberry Plains LLC - Main
- Created a SQL Server warehouse for maintenance data coming from diverse Excel sheets.
- Designed Power Apps workflows for data coming from Excel. Performed troubleshooting of Power Platform flows.
- Created Python data pipelines for data ingestion into a SQL Server data warehouse.
Technologies: Azure, Data Analysis, Azure Data Lake, Microsoft Power BI, ETL, Microsoft Power Platform
Microsoft Excel Expert
2025 - 2025
Valent Biosciences LLC
- Wrote an XML parser in Excel, Access, and VBA for standardized document uploading into government systems.
- Advised and guided the client on data pipelining and storage.
- Used AI to quickly design a process around publicly available scientific upload templates.
Technologies: Microsoft Excel, Macros, Excel VBA, Python, HTML, JavaScript, Claude Code, Back-end, Data Quality, Large Language Models (LLMs), Metadata, Data Taxonomy, GIS, Geographic Information Systems, Audits, Data Cleaning, Data Transformation, Database Schema Design, Workflow Automation, Reporting, Data Science, Data Labeling, Datasets, B2B, NoSQL, Database Normalization, Microsoft Office, Data Orchestration, Agriculture, Research
Senior Data Engineer - AI Integration & Automation
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, Full-stack Development, HTML, API Integration, Subscriptions, Single Sign-on (SSO), ETL Development, Python, Optical Character Recognition (OCR), Data Warehouse Testing, Azure SQL Databases, Azure SQL Data Warehouse, Enterprise, Team Leadership, Front-end, Project Management, Solution Architecture, Amazon Web Services (AWS), Data Extraction, PDF, Complex SQL Queries, Relational Databases, Data, Non-relational Databases, Claude Code, GitHub, Back-end, Data Quality, GitHub Actions, Startups, Claude, REST APIs, Large Language Models (LLMs), Medallion Architecture, Metadata, RESTFul APIs, Role-based Access Control (RBAC), Data Cleaning, Data Transformation, Database Schema Design, Retrieval-augmented Generation (RAG), Node.js, DevOps, Continuous Integration (CI), Deployment, Scripting, Version Control, Reporting, Data Science, Data Labeling, Datasets, B2B, NoSQL, Database Normalization, Data Orchestration, Flask, GDPR
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, API Integration, Single Sign-on (SSO), ETL Development, Data Warehouse Testing, Azure SQL Data Warehouse, Enterprise, Team Leadership, Front-end, Solution Architecture, GIS, Mapping, Data Extraction, Data Reconciliation, Complex SQL Queries, Relational Databases, Data, Non-relational Databases, Back-end, Data Quality, GitHub Actions, Power Query, Claude, Large Language Models (LLMs), Microsoft Power BI, Medallion Architecture, Metadata, RESTFul APIs, Geographic Information Systems, Star Schema, Audits, Data Cleaning, Data Transformation, Database Schema Design, EMR, Google BigQuery, Google Cloud, Looker Studio, Query Optimization, DevOps, Continuous Integration (CI), Deployment, Scripting, Version Control, Rollback, Reporting, Data Labeling, Datasets, Salesforce, NoSQL, Database Normalization, HIPAA, HIPAA Electronic Data Interchange (EDI), Data Orchestration, Flask, Customer Data Platform (CDP), Research
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, Full-stack Development, HTML, API Integration, ETL Development, Data Warehouse Testing, Enterprise, Team Leadership, Front-end, Solution Architecture, Data Reconciliation, VB, Complex SQL Queries, Relational Databases, Data, GitHub, Back-end, Data Quality, REST APIs, Metadata, RESTFul APIs, Star Schema, Data Transformation, Database Schema Design, Workflow Automation, Deployment, Version Control, Rollback, Visual Basic .NET (VB.NET), Visual Studio, Reporting, Data Labeling, Datasets, B2B, Database Normalization, Data Orchestration
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, Full-stack Development, HTML, API Integration, ETL Development, Enterprise, Team Leadership, Front-end, Solution Architecture, Data Reconciliation, VB, Complex SQL Queries, Relational Databases, Data, GitHub, Back-end, Data Quality, REST APIs, Metadata, RESTFul APIs, Data Transformation, Database Schema Design, Query Optimization, Workflow Automation, Continuous Integration (CI), Deployment, Scripting, Version Control, Rollback, Visual Basic .NET (VB.NET), Visual Studio, Reporting, C#, Data Labeling, Datasets, B2B, Database Normalization, Data Orchestration
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, Full-stack Development, HTML, Macros, API Integration, Single Sign-on (SSO), ETL Development, Python, Data Warehouse Testing, Azure SQL Data Warehouse, Team Leadership, Front-end, Solution Architecture, Financial Planning & Analysis (FP&A), Data Extraction, Data Reconciliation, VB, Complex SQL Queries, Relational Databases, Data, Back-end, Data Quality, REST APIs, Metadata, Role-based Access Control (RBAC), Data Cleaning, Data Transformation, Database Schema Design, Google Cloud, Query Optimization, Workflow Automation, DevOps, Deployment, Scripting, Version Control, Visual Basic .NET (VB.NET), Visual Studio, Reporting, C#, IIS, Data Science, Data Labeling, Datasets, NetSuite, B2B, Database Normalization, Data Orchestration
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 Warehouse Design, Data Warehousing, Data Integration, Python 3, ETL Implementation & Design, Data Engineering, Data Analytics, Transact-SQL (T-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, Macros, ETL Development, Data Warehouse Testing, Azure SQL Data Warehouse, Enterprise, Solution Architecture, Mapping, Data Extraction, Data Reconciliation, PDF, VB, Complex SQL Queries, Relational Databases, Data, Geospatial Data, Back-end, Data Quality, Power Query, Microsoft Power BI, Medallion Architecture, Metadata, GIS, Geographic Information Systems, Star Schema, Role-based Access Control (RBAC), Audits, Data Cleaning, Data Transformation, Database Schema Design, Query Optimization, MySQL, Scripting, Visual Studio, SQL Server 2016, Oracle 11g Forms, Reporting, Applied Statistics, Insurance, Data Labeling, Datasets, NetSuite, B2B, Database Normalization, Microsoft Office, Data Orchestration
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), Transact-SQL (T-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, Macros, ETL Development, Data Extraction, Data Reconciliation, VB, Complex SQL Queries, Relational Databases, Data, Back-end, Data Quality, Metadata, Data Cleaning, Data Transformation, Workflow Automation, Scripting, Visual Studio, SQL Server 2016, Reporting, Data Labeling, Datasets, B2B, Database Normalization, Microsoft Office, Research
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, Transact-SQL (T-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, Full-stack Development, HTML, Macros, Mobile Apps, ETL Development, Data Warehouse Testing, Enterprise, Team Leadership, Front-end, Project Management, Mapping, Data Extraction, Data Reconciliation, VB, Complex SQL Queries, Relational Databases, Data, Geospatial Data, GitHub, Back-end, Data Quality, Power Query, REST APIs, Microsoft Power BI, Medallion Architecture, Metadata, RESTFul APIs, GIS, Geographic Information Systems, HL7 FHIR Standard, Data Cleaning, Data Transformation, Database Schema Design, EMR, Query Optimization, Workflow Automation, Deployment, Scripting, Version Control, Rollback, Visual Basic .NET (VB.NET), Visual Studio, SQL Server 2016, Reporting, ActiveX Data Objects (ADO), IIS, Data Labeling, Datasets, Database Normalization, HIPAA, HIPAA Electronic Data Interchange (EDI), Data Orchestration, Time Series
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 Warehouse Design, Data Warehousing, Data Integration, Excel VBA, ETL Implementation & Design, Data Engineering, Data Analytics, Transact-SQL (T-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, Full-stack Development, HTML, Macros, API Integration, Mobile Apps, ETL Development, Data Warehouse Testing, Enterprise, Team Leadership, Front-end, Project Management, Financial Planning & Analysis (FP&A), Data Extraction, Data Reconciliation, VB, Complex SQL Queries, Relational Databases, Data, Back-end, Data Quality, Startups, Power Query, Metadata, Financial Reporting Dashboards, Audits, Data Cleaning, Data Transformation, Database Schema Design, EMR, Query Optimization, Workflow Automation, Deployment, Scripting, Rollback, Visual Basic .NET (VB.NET), SQL Server 2012, Visual Studio, SQL Server 2008 R2, SQL Server 2016, Reporting, C#, Intelligent Content Processing (ICP), ActiveX Data Objects (ADO), IIS, Data Labeling, Datasets, B2B, NoSQL, Database Normalization, Microsoft Office, Data Orchestration
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, Transact-SQL (T-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, Full-stack Development, HTML, Macros, API Integration, Single Sign-on (SSO), ETL Development, Data Warehouse Testing, Enterprise, Team Leadership, Front-end, Project Management, GIS, Amazon Web Services (AWS), Mapping, Financial Planning & Analysis (FP&A), Data Extraction, Data Reconciliation, PDF, VB, Complex SQL Queries, Relational Databases, Data, Non-relational Databases, Geospatial Data, Back-end, Data Quality, Power Query, Metadata, Data Taxonomy, RESTFul APIs, ArcGIS, Star Schema, Financial Reporting Dashboards, Data Cleaning, Data Transformation, Database Schema Design, Query Optimization, Workflow Automation, Deployment, Scripting, Visual Basic .NET (VB.NET), SQL Server 2012, Visual Studio, SQL Server 2016, Reporting, C#, IIS, Applied Statistics, Insurance, Data Science, Data Labeling, Datasets, Database Normalization, Microsoft Office, Data Orchestration, Simulations, Time Series
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, Transact-SQL (T-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, Macros, Single Sign-on (SSO), ETL Development, Data Warehouse Testing, Enterprise, Amazon Web Services (AWS), Mapping, Data Reconciliation, VB, Complex SQL Queries, Relational Databases, Data, Back-end, Data Quality, Metadata, Data Cleaning, Data Transformation, Database Schema Design, Query Optimization, Scripting, SQL Server 2012, Visual Studio, SQL Server 2008 R2, SAP Materials Management (MM), Reporting, ActiveX Data Objects (ADO), PeopleSoft, Data Labeling, Datasets, B2B, Database Normalization, Microsoft Office
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 Warehouse Design, Data Warehousing, 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, Full-stack Development, ETL Development, Enterprise, Data Reconciliation, VB, Complex SQL Queries, Relational Databases, Data, Back-end, Data Quality, Data Cleaning, Data Transformation, Scripting, SQL Server 2012, Visual Studio, SQL Server 2008 R2, Oracle 11g Forms, Reporting, Oracle9i, Data Labeling, Datasets, NetSuite, B2B, Database Normalization
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, Full-stack Development, ETL Development, Enterprise, Data Reconciliation, VB, Complex SQL Queries, Relational Databases, Data, Back-end, Data Quality, Data Cleaning, Data Transformation, Scripting, SQL Server 2012, Visual Studio, SQL Server 2008 R2, Oracle 11g Forms, Reporting, Oracle9i, Data Labeling, Datasets, NetSuite, B2B, Database Normalization
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, Transact-SQL (T-SQL), Data Analysis, Data Wrangling, Database Modeling, Data-driven Design, Architecture, Automation, Master Data Management (MDM), Business Analysis, Data Validation, Full-stack Development, ETL Development, Enterprise, Data Reconciliation, VB, Complex SQL Queries, Relational Databases, Data, Back-end, Data Quality, Data Cleaning, Data Transformation, Workflow Automation, Scripting, SQL Server 2012, Visual Studio, SQL Server 2008 R2, Classic ASP, Reporting, ActiveX Data Objects (ADO), ERPlite, IIS, Data Labeling, Datasets, B2B, Database Normalization, Microsoft Office
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, Full-stack Development, Mobile Apps, ETL Development, Data Reconciliation, VB, Complex SQL Queries, Relational Databases, Data, Back-end, Data Quality, Data Cleaning, Data Transformation, EMR, Deployment, Scripting, Visual Basic .NET (VB.NET), Visual Studio, SQL Server 2008 R2, Reporting, Intelligent Content Processing (ICP), IIS, Data Labeling, Datasets, Database Normalization, Research
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 Warehousing, Data Warehouse Design, 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, HTML, Macros, ETL Development, Data Reconciliation, VB, Complex SQL Queries, Relational Databases, Data, Back-end, Data Quality, Star Schema, Data Cleaning, Data Transformation, Database Schema Design, Scripting, SQL Server 2008 R2, Reporting, ActiveX Data Objects (ADO), Applied Statistics, Data Labeling, Datasets, B2B, Database Normalization, Microsoft Office, Data Orchestration
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, Transact-SQL (T-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, Macros, ETL Development, Enterprise, Team Leadership, Front-end, Project Management, Data Extraction, Data Reconciliation, PDF, VB, Complex SQL Queries, Relational Databases, Data, Back-end, Data Quality, Audits, Data Cleaning, Data Transformation, EMR, Workflow Automation, Scripting, SQL Server 2008 R2, Reporting, ActiveX Data Objects (ADO), IIS, Applied Statistics, Data Labeling, Datasets, Database Normalization, HIPAA, HIPAA Electronic Data Interchange (EDI), Microsoft Office, Data Orchestration
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, Transact-SQL (T-SQL), Data Analysis, Data Wrangling, Database Modeling, Data-driven Design, Architecture, Automation, Financial Data, Complex Data Analysis, Data Validation, Full-stack Development, Macros, ETL Development, Enterprise, Team Leadership, Front-end, Mapping, Data Extraction, Data Reconciliation, VB, Complex SQL Queries, Relational Databases, Data, Back-end, Data Quality, Data Cleaning, Data Transformation, Workflow Automation, Deployment, Scripting, SQL Server 2000, SQL Server 2008 R2, Reporting, ActiveX Data Objects (ADO), PeopleSoft, Data Labeling, Datasets, B2B, Database Normalization, Microsoft Office, Data Orchestration, Customer Data Platform (CDP)
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, Transact-SQL (T-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, Macros, ETL Development, Enterprise, Front-end, Data Reconciliation, VB, Complex SQL Queries, Relational Databases, Data, Back-end, Data Quality, Data Cleaning, Data Transformation, Database Schema Design, Scripting, SQL Server 2000, Reporting, ActiveX Data Objects (ADO), Data Labeling, Datasets, B2B, Database Normalization, Microsoft Office, Simulations, Time Series, Simulation Modeling
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, Transact-SQL (T-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, Macros, ETL Development, Enterprise, Front-end, Data Reconciliation, VB, Complex SQL Queries, Relational Databases, Data, Back-end, Data Cleaning, Data Transformation, Scripting, SQL Server 2000, Classic ASP, Reporting, ActiveX Data Objects (ADO), BaaN, Data Labeling, Datasets, B2B, Database Normalization, Microsoft Office
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, Macros, Enterprise, Data Reconciliation, VB, Complex SQL Queries, Relational Databases, Data, Back-end, Financial Reporting Dashboards, Data Cleaning, SQL Server 2000, Reporting, ActiveX Data Objects (ADO), Data Labeling, Datasets
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, Transact-SQL (T-SQL), Windows Server, Data Analysis, Data Wrangling, Automation, Enterprise Resource Planning (ERP), Complex Data Analysis, Data Validation, Macros, ETL Development, Enterprise, Front-end, Data Reconciliation, VB, Relational Databases, Data, Back-end, Data Cleaning, Database Schema Design, Deployment, Scripting, SQL Server 2000, Classic ASP, Reporting, ActiveX Data Objects (ADO), Data Labeling, Datasets, Database Normalization, Microsoft Office
Project History
Enterprise Profitability and Cost Intelligence Platform (FinTech)
I led the architecture and development of a multi-year fintech platform that delivers full-cost accounting and profitability intelligence to enterprise clients. Working closely with domain experts, I designed a scalable data ingestion and transformation pipeline that converted diverse monthly client datasets into a purpose-built Azure SQL data warehouse. The platform standardized complex financial and operational data across organizations, enabling consistent, high-fidelity analysis of cost structures, revenue streams, and profitability drivers.
On top of this foundation, I built an integrated analytics layer using Power BI, delivering a suite of advanced dashboards and KPI frameworks that provided deep, actionable insight into business performance. The solution incorporated master data management, role-based access control (RBAC), and a hybrid technology stack including Python, .NET, SQL Server, Azure SQL, and Power Query. The result was a production-grade system with over a dozen specialized reports, empowering stakeholders to move from fragmented reporting to a unified, data-driven profitability model—aligned with the broader trend of data-driven decision systems transforming modern fintech platforms.
On top of this foundation, I built an integrated analytics layer using Power BI, delivering a suite of advanced dashboards and KPI frameworks that provided deep, actionable insight into business performance. The solution incorporated master data management, role-based access control (RBAC), and a hybrid technology stack including Python, .NET, SQL Server, Azure SQL, and Power Query. The result was a production-grade system with over a dozen specialized reports, empowering stakeholders to move from fragmented reporting to a unified, data-driven profitability model—aligned with the broader trend of data-driven decision systems transforming modern fintech platforms.
Hyperscale Music Analytics and Data Platform (Snowflake | iOS App)
https://feelthemusi.comI architected and delivered a hyperscale data platform for Musi, supporting analytics and in-app features for a high-traffic iOS music streaming application. I designed a Snowflake-based data warehouse capable of ingesting and processing tens of billions of records per day via Snowpipe pipelines integrated with AWS storage. Robust ingestion, transformation, and orchestration layers were built using SQL and JavaScript stored procedures, along with Python integrations, to ensure reliable, near-real-time data availability across both analytics and operational use cases.
The platform powered a wide range of business intelligence and product features, including Top 100 rankings, user favorites, and behavioral insights, delivered through Power BI and Tableau dashboards as well as embedded application pipelines. A key focus was optimizing performance and cost at extreme scale—tuning ingestion throughput, managing data in transit, and refining warehouse scheduling and maintenance processes within Snowflake. The result was a highly efficient, production-grade system that enabled data-driven product innovation while maintaining stability under massive, continuously streaming workloads.
The platform powered a wide range of business intelligence and product features, including Top 100 rankings, user favorites, and behavioral insights, delivered through Power BI and Tableau dashboards as well as embedded application pipelines. A key focus was optimizing performance and cost at extreme scale—tuning ingestion throughput, managing data in transit, and refining warehouse scheduling and maintenance processes within Snowflake. The result was a highly efficient, production-grade system that enabled data-driven product innovation while maintaining stability under massive, continuously streaming workloads.
AI Knowledge Platform and Hybrid RAG System (LLM and Vector Search)
https://insightspring.aiI architected and built an advanced AI knowledge platform for InsightSpring.ai, focused on delivering high-quality retrieval-augmented generation (RAG) across both local and external large language models. I also designed and implemented a custom data warehouse and preprocessing pipelines. A key innovation was the development of a hybrid search framework that combined FAISS-based vector similarity with deterministic SQL-driven keyword matching to significantly improve precision, recall, and explainability in enterprise search scenarios.
The platform was integrated with a wide ecosystem of models, including GPT, Gemini, Gemma, Claude, and Mistral, enabling flexible deployment across cloud and self-hosted environments via LocalAI. I built end-to-end orchestration covering ingestion, embedding generation, prompt engineering, and user interaction layers using Python, Streamlit, Reflex, PyTorch, and CUDA acceleration. The result was a production-grade AI system capable of delivering context-aware insights across multiple use cases, from internal knowledge retrieval to client-facing AI applications, with a strong emphasis on performance tuning, modularity, and data governance.
The platform was integrated with a wide ecosystem of models, including GPT, Gemini, Gemma, Claude, and Mistral, enabling flexible deployment across cloud and self-hosted environments via LocalAI. I built end-to-end orchestration covering ingestion, embedding generation, prompt engineering, and user interaction layers using Python, Streamlit, Reflex, PyTorch, and CUDA acceleration. The result was a production-grade AI system capable of delivering context-aware insights across multiple use cases, from internal knowledge retrieval to client-facing AI applications, with a strong emphasis on performance tuning, modularity, and data governance.
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.
Taking requirements from the business, I designed and coded the entire solution end-to-end, documented it, and mentored internal staff for handoff.
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, Complex SQL Queries, ActiveX Data Objects (ADO), REST APIs, Pandas, Stanford NLP, Power BI REST APIs, Torch AI, Google Ads API, Snowpark, ArcGIS, Node.js, PySpark
Tools
Microsoft Access, Microsoft Power BI, Microsoft Excel, Excel 2016, Visual Studio, Microsoft Report Builder, Git, GIS, Claude Code, GitHub, Power Query, Claude, 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), WireGuard, Stimulus Reflex
Languages
Visual Basic for Applications (VBA), Visual Basic .NET (VB.NET), VB.NET, Python, Transact-SQL (T-SQL), HTML, SQL, Snowflake, Excel VBA, Visual Basic, VB, Python 3, C#, JavaScript, PHP, R, Java, C#.NET, Bash Script
Frameworks
ASP.NET Web Forms, ADO.NET, Classic ASP, ASP.NET, .NET, Streamlit, Eclipse Gemini, Flask, Apache Spark
Paradigms
Database Design, ETL, ETL Implementation & Design, Business Intelligence (BI), Database Development, Data-driven Design, Automation, B2B, HIPAA Compliance, DevOps, HL7 FHIR Standard, Change Management, Dimensional Modeling, Agile, Role-based Access Control (RBAC), Continuous Integration (CI)
Platforms
Azure, Azure SQL Data Warehouse, Windows Server, Amazon Web Services (AWS), Microsoft Fabric, Ubuntu, Oracle, Windows, Windows Mobile, YouTube, Google Cloud Platform (GCP), NVIDIA CUDA, Proxmox, Vercel, Databricks, Salesforce, Microsoft Power Platform
Storage
Microsoft SQL Server, Database Architecture, Database Security, Databases, Data Pipelines, Data Integration, Database Modeling, Azure SQL Databases, Data Validation, Relational Databases, SQL Server 2012, SQL Server 2016, SQL Server 2008 R2, SQL Server 2017, SQL Server 2000, PL/SQL, SQL CE, SQLite, PostgreSQL, MySQL, Oracle PL/SQL, SQL Server Reporting Services (SSRS), Azure SQL, Master Data Management (MDM), Data Lakes, SQL Stored Procedures, Google Cloud, NoSQL, Oracle 11g, Oracle 12c, Oracle9i, SQL Server 2014, IBM Db2, SQL Server Integration Services (SSIS), JSON, Amazon DynamoDB, SQL Server 2022
Industry Expertise
Healthcare, Applied Statistics, Insurance, Project Management
Other
Data Analysis, Data Architecture, Data Modeling, Data Engineering, Reporting, Data Analytics, Data Management, Data Mining, Software Architecture, Solution 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, Macros, ETL Development, Enterprise, Front-end, Data Extraction, Data Reconciliation, Data, Back-end, Data Quality, Metadata, Data Cleaning, Data Transformation, Database Schema Design, Query Optimization, Workflow Automation, Deployment, Scripting, Data Labeling, Datasets, Database Normalization, Microsoft Office, Integration, Data Processing, IIS, Data Warehousing, Big Data, Data Governance, SaaS, Performance Tuning, ELT, APIs, Enterprise Architecture, Forecasting, Statistical Analysis, Data Science, Back-end Development, Data Warehouse Design, Financial Reporting Dashboards, 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, Azure Data Factory (ADF), Full-stack Development, API Integration, Mobile Apps, Single Sign-on (SSO), Optical Character Recognition (OCR), Data Warehouse Testing, Team Leadership, Mapping, PDF, Non-relational Databases, Geospatial Data, Startups, Large Language Models (LLMs), Medallion Architecture, Data Taxonomy, RESTFul APIs, Star Schema, Audits, EMR, Retrieval-augmented Generation (RAG), Version Control, HIPAA, Data Orchestration, Customer Data Platform (CDP), GDPR, Reverse Engineering, Research, DAX, PeopleSoft, ERPlite, BaaN, SAP, BAPI, Statistical Modeling, Economics, Machine Learning, Natural Language Processing (NLP), Neural Networks, Convolutional Neural Networks (CNNs), Computer Vision, Deep Learning, 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 Lake, Subscriptions, Financial Planning & Analysis (FP&A), Local AI, Hypervisors, ZFS, Virtual Machines, Ubuntu Server, Open-source LLMs, Prompt Engineering, LibreChat, OpenAI, Proxmox Backup Server, GitHub Actions, Data Build Tool (dbt), Snowpipe, Vector Databases, Delta Lake, Geographic Information Systems, Google BigQuery, Looker Studio, Rollback, NetSuite, HIPAA Electronic Data Interchange (EDI), Zoho, Simulation Orchestration, Simulations, Time Series, Agriculture, Simulation Engines, Simulation Modeling
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.
1
Share your needs
Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2
Choose your talent
Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3
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