database analyst

Claire (Sijie) Yang

** ******* **. ■ Bridgewater, NJ ■ 614-***-**** ■ *****.****@*******.***.***

EDUCATION

Robert H Smith School of Business, University of Maryland, College Park, MD May 2015

Master of Science in Marketing Analytics, GPA: 3.40

Coursework: Linear and Linearizable regression models, Poisson regression and Binary Logit models, Choice modeling using Multinomial logit, Mixture regression models, Conjoint Analysis, Market Demand Forecasting using Bass, Exponential and Market Share Models.

College of Education and Human Ecology, The Ohio State University, Columbus, OH May 2014

Master of Arts in Foreign and Second Language Learning, GPA: 4.00

Graduate Assistant in the Office of Student Life.

EXPERIENCE

WETA Public Television and Classical Music for Greater Washington August 2015 till Now

Database Analyst (Contractor)

Extracted and analyzed data from an offsite Oracle database using custom database query tools and other tools as required. And developed strategies for managing data anomalies.

Work with fundraisers to design data specifications that are either executed in-house or delivered to database vendor for execution. And worked with database vendor to develop clear and concise technical specifications.

Assisted with development of new productivity and business intelligence tools for fundraising and audience service teams.

Manipulated data using standard office tools such as MS Excel and MS Access.

Collaborated with the DSM team to develop and execute ongoing in-house training programs.

Oriental Department Store, China June 2013 – August 2013

Market Research Intern

Conducted research on the Test local market to understand customer behavior.

Collected data from 100 customers using consumer surveys for cosmetic and clothing department.

Analyzed data using SPSS to aide the decision-maker secure a marketing strategy.

Institute for Chinese Studies, The Ohio State University February 2013 – May 2013

Research Assistant -- Project: Acquisition of Mandarin - Lexical Tones by Children

Collected data on Mandarin lexical tones from 16 participants by hearing screenings.

Processed and analyzed the collected data using statistical software.

Examined the acquisition of Mandarin lexical tones to understand children’s phonological development.

Researched the factors affecting the rate and accuracy in learning the tones.

PROJECTS

Strategic Targeting of UnderArmour Map My Fitness Users for Better Conversion

Analyzed users’ longitudinal workout patterns and demographics to identify patterns in purchase behavior.

Developed finite mixture model to segment users on behavioral factors and analyzed purchase patterns in each segment.

Developed linear regression models on each segment to evaluate impact of demographic factors.

Presented recommendations to Director, Digital Marketing and Analytics, UnderArmour for strategic targeting of Map My Fitness users.

Predictive Customer Churn Management Program for Cellphone Company

Developed logistic regression model for predicting customer churn using SAS.

Analyzed the model to identify the most important drivers of churn and recommended a proactive retention program based on actionable insights.

Pricing decisions for Tropicana Orange Juice

Developed a regression model to analyze the effects of price, promotional offers and season on sales.

Fitted linear, semi-log, log-log regression models and determined optimal price for maximum profitability using best fitting model.

Analyzing print ad designs using eye-tracking data

Analyzed eye tracking data to evaluate L'Oreal's print ad design using binary logit and linear models.

Recommended the optimal design covering location, size of picture and text for better brand retention and recall.

Evaluating Sales Promotion Effects Using Scanner Panel Data

Assessed the effectiveness of sales promotions on consumers’ purchase incidence, brand choice and purchase quantity decisions in the context of liquid laundry detergent.

International Market Segmentation for Global Retailers (Whole Foods Market)

Developed mixture regression model in GLIMMIX to identify segments of regions based on store image drivers.

Recommended regions target for Whole Foods Market for successful entry into European markets.

ADDITIONAL INFORMATION

Technical Skills: SAS, R, SPSS, SQL, GLIMMIX, Excel, Amazon Web Service, Tableau, MS Office Suite.

Certifications: SAS Certified Base Programmer (Certificate Serial No: BP048360v9).

Contact this candidate