Open to opportunities

Yanchao Shen

@yanchaoshen

Message

Data analyst with expertise in AI and financial project management.

China

Message

What I'm looking for

I am seeking a role that fosters innovation and allows me to leverage my data analysis skills in a collaborative environment.

I am a dedicated data analyst with a strong background in applied analytics and economics. I hold a Master of Science in Applied Analytics from Columbia University and have honed my skills through various professional experiences, including my current role as a Bond Project Manager at Soochow Securities Co., Ltd. Here, I manage complex bond projects, leveraging my expertise in financial analysis and project management to drive successful outcomes.

My experience extends to AI data analysis, where I interned at Hangzhou Guandata Co., Ltd., collaborating with prestigious clients like LVMH. I developed workflows and ETL processes, utilizing Python and SQL to ensure data integrity and deliver actionable insights. My technical skills, combined with my strong analytical abilities, enable me to contribute effectively to any team and drive innovation in data-driven projects.

Experience

Work history, roles, and key accomplishments

Current

Bond Project Manager

Current

Soochow Securities Co., Ltd.

Mar 2023 - Present (2 years 4 months)

Managed bond projects across all types, overseeing the entire project lifecycle from due diligence to regulatory communication. Acted as the primary point of contact, coordinating among issuers, rating agencies, and internal departments to ensure efficient project progression. Successfully led/core participated in securing approval and execution for over 30 bond projects, raising cumulative funds

Project Management Financial Analysis Due Diligence Regulatory Compliance Python Data Automation Risk Management Financial Modeling

AI Data Analyst Intern

Hangzhou Guandata Co., Ltd.

Sep 2022 - Feb 2023 (5 months)

Collaborated with LVMH on AI data analysis projects related to product recommendation and customer acquisition, building dozens of related workflows and ETL framework processes. Utilized Python and SQL for data cleaning, quality-checking, and analysis, establishing hundreds of data quality check rules. Extracted data from the data warehouse to perform post-processing calculations and analysis, bui

Data Analysis Python SQL ETL Data Cleaning Data Quality BI Reporting Customer Acquisition Forecasting

Education

Degrees, certifications, and relevant coursework

Columbia University

Master of Science, Applied Analytics

Grade: 3.6/4.0

Activities and societies: Core Courses: Machine Learning, SQL, Python, Probability and Statistic

Completed a Master of Science in Applied Analytics, focusing on advanced data analysis and predictive modeling. Developed expertise in machine learning, SQL, and Python for practical application in various industries.

Columbia University

Bachelor of Arts, Economics

Activities and societies: Core Courses: Applied Econometrics, Micro/Macro Economics, Research

Pursued a Bachelor of Arts in Economics, gaining a comprehensive understanding of microeconomic and macroeconomic theories. Applied econometric methods and conducted research to analyze economic trends and policies.

Columbia University

Bachelor of Arts, Psychology and Social behavior

Grade: 3.54/4.0

Activities and societies: Core Courses: Industrial & Organizational Psychology, Research Design, Strategy and Analytics

Earned a Bachelor of Arts in Psychology and Social Behavior, with coursework emphasizing industrial and organizational psychology. Developed strong analytical and research design skills, applicable to understanding human behavior in organizational contexts.