Data Analyst

Dhananunt (Nancy) Ploydanai

*** * ***** ***, *******, IL, 60657 415-***-**** ****.**@*****.***

PERSONAL SUMMARY

A former marketing research analyst and actuarial with excellent data scientist and statistical knowledge, a voracious curiosity, and the ability to reveal the hidden pattern within large data sets, afford to leverage a comprehensive of mathematics, applied statistics, visualization to the real- world situation, strong time-management and organizational skills.

EDUCATION

DePaul University, College of Computing and Digital Media, Chicago, United States, 3.91 March 2017 Master of Science with Distinction in Predictive Analytics, Concentration in Computational Method Chulalongkorn University, Chulalongkorn Business School, Bangkok, Thailand, 3.56 April 2011 Bachelor of Science in Statistics with Distinction, Concentration in Actuarial Science SKILLS

• Programming: R, Python, SQL, HTTP&CSS, JavaScript

• Tools: SPSS, SAS, Tableau, MATLAB, Microsoft Azure, RStudio, Jupyter Notebooks, Hadoop, Microsoft Office

• Database: SQLite, MySQL, Oracle SQL, HBase, Hive, Pig EXPERIENCE

Otake Inc, United States Aug 2017- Present

Web Data Analyst

• Collected structured and unstructured data – primarily from YELP (textual comments)

• Performed Sentiment Analysis finding keyword priorities to understand consumer’s reaction by R

• Summarized and Reported sales and traffic sources monthly using SQL, planned strategically future campaign and marketing activities

• Completed ad-hoc duties as an assistance administrator LIEN HOA FOOD CORP, Chicago, United States Jan 2017- Mar 2017 Data Analyst and Marketing Intern

• Extracted, cleaned and aggregated data for analyzing to support sales and marketing using R, Python and Pandas

• Performed basic analysis and insights based on seasonality, market changes, and trending pattern

• Replaced PowerPoint and Excel report with Tableau Desktop and consulted with other teams to support data collection NUMBER 10 RESEARCH CO., LTD., Bangkok, Thailand Jan2013- Apr 2014 Senior Marketing Research Analyst and Research Project Leader

• Designed the method of collecting data, collaborated with more than 20 of variety firms to understand business objectives and discover expected client’s propensity e.g. KFC, Pizza Hut, Toyota, Kubota, etc.

• Compiled and analyzed statistical data by utilizing SPSS, R, and Oracle SQL converted and interpreted to provide research finding

• Conducted quantitative, qualitative research, moderator guide, and focus group for pre/post launched product, pre/post launched advertisement, product test, etc.

TEAM EXECELLENT CONSULTING CO., LTD., Bangkok, Thailand Jan 2012- Jan 2013 Actuarial Analyst

• Conducted primary presentation to prospective clients, Introduced clients the International Accounting Standard for Employee Benefit, the importance, and the concept of calculation

• Analyzed statistical data to calculate expected mortality, accident, and retirement rate using Excel, Macro, SPSS

• Executed the actuarial assumption, constructed probability table to estimate risk and liability payment of employee future benefits for clients SANSIRI CO., LTD., Bangkok, Thailand May 2011- Jan 2012 Corporate Marketing Communication Executive

• Planned, developed, and implemented Public Relations strategies for both internal and external organization

• Monitored online marketing for resale and leasing property regarding sales data; Company Website (plus.co.th), Instagram, and Twitter

• Extracted data, Implemented sales report and online marketing plan quarterly and calculated digital marketing budget using Excel, SPSS PROJECTS

Behavioral Risk Factor Surveillance System (R, Macro, Excel) Health data and descriptive analysis by using Linear Regression and Logistic Regression (Predicting respondent’s sleep time and health condition) DIVVY bike Chicago’s bike share program (Tableau, R)

• Applied visualization techniques and combined tools like R, Tableau to explain biker’s behavior and usage City of Chicago Chicago Crimes Data (Java, Python, SQL)

• Implemented distributed file system and map-reduce technology (Hadoop, Hive, Pig, etc.) to analyze Crimes Data from year 2001-2016

Airbnb Online marketplace for renting vacation homes (Tableau, R)

• Created a Decision tree, Association rules model with accuracy 64% to explore the important factors and patterns of Airbnb user’s associated with understanding characteristics of existing customers PONPARE Japanese website sells discounted coupon (Python, R)

• Created a model of Decision Tree, Random Forest, and SVM to classify coupon categories with the highest accuracy of 95%. Then predicted sales volume from KNN and Regression model

YELP (Python, R)

• Created collaborative recommender system from YELP user’s reviews by performing a text mining and Sentiment analysis KUBOTA Agriculture Machinery Pricing Structure Research

• Performed market analysis and determined Kubota competitive sales share and movement of 1st half 2013 and 2nd half 203 DERMATIX ULTRA Story Board Evaluation

• Conducted focus group discussion among product users, competitive users, and non-users expected to gain more consumer perception towards product

KFC Krushers Buyer Reaction Study

• Research of how KFC new product performs in the market place and gauge consumer acceptance and satisfaction toward KFC new product and determine consumer’s attitude

TOYOTA plan-do-check-act Research

• Quantitative research of Toyota PDCA cycle for continuous product improvement among Toyota users compare with direct competitor

Contact this candidate