-Performed in Python exploratory analysis (data interpolation, consolidation, etc.) on sales and consumer behavior data of 19 e-stores within identical category-Conducted polynomial regression on daily new consumers, purchases, retention, repurchases, and bounce rate to evaluate efficacy of each step in the AARRR model, and calculated consumer value and ranking per the RFM model-Provided processed data for 5 departments including product, marketing, CRM and so on

-Participated in the OPPO Phoenix Project to construct a digital infrastructure including all business areas, boost organizational operating efficiency, and implement digital transformation-Developed batch processing in lambda architecture, performed the Extract-Transform-Load (ETL) procedure, developed and monitored data transmission tasks between hierarchies in Oracle, Hadoop, and MySQL-Completed design and remodeling of key dimension tables (serve 70% tables in OPPO data warehouse) of workshop data covering Dongguan and Chongqing in China, Bangalore in India, and Jakarta in Indonesia