Experience

• 

  Yanfeng adient seating

  Jul 2020 - Sept 2020

  Data bi intern

  • Contributed to the development and maintenance of critical company databases, ensuring high standards of data accuracy and reliability• Performed detailed data analysis to evaluate sales performance across various automotive companies, aiding in strategic supplier profile development.• Utilized SQL and Excel for advanced data processing and analysis, delivering actionable insights and comprehensive reports.

• 

  Everbright securities

  Mar 2021 - Aug 2021

  Ibd intern

  • Contributed to the investment and financing of state-owned enterprise bonds, playing a key role in deals totaling over 5 billion RMB.• Engaged in the issuance of 6 major projects, handling the preparation of bidding documents, filing materials, and roadshow plans, thereby enhancing project management efficiency and documentation accuracy.• Conducted thorough verification and investigative analysis of work documents, ensuring the accurate and timely execution of tasks, and provided regular progress reports to supervisors, demonstrating strong project tracking abilities. Show less

• 

  The university of edinburgh

  Jan 2023 - now

  • Delivered comprehensive lectures on cryptography, covering symmetric and asymmetric encryption, and hash algorithms, significantly enhancing students' knowledge base.• Led practical sessions for 20 students on TLS/SSL and SSH protocols, promoting hands-on experience in secure communication methods.• Provided in-depth guidance on network and system security principles, focusing on practical applications of authentication, access control, and vulnerability assessment.

  • Postgraduate Student

    Sept 2019 - now

  • Course Tutor, Computer Security

    Jan 2023 - May 2023
• 

  Alibaba group

  Jul 2023 - Sept 2023

  Data analyst

  • Enhanced MySQL database by adding over 80k records, utilizing Python’s pymysql for integration with the company’s cloud database. Executed comprehensive data processing tasks including outlier detection, blank processing, and dimension screening to optimize data for business analytics.• Spearheaded the development of a user analysis table through data segmentation, cleaning (10k to 35k daily), and summarization, automating the process for 4 am daily execution.• Integrated revenue data with FineBi for strategic customer value analysis. Classified revenue channels based on RFM principles, identifying key customer segments and analyzing revenue distribution and population profiles across various pricing tiers. Show less

• 

  Guosen securities

  Jul 2024 - now

  Quantitative research intern

  • Market Research: Participated in research on the fixed income market, analyzing macroeconomic data and bond market trends to support investment decisions. Proficient in using financial data platforms such as Wind for market data retrieval and analysis. Assisted in completing a detailed analysis report on the corporate bond market.• Quantitative Analysis: Utilized Python and Excel to handle large datasets, conduct quantitative analysis, and develop models for predicting returns and risks. Successfully identified and proposed an improvement to the existing investment strategy, which enhanced portfolio returns. Show less