Morgan Savard Email & Phone Number

Kitchener, On, Ca

Toronto, Ontario, Canada

Refactored ETL Dag in preparation to connect to multiple application QA environments.Used Airflow (Python) and RESTful api to create pipeline to import data from call center platform into Redshift.Leveraged data stack to automate Speed to Lead reporting by moving Python (pandas) report into warehouse using SQL & dbt.Reviewed call center processes and provided recommendations on how to improve KPIs to stakeholders.Conduct code review for pull requests from team members.Debugging data warehouse (dbt).

Toronto, Ontario, Canada

Used dbt & SQL to model data in warehouse to be used for reporting.Created dashboards in Looker to report on key metrics for internal and external stakeholders.Created pipeline using Apache Airflow to import data from Google Sheets into Redshift.Used LookML to expose & model data from warehouse into visualization tool.Created Speed to Lead reporting using Python (pandas) by combing data from multiple sources.Used Google Apps Script to automate the creation of new pricing models in Google Sheets.

Kitchener, Ontario, Canada

Production management, including prioritization across shifts of team members & queues to ensure turnaround times are met.Escalation point for stakeholders (team members, customer support, sales).Oversee Data Services training program, including associated documentation.

Kitchener, Ontario, Canada

Kitchener, Canada

Cambridge, On

Responsibilities include:Ensuring smooth and continuous production by stocking manufacturing lines with the appropriate cartons.Monitoring and operating the ACE (Auto Case Erector) and T-ACE systems.Operating a "tote dumper" packaging machine feeding system.