- Compiled 30 dossiers of archives in 2019 and established lookup tables using Excel;- Organized and archived more than 500 contracts, and completed the contract database; - Sorted out the supporting documents for annual inspection of the People's Bank of China etc.

- Collected and organized the data in insurance contracts;- Translated insurance clause;- Exported and sorted out the yields of main crop in the Northeast China using ArcGis;- Organized the “Agricultural Index Insurance” products of Taiping and China Life Insurance Company and established database;- Collected resources of seed potatoes in Gansu Province and made comparison with foreign countries;

- Carried out analysis and management of customer resources and information;- Undertook the business objectives of new insurance and renewal;- Developed customer business plan.

- Collected data of 100 American insurance companies, and analyzed the development of American insurance industry; - Set different parameters and indicators to conduct correlation analysis of data; - Conducted big data analysis using Excel and R; - Made independent study about public sentiment analysis and wrote formal research report.

- Sorted insurance policy and agents files;- Inspected and explored vehicle accidents.