Social Media Business Analyst

Yueming Ni

*****@*****.*********.*** 585-***-**** linkedin.com/in/yueming-ni-307167280

SKILLS

• Data Analysis & Machine Learning: Python(Pandas, NumPy, Scikit-learn, Matplotlib, seaborn), R (Caret,Dplyr,Ggplot2); SQL(Query, Window Function)

• Data Visualization: Tableau, Power BI, Google Analytics

• Statistical Methods: Regression (Linear, Logistic, GLM, GAM), A/B testing, Time-series Analysis

• Marketing Strategy: SEO, SEM, Social Media Analytics, Customer Segmentation

• Customer Analytics: CLV, Churn Analysis, CRM

PROFESSIONAL EXPERIENCE

Jiangsu Foreey Technology Co., Ltd. Remote

Business Analyst April 2022 - Present

• Conducted analysis of a database with over 50K raw entries and 20+ attributes related to hospital products, including product ID, name, purchase dates, hospital codes, and maintenance schedules. Supported 4 departments with data-driven strategies, contributing to an 18.6% cost reduction in the second quarter

• Developed a SQL-based ETL pipeline to integrate and process data from 20+ competitive company product markets. Performed statistical analysis and created 30+ Tableau dashboards with detailed insights, presented to over 100 stakeholders across the company

• Collaborated with multiple teams to identify needs and design data solutions, creating over 10 ad-hoc dashboards to support decision-making processes

Blackmore Partners Inc. Chicago, United State

Marketing Analyst Intern August 2024 - Present

• Developed a market investor database from scratch using Python APIs, gathering data from 20 websites and 5 social media platforms. Conducted data cleaning and filtering, achieving 98% data accuracy by removing duplicates, renaming indexes, and filtering outliers. Automated the process, leading to an 80% reduction in labor costs

• Supported marketing strategy by conducting A/B testing to optimize client features and user experience. Ensured data integrity across operational workflows, contributing to effective weekly reports and dashboards

• Led a 6-person group to host 3 investor events, ensuring prepared information before the conference, summarizing and analyzing performance metrics and financial outcomes, resulting in a 13% increase in investor engagement and a 21% improvement in event preparation efficiency

LTK Information Technology Consulting (Shanghai) Co., Ltd. Shanghai, China Analytics & PR Intern June 2022 - August 2022

• Analyzed customer behavior and churn rates through CRM systems to deliver actionable insights, supporting 52 bloggers and over 40 platforms in increasing engagement and monetization

• Utilized Google Analytics and SEO/SEM strategies to improve digital presence and optimize the "Fashion Blogger Promotion Program," boosting customer satisfaction and driving over $400,000 in commissions

• Directed a team of interns to execute a data-driven fashion and lifestyle social media strategy in the Asia-Pacific region, resulting in a 100,000-follower increase on Instagram PROJECTS

Simon Vision Consulting Rochester, United State

Consultant January 2024 – June 2024

• Analyzed customer behavior data (1M+ rows), including customer ID, average purchase value, and conversion rates, enabling personalized marketing that boosted email CTR by 19.2% and purchase conversions by 12%

• Utilized insights from customer behavior analysis to recommend product improvements, resulting in a 15% increase in customer satisfaction and a 10% boost in retention EDUCATION

Simon Business School, University of Rochester Rochester, United State Master of Science in Marketing Analytics (A STEM-Certified Program) December 2024

• Relevant Coursework: Pricing Policies Prescriptive Analytics Data Management & Analysis Consumer & Brand Research AI & Business Marketing Segmentations

Hong Kong Metropolitan University Hong Kong, China Bachelor of Arts (Honours), Creative Advertising and Media Design September 2019-June 2023

• Relevant Coursework: Social Media Marketing Media Production Exhibition Design Advertising Production & Publishing Advertising for Digital Media Web Design & Interactive Media

Contact this candidate