Yue Weng Email & Phone Number

Irvine, California, United States

• Uniquely identified over 80 million accounts in Snowflake platform by identifying user information data after cleaning them, utilized SQL to merge duplicated accounts and assigned confidence scores and golden IDs to.
• Defined metrics based on customer purchase history and behavior and marketing campaigns with a comprehensive mind map, designed and optimized SQL queries to extract data from database to create features
• Developed visualizations using Tableau and time series analytics on customer purchase history to understand customer journey
• Created propensity models on AWS using python and get 90% accuracy to help clients target the customers with the highest ROI, refined propensity scores with customer interaction and marketing campaign data to recommend.

Shanghai, China

• Designed KPIs for market performance and automated monthly sales reports on large scales of data from CRM and other internal systems, built dashboards in Tableau and interacted with cross-functional teams
• Constructed diagnostic analysis to detect sales anomaly for last 12 months and conducted root cause analysis with recommended solutions for sales team to prevent customer churning, increasing monthly sales by 12%

Shanghai, China

• Conducted healthcare and consumer market research by analyzing internal and external data sources
• Analyzed the acceptance of new products in various provinces by looking at similar products’ sales and communicating with sales and regional clinic team, providing holistic insights for new product “Toujeo” launching

• Increased data usability by using Excel and SQL to clean, sort, organize and verify data sets from various internal and external resources, resolved branch hospitals and missing address problems
• Segmented customers into attempters, users and advocates based on their behaviors; communicated findings with marketing and sales team to propose customer development strategy, converting 16% of attempters and users.

Shanghai

Processed macroeconomic data, real estate industry and company data and completed 2 analysis reports Calculated earnings and valuations using P/E, P/S, DCF methods based on Bloomberg and WIND consensus Forecasted the real estate market trending in Shanghai using PESTEL model and marked potential risk points

Master Of Science - Ms, Business Analytics, 3.9

Bachelor, International Economy And Trade, 3.61