LATEST INTERNSHIP & ACADMIC PROJECTS
Project | 01
| Click to view the full report
​
| Semantic Web & Decentralized Finance Interactive Dashboard Data Science Capstone Project for Fidelity Investments, Boston, MA
TEAM SPARQL
May 2023 - August 2023
​​
Designed and Developed Semantic Web Dashboard for DeFi Products
- Spearheaded the design of a semantic web dashboard, visualizing properties of DeFi products using Python and SPARQL
- Formulated investment recommendations by analyzing historical trade data
Ontology Creation and Data Visualization
- Utilized Protégé for the construction of ontologies catering to various cryptocurrencies and financial products
- Effectively visualized data trends and mapped relationships between diverse datasets
User Interface and Data Query Enhancement
- Developed SPARQL queries for structured data entries and integrated a user-friendly drop-down menu for streamlined option selection
- Leveraged Pandas in Python to augment SPARQL capabilities, incorporating functions such as standard deviation
​
The SPARQL queries on the left could display the price of all cryptocurrencies added in the Defi ontology on a given day, the average price of different currencies, and the highest and lowest price of a cryptocurrency in a given range of date.
Project | 02
| Analysis and Visualization on US Used Car Market Project from BUS 211A-1 Foundation of Data Analytics, Boston, MA
August 2022 - December 2022
​
Directed a comprehensive analysis of the US second-hand car market, extracting insights from a dataset originally sourced from cars.com on Kaggle. Derived key pricing determinants by scrutinizing factors like location, consumer ratings, and vehicle features.
​
Data Refinement and Database Design
- Streamlined an extensive dataset of over 5000 records down to a precise collection of 4737 rows and 17 columns through a strategic data refinement process
- Employed SQL, with platforms such as MySQL and PostgreSQL, to establish a robust database that adheres to the 1st, 2nd, and 3rd normal forms
Visualization and Market Insight Extraction
- Leveraged the ggplot tool in R for creating intricate visualizations that shed light on sales distributions across states and price variation based on diverse parameters
- Ascertained critical consumer preferences and patterns, providing stakeholders with valuable guidance in the US used car market
Project | 02
| Social Media Analysis for Gaosheng Wealth
​
During my internship at the Marketing Department of Gaosheng Wealth, where I monitored competitors’ social media accounts for months and analyzed their traffics with statistical methods. With the help of my supervisor, I concluded the kind of content that were likely to receive positive feedback from client, and advised my apartment to produce similar content on social media in the form of speech.
Project | 02
| Social Media Analysis for Gaosheng Wealth
​
During my internship at the Marketing Department of Gaosheng Wealth, where I monitored competitors’ social media accounts for months and analyzed their traffics with statistical methods. With the help of my supervisor, I concluded the kind of content that were likely to receive positive feedback from client, and advised my apartment to produce similar content on social media in the form of speech.
Project | 02
| Social Media Analysis for Gaosheng Wealth, Beijing, China
May 2020 - August 2020
​
During my internship at the Marketing Department of Gaosheng Wealth, where I monitored competitors’ social media accounts for months and analyzed their traffics with statistical methods. With the help of my supervisor, I concluded the kind of content that were likely to receive positive feedback from client, and advised my apartment to produce similar content on social media in the form of speech.
Project | 03
| YouTube Video for Architectural Health, Boston, MA
January 2021 - May 2021​
​
During my time as an Account Executive at PRLab, I've produced YouTube videos, blog post, and social media posts. As for this introduction video of Architectural Health, I cut out pet phrases, edited subtitles, added background music, and adjusted volumes by using Adobe Premiere Pro and Adobe Audition
Project | 04
| Digital Graphic Design Project from CM501 Design Strategy & Software, Boston, MA
January 2021 - May 2021
​
-
Logo design for an imaginary coffee shop "Excellency"
-
Creative lyrics layout design for "Lust for Life"
-
Advertisement for Snapple