Mandeep Lotay

Experience

• 

  Promatek Research Centre

  Sept 2009 - Jan 2010

  Quality Control Assistant

  - Utilized a CNC machine, creating standard test samples for tensile testing- Tested parts with the Brinell hardness procedure and recorded the results for further analysis- Performed tensile testing on standard test samples (dog bones), and recorded the findings at failure- Executed duties autonomously, with minimal supervision

• 

  Bombardier Aerospace

  May 2013 - Aug 2014

  Junior Methods Engineer

  --Data Analysis-- - Conducted various analyses on data aggregated from Microsoft Access databases - Created weekly reports using Microsoft Excel, utilizing pivot tables and vlookups to facilitate management decision making - Managed information which conveyed health of various aircraft series manufacturing lines--Data Management /Creation-- - Managed multiple relational databases in terms of data organization and replenishment - Conducted meetings with various data source stakeholders on data accuracy improvement and integrity--Projects---Creating Historic Data Backup- - Task required to pull raw information from over 100 excel reports and create a single organized repository that could be easily searched and queried - Utilized Excel VBA to quickly copy all relevant data from within each file and paste it into a single source-Cost Reduction Project- - Problem: Administrative Assistants had the tedious task to crosscheck bills from 3rd party uniform supply and cleaning service to verify if it was correct - Created a new database that was easy to use that would automatically crosscheck employee rosters with billing information - Reduced time on task to seconds rather than hours, and also identified anomalies that could lead to savings of $10,000+ annually-Budget Creation- - Tasked with creating the budget for the Toronto site Lear Aircraft Program for the next fiscal year - Collected from stakeholders in finance and manufacturing departments - Conducted meetings to verify buy-in from management, and manufacturing leadership on the future budget-Knowledge Transfer- - Due to important nature of the various reporting and data management responsibilities, creating instructions on how to complete various tasks was necessary - Created in depth instructions with screenshots and examples on how to complete tasks - Further refined instructions by conducting mock knowledge transfer session with future employee Show less

• 

  Swissway Machining Ltd.

  Sept 2014 - Apr 2015

  Lean & Six Sigma Initiative (University of Toronto Capstone Project)

  - Utilized Lean and Six Sigma methodologies to formulate plan of action - Stayed in constant contact with company stakeholders in order to collect and verify information- Identified value chains through client interviews and identified critical goals and areas of improvement- Created business process maps of the current systems, then utilizing business process redesign heuristics, created possible improvements - Created a value stream map to identify total Value Added time and Non-Value Added time, and to identify the sources of the problems- Utilized Lean waste analysis to identify problem areas and create possible recommendations- Utilized Six Sigma Methodology to understand and create control measures for sources of variation within manufacturing processes- Created implementation plan for various recommendations to ensure smooth transition for client Show less

• 

  Skyservice Business Aviation Inc.

  Nov 2015 - Jul 2017

  Junior Analyst

  Data Analysis & Cleaning- Utilized knowledge of data cleaning techniques to harmonize unclean data in a usable form for planning department - Many instances required customized VBA scripts in order to quickly clean data due to varying requirements from stakeholders- Conducted monthly analysis on manpower for the company summarizing hours worked to be used in financial statements - Managed data and created analysis pertaining to royalties due to manufacturers in order to maintain Authorized Service Facility status- Created Excel VBA tool to slice and dice labour hours worked by employees to see hourly productivity for use in creating crew schedules - Using custom VBA script to distribute hours worked over 24 hour increments - Summarized findings to indicate peak hours of productivity and overall manpower at any given hour in the day- Using Excel VBA, created a dashboard that would create graphs comparing annual budget vs actual performance across all business units - Report features customized Excel GUIs that aid in adding budget and actuals data - Graphs include dynamic formulas that adjust overall projection to hit budget values - Creates 90+ graphs looking at overall company performance to detailed departmental data- Aided in creating the company budget for the 2017 – 2018 fiscal year - Using historical data created forecasts for individual GL accounts across multiple departments and across multiple bases- Reworked warranty claims submission process and created standardized procedure to follow - Worked closely with stakeholders to map existing process for submitting warranty claims using Business Process Modelling Notation - Created an Excel VBA tool that would aid administrators track ongoing work eligible for warranty- Added time saving features to company reports through Excel VBA allowing project coordinators to quickly report project statuses to customers Show less

• 

  BOMBARDIER

  Aug 2017 - now

  Industrial Engineer