· Daily monitor data related to ads, analyze the effectiveness and make daily report, including indicators such as "CTR" "Average running time" "Effective exposure time";· Improved SQL statements (Data Manipulate Language), achieved automatic matching of advertising materials, increased the working efficiency up to 70%; · Monitor short video material quality and conversion rate, analyze the commonness of low quality materials and constantly optimize the conversion efficiency of ads.

· Assist RM to open 5 NRA accounts for clients · Analyze customer's solvency according to their financial statements · Independently improved the excel worksheet for quantification of RM's work, realized the automation of analyzing the relevant performance data of RMs, saved 50% labor costs