Alan Yan Email & Phone Number

Ch

Provide monthly and quarterly reports to Property Board, Risk and Underwriting Committee, Regulatory and Rating Agencies. Provide complex analytical insights into the overall group portfolio or subset portfolios, designed to help the company effectively manage its catastrophe exposures.

Irvine, Ca, Us

• Use Microsoft SQL Server to extract, transform, and load large datasets into the CoreLogic RQE (Risk Quantification and Engineering) natural catastrophe risk modeling software. This includes converting clients' RMS EDM databases to load into RQE.• Perform a 2018 flood risk analysis for Federal Emergency Management Agency (FEMA) to update flood insurance rates for the National Flood Insurance Program (NFIP).• Manage and perform the annual Florida Hurricane Catastrophe Fund (FHCF) project for the State Board Administration of Florida to estimate hurricane losses.• Manage and perform the semiannual earthquake analysis for the California Earthquake Authority (CEA).• Perform wildfire catastrophe bond risk analyses for 3 major California electric utility companies.• Support issuances of Insurance-Linked Securities (ILS) and catastrophe bonds.• Proficiency with ArcGIS Pro GIS software to spatially evaluate clients' portfolio assets in relation to natural hazard locations and geopolitical boundaries, and to create attractive maps for reports and presentations.

Spring, Tx, Us

• Worked in the EQECAT subsidiary performing natural catastrophe risk analysis projects using the WORLDCATenterprise risk modeling software.• QA testing for model verification / validation.• Advanced Excel skills to process data.• Support due diligence calls and meetings by creating presentations that deliver complex data and concepts to clients in an easy to understand manner.• Build data visualizations using QlikView.• Prepare product release documents which include changes compared to the previous version of the product.• Use QGIS to map site locations, earthquake faults, and hurricane tracks, and to create maps for reports.• Help maintain the servers and computers in our office by solving software and hardware issues.