Overview
Work History
Education
Skills
Timeline
Generic

Lefei Chen

29-59 Northern Boulevard,NY

Overview

1
1
year of professional experience

Work History

Analysis on JP Morgan Client Service

Assistant Of Professor Steven Blader From New York
New York, New York
06.2020 - 08.2020

⬧ Client feedback analysis: used digital tools to help analyze real-time feedback from JP Morgan Private Wealth clients with presence in 35 countries and total asset-under-management totaled $2.8 trillion.


⬧ Client service optimization proposal: issued 12 product optimization proposal, covering streamline onboarding, automated account maintenance and cross-border account information sharing based on feedback analysis results.

Research on Cross-border Derivatives Hedging Trans

Part-Time Assistant Of Analyst Jianxin Chen At CIT
Shanghai, Shanghai
10.2020 - 12.2020

⬧ Macro market research: compiled daily market tracking reports and weekly market forecast reports
⬧ Closely followed global macroeconomic indicators, interest rates, and exchange rate trends
⬧ Foreign exchange trading support: used financial engineering analysis model tools such as bond yield calculation, spread analysis, yield curve, investment portfolio, and risk control for valuing currency forwards, currency swaps, etc.

⬧ Proficient in algorithms in the field of foreign exchange and currency derivatives and provided decision-making basis for foreign exchange transactions

⬧ Foreign exchange risk identification: used database tools such as Bloomberg to identify common risks in the foreign exchange market such as country risk, market risk, counterparty risk, operational risk

⬧ Organized foreign exchange transaction analysis hedging suggestions data, improved relevant analysis templates and provided customers with hedging suggestions

Music Recommender

NoSQL, Python
New York, New York
01.2022 - 05.2022

⬧ Created music recommendation system by analyzing audio variables including tracks, feature, genre, artists through scraping data from Spotify Web API.

⬧ Conducted regex search and visualized search based on the cleaned data imported in Elasticsearch and Kibana

⬧ Provided graph-based recommendation using Neo4j visualizing relationship within audio variables.


Trip to Iceland

SQL PROJECT
New York, New York
01.2022 - 05.2022

⬧ Developed an end-to-end travel planning app(RShiny) for travelers wanting to visit and stay in Iceland

⬧ Created a PostgreSQL database on the back end to store the needed data related to hotels, restaurants, attractions, and combinations of such for a bundled package

⬧ Built a fully functional user account system that allowed new users to create travel accounts and for existing users to access their historical travel information

⬧ Presented aspects of the app and its functionality of expert judges and received many accolades for innovation and invention

Education

Master of Science - Applied Analytics

Columbia University in The City of New York
New York, NY
02.2023

Bachelor of Arts - Economics

The Ohio State University
Columbus Grove, OH
05.2021

Skills

  • Technical Skills: R, Python, SQL, Tableau, Excel,PowerBI
  • Soft Skills: Variance Analysis, Customer Monitoring, Templates Management, Database Building
  • hobby: music and swimming

Timeline

Music Recommender

NoSQL, Python
01.2022 - 05.2022

Trip to Iceland

SQL PROJECT
01.2022 - 05.2022

Research on Cross-border Derivatives Hedging Trans

Part-Time Assistant Of Analyst Jianxin Chen At CIT
10.2020 - 12.2020

Analysis on JP Morgan Client Service

Assistant Of Professor Steven Blader From New York
06.2020 - 08.2020

Master of Science - Applied Analytics

Columbia University in The City of New York

Bachelor of Arts - Economics

The Ohio State University
Lefei Chen