Yalin CHEN
Shanghai,China
Summary
Positive, analytical problem-solver with strong foundation in data systems and processes. Possesses solid understanding of data modeling and database design, coupled with skills in SQL and Python. Capable of driving data-driven decision-making and improving data infrastructure.
Overview
4
4
years of professional experience
Work History
Data Engineer
Everbright Securities Company
08.2023 - Current
- Data Model Development: Collaborated with channel operations and compliance divisions to provide daily data queries, design scalable data models (GP, Oracle) and dashboards, enhancing better client insights and improving risk identification. Key projects included anti-money laundering metrics development and online channel performance analysis.
- Data Integration and Governance: Integrated data from multiple systems, including trading platforms, client management systems, and risk management databases, ensuring regulatory compliance and maintaining the quality, integrity, and consistency of transactional and client data.
- ML Model Application: Developed a model (lightGBM) to forecast potential client sign-ups for financial advisors, leveraging key behavioral and asset data. It aims to drive the company's exploration of new business growth opportunities.
Data Scientist Intern
Bytedance
12.2021 - 11.2022
- Metrics Design: Participated in the design of North Star metrics and developed five core dashboards for daily analysis. Designed success metrics and an event tracking system for transaction flow revamp, improving data coverage by 40%.
- Data Analysis: Utilized causal inference and linear regression models (sql and python) to analyze the impact of creator incentives on video performance, planning to implement it as a business model. Designed and conducted an A/B test for the branded content video disclosure feature, validating that the format change significantly improved video performance.
- Market Analysis: Designed and deploy branded content recognition and order price methodology, which identified 80% more offline videos and compared with the competitor products in terms of product channel, user profile and price level to locate the potential opportunities with strategy team.
Data Analyst Intern
DIDI
03.2021 - 07.2021
- Data Support: Developed and maintained more than 20 hive tables and sql templates to provide data analysis with operations and product; Built Tableau dashboard to track the key indicators during the new market opening phase, and locate potential risk region based on passenger retention and driver acceptance rates;
- Case Study: Analyzed the problem of imbalance completion rate among regions by doing the funnel analysis, and breakdown by order distance and period. Combining the local situation and team strategy, provide the feasible advice that increase the rate by 10% after 2 months.
Education
Master of Data Science -
University of Melbourne
Melbourne, Australia03.2023
Bachelor of Commerce/Information System - Accounting
University of New South
Sydney, Australia08.2020
Skills
- Proficient in SQL, Python, R, SAS
- Proficient in Tableau, Excel, Powerpoint
- Know JAVA, Javascript
- Data Visualisation
- Data Modeling
- Data Pipeline Design
Timeline
Data Engineer
Everbright Securities Company
08.2023 - Current
Data Scientist Intern
Bytedance
12.2021 - 11.2022
Data Analyst Intern
DIDI
03.2021 - 07.2021
Master of Data Science -
University of Melbourne
Bachelor of Commerce/Information System - Accounting
University of New South
Similar Profiles
Ka Hung, Yoey LeungKa Hung, Yoey Leung
Senior Associate (Client Onboarding) at Everbright Securities Investment Services (HK) LimitedSenior Associate (Client Onboarding) at Everbright Securities Investment Services (HK) Limited
WEIHUA (DINAVIA) LIWEIHUA (DINAVIA) LI
Intern at Everbright SecuritiesIntern at Everbright Securities
Daniel Weiyue MeiDaniel Weiyue Mei
Intern at Everbright SecuritiesIntern at Everbright Securities