Quatrix, SPSS, SQL, Microsoft Office (Advanced Excel), Adobe Creative

HAN LIU

Kew Gardens, NY ***** 845-***-**** *******@*******.*** http://linkedin.com/in/han-liuhan EDUCATION

• Master of Science in Marketing Intelligence

• Relevant Coursework: Advanced Marketing Analytics, Consumer Behavior, Digital Marketing, Market Research Methods FORDHAM UNIVERSITY, GABELLI SCHOOL OF BUSINESS New York, NY MS, Marketing Intelligence, GPA:3.83 August 2023-Present

• Bachelor of Science in Supply Chain and Information System

• Coursework: Micro/Macroeconomic Analysis, Statistics, Financial Decision Making, Mass Media and Society, Management, Principle of Marketing, International Business Operation, Spreadsheet Analytics and Info Management, Supply Chain Analytics THE PENNSYLVANIA STATE UNIVERSITY, SMEAL COLLEGE OF BUSINESS State College, PA Bachelor of Science, Major in Supply Chain Management August 2018-May 2023 PROFESSIONAL EXPERIENCE

• Conducted market landscape analysis in Brooklyn's automobile market, identifying key trends and collaborating with sales team to leverage opportunities, resulting in $11,500 in sales growth

• Built and distributed consumer surveys among 100+ local students, gathering insights directly informed marketing strategies and boosted engagement by 15% through proposed campaigns

• Created visually appealing promotional materials, including brochures and videos, enhanced brand visibility and attracted 25% more foot traffic from targeted local promotions

• Constructed storytelling-based social media campaigns, improving brand awareness and enhancing engagement by 30% across key platforms

• Designed influence marketing to engage local students, increasing social media engagement by 20% and boosting brand recognition within student community

YOUYIJIA GARAGE Brooklyn, NY

Marketing Intern January 2019-January 2024

• Operated management by overseeing cashiering, verifying 50+ transaction bills weekly, and accurately declaring taxes, ensuring smooth financial operations

• Developed an Excel-based worksheet to automate financial data updates, perform calculations, and generate visual graphs, streamlining reporting processes, reduced reporting time by 40% and increasing accuracy

• Ensured excel solution improving daily operational efficiency, reduced manual errors, and lowered cost of manual data entry, contributing to a more efficient financial system

HONGHE NUOBANG MORTGAGE LIMITED COMPANY China

Teller May 2021-December 2021

PROJECTS

• Conducted primary and secondary research using Qualtrics and Statista for a wellness product brand, Asutra

• Directed in-depth market, company, and competitive analyses from a 54-participant sample, identifying a 60% interest in self-care and wellness bundles, informed a targeted marketing plan and expanded engagement

• Constructed a marketing plan including a creative/social media campaign, with a $15,000 budget allocation

• Presented recommendations to company CEO, resulting in first place ENTREPRENEUR PROJECT, FORDHAM UNIVERSITY, GSB Fall 2023

• Analyzed 80,000+ customer transaction records using SPSS, segmenting customers by demographics and purchasing behaviors to identify high-value segments

• Developed regression models to identify key factors driving purchasing behavior among high-value customers, specifically addressing females aged 55–64, to optimize profitability within Sephora’s Segment 4

• Delivered executive reports recommending loyalty enhancements and regional promotions, projected to expand engagement by 20% and drive $200,000 in additional revenue

CUSTOMER SEGMENTATION PROJECT, FORDHAM UNIVERSITY, GSB Fall 2023

• Technical Skills: Quatrix, SPSS, SQL, Microsoft Office (Advanced Excel), Adobe Creative Suite (Photoshop, Final Cut Pro), Tableau

• Languages: Mandarin Chinese (CEFR C1), English (CEFR C2)

• Data Analysis: Customer Segmentation, Predictive Modeling, Regression Analysis, Data Visualization ADDITIONAL

Contact this candidate