Yanchao Shen
@yanchaoshen
Data analyst with expertise in AI and financial project management.
What I'm looking for
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
Bond Project Manager
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
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
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.
Tech stack
Software and tools used professionally
Availability
Location
Authorized to work in
Job categories
Interested in hiring Yanchao?
You can contact Yanchao and 90k+ other talented remote workers on Himalayas.
Message YanchaoFind your dream job
Sign up now and join over 100,000 remote workers who receive personalized job alerts, curated job matches, and more for free!
