Design Engineer Marketing Analyst

Yu-Hsuan Chuang

240-***-**** ● ********@***.*** ● linkedin.com/in/yuhsuanchuang

EDUCATION

University of Maryland, Robert H. Smith School of Business - Maryland, USA May 2022 Master of Science in Marketing Analytics, 3.58 (STEM certified)

• Courses: Statistical Programming, Advanced Marketing Analytics, Market Research, CRM, Digital Analytics, Data Science Tatung University - Taipei, Taiwan September 2008 – June 2012 Bachelor of Science in Industrial Design, 3.66

• Courses: Product Design, Product Development, Material and Manufacturing Process, Human Factors, Color and Light TECHNICAL SKILLS

• Data Analytics: SQL, Python, EXCEL, R/ RStudio, Google analytics, SAS, BigQuery

• Database: Hadoop System, RDBMS, MySQL

• Data Visualization: Tableau, Power BI

• Data Science: Classification, Clustering, Regression, Decision Trees, Bayes Theorem, PCA, A/B testing

PROJECT EXPERIENCE

COVID-19 Data Analysis (SQL, R, Excel, Tableau) November 2021 – December 2021

• Managed extensive data and analysis, including T-test, Chi-Square, ANOVA, and regression with SQL and R to forecast vaccine and masks requirements for the governor of Texas

• Conducted Statistical hypothesis testing to test the effectiveness of mask and vaccine mandates

• Transferred dataset into actionable business insights and recommendations to stakeholders using R and Tableau Digital Marketing Execution (R, Excel, Google Analytics) September 2021 – December 2021

• Implemented a movie recommendation system based on k-NN algorithm in R and Excel, with 67% prediction accuracy

• Monitored KPIs & CRM through Google Analytics to find optimal SEO/ SEM traffic, increased App engagement time by 2x Customers’ Behavior Analysis (Python, Excel) October 2021 – December 2021

• Implemented Factor analysis and Cluster analysis including PCA & MDS through Python to analyze user behaviors

• Identified target segments and developed marketing strategies, which increased 18% brand awareness & 21% subscription Airbnb Price Prediction (R, Tableau) March 2021 – May 2021

• Experienced in cleaning big data and applied Forest attribute imputation using machine-learning methods by R to forecast the optimal price and identify business insights, encouraged transactions by 25%

• Visualized market dataset by Tableau and created reports and presentations to articulate the market insights to both technical and non-technical leadership of the organization PROFESSIONAL EXPERIENCE

Skycable Inc. - Taipei, Taiwan June 2020 – August 2020 Digital Marketing Analyst (Google Analytics, Adobe Photoshop, Adobe Illustrator, MySQL)

• Identified keywords for websites by Google Analytics to boost 105% visibility and 33.2% online order

• Proposed solutions and developed websites’ structure to enhance user experience, increasing 25% user attention

• Built daily ad hoc queries in MySQL and experienced database administration MMC Multimedia Connect Headquarter - Wissous, France (CMF Ltd. - Taipei, Taiwan) October 2012 – March 2019 Product Design Engineer & Product Management (SolidWorks, AutoCAD, Pro/Engineer, Cinema 4D, Excel)

• Drove product development based on business needs and created over 20 B2B products from conceptualization to launch

• Analyzed testing data by Excel and proposed solutions which helped increase productivity and accuracy to nearly 100%

• Performed market analysis using pivot table in Excel on competing products and brands to identify design principle

• Negotiated and analyzed with vendors in feasibility, cost, and return on investment for product ideas, saved 48% of budget

• Converted engineering analysis into business recommendations, developed presentations, and briefed to customers E-Link Plastic & Metal Industrial Co., Ltd. - Taipei, Taiwan July 2010 – August 2010 Co-Op Product Designer

• Investigated competitor’s products features by comparing pros and cons to define next generation of product ACCOMPLISHMENTS

• Certification & Training: Advanced Google Analytics, Google Analytics for Beginners- Google Academy (2021)

• Patent: “Waterproof Coupler.”- Taiwan Patent M563692, Tsu Yuan MA and Yu-Hsuan CHUANG, issued 07/ 11/ 2018

• Awards: Best in Show Awards, BICSI SHOW –USA, Telecommunications Technology Fiber stripper Design (2015)

Contact this candidate