Experience

Redstar Macalline

• China
• Real Estate
• 1 - 100 Employee

• Business Analyst-Intern

  • Jun 2016 - Present

  · Through R programming and SQL queries, pulled and manipulated large sets of data in SAP HANA and Hue to meet business needs. · Visualized data in R and Excel and prepared reports for group presentation.· Worked with the merchant department and developed pricing algorithm to estimate mall pricing and recommend contract price of booths for pricing project. · Built a model for booth evaluation using Principal Component Analysis. · Researched similar auction websites in the market and designed the layout and bidding process tailored for target audience. · Built an interactive prototype for an online auction system using Axure RP.



PICC

• Insurance
• 300 - 400 Employee

• Data Analyst-Intern

  • Jul 2014 - Aug 2014

  · Summarized the historical loss of the company using Excel and SQL.· Did simple risk evaluation judging from the geographical location and risk control. · Summarized the historical loss of the company using Excel and SQL.· Did simple risk evaluation judging from the geographical location and risk control.



Sinatay Life Insurance Co., Ltd.

• China
• Insurance
• 1 - 100 Employee

• Actuarial Intern

  • Jun 2013 - Aug 2013

  · Collected and cleaned data for modelling using Excel and SQL.· Analyzed the life insurance reserves based on different interest rate structure using AR model. · Collected and cleaned data for modelling using Excel and SQL.· Analyzed the life insurance reserves based on different interest rate structure using AR model.