Business Intelligent Engineer

Yu-Wei Tang

858-***-**** *****.****@****.****.*** www.linkedin.com/in/Wayne-Tang-UCSD

**** ******** ***. ***. ****, Rancho Cucamonga, CA 91730 Github: https://github.com/1VCD1

Summary

Business Intelligent Engineer currently on 3-year OPT with 2 years of experience in project work, intern, and full-time work. Proficient in Python(1 year), R(2 year), SQL(2 year), Machine Learning(1 years), data/marketing analysis(1.5 year), and data research(1 year).

Education

Master of Science in Business Analytics 08/2018 - 08/2019

University of California San Diego

Relevance course: Working with Unstructured Data, Recommender Systems, Customer Analytics, Collecting/Analyzing Large Data, Web Analytics

GPA: 3.7

Bachelor of Business Administration in International Business 06/2012 - 06/2016

Soochow University, Taipei, Taiwan

Experience

Business Intelligent Engineer, A.R.T. Furniture Inc, Ontario, CA, U.S.A. 10/2019 – Present

Cooperated with Product, Supply Chain, E commerce teams, identified business issues, created ETL pipeline and demonstrated ad-hoc analysis with PowerBI visualization or Excel spreadsheet

Created refresh-able report data & dashboard that increase supply chain team and eCommerce team efficiency of decision making by 90%

Created T-SQL procedure or python program that crawl data, cleanse data, and mine meaningful and behavior outlier from customers and partners company

Data Scientist, Daasity, La Jolla, CA, U.S.A. 04/2019 – 08/2019

Utilized R DBI package to build data pipeline that pull relational tables from large scale eCommerce inventory data sets from Amazon Redshift data warehouse

Pre-processed, analyzed large data sets, and built time-series model to predict SKU demand

Developed R Shiny Dashboard that visualizes inventory suggestion and SKU’s inventory forecast and sales forecast

Research Executive, Ipsos LTD., Taipei, Taiwan 10/2017 - 01/2018

Built metric dashboards and performed spreadsheet analysis for clients to track their KPI and ran ad-hoc analysis to address daily issue

Analyzed advertisement campaign’s performance, and implemented conversion funnel analysis to identify root cause of digital marketing issues that affect business outcome

Ran hypothesis testing, A/B testing, and other statistical methods to measure the impact of marketing campaigns and effectiveness of customer acquisition strategies

Performed RFM analysis and logistic regression model to help client optimized marketing campaign cost

Data Analysis Intern, Hao-Shi Foundation, Taipei, Taiwan 02/2017 - 06/2017

Automated and pre-processed data entry of participant’s demographic data of main campaign of the year

Individually designed a questionnaire to collect pre- and post-event data and design an initial data framework for future CRM analysis

Leveraged collected data to perform CRM analysis and created a list of 90 potential attendants for future Bootcamps, which is potentially worth $540,000

Projects

Pentathlon: Email Campaign Optimization

Trained machine learning model with customer profile and purchase history data to predict customer response rate and order size of different email promotion content, and maximize expected profit by sending the highest expected profit email content to the customer

Specialized Skills

Tool: Tableau, PowerBI, Pentaho, Datagrip, Microsoft SQL server, Google Analytics, Excel, Spark

Coding: Python (Pyspark, pandas, scikit-learn, matplotlib, numpy), R (dplyr, ggplot, DBI), T-SQL, MYSQL, Excal VBA

Machine Learning Technique: Linear Regression, Logistic Regression, Neural Network, Random Forest, GBM, XGBoost

Soft Skill: Independent, Self-motivated, Logic thinking, Problem Solving, Communication, attentive to detail

Contact this candidate