Led the transformation to a data-driven organization by evolving Business Intelligence and Enterprise Data vision and strategy.• Instrumental in building and leading the analytics team consisting of data analysts, scientists and engineers. • Led the selection and implementation of a cloud-based data lake, warehouse (BigQuery), ETL processes, and business intelligence platforms (Tableau & DundasBI).• Partnered with business unit leaders across Canada to establish a continuous requirements gathering process identifying data sources and data stewards.• Strategized and documented organizational data lineage, master-data-management and data governance concepts.• Managed incoming requests, the analytics roadmap, and relationships with business intelligence and cloud vendors.

A dual role leading a specialized software support team and database admin team.• Support team - Reduced outstanding tickets by as much as 90% by thoroughly assessing a multi-team workflow and toolsets (Jira & Service Now) and subsequently improving visibility of critical tickets and communication.• Support team – Lead the integration of support systems Jira and Service Now, significantly increasing workflow efficiency and multi-team communication.• Data - Planned and deployed an AWS data lake (S3,) Redshift warehouse, ETL processes (DMS/Glue), and administration of Tableau.• Data - At times, achieving a 99% reduction in query execution time by examining slow query logs and rewriting SQL previously written by software developers.

• Interfaced with business analysts interpreting software development requirements and producing related ERD’s (Powerdesigner) and DDL.• Planned, implemented and administered multiple highly available database clusters. On-prem and cloud-based MySQL and MS SQL servers.• Continually monitored and improved database performance via tuning, indexing and query optimization.

• Implemented and managed a Redhat MySQL high availability solution for the company’s premier software project management system.• Managed multiple MySQL and MS SQL Server instances.• Planned and implemented a disaster recovery plan which included full/incremental backup and multi-region replication solutions.• Implemented and administered database monitoring toolsets.

• Coordinated teams of back and front end developers.• Full stack development using PHP/DOM/JavaScript/JQuery/HTML/CSS.• Designed data models and produced/executed DDL of database tables, stored procedures, triggers and indexes. • Managed MySQL databases and implemented backup and replication processes.