Yi Lan Email & Phone Number

Waltham, Ma, Us

Bentonville, Arkansas, Us

China, China, Cn

Boston, Ma, Us

Overland Park, Kansas, Us

• Processed customers’ demographics data from Oracle SQL Developer, built models for different counties’ customer segmentation in the New England Region • Utilized internal CRM platform and advanced Excel skills (V-Lookup, Pivot Table) to integrate KPIs about sales opportunities and campaign performance. Delivered actionable analysis in dashboards to senior management• Monitored the release circumstance of advertisements of different stores, including televisions, billboards, radio, and newspapers. Created daily ad-hoc reports and reported to Sprint teams in New England Region• Hosted and organized in promotional events. Assisted supervisors in international student program that cooperated with Fluent, Inc., decided advertising and branding strategies• Compared latest promotional offers from competitors (Verizon, AT&T, T-Mobile) with Sprint’s, provided suggestions to the team in developing refined tactics

• Took charge of documents management, customer reception and customer relationship development utilizing advanced Excel skills (V-Lookup, Pivot Table).• Verified and checked the charge of commodities and service in line with agreement and under compliance.

• Cooperated with Baitian data team, extracted key metrics(columns) from the internal database (SQL queries), applied the Classification Tree Model to develop customer segmentation and generated email lists for the email campaign.• Composed Html5 ads for promotion purpose, managed blog posts on WeChat and received 100,000+ views and 8,700+ likes, aggregated audience demographic information and evaluated campaign effectiveness by Response Analysis.• Monitored and collected information on competitors’ products, conducted Competitor Analysis based on the big data from external source

Master’S Degree, Marketing

Bachelor’S Degree, Electronic Information Engineering

Bachelor’S Degree, Electronic Information Engineering