• Initiated an in-depth research on 30+ software and traditional law firms regarding tech application in the legal industry. Conducted SWOT analysis to identify technological challenges, discover 5 major business opportunities, facilitate product optimization and strategy development, and provided innovative solutions for clients.• Integrated data from 10+ dynamic sources, cleaned and visualized data using Python and Tableau. Reorganized the workflow between teams and pioneered the redesign of backend databases and the data management system. Automated data cleaning processes, improving efficiency by 40% while ensuring data accuracy.• Presented data insights to help the product design and development. Managed a cross-functional team of 15+ in the ideation and development of 3 LLM-based AI product, and corresponding prompt design. Boosted product functionality by 25% informed by targeted marketing insights and user analysis.

• Led a strategic competitor analysis for 8 key market players regarding product innovation, branding, and digital marketing effectiveness. Presented insights on market trends and competitive strategies to the management.• Integrated 100k+ client data using SQL, visualized data with Tableau for customer profiling analysis, providing strong data support for new product development and sales pricing strategies.• Designed and implemented A/B testing for sales pricing, achieving a 52% quarterly sales increase.• Conducted user and keyword analysis on multiple social media platforms, assisted the marketing department in creating a new media channel, enhancing brand awareness. Analyzed website data, generated reports, assisted in implementing search engine optimization (SEO), resulting in a 12% increase in quarterly lead quantity.

• Led a market analysis initiative, evaluating data from 390+ local financial institutions using SQL and Python. Developed predictive models for market trends, enhancing forecast accuracy by 30%.• Built data dashboard through Tableau to visualize 10,000+ data points, enabling in-depth demographic and socioeconomic trend analysis, crucial for shaping targeted marketing campaigns and strategic decisions.• Conducted a thorough location analytics study, identifying 4 prime branch locations. Developed comprehensive business strategies focusing on market-specific talent and service needs.• Successfully delivered an one-stop new branch selection system, acknowledged by the company and integrated for future use, resulting in a 35% improvement in strategic decision-making efficiency and a 10% increase in customer expansion.

• Executed data processing and a thorough analysis over 90 million transactions and customer survey data using SQL and Python, conducting regression analysis, validating the correlation between Net Promoter Score (NPS) and sales, and visualizing by Tableau.• Analyzed customer purchasing behaviors over last 15 months across 100,000+ customers with the RFM model, refining marketing strategies and boosting campaign targeting accuracy by 25%.• Developed predictive models in R to assess factors (App download, survey results, coupon usage, etc.) affecting customer behavior and sales trends, resulting in a 20% enhancement in forecast accuracy.• Devised a data-driven marketing strategy for the member reward system and App downloads, boosting customer engagement, shopping frequency, and promoter conversion rates by 18%, leading to a 10% increase in sales.