Special Education Data Analyst

Yiyi Xu

****.**@*****.*** • 832-***-**** • linkedin.com/in/yiyi-amber-xu

Professional Summary

• Prove ability of defining problem statements and creating models, and reporting results to clients.

• Two years of experience in data analysis, risk management, statistics, forecasting and estimation.

• Experience with SQL, R and Tableau.

• Capable of providing leadership in teams and also capable of integrating team members together from multiple departments, by using verbal communication skills. Education

University of Connecticut, Storrs, CT

Master of Science, Applied Financial Mathematics-Actuarial Science, December 2019 GPA:3.9/4.0 Relevant Courses: Statistical Computing (R), Mathematical Statistics University of Maryland, College Park, MD

Bachelor of Science, Mathematics-Statistic, December 2017 GPA:3.4/4.0 Relevant Courses: SAS, Object-Oriented Programming, Matlab, Numerical Analysis, Mathematical Logic Technical Skills and Certification

Programming Languages: Excel/VBA, SQL, Tableau, R, SAS, JavaScript, MATLAB, Python Excel Skills for Business Advanced(Pivot tables, Lookup, If statement): Completed May 2020 at Coursera.org SAS Programmer: Three Course Certification track completed April 2020 at Coursera.org Python for Everybody: Five Course Certification track completed August 2020 at Coursera.org Related Experience

Ping An Health Care Insurance (Group) Company of China, Shanghai, China Data Analyst Intern, March 2018 – July 2018

• Analyzed historical five-year data of medical expenses of patients with chronic diseases using R and designed a model to recognize potential customers qualified for health insurance among the patients.

• Wrote complex SQL Queries to analyze large datasets and answer business questions for multiple departments.

• Created a model in R to track and monitor the claim experience (Actual-To-Expected ratio) for different product lines.

• Performed calculations with advanced formulas and functions to help make informed business decisions, using Excel. The Janet & Mark L. Goldenson Center, UConn, Storrs, CT Student Research Assistant, December 2018 – Current Actuarial Funding Model in Special Education Cost

• Designed and built a pre-fund model to predict the future special education cost for 166 districts in Connecticut for Connecticut’s Special Education Department, using R.

• Incorporated Credibility Theory and the pooling principle to the model, which resulted in 15% reduction of volatility of the average special education cost per student in each district, while ensuring overall solvency in aggregate.

• Gave a presentation as a representative at the Annual Goldenson Center Board Meeting. Dynamic Retirement Financial Planning Project

• Developed a stochastic financial planning model to maximize retiree’s discretionary expenses while ensuring basic expenses of retirees’ healthy or unhealthy status.

• Applied Multi-Year Guaranteed Annuities to the retirement portfolio and increased optimal annual withdrawals by 10%.

• Applied Kalman Filter algorithm to the recalibration process to make the model more effective in reflecting the impact from the investment market, which minimized the ruin probability to near 0%. Second-to-die Claims Project

• Created a model to project the expected claims and reserves of the second-to-die product under the assumption that insured’s mortalities will be affected by the loss of spouse, which increased the accuracy of the prediction.

• Designed Chi-index which can calculate the impact of loss of spouse on individual’s mortality, incorporated various individual characteristics like gender and age.

• Used grief counseling treatment to increase the life expectancy for widow/widower; saved 21% on next year ‘s expected claim and 5% on reserves.

Contact this candidate