Close Close Preview

Your amazing online presence is right this way.

Create your profile
Capture who you are, what you do, and where you're going. All in one place.

Yuyi Cheng

Yuyi Cheng

Database Marketing Analyst

Learning Tree International

Database Marketing Analyst at Learning Tree International

Message
MENU ☰

Learning Tree International

Database Marketing Analyst

Translate strategic data-driven business needs into analysis providing insights, knowledge and understanding
Prepare and maintain in-depth campaign analysis/reporting with relevant SQL stored procedures or SSRS projects
Write SQL scripts per requests to target customers based on contact history, location and etc. for email campaigns
Create complex SQL queries to extract data of email campaigns, web marketing, and sales performance and deliver solutions in the form of pivot table/SSRS report to management
Participate in development, maintenance and validation of predictive marketing models
Participate in marketing test design and segmentation for direct mail campaigns and email campaigns

Career medium 01
Career
Career medium 04

AARP Foundation

Program Analytics - Intern

Assisted a Senior Statistician with the Food Insecurity Risk Modeler, a tool that estimates the food insecurity rate for elderly people in all counties in the U.S.
Produced monthly analysis of SNAP enrollment assistance data which identify issues needing immediate and appropriate actions
Used Excel to merge data from Weekly Call Center Reports to produce monthly quarterly performance summaries and to visualize the performance of marketing plans

Career

Worldunion Properties

Market Research Intern

Conducted data mining on customer data to prepare marketing scheme and elect optimal marketing channel
Collected and analyzed data of sales representatives’ work performance, including sales and telemarketing records

Career medium 03
Career

Beijing Normal University

Bachelor of Science, Management Science

The George Washington University

Master of Science, Statistics