Marketing Intern Intelligence Analyst

ELSA (YUN-CHIEN) YEN

952-***-**** • *********@*****.*** • linkedin.com/in/yenyunchien/ • github.com/elsa1998 SUMMARY

Analytics professional with 3+ years of experience in delivering data-driven actionable recommendations in fast-paced company. Proficient in building data pipelines and business dashboards for cross-functional projects and communicating insights to global stakeholders. Well versed in ETL, Data Storytelling and Data Visualization. EDUCATION

UNIVERSITY OF MINNESOTA, Carlson School of Management, Master of Science in Business Analytics (STEM) May 2023 NATIONAL TAIPEI UNIVERSITY, Bachelor of Statistics June 2020 EXPERIENCE

CARLSON ANALYTICS LAB, Minneapolis, USA

Data Science Consultant Jul 2022 – Present

Client: Fortune 500 CPG company – Market Basket Analysis

● Increased retailer sales by categorizing 1k+ products and utilizing association rules mining to optimize lift thresholds

● Led team of 5 as tech lead to formulate roadmap aligned with business needs to promote key products under agile frameworks Client: Leading US Airlines – Customer Segmentation

● Redesigned customer behavioral metrics and marketing events using K-prototype clustering and churn analysis

● Detected the causal inference of search ads and effectiveness. Redefined the overrated ROI and lifted CTR of websites by conducting A/B testing on searching engine machine in R Client: Leading Global Learning Company – Root Cause Analysis

● Identified root causes of low candidate persistence rates with exploratory analysis and anomaly detection using transactional and demographic data (3M+ rows) and suggested performance disparity for service improvement in SQL

● Increased 5% user retention rates by building regression models to better determine top 3 important resources in Python Client: Leading US hunger relief agencies – Sentiment Analysis

● Streamlined donation evaluation for 10+ social media channels using 2-year data by building KNN model with 2% error

● Improved donation amounts by 2x by implementing text analytics to locate the most engaging topics for users AVNET, Taipei, Taiwan (Fortune 500 Global Semiconductor Company) Business Analyst Jul 2020 - Apr 2022

● Optimized SQL queries for ETL tasks and reports, enabling functional leads to support performance tuning applications

● Redefined KPI metrics, resulting in 29% profit growth of top 20 key suppliers, by building Power BI dashboards

● Saved 10 hours of manual effort per month by creating customized tables in SQL and VBA to monitor supply chain

(purchase, sales, and inventory) for each material for 3 key accounts as a collaborator with sales, PM and finance leads

● Trained 600+ colleagues across different countries in Asia for productivity tracking tool, improving the usage by 12%

● Led the end-to-end development of project pipelines for 10+ supplier lines, including stakeholder requirements gathering, user acceptance testing, issue logging, proof of concept design, and documentation

● Predicted risky transactions by building machine learning classification models in Python and shared cases in the workshop

● Identified influence of lead time, daily shipment, and other factors on revenue in each country in Asia by deploying regression model with overall 90% accuracy for management THE WALT DISNEY COMPANY, Taipei, Taiwan

Business Intelligence Analyst Feb 2020 - Jun 2020

● Created BI reports in Tableau and provided specific investment thesis about CRM for workforce reviewing in sales function

● Analyzed target audience ratings of 7 channels and 100+ programs per day in the networks group and optimized advertisings exposure by reaching 140%+ weekly goal

● Developed scheduling platform in VBA and SQL to specify 500+ digitized ads projects which mitigated risk and resulted in 35% decrease of turnaround time in the internet commercial system SIEMENS, Taipei, Taiwan

Analytics & Marketing Intern - Product System Sales Jul 2019 - Aug 2019

● Established product portfolio to predict EV charging stations, conducted competitor assessment, and found potential customers to track product feature metrics and assortment which delivered market intelligence for 3 business units

● Presented data-driven strategies about IoT applications by introducing customer funnel analyses (AARRR) FOX NETWORKS GROUP, Taipei, Taiwan

Analytics & Planner Intern - Advertisement Sales Jul 2018 - Aug 2018

● Won 1st place by initiating Fox+ business proposal as a program launcher in Internship Innovation Competition

● Strategized with core team to support campaigns and planned funding pipelines for 2 social media platforms SKILLS AND CERTIFICATIONS

Tools: SQL, Tableau, Python, R, Power BI, Excel VBA, Spark, Databricks, Hadoop, AWS, Snowflake Techniques: Data Warehousing, Exploratory Analytics, Machine Learning, CRM, Experimental Design (A/B Testing) Passed Google Analytics, Project Management (Scrum), SQL, Excel, Cloud Computing, Data mining & AI Certificates

Contact this candidate