/

MIN CAO

adcmmj@r.postjobfree.com 515-***-**** Palmdale, California 93550

SUMMARY

1.5 years programming experience with multiple programming languages using knowledge of Finance, data analysis, and mathematical skills Good financial modeling skills. And have ability to create complex financial models and financial planning and analysis reports Excellent problem-solving skills gained from various projects, always eager to learn and try new projects and challenges Strong interpersonal teamwork skills, great self- direction and time-management gained from work experience FINANCIAL MODEL: CAPM using Fama- MacBeth, Volatility model, Garch model, Monte-Carlo simulation, Binomial model, VaR for options and portfolios, Back testing COMPUTER: Proficient in Python, SAS, SQL( SQLITE), Data Visualization( Tableau), Excel( Pivot table) SKILLS

EMPLOYMENT

M&C Agency, Financial Analyst, Palmdale, California 2020 - Current Communicate with clients, collect all information about clients' incomes and outcomes Help clients to control their monthly budget by determining where their money going Make budget report in details to clients, and help them identify areas they can improve Dongguan Securities Co., Ltd, Investment Analyst Intern, Dongguan, China May 2018 - Aug. 2018 Conducted couple company profile including industry overview, competitive landscape, and valuation analysis Worked with rating agency to obtain the issuer's credit rating using SAS(SQL), including creating rating agency presentation Cooperated with lawyers and auditor in drafting the offering circular, responsible for business and financial report sections Applied VaR calculations in the EXCEL to measure firm-wide risk exposure and determined the potential for loss in entity being assessed Zhongye Geographic Information Co., Ltd, Budget Analyst Intern, Guangdong, China Feb. 2018 - Apr. 2018 Input cost data display in Pivot Table to calculate cost of inventory, product and service for every season about 14 million RMB Created the implementation of the monthly cost and budget plan to let CFO understand Prepared cost accounting statement based on FIRS for income statement monthly to observe, analyze and assess budget plan and predict cost for next period Prepare bidding material, assisted in drafting the company 's quoted price for 1 million RMB government contract Iowa State University, Teaching Assistant, Ames, United States Aug. 2014 - Dec. 2014 Held office hours to review and explain problem for economics course prepared answer sheets and graded homework and exams PROJECTS

DATA ANALYZE FOR INSURANCE COMPANY'S PRICING Jan. 2019 - Apr. 2019 Identified how to calculate home insurance policy, and created pricing model to make sure it can adequately cover losses, internal expense and hit profitability target Pulled data from multiple data source and perform data in EXCEL and SAS Developed regression model using EXCEL and SAS to identify base rate and to validate model factors Designed scenarios analysis to predict policy price for different house types and created dashboard and parameters in Tableau Provided recommendation and help company to correctly and precisely set policy price PYTHON APPLICATIONS Aug. 2019 - Dec. 2019

Developed a trinomial model's algorithm using Numpy to value specific European and American calls and puts. And drawn figure showing n-periods price of the call and put by using Matplotlib

Handled data in Pandas, grabbed rows and columns data using loc and iloc, created functions to apply on data, summarized and graphed data in many ways Designed a new stock index linked structure notes, loaded historical data from Yahoo, and took sensitivities analysis, market analysis by using multiple Functions to support in developing and describing issues faced in its design EDUCATION

Case Western Reserve University Aug. 2018 - Jan. 2020 MSM-Finance Risk Management

Award: Merit- Scholarship

Iowa State University Jan. 2014 - May 2017

Bachelor of Science Economics and Mathematics

Award: Dean's List: 2014, 2015