• Delivering assignments and office hours for course 17637 (Web Application Development)• Building real-time framework to automatically test and grade students' coding assignments

• Constructed and optimized 20+ data query scripts to calculate 200+ metrics, and built automatic data-wrangling pipelines using Hive and Python Pandas to improve efficiency• Designed and configured event tracking to record drivers and passengers interactions with new features, and improved users’ click-through rate by AB-testing experiments collaborated with algorithm team• Detected the abnormal loss of Mexican drivers by monitoring key metrics on a daily basis; Broke down the decreasing trend, located the root cause using SQL, and informed ops team the risk of competitor’s pricing strategy in advance.

• Provide business support to premier client-China Resources Vanguard Co. Ltd; obtain sales data through the internal database(Nielsen Answer Desktop); create 10+ monthly reports of business review, category review and market comparison analysis; propose improvement suggestions based on sales performance• Assist three different teams’ analysts to provide new item report and assortment report for retail clients including baby stores, convenience stores, and supermarkets; help clients launch profitable combination of products• Build up structured templates to automate the process of 30+ reports making; shorten 30% respond time when retrieving queries and save up 5+ hours per week

• Surveyed the current situation of Guangdong Power Grid Corporation's IT sharing service center construction project; collected customer needs, and created a feasible construction plan• Analyzed the share-service construction path and profits of ZTE, Sinopec and Haier Group; finished practice analysis and feasibility report and offered reference and samples for customers to build IT sharing service center