• Turned routine report work into automation by using R, MySQL and crontab, saving 90% time.
• Made SQL queries to get the target list for marketing campaign.
• Created Excel sales dashboards in order to allow sales team to quickly view and analyze their merchants easily.
• Through inspected transaction record, found a loophole in reward system, and avoided potential loss.
• Assisted Customer Service team to deal with problems from customers.
• Studied user behavior including customer’s motivation, usage habit and scenario etc. and discussed idea with supervisor to check our imagination of customer.