Worked Projects
Tripper - the tour guide of the world 🌍

- User-friendly platform that allows tourists to easily match with local guides🧳/ reshape the way to make new frinds
- AI-powered interaction to provide real-time, knowledge-rich interactions and plan. 🤖
- A social forum where users can share and discuss their travel experiences, fostering community interaction and information sharing. 🗣️
🔧 技术栈 Tech Stack
Front End: React, JavaScript, HTML, CSS | Back End: FastAPI, Python, PostgreSQL, Docker | Webpage Design: Figma | Other Technologies: REST APIs, OAuth 2.0
Project Overview Video
For detailed information, please view the provided Materials
📄Detailed report for Tripper (PDF)For detailed Wireframe diagrams, please view the provided Materials
📄Figma_Wireframe for Tripper (PDF)🔑Key Functions

Home Page design
Navigation Simplicity

Registration and Login Functionality
Sign in via email & password

Registration and Login Functionality
Sign Up

User center
for Tourists

User center
for Tour Guides

Tour Guide Matching and Social Features
Guide Matching/Filtering and Social Features

Instant Messaging Interface
Search and Add New Contacts Feature

Instant Messaging Interface

Forum
Homepage for Forum - Filtering/ Setting/ Creating thread

Forum
Thread Example

AI Tripper Rabbit
Personal AI Assistant

AI Tripper Rabbit
Users ask Tripper Rabbit to provide travel Plan

AI Tripper Rabbit
Tripper Rabbit provides detailed travelling plan in detail

Explore
Preview Page - Provides the preview for customized Attraction/ Restaurant/ Drink information

Explore
Attraction Details Card

Explore
Restaurant details Card
Backend

FastAPI Framework
FastAPI endpoints

Database SQLite
Entity relationship diagram of the forum

Database SQLite
Details of each column in the attraction_details

Database Firebase
Message entity relationship diagram
🌐Third-Party APIs

Third-Party APIs
Navigator API & Google API Implementation
Bitcoin Price Prediction
This study aims to create an accurate sequence prediction model to forecast Bitcoin price trends. The publicly available dataset is from Kaggle, covering Bitcoin price data from May 5, 2013, to October 23, 2022.
Data Processing and Feature Engineering
Data Processing: Cleaned data, handled missing values and anomalies, converted timestamps to datetime format.
Feature Engineering: Calculated VWAP, selected monthly data to reduce noise, performed stationarity tests, and STL decomposition.

Close price against time
Dayly, Monthly, Seasonally and Yearly

Seasonal and Trend decomposition visualization
Model Development

ARIMA Model
Implemented time series prediction through stationarity tests and parameter optimization

Parameters Comparison
MSE, RMSE, MAE statistical histogram of 7 models
LightGBM: Improved training efficiency and prediction accuracy using histogram optimization and leaf-wise growth strategy.
XGBoost: Achieved high accuracy predictions by combining gradient boosting and regularization.
Transformer: Processed complex sequences efficiently through self-attention mechanisms and parallel processing.
Prophet: Modeled seasonality and trends in time series data.
LSTM: Captured long-term dependencies in time series data using long short-term memory networks.
SVM: Implemented classification and regression predictions through kernel functions and support vectors.
Model Comparison
Deep Learning Models: Performed best, effectively capturing long-term dependencies.
Seasonal Models: Handled seasonality and trends well.
Traditional Machine Learning Models: Struggled with long-term dependencies.
🔧 Tech Stack
Data Processing: Python, Pandas
Feature Engineering: VWAP, STL Decomposition
Machine Learning Models: ARIMA, LightGBM, XGBoost, SVM
Deep Learning Models: Transformer, LSTM
Time Series Models: Prophet
Libraries: scikit-learn, statsmodels, lightgbm, xgboost, pytorch, fbprophet
Evaluation Metrics: MSE, RMSE, MAE
Comprehensive Detailed Design& Research for a 22-story Podium Single Tower 🏢 Structure
- A complete Design Package including Design& Research Report, Engineering Drawings, and Calculation Report.
- Shear Core Design Assessment ensuring deflection and drifts at each level met Serviceability Limit State requirements.
- Structural Model Validation through comparison of 2D hand calculation results with 3D Finite Element Analysis outcomes.
🔧 Tech Stack
Structural Design: SAP2000, ETABS | Architectural Design: AutoCAD, Revit | Analysis: MATLAB, Python, Excel | Rendering: Twinmotion, Lumion | Documentation: Microsoft Office, LaTeX
Project Overview Video
🖼️ Rendering Pictures

Overview

Overview
22楼的商住混合高层建筑

Overview

Car Parking Level
停车场

Car Parking Entrance
停车场入口
Technical Drawings

Car parking plan view

Elevation_view

Reinforcament Detailings

Reinforcament Detailings

Typical Level_Plan View
📊 Detailed calculation report

Detailed calculation report
Final Design Report

3D profile model acces design

Deflection contour for core frame and core FEA model

Deflection and drift comparison between 2D and 3D results

Design report final

FEA Analysis

FEA Model Level 2

HvAc energy comparison between double and single-layer glass curtains

Lighting comparison between flat slab and traditional beam-to-slab system
🏢Sustainable Design and Analysis of a Nine-Story Steel Frame Office Building
- Innovative Structural Solutions: Design of composite slabs, beams, and a cantilever truss system to address site-specific challenges.
- Robust Steel Framework: Detailed analysis and design of steel columns and wind bracing for optimal stability and resilience.
- Precise Connection Design: Meticulous engineering of beam-beam, beam-column, and bracing connections for structural integrity.
- Comprehensive Analysis: Parametric study to explore alternative approaches and drive future enhancements.
- Integrated Documentation: Extensive reporting with detailed drawings and calculations, ensuring transparency and precision in every aspect of the design.
🔧 Tech Stack
Structural Design: SAP2000, Autodesk Revit | Architectural Design: AutoCAD | Analysis: Python, MATLAB, Excel | Rendering: Twinmotion | Documentation: Microsoft Office, LaTeX
Steel Structure Detailed Design
.png)
OverView
Global Structural Model for Proposal 1 (SAP2000)
.png)
OverView
Global Structural Model for Proposal 2 (Autodesk)

OverView
Ground FloorArchitectural Layout

Composite Slabs Design
Design Criteria:Fire rating, deflection checks, and manufacturer’s data considered. | ULS and SLS Checks
.png)
Bracing Design
3D View for Global Bracing System in Proposal 1 (Autodesk CAD)
.png)
Bracing Design
Global layout of the bracing system (in SAP2000)

Isolated cantilever region
.png)
Connection design
column-column connections (8 bolts per column)

Beam Section with Critical Section
Analysis of Hexagonal and Triangular Lattice Structures in MATLAB
- Simulated different loading scenarios for each model in MATLAB and Excel.
- Validated model accuracy with proposed refinements.