Experience

Bench Accounting

• Canada
• Accounting
• 400 - 500 Employee

• Analytics Engineer

  • Sep 2021 - Present

  Key projects - Supported restructuring a 700+ field object into fact/dimension tables with appropriate relationships, allowing for more detailed and flexible and scalable reporting infrastructure. - Supported statistical and technical implementation of survival-curves based client analysis, which directly impacted company objectives. - Proposed, supported and implemented needed warehouse cleanliness and optimization projects which had a direct large impact on reducing cluster load and query speeds within an extremely short timeline, leading to an elimination of load-based errors in the warehouse. Main responsibilities - Ingestion, orchestration, architecture and maintenance of data assets, with a focus on dimensional modelling, performance and long term maintainability within a modern data stack * DBT * ETL [ Stitch, Hightouch, Census,] * AWS Cloud - Created visualizations and reporting in both an ad-hoc manner, alongside durable assets such as Tableau dashboards, based on business requirements - Key partner in systems integration projects involving multiple systems of record such as ETL tools, Salesforce, Stripe and in house solutions using DMS, Terraform , AWS Glue. - Led team transformation from monolithic to agile development practices within a cohesive data unit involving both analytics engineers, analysts and business partner through use of : * iterative deliverable definitions * context‐driven project kickoff sessions * office‐hour support sessions - Mentored analysts, business partners and engineers in various topics including : * Redshift warehouse and data principles * Business impact of analytics * Technical implementation * Analytic problem solving - Implemented various augmentations to work pipeline through creation of bash, python and SQL scripts [jinja macros] to facilitate tasks such as: * Documentation alignment * Engineer / analyst onboarding * CI testing automation Show less



Institute for Management & Innovation (IMI) UTM

• Canada
• Higher Education
• 1 - 100 Employee

• Business Data Analyst

  • Jan 2021 - Sep 2021

  - Analysis and conceptualization of data for a career mobility study,to be published - Leveraging Elastic Cloud to transform raw data into patterns of career mobility - Used advanced data aggregating techniques (Time Series, Nested Aggregations) effectively - Conducted requirements analysis to understand data integrity challenges and proposed multiple methodologies, which were approved - Analysis and conceptualization of data for a career mobility study,to be published - Leveraging Elastic Cloud to transform raw data into patterns of career mobility - Used advanced data aggregating techniques (Time Series, Nested Aggregations) effectively - Conducted requirements analysis to understand data integrity challenges and proposed multiple methodologies, which were approved



Innovation and Policy Lab (IPL)

• Toronto, Ontario, Canada

• Data Analyst

  • Sep 2018 - Dec 2020

  - Developed a database that successfully identified socio economic and innovation performance indicators for a variety of clients, including Toronto Global and Toronto Region Board of Trade - Architected, extracted and analyzed socio economic and locational data, by automating aggregations of demographic indicators - Collaborated with a group of 3 researchers, acting as the key contact for turning business and analysis requirements into technically feasible methodologies - Developed a database that successfully identified socio economic and innovation performance indicators for a variety of clients, including Toronto Global and Toronto Region Board of Trade - Architected, extracted and analyzed socio economic and locational data, by automating aggregations of demographic indicators - Collaborated with a group of 3 researchers, acting as the key contact for turning business and analysis requirements into technically feasible methodologies



University of Waterloo

• Canada
• Higher Education
• 700 & Above Employee

• Research Assistant

  • Sep 2018 - Dec 2019

  - Performed ETL with a focus on qualitative to quantitative codification and spatial analysis of survey results from an industry-level survey (Lowe & Vinodrai 2020) - Developed subject matter expertise in textile manufacturing supply chain dynamics for home-based operations to large-scale manufacturing - Created customized dashboards to display data for bushiness purposes, such as supplier rating - Point person to chief researcher for ad-hoc feasibility analysis for greenlighting projects Show less



Astrala Inc.

• Vaughan, Ontario, Canada

• Consultant

  • Oct 2017 - Jun 2018

  - Created and implemented an e-commerce platform for a major B2B retailer with a small team - Proposed solutions and presented strategies via visual representations and roadmaps - Initiated competitor analysis, which yielded evidence to support a UI/UX overhaul , resulting in an accepted proposal from the client - Architected and scripted faceting search and pagination within a MongoDB environment with a focus on improving query speed and UI responsiveness using MeteorJS - Created and implemented an e-commerce platform for a major B2B retailer with a small team - Proposed solutions and presented strategies via visual representations and roadmaps - Initiated competitor analysis, which yielded evidence to support a UI/UX overhaul , resulting in an accepted proposal from the client - Architected and scripted faceting search and pagination within a MongoDB environment with a focus on improving query speed and UI responsiveness using MeteorJS



CAE

• Canada
• Aviation and Aerospace Component Manufacturing
• 700 & Above Employee

• GIS Analyst

  • Sep 2017 - Dec 2017

  - Created multiple custom transformers in FME with Python which reduced manual input by 90% and ensured consistency among project parts during ETL processes - Maintained confidentiality with highly secure and sensitive military datasets - Automated Bash and Powershell scripts to ensure efficient and consistent file and folder management within a multi tasking project environment - Introduced an algorithm to facilitate communication between teams and reduce errors - Created multiple custom transformers in FME with Python which reduced manual input by 90% and ensured consistency among project parts during ETL processes - Maintained confidentiality with highly secure and sensitive military datasets - Automated Bash and Powershell scripts to ensure efficient and consistent file and folder management within a multi tasking project environment - Introduced an algorithm to facilitate communication between teams and reduce errors



