Close

Qianhui Yu

Software Engineer

Download Resume

About Me

Hi! I am an M.S. in EE at Columbia University, Software Engineer and Saxophone Player, who is very passionate about technology and music.
As a Software Engineer, I am proficient in Java/Spring and familiar with Python/Django and JavaScript/React.
My vision is to use my knowledge and creativity to develop tons of innovative Apps and features to facilitate people's lives!
For more experience and my tech stacks, please refer to the related parts.

Experience

Walmart, Sam's Club

Software Engineer Intern

  • Redesigned and implemented the product database of the Recovery Rate Optimization team.
  • Enabled the new database schema to meet new business requirements (Liquidator on-boarding and club configuration).
  • Initiated a new microservice: Liquidator Profile Management (including rate exception) with Spring Boot, Spring Data JPA ,and MSSQL Server.
  • Enabled associates enter new liquidators into the system and give them more control of configuring liquidators’ business.
  • Completed more than 30 liquidator swap and rate update requests.

E-Navigation Information & Technology Co., Ltd

Software Engineer Intern (Java)

  • Implemented Ship Route Planning Module with Java, Spring, SpringMVC, and MySQL.
  • Remodeled the ship route planning service using the heap optimized Dijkstra algorithm.
  • Improved the response speed of route planning service (from the harbor to harbor) by 28.3% on average.
  • Initiated a new feature which enables our system to provide route planning service from any location to destination harbor.

Huazhong Data Science Center

Research Assistant

  • Oversampled FMRI data using Analytical Phase Projection to solve the periodic problem；
  • Searched for the 3D path of the Middle Cerebral Artery using Reinforcement Learning based on the Bellman equation；
  • Improved MDPDE to 4D effective and using it to modeling & fitting Partial Differential Equation of Middle Cerebral Artery.

Education

Columbia University

Sept 2019 - Dec 2020

M.S. in Electrical Engineering, GPA: 3.78/4.00

Courses: Analysis of Algorithms, Cloud Computing, Introduction to Databases, Big Data Analytics, Computer Networks, Introduction to Blockchain, Applied Deep Learning, Internet Economy

Huazhong University of Science and Technlogy (HUST)

Sept 2015 - June 2019

B.S. in Electrical Engineering, GPA: 3.76/4.00

Projects

Intelligent Security Access System based on AWS

  • Established visitor filter with Lambda Function, Amazon Rekognition, and Dynamo DB.
  • Enabled system to distinguish between strangers and known visitors.
  • Created visitor authentication workflow with Lambda Function and API Gateway.
  • Enabled managers to authorize visitors’ access.
  • Enabled system to store new visitors’ faces and send one-time-password.
  • Designed and Developed the visitor/manager portals
  • Integrated two web pages with API Gateway and Swagger.

Better Name More Money: Airbnb analysis

  • Developed the web application using Django and generated the following listed functions’ APIs for the application.
  • Visualized significant words used in names of listings with high popularity by clustering and generating WordCloud.
  • Recommended words that could bring more popularity for householders.
  • Generated Airbnb price heat map and crime heat map with Google API.
  • Developed and tuned popularity prediction tools based on Random Forest and XGBoost.
  • Achieved lower MAE from 1.21 reviews (baseline) to 0.63 using Cross-Validation and Grid-Search.

Group shopping web application

  • Designed and created the group shopping database in PostgreSQL.
  • Implemented the demo functions including login, adding items, adjusting cart, placing orders, showing order history, and management mode with Flask.
  • Deployed the application on the VM in GCP.

Skills

Get in Touch