Yiwei Li Email & Phone Number

New York, United States

1)Established an ETL pipeline using SQL for title standardization and adding file prefixes, leading to 50% decrease in manual data extraction time 2)Demonstrates profound proficiency in SAS and has designed and enhanced advanced credit risk models using methods like Macro, Proc Corr, Proc Reg, and Proc Logistic. Regularly generates performance reports for.

1)Imported over 5,000 rows of sales data into Databricks by establishing a cooperative ETL process and data analytics environment, pinpointing key metrics influencing client acquisition rates, and eliminating over 10 redundant calculation steps, thereby increasing calculation precision by 25% to 87%.2)Implemented Logistic Regression in Python to project.

Shenzhen, Guangdong, CN

• A Consolidated data from Tencent game platforms and analyzed data around DAU (daily active users), user segmentation based on demographics, and user spending behavior on games.
• Cleaned data using B numpy and built data visualization dashboard using Tableau.C Wrote SQL stored procedures and queries to automate generation of business intelligence reporting.

Central, Hong Kong, HK

1）applied modified Support Vector Machine on Aluminum price Tendency Predictive model and achieve 64% accurate which is 32 percent higher than the old predictive model2)Worked on financial modeling of coper and aluminum futures in financial planning department.3)Developed regression and XGBOOST using numpy, matplotlib, TensorFlow and Keras.4) sloving the.

Central, Hong Kong, HK

1)Applied the machine learning model(Deep Neural Newtwork) build on python Tensorflow by select more than 15 features to predict the S&P 500, and Russell 2000 return on 1day, 3 day and 5 day time range achieve 67.1%, 62.5%, 59.4% accuracy for S&P 500 and 61.4%,57.2% and 59.7% on Russell 2000 based on more than 100000 data from 2011-20162)help the the team.

1. using advanced Excel functions like Pivot Table and python package Pandas and NumPy to Fetch more than 50000+ data and classify 2136 public listed company base on their EPS, PE, PB and other Financial index analysis 2.applying statistical regression models, to forecast reserve earnings and loss ratios for our business lines and client which help the.

CN

1esponsible for analyzing the creditworthiness of corporate borrowers, reviewing financial statements and legal documents, and monitoring ongoing compliance with financial covenants.2determine appropriate grid-based pricing for borrowers to ensure that the bank is adequately compensated for credit risk.3)expertise in calculating financial ratios, such as.

Master, Data Analysis Of Engineer

Master'S Degree(Transfer To Engineer School), Data Analysis

Master'S Degree, Applied Economics

Bachelor'S Degree, International Business