Financial Analyst Data

Qianwen Xing

979-***-**** *******@*****.*** linkedin.com/in/qianwen-xing

EDUCATION

Texas A&M University College Station, Texas

Master of Science in Economics (STEM) August 2018-May 2020 Honor: Texas A&M Economics Scholarship GPA:3.7/4.0 Courses: Distribution Theory, Economic Forecasting (Time Series), Accounting Procedure, Financial Econometrics Central University of Finance and Economics April 2020- Dec 2020 Minor: Accounting (21 credits)

Shanghai University of Finance and Economics Shanghai, China Major: Banking and International Finance, Bachelor of Economics September 2014-June 2018 WORK EXPERIENCE

C&Y GLOBAL, INC Houston, Texas

Financial Analyst May 2020-present

Recorded $2,000,000+ funds in AR and AP with QuickBooks on the daily basis. Reconcile and highly detailed analysis of client accounts receivable& payable invoices to ensure completeness and accuracy payments.

Prepared comparable monthly expense reports and maintain key monthly metrics and statistics related to variance explanation, benefit plan change impacts, vendor costs, warehouse supplies. Analysis for each location on scenario analysis to help the supervisor reduce $10,000+ expenses.

Creation of specified spreadsheets and reports using Microsoft Excel (pivot table & VBA) to aid in data analysis.

Estimated the cost of debt financing of a company. FOUNDER SECURITIES RESEARCH INSTITUTION Shanghai, China Financial Research Analysis May 2019-August 2019

Recorded 30+ important industries workshops, such as real estate, health cares, energy and chemical industries.

Use SQL to analyze 20+ financial institutions’ information; Researched on investment styles of fund managers by studying their asset portfolios in both fixed income and stock markets.

Collected information from Financial Statements and Financial Statement Notes of the target company including EBITDA, working capital, current ratios, quick ratios.

Researched on markets and industries, including structures, chains and companies. ABN AMRO BANK N.V. Shanghai, China

Financial analyst intern March 2017-July 2017

Investigated background, business and project of borrower-side company. Recorded the transactions between clients and the Bank. Updated the large and important changes in client’s company, including board, operation, finance, guarantees and collateral changes.

Assisted senior managers in risk reports.

PROJECTS

Using Logistic Regression model to Forecast Probability of U.S. Economic Recession in R

Data mining and cleaning from Yahoo Finance; Used Logistic Regression model to fit the spread of 10-year and 3- month treasury bond yield in order to predict the probability of the U.S. economic regression in 2019; Conducted back testing with fixed windows, rolling windows and recursive windows.

“Sports Bar” Market Analysis in SAS

Implemented SAS to analyze Texas alcohol drink market data and used income analysis, survive analysis and ARIMA model to predict future sales based on present evidence and chose the benchmark for location decision of new sport bars in Texas.

Using Time Series Model to Predict Stock Prices of PDD in Python

Extracted and uniformed PDD’s closed stock prices in 2019 from Yahoo Finance; Separated data into controlling groups and experimental groups. Measured VAR models to predict future stock prices in three months in order to control the risk of the portfolio and provide buy or sell suggestions for operating in the stock market.

SKILLS

Familiar with MYSQL, VISIO, Python (Pandas, Numpy, Matplotlib, Statsmodels), STATA; SAS Advanced Certificated.

Advanced knowledge of EXCEL (PivotTable, basic functions, vlookup,VBA), Outlook. CFA level II candidate, FRM level I candidate, knowledge of CAPM, Risk Modelling.

Contact this candidate