Lian Duan

liand.dev/

liand@student.ubc.ca

Lian-D

LianDu

lian_duan_

Vancouver, BC Canada

778-709-9416

Interests

API Development (API, REST), Microservice Development , Back-End Security

Skills

Languages: TypeScript, Python, C#, JavaScript, Java, PHP, C++, SQL/MySQL

Frameworks: ExpressJS, NodeJS, VueJS, ASP.NET, Sequelize, OAuth2.0, CodeIgniter, JQuery

Toolsets/OS: MacOS, Ubuntu, Git/GitHub, Jenkins, Heroku, AWS, Azure, CentOS

Education

University of British Columbia, Vancouver, BC, Canada

B.Sc., Computer Science (expected Spring, 2023)

2017 - 2023

Work

Agile Developer (Infrastructure) Intern, Brock Solutions

www.sap.com/canada/index.html

Software Development Engineer

  • Designed and developed an internal remote tooling solution in C# and ASP.net, allowing for team-based collaboration and debugging on emulated baggage systems, significantly cutting down licensing fees by up to $40,000 USD annually.
  • Provided software customizations to JFK airport; implementing a digital baggage tracking map responsible for tracking and visualization of terminal 4 and 6 baggage systems through C#, SQL and python as part of a $25 million USD contract.
  • Presented micro-service functionality and features to the upper level management of JFK International Airport.
  • Developed new baggage tracking and handling system for Domestic and Transborder terminals of Vancouver International airport. Specifically handling the configuration, customization and integration testing of variouscore microservices.

2023 - Present

Agile Developer (Infrastructure) Intern, SAP

www.sap.com/canada/index.html

Infrastructure Developer Intern

  • Updated, maintained and deployed micro-services belonging to the SAP S4/HANA Enterprise Resource Planning (ERP) suite utilized by over 17,500 companies globally to provide real time analytics for their data. Specifically on the XSN Team using JavaScript and later TypeScript.
  • Issued patches for critical security issues in HANA related microservices ontop of refactoring non-standard API patterns and code defects through Java (Java Spring) and JavaScript (Node.JS).
  • Centralized micro-service deployment statuses for team by implementing a deployment dashboard, streamlining and allowing for rapid remediation to failing deployments.

2021 - 2022

Web Software Developer Co-op, Form Swim (formerly Form Athletica)

www.formswim.com/

Coop Web Software Developer

  • Developed, updated and maintained back-end REST API routes utilized by the mobile app for 45,000+ active swimmers using TypeScript, MySQL and AWS services.
  • Implemented end-to-end (database, backend and API) support for “Verified” and “Professional” displayable user badges in the mobile app using Express.JS, TypeScript and Sequelize(SQL).
  • Set up staff email alerts on production firmware releases, flagging and alerting engineers of unintended releases by using AWS Lambda functions with delivery through AWS SES; increasing overall response readiness.

2020 - 2020

Web Applications Developer, LedgerDocs

www.ledgerdocs.com/

Developer of LedgerDoc's OCR module

  • Reduced the job-based load on server instance CPUs by up to 99.7% and eliminated server crashing occurrences by implementing a queue worker system to distribute high CPU consumption during peak processing hours.
  • Implemented an Optical Character Recognition (OCR) system responsible for the reading, processing, and parsing of 30,000+ photographic invoices per annual quarter by integrating Tesseract library onto the existing PHP codebase.
  • Prototyped user SMS document uploading to the web application using a Twilio client and REST API built onto existing backend infrastructure.

2019 - 2020

Activities

Flight Sergeant & Senior Cadet Instructor, 513 Hornet Squadron Cadets Canada

513aircadets.ca/

Cadet Instructor and Flight Commander of Hurricane Flight

  • Managed a flight of approximately 30 cadets, ensuring attendance, uniform standards and general standards were met
  • Taught leadership and marksmanship classes
  • Assisted Officers in running activities and parades

2012 - 2017

Vice President, Burnaby Mountain Secondary Music Department

Vice President of the Music Department

  • Managed and catalyzed brainstorming, planning and running of events within the music department to promote the student experience
  • Oversaw and managed the set-up, take-down and intermission of concerts

2016 - 2017

Recreational Volunteer, Burquitlam Lions Care Centre

Recreational Volunteer

  • Assisted nursing staff in providing companionship and giving aid to residents in the care home
  • Provided visits in addition to conversing with residents

2015 - 2016

Awards

British Columbia Government BC Achievement Scholarship, British Columbia Government, 2017

BC Achievement Scholarships recognize the top 8,000 graduates in the province.

References

Available upon request