Crawford & Company

• United States
• Insurance
• 700 & Above Employee

• Research & Development co-op

  • Jan 2017 - Sep 2017

  - Piloted an all-in-one compliance suite for the property management sector to successful track and monitor property - Utilized Google Maps API in a innovative application for maintenance management - Managed conversion of suite to mobile platforms which led to the successful release of the application to business specifications - Acted as liason between technical team and senior leadership, translating technical requirments to buisness solutions. - Presented technical concepts to clients, ensuring clear communication and translating client needs into technical buisness-ready solutions Show less



Agriculture and Agri-Food Canada/ Agriculture et Agroalimentaire Canada

• Canada
• Government Administration
• 700 & Above Employee

• Geomatics Technician

  • May 2016 - Aug 2016

  - Architected and implemented a multi-script approach for the mapping of Soil moisture statistics with intelligent file selection and multi-year rollover in an automated setting - Automated and streamlined multiple previously running scripts which resulted in a 95% decrease of manual input and decreased runtime of the scripts by 60% - Selected as a part of the team that performed tests and optimized the running of the Crop Classification system,which increased accuracy by 35% - Architected and implemented a multi-script approach for the mapping of Soil moisture statistics with intelligent file selection and multi-year rollover in an automated setting - Automated and streamlined multiple previously running scripts which resulted in a 95% decrease of manual input and decreased runtime of the scripts by 60% - Selected as a part of the team that performed tests and optimized the running of the Crop Classification system,which increased accuracy by 35%



Agriculture and Agri-Food Canada/ Agriculture et Agroalimentaire Canada

• Canada
• Government Administration
• 700 & Above Employee

• Geomatics Technician (Co-Op)

  • Sep 2015 - Dec 2015

  - Designed and implemented a model that calculates the estimated crop area of a target crop with 97% accuracy to real world values. - Designed and implemented a multi-script model that generates MODIS time series with high accuracy. - Member of the field-research team gathering data regarding sustainability and resilience of the Ottawa River against human influence. - Designed and implemented a model that calculates the estimated crop area of a target crop with 97% accuracy to real world values. - Designed and implemented a multi-script model that generates MODIS time series with high accuracy. - Member of the field-research team gathering data regarding sustainability and resilience of the Ottawa River against human influence.



City of Greater Sudbury

• Canada
• Government Administration
• 700 & Above Employee

• GIS Environmental Project Assistant (Co-Op)

  • Jan 2015 - Apr 2015

  • I developed a user-friendly Geographic Information System(GIS) procedure that reduced the project timeline by over 30%. •I was hand-picked by project manager to introduce automation within the Spatial Database Engine . I successfully completed this project with very limited guidance, reducing required manual effort by 50%. •City of Greater Sudbury tracked water main breaks and repairs using PDF format that was not searchable. I digitized those entries, generating a searchable database for future reference. Show less



Georgetown Agricultural Society

• Website Administrator

  • Sep 2008 - Jan 2015

  Website Administrator Design, code, manage, and promote the Georgetown Fall Fair`s website, which is the main resource for the public about the activities and events of the Georgetown Agricultural Society. • Spearheaded the implementation of 3rd-party software for a more interactive and modern look and feel. • Increased web traffic by 40% to the website over the past 4 years • Implemented Joomla! Content management software to streamline and facilitate editing from Society Leaders. Website Administrator Design, code, manage, and promote the Georgetown Fall Fair`s website, which is the main resource for the public about the activities and events of the Georgetown Agricultural Society. • Spearheaded the implementation of 3rd-party software for a more interactive and modern look and feel. • Increased web traffic by 40% to the website over the past 4 years • Implemented Joomla! Content management software to streamline and facilitate editing from Society Leaders.



Town of Halton Hills

• Canada
• Government Administration
• 100 - 200 Employee

• Lifeguard/Swim Instructor

  • Mar 2011 - Aug 2014

  Build and nurture swimming and lifesaving skills in candidates. Enforce and educate general public about water safety and pool-deck safety. • Taught and assessed swim candidates according to Lifesaving Society Standards. • Received high amounts of praise for my candidate- oriented attitude and teaching style • Received multiple requests for priority picks to be the client`s instructor, often private 1-on-1 sessions. • Led the first-aid effort to rescue a patient from a medical emergency on-deck. Show less



Nova Computers

• Co-Op Computer Technican

  • Sep 2012 - Jan 2013

  Work closely with clients to resolve their hardware and/ or software problems with a very high success rate, thorough evaluations of system problems and high customer satisfaction. • Designed and implemented the Nova-Computers website, which increased web traffic significantly. • Worked closely with peers to solve client`s problems with the most time and financially-efficient method possible,. • Participated in the removal of virus cases that were deemed “impossible” to remove by the competition. • Decreased number of unhappy customer returns with systematic and through testing and efficient turn-around times. Show less