Sean MacKenzie, Senior Database Developer in Chilliwack, BC, Canada
Sean MacKenzie

Senior Database Developer in Chilliwack, BC, Canada

Member since May 14, 2020
Sean MacKenzie is a certified and university-educated data analytics consultant with 20 years of experience in most aspects of data and its usage in small and large organizations. This includes extensive experience in data engineering, data application development, data modeling & architecture, analytics, and data science methods. Sean also has experience in the manufacturing, aerospace, health, transportation, insurance, finance, logistics, and retail industries.
Sean is now available for hire

Portfolio

Experience

Location

Chilliwack, BC, Canada

Availability

Full-time

Preferred Environment

SQL Server, Oracle, ASP.NET, VB.NET, Python, Windows

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.

Employment

  • Freelance Senior Reporting Developer

    2018 - 2020
    Emergency Health Services of BC
    • Worked as an architect of a new data warehouse to integrate large Oracle and SQL Server systems along with building 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: SQL Server 2014, Oracle 12c, ASP.NET, VB.NET, Python
  • 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: SQL Server, MS Access, VBA, Python, VB.NET
  • Senior Data Analyst

    2016 - 2018
    Mutual Fire Insurance of BC
    • Designed, coded, and deployed a data warehouse for P&C insurance systems.
    • Designed, coded, and deployed SSRS reporting for users in a P&C insurance environment.
    • Designed, 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: SQL Server, PostgreSQL, ADO.NET, VB.NET, Python, SSRS, Power BI, ASP.NET
  • 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 & 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: SAP BAPI, VBA, MS Access, SQL Server
  • Freelance Oracle Developer

    2012 - 2015
    Bilsland Griffiths Benefit Administrators
    • Performed support for a benefits and pension system hosting various union pensions.
    • Created benefits and pension system enhancements in Oracle as required.
    • Assisted in the migration of a legacy MySQL/PHP system to newer .NET technologies.
    • Provided technical strategy and leadership advice to senior executives.
    Technologies: Oracle 11g, Oracle Forms 9i, MySQL, PHP
  • 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: Oracle 11g, Oracle Forms 9i, MS Access, VBA
  • Freelance Senior Database Developer

    2007 - 2013
    International Water-Guard Industries, Inc.
    • Provided guidance and advice on the adoption of ERP and MRP systems for aerospace production manufacturing.
    • Designed and coded several data applications for data management of things like sales and compliance.
    • Provided regular user application support for system downtime.
    • Designed and coded system updates and user reporting as required.
    Technologies: SQL Server, VBA, MS Access, MS Excel
  • 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: Windows Mobile, SQL Server, SQLCE, VB.NET, MS Access, VBA
  • 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).
    • Designed and coded the metrics for a drill-down tool to allow the oversight of things like product or lead-time shortfalls.
    • Provided technical documentation and advice on how to implement the solution.
    Technologies: Oracle 11g, ODBC, MS Access, VBA
  • Freelance Senior Technical Analyst

    2007 - 2008
    Vancouver Coastal Health Authority
    • Acted as a senior technical analyst on the deployment of an off-the-shelf bed management and logistics system at four hospitals in 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.
    • Led the deployment team that was in charge of hospital transport software deployment component.
    Technologies: SQL Server, VBA, MS Access, MS Excel, ODBC
  • Freelance Database Developer

    2003 - 2006
    Recall
    • Integrated six office locations using the same MS Access logistics database into one system on SQL Server with minimal user disruption.
    • Provided ETL support and code for migration to PeopleSoft.
    • Provided user technical training and system documentation.
    Technologies: SQL Server, VBA, MS Access, MS Excel
  • Freelance Reporting Developer

    2004 - 2004
    Teleflex Canada, Inc.
    • Designed, coded, and deployed a system to evaluate MRP master scheduling and sales histories.
    • Performed data analytics and forecasting for sales activities.
    • Created project documentation and provided deployment support.
    Technologies: SQL Server, VBA, MS Access, MS Excel
  • 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.
    • Designed, coded, and deployed systems for data capture around engineering quality assurance.
    Technologies: SQL Server, VBA, MS Access
  • Freelance Business and Technical Analyst

    2000 - 2002
    Insurance Corporation of BC
    • Designed, 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 roll-out of a new insurance product.
    • Wrote business and technical documentation to support various projects.
    Technologies: MS Access, VBA
  • Operations Coordinator | Developer

    1997 - 2002
    BC Rail
    • Designed, coded, and developed five systems to enhance data collection in the passenger services department.
    • Designed, coded, and developed an onboard point-of-sale system for staff to use on long rail trips. The system utilized replication and ETL procedures.
    • Provided strategy and decision-making support for various projects.
    Technologies: SQL Server, VBA, MS Access, MS Excel

Experience

  • SaaS Project Management System with Time Collection, Invoicing, and PDF Reporting (Development)
    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 components from ASP.NET, ASP Classic, SQL Server, and Microsoft Office.
    Being a full-featured solution, it had invoicing and statistical reporting via PDF to the desktop, and included a support module for HR, including vacation and sick day monitoring, pay and raise anniversary tracking. It also had a plug-in system for assisted living and homecare, for companies needing specialized data collection in those areas. Over its lifetime, it supported hundreds of users, accessing it from all over the world.
    Click the link to see my blog page detailing BillZone's history, and a pretty funny promo video that was created for it back in its beginnings!

Skills

  • Languages

    Visual Basic for Applications (VBA), Visual Basic .NET (VB.NET), T-SQL, SQL, VBScript, Python, HTML
  • Frameworks

    ASP.NET Web Forms, ADO.NET, Classic ASP
  • Libraries/APIs

    ODBC, Pandas
  • Tools

    Microsoft Access, Microsoft Excel, Microsoft Power BI, Visual Studio, SSRS, SAP MM, SugarCRM, Oracle 11g Forms
  • Paradigms

    Database Design, ETL, ETL Implementation & Design
  • Other

    VB.NET, Data Analysis, Data Architecture, Data Modeling, ActiveX Data Objects, IIS, Data Warehousing, DAX, SAP BAPI, PeopleSoft, ERPlite, BaaN IV
  • Platforms

    Windows Server, Ubuntu
  • Storage

    SQL Server 2012, SQL Server 2016, SQL Server 2008 R2, SQL Server 2017, SQL Server 2000, PL/SQL, SQL CE, SQLite, PostgreSQL, Oracle 11g, Oracle 12c, Oracle 9i

Education

  • Bachelor of Arts degree in Economics
    1991 - 1995
    University of British Columbia - Vancouver, BC, Canada

Certifications

  • Data Analytics
    MARCH 2019 - PRESENT
    Cornell University

To view more profiles

Join Toptal
Share it with others