[PT/FT] Data Engineer for Snowflake analytics project
2022 - PRESENTMusi Inc- 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, JavaScriptDashboard Developer (Finance Background)
2021 - PRESENTEverstell, LLC- 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 including 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 3Consultant
2000 - PRESENTMacKenzie & 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, T-SQL, Windows Server, SQLite, Pandas, Data Analysis, Data WranglingSenior SQL Developer
2020 - 2021Insurance 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, T-SQL, Pandas, Data Analysis, Data WranglingMRP Operations & Analytics Developer
2020 - 2020Southwest 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, 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 WranglingFreelance Senior Reporting Developer
2018 - 2020Emergency 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, EHR, 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 Warehousing, Data Warehouse Design, Data Integration, ASP.NET Web Forms, ETL Implementation & Design, Data Engineering, Data Analytics, Oracle PL/SQL, T-SQL, Windows Server, Data Analysis, Data WranglingFreelance Senior Developer Analyst
2002 - 2020Work 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, 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, T-SQL, Windows Server, Data Analysis, Data WranglingSenior Data Analyst
2016 - 2018Mutual 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, 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 Warehousing, Data Warehouse Design, Data Integration, Excel VBA, Python 3, ASP.NET Web Forms, ETL Implementation & Design, Data Engineering, Data Analytics, Data Governance, T-SQL, Windows Server, Data Analysis, Data WranglingFreelance Senior ETL Developer
2015 - 2016Metrie, 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 Warehouse Design, Data Warehousing, Data Integration, Excel VBA, Data Engineering, Data Analytics, T-SQL, Data Analysis, Data WranglingFreelance Oracle Developer
2012 - 2015Bilsland 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 WranglingFreelance Oracle Database Developer
2012 - 2015Teamster'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 Warehouse Design, Data Warehousing, ETL Implementation & Design, Data Engineering, Data Analytics, Oracle PL/SQL, Data Governance, Data Analysis, Data WranglingFreelance Senior Database Developer
2007 - 2013International 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, Data Analysis, Data WranglingFreelance Mobile Systems Developer
2008 - 2012University 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 WranglingFreelance MRP Reporting Analyst
2008 - 2009Viking 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 WranglingFreelance Senior Technical Analyst
2007 - 2008Vancouver 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, EHR, 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, Data Analysis, Data WranglingFreelance Database Developer
2003 - 2006Recall (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 Warehousing, Data Warehouse Design, ETL Implementation & Design, Data Engineering, Data Analytics, T-SQL, Data Analysis, Data WranglingFreelance Reporting Developer
2004 - 2004Teleflex 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, Data Analysis, Data WranglingFreelance Database Developer
2003 - 2003Avcorp 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, Data Analysis, Data WranglingFreelance Business and Technical Analyst
2000 - 2002Insurance 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 WranglingOperations Coordinator | Developer
1997 - 2002BC 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, Windows Server, Data Analysis, Data Wrangling