Yuxin Tang

Yuxin Tang

Marketing Analyst Intern
United States of America

About Me

Yuxin Tang is a marketing analytics graduate with experience in marketing analysis, data analysis, and product management internships. She has worked with Python, SQL, R, Tableau, Power BI, Excel, and statistical and mac…

Experience

Marketing Analyst Intern

Apexus – Tech, New York, USA
May 2023 - Aug 2023 · 3 months

Performed customer segmentation on user data using K-means clustering in Python to inform the advertisement placement strategy, leading to a 2x increase in revenue and 20% increase in Lifetime value (LTV)
Designed and implemented A/B testing to optimize interface interaction, displaying high-traffic metrics on the first-level page, increased 30% navigation efficiency and 34% click through rate (CTR) by metrics category
Utilized Marketing Mix Modeling to assess the effectiveness and efficiency of various digital media channels (Paid Social/ Paid Search/Campaign Granularity, etc.) and macro factors to KPIs
Analyzed data using MySQL and Excel, providing >5 marketing insights for a marketing plan
Created > 5 data visualizations in Tableau
Generated presentations to senior leaders, providing business insights

Data Analyst Intern

Citibank
Aug 2021 - Sep 2021 · 1 month

Integrated PostgreSQL database and external data sources
Utilized Python (NumPy, Pandas) to automate data extraction, transformation, and loading (ETL) processes, resulting in streamlined report generation
Built 10+ interactive Power BI dashboards to visualize and track daily active user, total user count, sign up rate and different stock performance
Ensured data integrity and interpreted data with Excel, statistical inference, regressions and predictive modeling, contributing to a 30% increase in client retention rate
Extracted data insights from weekly reporting
Developed and presented data-driven sales reports using Power BI to senior leadership, improving the operation strategy resulted in reducing client loss by 15%

Product Manager Intern

Hubei Rural Commercial Bank, Shiyan, China
Jul 2020 - Aug 2020 · 1 month

Led the prioritization of app features, and facilitated scrum team activities for a seamless App development process using a SAFe framework
Leveraged MySQL and Tableau to create 20+ interactive revenue reports and dashboards, enabling agile decision-making and driving informed cost adjustments, achieving a 15% cost reduction
Managed 7 financial products, analyzed customer portfolio, gaining $65,000 revenue
Cultivated and nurtured client relationships through weekly meetings and promoted the adoption of the bank's mobile app, ultimately attracting >100 new customers

Skills

Google Analytics Python SQL Database Sales & Marketing Tableau Pandas Matplotlib NumPy MySQL PostgreSQL dplyr ggplot2 SAS Power BI Excel Statistics A/B Testing Data Wrangling Database Management Data Visualization Linear Regression Logistic Regression Random Forest K-means Marketing Mix Modeling ETL Statistical Inference Predictive Modeling Scrum SAFe
Report this Profile?