BAOCHENG · J

San Francisco, CA 628-***-**** adm7c6@r.postjobfree.com

LinkedIn https://www.linkedin.com/in/baocheng-j-899452189/ SUMMARY

Master student with high ability of self-study and full of enthusiasm in active thinking who aims at finding business/finance analyst opportunities. Adequate project experiences in business intelligence, data visualization and financial analysis. Strong knowledge of data analytics and solid programming skills in Python and SQL.

EDUCATION

University of San Francisco (School of Management) San Francisco, CA Master of Science of Financial Analysis (MSFA) August 2019 - December 2020

• GPA: 3.5/4.0

• Leadership: Leader of program case on students’ ETF foundation Shanghai Jian Qiao University Shanghai, China

Bachelor of Financial engineering September 2015 - June 2019

• GPA: 2.5/4.0

SKILLS & INTERESTS

• Programming: Python (sklearn, pandas, numpy, seaborn, matplotlib), SQL, Matlab

• Tools: Office Software (Excel, PPT), Spark, Bloomberg, Xero

• Analysis Techniques: A/B testing, Decision Tree, Random Forest, Hypothesis Testing, PCA (principle component analysis)

• Certificates & Licenses: CFA Level 2 candidate

• Interests: Guitar, Hiking, Portfolio management enthusiasts EXPERIENCE

NorthMountain Fund Services LLC San Francisco, CA

Fund Accountant Intern March 2021- May 2021 (3 months)

• Learn about the private equity business model and relevant typical companies within the industry.

• Check and update quarterly financial data (from Balance Sheet, Income Statement, Cash Flow Statement) into the financial analysis model for each company.

• Go through and derive main information from Limited Partnership Agreement and for the fund clients.

• Using Xero to check bill balance and reconcile bank statements in different accounts for clients' companies.

• Write a working report summary each day.

PROJECT

New structure notes product construction (CPPI)

• Fix income selection for structure note’s base.

• Develops the rationale of getting into stock market as keeping principal stable (Using the interests of capital to buy stocks’ option).

• Market research to find the most suitable option considering stock volatility and option price.

• Data analysis (This need use Excel to process the historical price data computing SD and through BS model generating future volatility prediction)

• Scenario test: Simulates the result under two different market situations (Both bullish and bearish possibility)

• Marketing art to make our product easier to understand and attractive as well (While keep the capital safe take piece of cake of stock market when bullish market).

• Writes the brochure and packs our new structure note product to the public and sell it. San Francisco Crime Analysis in Apache Spark

• Performs spatial and time series analysis for 5 years’ dataset of reported incident from SFPD.

• Builds data processing pipeline based on Spark RDD, Dataframe and Spark SQL for big data OLAP in Databrick.

• Trains and fine-tunes an ARIMA model to forecast the number of theft incidents per month among districts.

• Explores and visualizes the variation of spatial distribution of different incidents over time.

• Gives constructive suggestions to SF police office based on the visualization of data. Amazon Prime Video view time prediction

• Works on Amazon Prime video dataset and builds a forecast model in Python to predict video view time.

• Develops exploratory data analysis and preprocesses raw sales and product data via dealing with handling values, categorical feature encoding and feature scaling.

• Builds linear regression and random forest model and evaluates the model through multiple metrics.

• Gets the most suitable prediction model based on RMSE and identifies the key factors for Amazon Prime Video view time.

• Gives Amazon senior manager some constructive advices for improving their website. (e.g. Focusing on IMDB votes and weighted vertical position)

Contact this candidate