Xiongfei (Jimmy) Ding
** * ***** **, *** York, NY. 10025 ● 312-***-**** ● ******@********.***
EDUCATION
.
Columbia University, MS in Actuarial Science; GPA 3.65; New York, NY Expected Dec 2017
University of Illinois at Urbana-Champaign, BS in Actuarial Science; GPA 3.81; Urbana, IL Dec 2015 ACTUARIAL EXAMS (SOA/CAS) AND OTHER CREDENTIALS
Exams: P, FM, MFE, C; CFA level II Candidate; VEE Fulfilled: Applied Statistics, Economics, and Corporate Finance. Computer Skills: Excel, VBA, R, SQL, Tableau and C++ PROFESSIONAL EXPERIENCE
Blue Cross Blue Shield of Michigan/AF Group - Actuarial Intern; Lansing, MI May 2017-August 2017
• Audited Loss Cost and Loss Cost Multiplier filings to rating agency; facilitated the process with SQL and R corrected over 8,000 discrepancies and improved data accuracy by 5%
• Calculated and mapped Loss Ratios Relativities per zip code in California by territories using Tableau, helped senior management visualize the historical Loss Ratio difference for better ratemaking decision
• Applied Logistic regression to forecast percentage change in Indemnity Frequency, Indemnity Severity, and Medical Severity with NCCI (National Council on Compensation Insurance) data for loss trend analysis
• Created 100 uniform distributed bands on new and renewal business for 50 states based on predicted loss ratio in VBA and R to support pricing and underwriting decision
• Selected loss development factor in loss triangle with ResQ, to help with company reserving Bank of Communications Co., Ltd.- Risk Management Intern; New York, NY September 2016-December 2016
• Generated a Country Risk Report of Mexico on economy and growth for senior management
• Identified insufficiency of cyber security against OCC regulatory and provided improvement recommendations to senior management
• Worked with the PwC cyber risk consulting team to improve the current compliance code China Securities Co., Ltd. - Bond Underwriting Intern; Beijing, China January 2016-June 2016
• Worked with a team to facilitate a $200m Principal Protected Note (PPN) issuance for a client
• Performed Financial Statement Analysis for four prospectuses including two Corporate Bonds and two PPN to aid the successful initiation of the bond issuing process
• Analyzed market, liquidity, and credit risk of a bond issuer and ensure all the factors are disclosed to potential investors and properly addressed
• Participated meetings with China Security Regulatory Commission (CSRC, equivalent to SEC) and obtained bond registration approval for a real-estate client
PwC - Management Consulting Intern; Beijing, China June 2013-August 2013
• Assisted a top tier U.S pharmaceutical company to standardize their business procedure to avoid potential bribing situation and comply with relevant laws and regulations
• Participated in customer meetings and took detail logs on incompliances with formal meeting structure ACTIVITIES .
AXIS Student Challenge Second Place - Team Leader; Urbana, IL September 2015-December 2015
• Created a model in R that successfully predicted the expected loss from Security Class Action of a single company with a dataset containing over 40,000 companies’ information
• Utilized Logistic Regression, Random Forest, and Linear Discriminant Analysis on frequency model (ROC as criteria); and linear regression and Principal Component Analysis (PCA) on severity model (MAPE as criteria). Actuarial Project - Research Assistant; Urbana, IL August 2015-December 2015
• Developed a stochastic pricing model for Guaranteed Minimum Withdraw Benefit (GMWB) products with Monte Carlo simulation