Allen Xiangwen Lan is a AIAA, Actuarial Consultant at Sunlight Consulting. He is proficient in English.
-
Actuarial ConsultantSunlight Consulting Aug 2020 - PresentPudong, Shanghai, China• Based on past claims data, conducted one-factor analysis, GLM model building, evaluation and explanation of models, production of rating table and its validation. • UBI (Usage-based Insurance) research and actuarial modelling program• Developed, maintained, and enhanced automated programs using SAS/Excel VBA, such as extraction of data, linking relevant data, validation/adjustment of rating table, which reduced manual efforts and improved program efficiency. • Vehicle brand and vehicle model risk rating: Based on Random Forest algorithm, developed a set of SAS-run calculation programs that enhance the predictivity power of vehicle brand/model risk models. • Explored other potential risk factors, such as interaction factors, UBI (Usage-based insurance) factors. • Summarised and presented industry research output, such as actuarial reports. -
Actuarial InternAia Technology Shared Services (Aiait) Dec 2019 - Feb 2020Guangzhou, China• Assisted in monthly reporting production run and profit analysis for various AIA business regions using Excel/VBA templates. Mainly responsible for tracing underlying data for abnormal results.• Assisted in the organisation and maintenance of Excel/VBA templates and reporting production manuals. -
InternE Fund Management Co.,Ltd. Dec 2017 - Feb 2018Guangzhou, China -
TutorGlobal Education & Technology Group Dec 2016 - Feb 2017Guangzhou, Guangdong, ChinaWorked in teaching department of Global Education school in Guangzhou for 3 months, during which I taught Edexcel A level Economics to 2 students on one-to-one basis.
Allen Xiangwen Lan Education Details
-
84.667%
Frequently Asked Questions about Allen Xiangwen Lan
What company does Allen Xiangwen Lan work for?
Allen Xiangwen Lan works for Sunlight Consulting
What is Allen Xiangwen Lan's role at the current company?
Allen Xiangwen Lan's current role is AIAA, Actuarial Consultant.
What schools did Allen Xiangwen Lan attend?
Allen Xiangwen Lan attended University Of Melbourne, 澳大利亚墨尔本大学.
Who are Allen Xiangwen Lan's colleagues?
Allen Xiangwen Lan's colleagues are John Kistler, Ziyue Sun, Sunlight Dış Tic, Mahammed Coker, Jeannette Lin, Maxine Zhang, Jiawei Ye.
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial