Wan Ting (Mina) Hsu
Data Analyst, Consumer Insights Consultant
Email:
Location:
New York, NY
Education:
Columbia University in the City of New York
Master of Science, Applied Analytics
Loyola Marymount University
Bachelor of Art, Economics; Business Administration
About Me.
I'm Mina, a passionate data enthusiast with 4+ years of experience in consumer insights, business analytics, and project management. My mission is clear: to empower businesses with actionable insights that drive performance and deliver tangible, data-driven results. With a proven track record of contributing to revenue growth for over 30 CPG brands, I specialize in optimizing marketing strategies, boosting sales initiatives, and cultivating brand loyalty.
In addition to my expertise in brand growth, I am deeply passionate about music and have a penchant for DJing in my free time. My love for staying active is evident through my involvement in various fitness classes, as well as my penchant for running marathons and participating in boxing. Traveling is another passion of mine, as I enjoy exploring new places and experiencing different cultures.
Education
2021-2022
Columbia University; New York, NY
Master of Science, Applied Analytics
In completing my master's degree in Applied Analytics, I gained expertise in analytical tools and methodologies, including Python, R, SQL, and Tableau. These skills have allowed me to conduct effective data analytics, build robust machine learning models, and create compelling data visualizations, all of which have been instrumental in driving sound business decisions.
Skills: Python, R, SQL, Tableau, Data Analytics, Machine Learning, Business intelligence
2016-2019
Loyola Marymount University
Bachlor of Art, Economics; Business Adminstration
With a background in Economics and Business Administration, I am well-versed in analyzing data to draw meaningful insights. My degree has equipped me to understand financial analysis, strategic planning, marketing, operations management, and organizational behavior.
Skills: Market Research, Budgeting and Forecasting, Financial Modeling, Project Management
Professional Experience
Sept 2019 - June 2020
CRM Analyst
Louis Vuitton is a leading international luxury fashion brand.
-
Extracted data by SQL, analyzed and presented customer performance insights for retail strategy support, resulting in a +48% increase in VIP sales and +30% growth in new recruitment clients YoY.
-
Collaborated with the event team to increase event-generated revenue and drive client visits by 20% by implementing SMS campaigns and developing tracking dashboards.
May 2017 - Aug 2017
Sponsorship Research Analyst (Internship)
Live Nation Entertainment is a global entertainment company specializing in live events, ticketing, and artist management.
-
Developed over 10 sponsorship research projects through quantitative and qualitative analysis using market research data from events like LakeShake Music Festival and Sasquatch! Music Festival.
-
Analyzed and interpreted data from 100,000+ customer surveys using SPSS and proprietary software platforms to create impactful market research presentations.
-
Collaborated on survey design and conducted data cleaning and analysis for surveys from 20+ events to derive actionable insights.
Jul 2020 - Jun 2021
PR & Marketing Manager
Yeyang Glamping is a luxury glamping resort located in Hsinchu Taiwan.
-
Developed and implemented marketing strategies & media KPI tracking, yielding a 10x increase in business flow from an average of 3 rooms to 33 rooms per day, reaching a capacity of 36 rooms.
-
Executed 30 marketing campaigns with over 25 small business partners, 5 international magazines (Vogue, Marie Claire, GQ), 50 social media influencers, and 3 travel TV shows in Taiwan. Achieved a monthly revenue surge from $5k to over $185k within 3 months.
Sept 2022 - Dec 2023
Data Science Consultant (Capstone Project at Columbia University)
Revel Transit is an EV focus rideshare service based in NYC.
-
Developed an automatic data visualization dashboard using Python, proficiently tracking and analyzing a dataset of over 50,000 customer reviews, encompassing both textual and numerical data.
-
The project resulted in the identification of over 15 drivers with 5 critical characteristics that impacted customer experience. Provided strategic recommendations that lead to a 15% jump in customer retention rate.
Jun 2022 - Current
Senior Consumer Insights Analyst, Consulting
Numerator is a data SaaS company in the market research industry.
-
Achieved $800+ million in ROI for 30+ CPG brands, utilizing dataset of over 1 million panel measurements to provide analytic insights and enhance marketing effectiveness and boosting sales.
-
For example, streamlined a sales decomposition dashboard that analyzes over 100 categories, 20 performance metrics, and 25 demographic attributes. This facilitated the extraction of insights such as brand loyalty among different shopper segments, significantly contributing to the revenue growth of brands and enabling strategic recommendations for clients.
Skills
Coding Skills
-
SQL
-
R
-
Python
-
Tableau
-
Docker
-
AWS/Google Cloud
-
Excel/Google Sheet
-
GIT
-
Google Analytics
-
Microsoft/Google Suite
Professional Skills
-
Data Analytics
-
Data Visualization
-
Business Intelligence
-
Market Research
-
A/B Testing
-
Project Management
-
Consumer Insights
-
Retail/GPG Industry Knowledge
-
Sales Analytics
-
Marketing Strategy
-
Communication & Storytelling
Language
-
English (Proficient)
-
Chinese Mandarin (Native)
-
Hokkien (Intermediate)
Interests & Hobbies
-
DJ 🎶
-
Long Run
-
Boxing
-
Free Diving
-
Reading & Painting
-
Traveling & Learning New Cultures