• Utilized web scraping skills with Python and extracted insurance claim records for 2018 California forest fires, with nearly 50000 records for over 80 billion U.S. dollars in total• Used Excel along with Python to deal with massive data as well as to calculate key metrics like the uninsured losses, which was speculated to be over 700 billion dollars for 2018, and so on• Created financial models to showcase stakeholders/investors it is feasible to introduce a derivative for systematic intervention & prevention methods in order to reduce losses from forest fires• Used Tableau for data visualization, created sheets like fire map etc., and then prepared a dashboard

• Checked information of fund documents for later management• Registered for investors’ shares and rates of return to track their profit allocations• Established profit distribution tables and then distributed profits according to investors’ shares• Carried out valuation on valuation days for future sells and redemptions• Assisted in creating monthly and quarterly statements for review by fund managers and investors• Assisted experienced colleague in creating monthly and quarterly statements

• Opened securities accounts for customers and answered customers’ questions timely• Assisted in sector analysis and financial analysis for investing purposes• Monitored unusual changes/issues in the reports and keep senior leadership informed of such problems• Participated and communicated in projects with different CITIC branches