Financial Analyst Equity Research Analyst

Yu, Xinyi (Charlotte)

Education New York City, NY10016 adlpq6@r.postjobfree.com 408-***-****

Fordham University, Gabelli Business School New York, USA M.Sc., Global Finance GPA: 3.83/4.0 Aug. 2019 – Feb. 2021

• Relevant Core Courses: Computational Finance, Financial Modeling, Financial Econometrics, Econ-tech: Econ & Data Mining, Advanced Portfolio Management, Fixed Income Securities, Global Financial Markets, Merger & Acquisition, Value Investing

• Honors: Dean’s Scholarship

Zhejiang University of Finance and Economics (ZUFE), School of Accounting Hangzhou, China B.A., Business Administration Major: Accounting GPA:3.74/4.0 Sep. 2015 -Jun. 2019

• Relevant Core Courses: Linear Algebra, Macro/Micro-economics, International Economics & Finance, Monetary and Banking, Advanced Financial Management, Asset Appraisal, Statistics & SPSS

• Honors: Second Class Merit Scholarship, Third Class Merit Scholarship, Outstanding Individual of ZUFE Columbia University, School of Professional Studies New York, USA Exchange Study GPA:3.80/4.0 Sep. 2017 – Dec. 2017

• Relevant Core Courses: Options and Futures, Security Analysis Experience

Botticelli Capital Partners LLC New York, USA

Equity Research Analyst Aug. 2020 – Nov. 2020

• Stocks covered: Marriott (MAR), Netflix (NFLX), Chipotle (CMG), Parker Hannifin (PH), Zoetis (ZTS)

• Conducted fundamental due diligence and financial analysis on investment opportunities

• Gathered and analyzed data, including but not limited to SEC/regulatory filings such as 10Ks and 10Qs, industry publications and bulge bracket firm researches

• Developed financial models for estimation and prediction of corporate performance, using advanced tools in Excel and Python

• Wrote investment theses derived from financial models and participated in meetings with management team Bosch Packaging Technology Hangzhou, China

Financial Analyst (CTG) Mar. 2019 – Jul. 2019

• Tracked project details and progress in SAP and performed cost controlling activities on projects

• Worked on monthly planning, which lay the foundation of all monthly work for the whole department

• Assisted in monthly and quarterly budgeting and forecasting

• Analyzed and reported monthly expenses and capital expenditures, etc.; reported patent royalties to managers in Germany

• Took charge of other monthly report: Account Receivable, Account Payable, Remuneration, After-delivery Posting and etc.

• Worked with HR Dept. to launch a sharing platform for better cooperation among all departments Pan-China Certified Public Accountants Hangzhou, China External Auditor Jul. 2018 – Aug. 2018

• Participated in the auditing processes of 5 companies in total, including 1 IPO company

• Took charge of manuscript writing of financial expenses, management costs and non-business revenue and expenditure

• Took cut-off test of raw materials and inventory, test of sales revenues and received payments, checked PPE and pipelines

• Went through bank inquiries, document supplement and data validation and collected materials to test the integrity of records CITIC Securities Zhejiang, China

Summer Intern Jul. 2017 – Aug. 2017

• Assisted in Risk Tolerance Assessment, maintained clients’ relationship and provided investment suggestions AXA Hong Kong Hong Kong, China

Financial Analyst Feb. 2016

• Team-worked on “Hedging Funds & Stock Analysis Project”, doing equity analysis, establishing investment portfolios and predicting stocks prices

Research & Projects

M&A analysis, Fordham University Sept. 2020 – Oct. 2020

• Team-worked in M&A cases: Genzyme & Sanofi, Heinz & 3G, Berkshire Hathaway, Masonite & KKR MAR stock analysis, Botticelli Capital Partners LLC Aug. 2020 – Sep. 2020

• Analyzed past 15-year 10Ks and 10Qs, recent quarters’ earnings calls and researches from bulge bracket firms for the forecast of Revenue Drivers and Income Statement

• Built financial models to get the appreciation of Marriott and wrote investment thesis Factor Analysis on Chinese Market, Fordham University Feb. 2020 – May. 2020

• Using MATLAB to replicate “Will Your Factor Deliver? An Examination of Factor Robustness and Implementation Costs” by Noah Beck, Jason Hsu, Vitali Kalesnik and Helge Kostka on Chinese stock market

• Cleaned database contained with 3845 stocks’ information from Dec. 1967 to Dec. 2019 and regrouped stocks into large, small and full samples

• Analyzed the impact of 6 factors (low beta, value, size, momentum, illiquidity and quality) on stock performance (stock returns, volatility, Sharpe ratio)

ETF Investing Suggestions during Recessions, Fordham University Apr. 2020 – May. 2020

• Analyzed XLE, XLI, XLF, XLK using Tableau, showing their performance in recessions in box & whiskers; compared with 10Y-2Y yield curve and PMI; provided investing suggestions

Impacts of COVID-19 on FAANG stock return, Fordham University Apr. 2020 – May. 2020

• Defined independent variables such as dummy variable, IWF price, lagged stock prices, 10Y-3M yield curve and S&P 500, applied ADF test on time-series data, utilized logarithmic process on non-stationary time-series sequence and applied first-order difference in logarithmic variables, ran regressions using Python and wrote analysis thesis Textual Information Analysis Project, Fordham University Apr. 2020 – May. 2020 Team Leader

• Built a dataset about film reviews, using NLP (Natural Language Programming) for textual analysis on Python

• Cleaned the reviews by negation handling, punctuations’ and stop words’ removing, stemming, lemmatization and tokenization, changing the words of different tenses and forms into their morphological roots and separated them into meaningful word

• Did sentiment analysis & dictionary-based approach for emotion analysis, color analysis and possible climate and political analysis

• Built a training library and did LDA and Word2Vector and wrote analysis thesis Competitions

SUIBE Financial Elite Contest May. 2018

Team Leader, represented Zhejiang Province and won the third Prize in Shanghai

• Analyzed the financial model for Suning Online Shop and concluded financial conditions of private enterprises in China ACCA JHC (Job Hunting Competition), Semi-Final Apr. 2018 Team Leader

• Delivered an English analysis report and applied ACCA related knowledge into case analysis (Reasons behind Tencent and Alibaba’s less impact in the U.S. and Europe market; Arguments on the importance of new ideas and profitable ideas; Challenges for family businesses in China to create future-proof wealth; Key factors for overseas businesses like Walmart, Home Depot to success in China)

KPMG Cup Simulation Accounting Firm Contest, Semi-Final Apr. 2018

• Analyzed shared-bike business models and markets in China and provided improvement suggestions ERP Contest (Simulated Company Operation) Mar. 2018

• Built a simulated company and put forward forecast and development strategies based on market conditions Additional

Languages: Mandarin (Native), English (Fluent), Japanese (Basic) Skills: Tableau, MATLAB, Python, SQL, MS Office Suite, Bloomberg, Julia, IBM SPSS Statistics, SAP Certificates: Advanced Diploma in Accounting and Business; the Association of Chartered Certified Accountants (12/13); Qualification Certificate of Fund; Qualification Certificate of Accounting; Qualification Certificate of Securities Activities: Member at Columbia University Women’s Ultimate Frisbee Club; Voluntary teenager golf coach; Deputy Director of the Department of Public Relationship, Students’ Association Union of ZUFE

Contact this candidate