Business Analyst
* Accelerated the due diligence with the supervisor towards 4 target companies and composed the reports about economics, industry, companies, and consumers before the investment.* Integrated raw data with SQL and vlookup and generated weekly reports of the AI industry by collecting industry news, predicting involved stock prices, and analyzing block trading.* Collected market trend information and financial metrics of comparative companies in the stock market to calculate Beta and WACC for the private company and conducted Comparative Company Analysis and Discounted Cash Flow Analysis for valuation. * Constructed different combinations for investment and calculated the annualized volatility, max drawdown, and Sharpe Ratio with the price of indexes for 14 years.* Accomplished 1 report of 10 projects about AI and implemented research about development trends, market opportunities, and the experience of management group with Wind, Compustat, and Factiva.* Briefed the financial statements to construct a spreadsheet for calculating financial indicators and visualized the difference in profitability, operating capability, and risk with Excel.