Financial/Data Analysis, Financial Planning/Advisory

YIQUN (ROGER) LI

*** * ********** **. #* Arcadia, CA 91007

626-***-**** ********@*****.***

EDUCATION

• University of California, Santa Barbara – Statistics and Data Science 2015 – 2019 Courses: Regression & Time Series Analysis, Stochastic Model, Monte Carlo Simulation, Machine Learning, Derivative and Bond Pricing, Portfolio Optimization, Accounting, Corporate Finance LICENSES & CERTIFICATES

• FINRA 7, 65, SIE, CA L&H Insurance License

• CFA Level 2 Candidate

SKILLS

• Mandarin, Cantonese, English

• R, Python, SAS, SQL, C++, Excel VBA, Tableau

WORK EXPERIENCE

Mutual of Omaha – Investment Advisor Mar 2020 – Oct 2020 Los Angeles, California

• Met with 250+ clients, determined their financial goals and risk tolerance to develop a financial plan.

• Worked with broker and underwriters on purchase of insurance, equities, bonds, and mutual funds.

• Collaborated with other associates to provide value to the clients through joint appointments.

• CRD#: 7241618

Liberty SBF – Data Analyst (Part-time) May 2020 – June 2020 Los Angeles, California

• Funded 2300+ small businesses with more than $75 million during the Payroll Protection Program.

• Automated data validation and analysis with self-made Excel template and recorded Macros.

• Communicated with loan processors, small business owners and banks on rejected loans.

• Debugged XML code for loan processing.

Bank of China – Loan Internship Jun 2017 – Aug 2017 Shanghai, China

• Assisted senior credit analyst on client data validation.

• Coordinated with sales manager, clients, and accountant on funded mortgages and auto loans.

• Maintained customer relationship via telephone and email.

• Helped transform 3100+ client credit reports into a new system. SELECTIVE PROJECTS

Portfolio Management Sep 2015 – Current

• Developed and implemented an asset allocation strategy using US and global equities, bonds, etc.

• Forecasted returns using R and make any needed tactical shifts to seek near-term opportunities.

• Tracked ongoing performance against benchmark on risk-adjusted basis.

• Earned 43.37% & 56.17% ROI in 2019 and 2020.

U.S. Imports of Goods from China: Time Series Analysis Dec 2018

• Predicted the total amount of import goods from China using methods of time series analysis.

• Used transformation and differencing to eliminate seasonality and trend.

• Chose SARIMA model with the lowest AIC and BIC scores and applied GARCH model as supplement.

• Diagnosed Independence, Normality, and Heteroskedasticity.

• Forecasted values all lie in the 95% CI and mostly closed to the observed value.

Contact this candidate