Lavinia(Liyan) Wang Email & Phone Number

Seattle, WA, US

Chicago, Illinois, United States

• Created SQL queries in Access and Oracle databases and design 10+ data visualizations for 10 departments using Tableau
• Designed and distribute email communications as well as create and distribute online forms and surveys using Qualtrics and CRM
• Maintained Divisional Technology Resource and provide support to departments with web-based SharePoint applications and HTML

Greater Chicago Area

• Built dozens of score cards for marketing assets for seller behavior insights, decision strategy support
• Utilized Python, from ETL to final production, to build statistical /ML models to predict customer churn
• Analyzed weekly MIS reports, ROI of sales cycle, sales performance on asset engagement, expenditure

Greater Chicago Area

• Communicated effectively with professors on developing and refining search strategies
• Applied descriptive statistics & correlation analysis on 15-question survey data then generate reports from SPSS
• Transcribed handwritten notes and video and provide and provide suggestions for qualitative research methods

Greater Chicago Area

• Managed social media account for 30 marketing campaigns and increased followers by 510% in 4 months
• Developed 5 monthly sales reports by extracting data from SAP then presenting to management
• Researched 40+ PDF to NIMAS XML conversion service vendors and saved project cost by 30.1%
• Designed 5+ flyers using Photoshop & InDesign to promote books and workshop and increased brand awareness

Greater Chicago Area

• Coached 40+ undergraduate and graduate students in communication skills
• Identified common student challenges and provided working solutions with supporting training materials

Greater Chicago Area

• Originated analytical and reporting database for 20+organizations and built reporting prototypes
• Composed bilingual surveys to help clients better understand Chinese consumer behavior

Nanjing, Jiangsu, China

• Formulated multi-channel branding strategies for client by using content marketing and social media, celebrity endorsement and traditional radio broadcasting to lift brand awareness
• Improved client’s website ranking to top 3 in personal oral care and visitor number increase by 20%

Nanjing, Jiangsu, China

• Amplified wine sales volume by 16.7% in one month via executing observational study on consumer behavior
• Created and ran quarterly seasonal promotions to generate 10% increase in net profit margin

Master Of Science - Ms, Computer Science

Activities and Societies: Upsilon Pi Epsilon

Master Of Science - Ms, Marketing Analysis

Graduation with Distinction

Bachelor Of Management, International Tourism Management Intensive English

Activities and Societies: Welcome Party, Students Union, Foreign Song Contest, The Third Class Show, Community Service - Served as class.