Qianyi (Sandy) Zhao
**** **** **. *** ***, Davis, CA 95616
*********@*****.*** 267-***-****
Education
Pennsylvania State University University Park, PA
Smeal College of Business
Bachelor of Science in Risk Management GPA: 3.75/4.00 May 2018 Concentration: Actuarial Science
Minor: Statistics
Dean’s List: Spring 2014, Fall 2015, Spring 2016, Spring 2017 Professional Exams
Associate of Society of Actuaries (ASA) Designation Candidate
Exam P: Probability (40% Pass Rate) Passed: January 2017
Exam FM: Financial Mathematics (45% Pass Rate) Passed : February 2017
VEE: Economics Credited: April 2018
VEE: Accounting and Finance Credited: April 2018
VEE: Mathematical Statistics Credited: April 2018
Exam MLC: Long-Term Actuarial Mathematics (35% Pass Rate) Passed: June 2018
Exam C: Short-Term Actuarial Mathematics (43% Pass Rate) Passed: June 2018
Sitting for Exam IFM (Investment and Financial Markets) and Exam SRM (Statistics for Risk Modeling) Experience
Calbay Marble Inc. San Leandro, California
Project Estimator August 2018– Present
Perform data analysis on the company’s construction plans using work breakdown structure
Construct multi-layer mathematical models to automate weekly ETC, project costs, and resource constraints
Spearhead daily communication with clients to establish expectations, enhance deliverables, and review work details
Coordinate with Project Managers to monitor trade partner contracts, track project variances and budget integrity
Expedite responses to RFP’s in a deadline-driven environment, accomplishing a bid-hit ratio of 4:1 Corporate Securities Valuation Case Competition University Park, PA Team Leader Fall 2017
Examined the competitive advantages of the client’s company in today’s financial services marketplace
Assessed the client’s internal and external environments and identified factors affecting the client’s stock price
Performed statistical regression on client’s future performance based on the past data and corporate finance strategies
Refined qualitative and quantitative analysis based on publicly available information from the S&P 500 Index Insurance Pricing Group Project University Park, PA Project Leader Spring 2017
Identified and inquired with key stakeholders to pinpoint the clients’ potential risks and insurance needs
Calculated rating variables for final premiums based on documented mortality, interest, expense, and risk assumptions
Awarded 2nd Place across all participating teams for constructing effective pricing models for premiums Due South Computer Co. LTD Shenzhen, China
Data Processing Intern June 2014– August 2014
Compiled, cleansed, and verified unstructured data from source information using Alteryx
Reviewed data for deficiencies and errors, and resolved information discrepancies in data structure
Bridged the business and IT knowledge gap by preparing tailored data sets for differing information requests Honors & Activities
Mathematics Department Tutor Spring 2017- May 2018
Reviewed lecture materials for 3 advanced courses and held weekly office hours for college-sponsored tutoring
Developed academic strategies for improvement and successfully raised average test score as compared to class average Beta Gamma Sigma International Honor Society Spring 2016- May 2018
Selected as a candidate in the top 10% of a Bachelor’s business program from an accredited school
Participated in the business programs to refine skills and expand professional network Penn State President’s Freshman Award Recipient Spring 2015
Selected as 1 of 40 candidates among a pool of over 400 applicants
Awarded for excellence in academic standing (4.00 Cumulative GPA) upon completion of 36 University credits Skills
Language: English (Fluent), Mandarin (Native), Cantonese (Native)
Technical: Proficient with Microsoft Excel, SAS, Dreamweaver, R, and RStudio Various analytics software exposures including SPSS, Tableau, and Alteryx