Demin Wang, PMP

Exploratory data analysis focusing on the alcohol variables from the Portuguese school data set. Main goal is using Data Mining To Predict School Student Alcohol Consumption and finding the significant factors.

• Investigated the business insights through survey data on students alcohol and related conditions using R with 6 members team
• Trained 6 models to predict school students’ drinking behavior during weekdays and weekends and select the best by evaluations
• Completed 30… Show more

Exploratory data analysis focusing on the alcohol variables from the Portuguese school data set. Main goal is using Data Mining To Predict School Student Alcohol Consumption and finding the significant factors.

• Investigated the business insights through survey data on students alcohol and related conditions using R with 6 members team
• Trained 6 models to predict school students’ drinking behavior during weekdays and weekends and select the best by evaluations
• Completed 30 min presentation with 31 pages slides to explain the process and the advices to reduce student alcohol consumption
Show less

Business Idea Competition: Miao guide
This business Idea competition was held by UTD-JSOM Entrepreneurship division. Miaoguide is an official account on the largest Chinese Social Media App WeChat. Miaoguide is made for helping Chinese international student to find intern or full-time job at US job market. This report include:
- The problem and demand of international student
- Product Design
- Business Model Design
- Market Validation
- Marketing Plan
- Competitive… Show more

Business Idea Competition: Miao guide
This business Idea competition was held by UTD-JSOM Entrepreneurship division. Miaoguide is an official account on the largest Chinese Social Media App WeChat. Miaoguide is made for helping Chinese international student to find intern or full-time job at US job market. This report include:
- The problem and demand of international student
- Product Design
- Business Model Design
- Market Validation
- Marketing Plan
- Competitive Analysis
- Financial Projections
- Company Road map Show less

• Led 5 members team to identified the digital marketing situation and strategy for aba.org to increase awareness and conversion
• Implemented the analysis included market research, web UX, SEO, PPC, social media, mobile strategy and web analytics
• Generated 55 pages slides report and presentation to identify the next step development and potential improvement for aba.org

Adobe Analytics Challenge: PlayStation Customer Analytics
• Investigated the Sony PlayStation App customer data using Adobe Analytics with a 3 members team and gained business insights
• Segmented the PS APP users by paths to store and found that friend profile was significant helpful to increase the conversion rate
• Improved the UI design of friend profile pages on PS APP and profiled the regional community situation to give recommendation

• Drew entity relational diagram using MS Visio to clarify the information structure of CEO Global organization
• Constructed relational database by integrating entity tables in SQL Server for data selection
• Designed data input screens and report formats in MS Access to standardize future data input and report

Determined two courses for the Dominick's transnational database analysis: one performed on a corporate level to facilitate a variety of corporate planning activities; and the other one on a category level to improves sales performance and expand product offerings.
• Extracted one year sales data from 109 Dominick's stores in Chicago district and merged with store demographic data.
• Analysis the data by segmentation analysis (create groups of the stores similar in performance), response… Show more

Determined two courses for the Dominick's transnational database analysis: one performed on a corporate level to facilitate a variety of corporate planning activities; and the other one on a category level to improves sales performance and expand product offerings.
• Extracted one year sales data from 109 Dominick's stores in Chicago district and merged with store demographic data.
• Analysis the data by segmentation analysis (create groups of the stores similar in performance), response analysis (find targetable characteristics of identified groups of stores) and model validation (evaluate performance of the model on a 20% hold-out sample) utilizing SAS
• Explicated the result in 25 pages report, which discussed the evaluation of potential locations for a new store and choice of the stores to test market a new product. Show less

The market research about attitude of millennials towards life insurance for TransAmericam (Dallas), including brand position, insurance policies, marketing method, product attributes etc.
• Collected secondary data online and held one-hour focus group with 12 members and conducted hypotheses from the focus group.
• Designed questionnaire with 31 questions and surveyed 59 candidates online.
• Analysed the result by cluster analysis, regression, chi-square analysis and logistic analysis… Show more

The market research about attitude of millennials towards life insurance for TransAmericam (Dallas), including brand position, insurance policies, marketing method, product attributes etc.
• Collected secondary data online and held one-hour focus group with 12 members and conducted hypotheses from the focus group.
• Designed questionnaire with 31 questions and surveyed 59 candidates online.
• Analysed the result by cluster analysis, regression, chi-square analysis and logistic analysis utilizing SAS and SPSS.
• Completed 15-pages reports which discussed the millennial consumer segmentation and advice. Show less