Adrian Wan, P.Eng. Email & Phone Number

Seattle, Wa, Us

Calgary, Ab, Ca

• Built a support vector machine (SVM) model in Python to classify records based on freeform text fields, resulting in >85% accuracy in predicting the correct aircraft system and subsystem.• Created automated ETL workflows in KNIME to process and validate aircraft data from airlines, in order to prepare for more advanced analyses and machine learning models.• Defined future aircraft reliability targets by factoring in historic performance, regional factors, new product improvements, etc. to benchmark fleet performance across various metrics.• Designed a new tool to track and report airline flight schedule reductions and aircraft fleet size and status changes during the COVID-19 pandemic.

Dorval, Québec, Oo

• Forecasted aircraft fleet sizes for the next 10 years by factoring in historic trends, design life cycle, new deliveries, etc. in order to facilitate market valuation of CRJ and Q Series programs.• Benchmarked CRJ and Q series performance against competitors by using public FAA SDR database and internal metrics to extrapolate aircraft reliability performance.• Developed mixed integer programming (MIP) optimization model to find the optimal discount allocation across services to maximize respective profit margins, while meeting the target price.

Dorval, Québec, Oo

• Developed automated financial caption tool to generate detailed breakdown of expenses in SAP, increasing transparency of governance reviews for management and overall efficiency by 50%.• Designed daily, weekly, monthly customer relationship management (CRM) reports using data extracted from Salesforce, which were used to track on-time performance by team function.

• Designed and worked on a flexible Bill of Materials project for GVA Lighting.• Optimized the component selection process to minimize total cost, using different approaches, such as Mixed Integer Programming, Dantzig-Wolfe Decomposition, Branch-and-Bound.• Automated workflow jobs using Microsoft SQL Server, which included running Mixed Integer Programming C# code, retrieving data from server, running queries, and exporting to Excel.

Toronto, Ontario, Ca

• Created database of all Washington Accord accredited engineering programs across the world to optimize the transfer process for outgoing and incoming foreign exchange students.• Analyzed the accreditation status of more than 1000 universities and colleges in 25 countries to determine whether they were equivalent to engineering programs offered at UofT.

Toronto, Ontario, Ca

• Compiled and evaluated design components, course documents, and requirements for all undergraduate Mechanical and Industrial Engineering courses for the CEAB evaluation, which was carried out in October 2012 and resulted in the full 6-year accreditation.

Master Of Engineering (Meng), Industrial Engineering

Bachelor Of Applied Science (Basc), Industrial Engineering