• Established ETL pipelines via SQL + Hadoop + Doris + Hive + Aliyun (Chinese AWS), as the data source for enterprise financial credit risk assessment model;
• Determined the relationships between 250+ tables, aggregated, cleaned and produced 50+ metrics in several topics including equity pledge, equity trading, securities loan, profitability, rating, trust-breaking, shareholder info etc.
d
didi
Data Product Intern
Beijing, People's Republic of China
September 2021 - March 2022
M
MeiTuan
Business analyst intern
Beijing, People's Republic of China
June 2021 - September 2021
Skills
Languages
CantoneseChineseEnglish
Technical skills
cssgithtmljavajavascriptlatexpythonrsql
Skills
Dashboard CreationHiveMachine LearningOffice Word, Excel, PowerPoint, Premiere Pro CC, After Effects CC.Pivot TablesSPSSTableauTesting