Siqi Xu

Business Analyst at 交通银行
  • Claim this Profile
Contact Information
us****@****om
(386) 825-5501
Location
CN

Topline Score

Topline score feature will be out soon.

Bio

Generated by
Topline AI

You need to have a working account to view this content.
You need to have a working account to view this content.

Experience

    • Business Analyst
      • Jul 2021 - Present

    • China
    • Investment Banking
    • 1 - 100 Employee
    • Quantative Analyst Intern
      • Oct 2020 - Feb 2021

    • China
    • IT Services and IT Consulting
    • 200 - 300 Employee
    • Data Analyst Intern
      • Jul 2020 - Oct 2020

      • Responsible for monitoring the target investment targets of Ant Financial, analyzed the user conversion funnel of each channel, optimized the conversion process of the channel, and performed ABtest on the conversion page and analyzed the test results, improved the page conversion rate, used Tableau to make a Kanban to visually analyze the results of user conversion detection; • Analyzed the main characteristics of converted users, and filtered potential target groups based on data such as gender, city, age, account balance, and repayment status; • According to Ant Financial’s advertising space location, CTR, recall rate and other data, rated each advertising space, and the scores are normalized to be controlled in the numerical range within 0-1; and the unit price per thousand exposures of the advertising space is normalized and the score range is controlled within 50-100.

    • Hong Kong
    • Banking
    • 700 & Above Employee
    • Business Analyst Intern
      • Jan 2019 - May 2019

      • Reported, analyzed and predicted the current economic situations to upper managers every day. • Analyzed several companies’ financial status and built models to analyze their operating scale/ repayment ability and how high the risk of bad debts was in order to decide whether to issue loans to them and the size of the loans. • Proposed a portfolio plan of 10 million dollars with group members by analyzing and leveraging the potential risks and earnings according to customers’ demands, and also, built multiple business models in R (eg. linear regression, random forest) to test the feasibility of the plan.

    • China
    • Investment Banking
    • 1 - 100 Employee
    • Investment Banking Intern
      • Jul 2018 - Oct 2018

      • Analyze the financial statements of client companies, assess the risks of acquisitions, and predict the possible changes in stock prices and the possible impact of expected acquisitions on the company by establishing multiple models in R. During the period, due to large fluctuations in the stocks of listed companies, the value of the shares issued by the target company to raise supporting funds decreased, resulting in a weakening of the target company’s intention to sell. As an independent third-party financial institution, we mediated it and eventually contributed to the assets Completion of mergers and acquisitions; • Analyzed the financial indicators of listed companies, and conducted independent investigations on the asset restructuring of listed companies, and give independent opinions on the operating conditions of listed companies and target companies for reference by the CSRC; • Collected relevant materials and wrote industry analysis and project approval instructions; • Completed a group project that assisted a Shanghai- based company in its Initial Public Offering.

    • Analyst Internship
      • Jul 2017 - Sep 2017

      • Assisted manager to investigate financial, business and legal issues and conduct in-depth research on listed companies, including collecting and analyzing financial statements and records; • Learnt to conduct data analysis and macro-environment analysis for industry research; • Presented the data results using data visualization and Tableau. • Assisted manager to investigate financial, business and legal issues and conduct in-depth research on listed companies, including collecting and analyzing financial statements and records; • Learnt to conduct data analysis and macro-environment analysis for industry research; • Presented the data results using data visualization and Tableau.

Education

  • 美国哥伦比亚大学
    Master of Science - MS, Applied Analytics
    2019 - 2020
  • 上海理工大学
    Bachelor of Business Administration - BBA, Business Administration (Sino-US joint program)
    2015 - 2019

Community

You need to have a working account to view this content. Click here to join now