SIQI (SHELLY) YANG

Detail-oriented, organized and meticulous employee. Works at fast pace to meet tight deadlines. Enthusiastic team player ready to contribute to company success.

Marketplace Shopping Web App [Python, MySQL, AWS, Next.js]

• Built a marketplace shopping platform for the AWS employee to exchange their goods and improve the internal connection of the company
  
• Participate in the entire project process, including requirement, design, coding, testing and deployment
  
• Regular user can sell or buy product from the other employee or from the department sales
  
• Admin user have the access to manage users and posts
  
• Using AWS Lambda Function with AWS API Gateway to build the REST API for backend, and AWS RDS to host MySQL database server
  
• GitHub is used for source control to collaborate the work from different team member.

Job Search Database Application  [Java, JDBC, MySQL, SQL]  
 

• Constructed a job search database with different users and tables through MySQL, and applied OOP principles using Java to create classes for different objects
  
• Employed JDBC to connect the Java app to MySQL database to query, update, delete from the database
  
• Created an UI using Swing and AWT to interact with both the database and the Java classes

Insight Façade Object  [JavaScript, TypeScript, JSON, Chai, Karmar, Mocha]
 

• Created an app for UBC students to query for metadata of facilities around the campus
  
• Parsed valid input files into internal objects and personalized data structure for each of the groups, and write a copy of data to the disk and load data when needed to be used
  
• Parsed HTTP requests into JSON objects for queries, and used asynchronous promises to code and test parts
  
• Used test tools such as Mocha, Chai, Karmar to improve coverage to 90%, and RESTful web services for the fronted end to get requests from the server