Post Job Free

Resume

Sign in

SAS, SQL, statistics analysis

Location:
Maryland
Posted:
September 10, 2015

Contact this candidate

Resume:

Allison (Yuan) FANG

**** ****** **** **** *** *** College Park MD 20740

Mobile number 202-***-****) yuan.fang@ rhsmith.umd.edu EDUCATION

Robert H. Smith School of Business, University of Maryland, College Park, MD Master of Science in Marketing Analytics

May

2015

Shanghai Institute of Technology, Shanghai, China GPA: 3.67/4.0 2014 Bachelor of Management, Major: Exhibition and Convention Economics and Management

Scholarship for top 5% and top 10% during 2010 - 2013 academic years

Dean’s list in 2011 - 2012

EXPERIENCE

iTalkBB Media, Virginia, United States

Intern, Market Research

Conducted secondary research to analyze business strategies and marketing campaigns for targeting brands

Organized audience survey planning and administered the execution of web-based surveys

Led research design, questionnaire design and focus group

Synthesized and interpreted audience related data, to include demographics, behavioral data, and purchase intention data, and informed actionable recommendations 2015

Millward Brown, Shanghai, China 2014

Market Analyst Intern, Quantitative

Incorporated client feedbacks and recommendations for specific requirements in official report and led to great satisfaction, to include L’Oreal, and InterContinental.

Applied LINK model to measure TV ads effectiveness for L’Oreal and worked on recommendation report with specified actionable solutions.

Interpreted data for two projects, including InterContinental and Shanghai Dream Center. Performed a competitor analysis that accurately compared weaknesses and strengths to design a strategic path.

Designed and devised questionnaires for one annual project and was later utilized as a company-wide template.

Nielsen, Singapore

Research Analyst Intern, BASES

Produced fundamental performance analysis in Excel for product launch concepts for clients including Mondelez biscuits, Barilla noodle and Hershey.

Leveraged SPSS (Quanvert) to get ready for analysis and Advisor to collect data from fieldwork and RMS database.

Contributed to brainstorm solutions and hypothesis with Innovation department and provided rational cultural background to understand studies.

Constructed all client-deliverable documents and report preparations catered to specified clients’ demands.

2014

UNIVERSITY OF MARYLAND ACADEMIC PROJECTS

Make pricing strategies on store level based on marketing promotions and sales data using SAS

Built logistic model and multinomial regression model to evaluate sale promotion effects and predict the choice of brands and sales using scanner panel data

Build the churning model for mobile carrier and accurately forecast the actual churnings with 85% accuracy

Under Amour Project– Analyze app-based data to segment and target potential customers and forecast purchase incidence using SAS, SPSS and Excel and reduce the advertising cost by 30% 2014

ADDITIONAL INFORMATION

Certification: SAS Advanced Programming for SAS 9, Statistics Business Analysis for SAS 9

Technical: Microsoft Office Suites, SAS, SQL, SPSS, Qualtrics, Google Analytics, R, Tableau



Contact this candidate