yun chen

senior data analyst

About

Marketing and Data Analytics Intern at Real China Group

Country

china

City

shanghai

Industry

information technology and services

Skill

microsoft excel, marketing communications, marketing strategy, brand management, marketing, marketing research, crm, microsoft office, web analytics, sql, brand development, b2b marketing, digital strategy, seo, sales, powerpoint, microsoft word, tableau, google analytics, microsoft powerpoint, data analysis, business analysis, r, postgresql, html, photoshop, microsoft crm, axure rp, dreamweaver, indesign, python, facebook api, customer service, google tag manager, ecommerce

Experience

data analyst

sparkpad

2017-11 - 2019-1 · 1 yr 3 mos

* Communicated with clients to understand the needs and create the data dictionary * Communicated with data source teams and used SQL stored procedures to design the data flow and implement ETL processes * Wrote and optimized SQL queries to create reports * Interviewed the candidates of the team

account executive

ethos consulting group, inc.

2017-2 - 2017-3 · 2 mos

Door-to-door sales to educate customers and increase the customer base - Maintained good relationships with existing customers to increase customer lifetime value.

site merchandising digital analytics intern

ebags

2017-7 - 2017-9 · 3 mos

Built Association Rules model (Market Basket Analysis) using R to increase items per transaction for the holiday season - Text Analysis on customer reviews using Python to understand what people are talking about and help in the new feature (like Amazon's Themes) on Product Detail Pages

senior data analyst

baidu inc.

2019-3 - Present · 7 yrs 7 mos

business intelligence intern

vertex innovations, inc.

2016-6 - 2016-11 · 6 mos

Extracted and transformed social media using API and Python, combined it with Google Analytics data, and created Marketing Dashboards with Tableau to understand customer behaviors, optimize the investments in social media, and refine targeting and re-targeting strategies. - Extracted and transformed project management data using SQL, and created dashboards for clients with Tableau to track construction project milestones and evaluate the performance of the departments based on the KPIs such as project volume and duration.

oversea conference sales

pyxis consult

2013-5 - 2013-7 · 3 mos

Prospected clients from technology companies to increase the customer base - Pitched conferences to decision makers in relevant companies to ensure participation and increase the influence of the conferences.

marketing and data analytics intern

real china group

2015-2 - 2016-3 · 1 yr 2 mos

* Maintenance and customization of CRM system * Website updates, WordPress * Email Newsletter from August 2015, using Word, Dreamweaver (html), Photoshop, Illustrator and Google Analytics * MBA banner and K-12 backdrop, using Photoshop * 2016 K-12 Booklet, using InDesign and Photoshop