In Class Project: Columbia Exchange Platform

COMS 6998 Cloud Computing and Big Data

• With a group of four under professor Sambit Sahu's instruction, a full-stack programming project, including fronted and backend, has been implemented.
• Based on the AWS platform, a campus second-hand goods trading platform has been developed and has received widespread attention. The project used S3, Cognito, SES/SNS, CloudWatch, RDS (connecting with MySQL database), lambda functions, and other related services.
• Responsible for developing web modules including product uploading, modification, search, and deletion (completed the fronted part and dealt with lambda functions, RDS database, API gateways, s3 bucket in AWS platform) and solved other systemic problems in front-end code.

Project Presentation Detail

In Class Project: The Balance Sheet Learning Website

COMS 4170 UI Design

• This web application is our final project for the User Interface Design course with Professor Lydia Chilton. The project involves building a web application that teaches users about a particular topic through interactive, iterative learning. This website aims to teach users how to analyze balance sheets since it is a valuable topic for young adults to get acquainted with.
• The project includes a flask server, HTML pages, and JS functions. We formed a group of three, and I was responsible for the rules, additional resources, and quiz parts.

Project Presentation Detail

In Class Project: Squid Game

COMS 4701 Artificial Intelligence

• Employed Python and adversarial search algorithm to implement a Squid Game required to defeat the other group's code in Artificial Intelligence course with Professor Ansaf Salleb-Aouissi.
• The game is organized as a two-player game on a 7x7 board space. A player moves every turn and then throws a trap somewhere on the board. To win the game, you will need to trap the opponent, that is, surround them with traps from all sides so that they cannot move before they do that to you.

Project Detail in Github

In Class Project: Hospital Information Management System

COMS 4111 Introduction to Database

• Employed PostgreSQL in Google Cloud Platform to build a database and connect with fronted HTML pages to form a Hospital Information Management System under Professor Luis Gravano's instruction.
• Our group work was well-received by professors and presented to the whole class at the end of the semester.

Project Detail in Github

In Class Project: Analysis of Marriott

IEOR 2261 Financial Accounting

• Employed comparative valuation (P/B, P/S, EV/EBITDA) and based on the assumptions of WACC, FCF, and CAPM, to establish a DCF model to predict Marriott's financial status in the next five years under Professor Nadejda Zaets's instruction.
• Calculated and evaluated the company's return on equity, return on total assets, total asset turnover, current asset turnover, asset-liability ratio, earned interest multiple, sales (operating) growth rate, and capital accumulation rate. Predicted the future valuation of the company.

Project Detail in Sheets

In Class Project: The Mathematics of Gossip

MATH 271 Differential Equations

• Analyzed potential application of the SIR model to stimulate and better understand the spread of gossip in society under the instruction of Professor Lorelei Koss.
• Established the Gossip Model using modeling tools developed to understand infectious disease with Python.
• Studied the Anthropomorphized Sensitivity Analysis to illustrate the contextual significance of parameters and translate social characteristics into mathematical language using the Gossip Model, a compartmental model of SIR coded in Python.
• Concluded that the SIR model can be used to simulate more complex scenarios with high realistic validity.

In Class Project: Differences between the Chinese and American Medical Insurance Systems During the Epidemic

ECON 496 Senior Seminar (Political Economy of Health)

• An in-class research project as my Quantitative Economic major graduation project in class ECON 496 Senior Seminar (Political Economy of Health) with Professor Kongar Ebru.
• My dissertation explored the differences between the medical insurance systems in China and the United States. The main focus is on the difference in the payment of medical insurance for common respiratory diseases during the epidemic.

In Class Project: Regression Discontinuity Analysis in U.S. Congressional Elections Example

ECON 298 Econometrics

• By employing Stata and incorporating Congress.dta Dataset, this project aims to find how much party matters by looking at the ideology of members of the 112th Congress in the class of Econometrics with Professor Emily Marshall.
• By plotting scatterplot, histogram, and establishing report with the model specification for the varying-slopes RD models, a substantial bump at the discontinuity, which suggests the party does indeed matter, was found.
• With the assumption where discontinuities exist at the cutoff for child-poverty, median-income, obama2008, and whitepct by our four auxiliary varying-slopes models, a quantitatively analyzed report was built up after exploring the relationship between different variables.
• It concluded that the party does matter since a significant jump in ideology at the cutoff in obama2008 and the whitepct case; however, there is no sign of discontinuities in the child poverty and median income models.

In Class Project: Global GDP per capita Analysis

ECON 278 Intermediate Microeconomic Theory

• Analyzed the relationship between Global GDP per capita with thirteen different parameters with Professor Vlad Tarko.
• Established the linear regression model using modeling tools developed to understand relationships with R studio. The Data is retrieved from the Quality of Government Institute (QoG).

Project Detail: Global GDP per capita Analysis