• Utilised Power BI and conducted market research to strategize brand's expansion plan• Organised the implementation of a new ERP system, improving team efficiency through conducting user interviews, redesigning item and membership databases and streamlining process of purchase, sale and inventory• Formulated spreadsheets to automatically adjust inventory for products and product sets, facilitating the integration of detailed order data from online and offline sources

• Conducted consumer and retail analysis to formulate strategic plan for adjusting business scale and identifying potential business growth opportunities• Analyzed customer consumption data, with a focus on profiling frequent customers, to adjust strategy direction and marketing plans• Enhanced seasonal sales spreadsheet functionality by incorporating advanced formulas and functions, facilitating streamlined data management and analysis, achieving accurate tracking of sales trends and revenue projections• Collaborated with marketing and customer service teams to develop a SOP for integrating physical store with ecommerce(OMO)• Managed partnerships and achieved a 90% contract renewal rate for shopping mall tenants within a two-month period at the beginning of the second rotation during pandemic

• Planned cloud database file storage and archiving strategies• Uploaded course-related information to the official website using HTML• Managed external marketing activities, including social media fan page and official website management• Executed promotional video projects for course advertising campaigns including video planning, filming, and editing