Intern Data analyst.Independently developed five web-crawling algorithms, enabling investment managers to acquire data from websites directly.

Intern. Provided data-based consulting service about employee health and benefit for big companies, as well as designed and tested benefit systems updates with small databases. Collected and processed 100,000+ customer data and conducted the analytics. Offered client reports on a regular basis. English is working language.• Operate and maintain benefit system daily, providing benefit products for large companies such as Bayer and Cooper Standard. Collaborated with associate to make 100+ email contact with both vendors and clients.• Processed 10,000+ piece of consumer data about different dimensions of benefit product sales with Microsoft Excel pivot-table and Google Analytics service. Introduced usage of PowerPivot accessory to save 25% work time. Designed templates for data reports on different basis of time period for further discussion.• Put forward innovate suggestion to add office supplies to benefit menu, which becomes top-10-sale products.

Intern. Audited accounting statement and internal costs. Compiled internal auditing regulations and wrote a department manual. Examined updates of gold exchange system with department manager.• Arranged preparation work to receive annual inspection of Central Bank in August 2016. Lay down timeline reminder for project and assigned work for employees. Found and corrected a fatal mistake on receiving the Inspection Group from the Central Bank.• Collaborated with a law firm, finally saved USD15,000 litigation fees of the company by winning.