● Used SQL to organize, clean, and process marketing campaign performance data from multiple social media platforms (e.g., WeChat, TikTok, Red Book), improving data processing and further analysis efficiency● Analyzed marketing campaign performance based on key metrics (e.g., traffic, click-through rate, conversion rate), designed dashboards in Tableau, and presented weekly insights to cross-functional stakeholders, improving final conversion rate by 10% and driving strategy decision-making● Conducted competitor analysis to identify own strengths and weakness to continue to optimize strategy ● Attracted 5% more customers per semester by implementing and improving SEO and promoting advertisements ● Identified targeted offers for existing customers based on the analysis of customer features and demographic profiling

● Collected materials, information, and managed data with Excel for over 5 companies to analyze the potential results● Analyzed the accounting statements for over 3 companies and presented advice on their investment strategy to the leadership to help them succeed in bidding competition● Integrated companies’ collective outstanding resources with data and graphs on the web page to display the firm’s professional proficiency