Raymond Tian

ac7zkj@r.postjobfree.com

mobile 415-***-****

Summary:

Multilingual sales and Marketing Business Strong experience in sales, marketing strategy and critical analysis. Key skills and strengths: Customer services • SEM • Business Strategy • Research & Data Analyst • Excel(pivot tables, Macros, VLOOKUP’s) Marketing Strategy • SQL • Tableau • Content Review • Compliance • Localization • Translation

Additional Information:

Languages: Native in Chinese, Fluent in English and Korean

Programming Skills: SQL, Python, Tableau

Technologies: MS word, Excel, PowerPoint and Google AdWords

Project

ValleyRain International Project Mountain View Mar 2015 to current

BI Tableau Developer

ValleyRain International is the most popular and influential nonprofit 501 C cultural organization based at Mountain View, California for Chinese Community. The website is http://www.valleyrain.org/

As the founder of ValleyRain, promoting the NPO via Google AdWords, Facebook ad manager, mandarin SEO, spending 1000 dollars in general each month.

Helps to detail, design, and implement marketing plans for each event and talks being offered

Sets marketing schedules and coordinates with colleagues, sponsors, media representatives, and other professionals to implement strategies across multiple channels

Performing Data analysis and reporting using MS Excel (pivot tables, Macros, VLOOKUP’s) and SQL query

Working on big data for ValleyRain users and visitors and creating reports, dashboard using tableau

Education:

Master of International Business

HULT INTERNATIONAL BUSINESS SCHOOL San Francisco, CA, USA Graduated August2014

Bachelor of Business Administration

SUNGKYUNKWAN UNIVERSITY Seoul, South Korea Graduated July 2013

Professional Experience:

Data Rating and Labeling Analyst II/Data Analyst, Facebook Menlo Park Mar 2018 to Jul (via US Tech)

Assess Facebook’s data quality. label and analyze large data use excel and internal tools to inform product decisions

Identify trends within large mandarin data sets, investigating and rating page data, identifying patterns, and providing feedback to engineers to help improve data quality with Tableau.

BI Tableau Developer, YiQStyle.com -Mountain View, CA Mar 2017 to Dec 2017

YiQStyle.com is an online personalized men’s clothing service in bay area.

Develop, build and maintain reports, dashboards and metrics with Tableau and SQL query.

Identify operational issues, investigate root causes and work with appropriate teams to address issues.

Manage multiple debases and preform data-related tasks as needed with limited supervision

Responsible for analyzing current business processes and understand the need of the business

Identify, analyze, and interpret trends or patterns in complex data sets with excel pivot and Marcos

Promote the service through Google AdWords, SEO and wehcat.

Contributes information, ideas, and research to help develop marketing strategies

Tracks sales data and works to meet quotas or sales team goals

Develops sales strategies and approaches for various products and services, such as special promotions, sponsored events, etc.

Answers questions from clients about product and service benefits and troubleshooting

Analyses trends, data, demographics, pricing strategies, and other information that can potentially improve marketing and sales performance

Maintains excellent relationships with members through superior member service

implementation, and management of business intelligence systems;

• Manage report development lifecycle including Requirements, Design, Development, and Testing.

• Experience designing and deploying production quality SQL Server databases and code;

• Excellent SQL and T-SQL development skills in developing stored procedures, tables, views, and functions.

QA Analyst/Data analyst, Verizon Development Center San Jose, CA Apr. 2016 to Mar 2017(via Aditi)

Provided support with QC’ing streaming content, reviewing content metadata under digital supply chain workflow

Used content management system and excel pivot to QC video quality, report issues and resolve content error

Google Play App Content Analyst, Google HQ Mountain View, CA Nov. 2014 to Apr. 2016 (via

Accenture/Artech)

Reviewed large volumes of apps that help keep Google Play store's policy complaint as a top performer

Performed a wide variety of application policy reviews on Google Play for trust and safety

Protected and improved the users experience of Google Play store by taking action on violating mandarin apps

Trilingual Election Canvasser, APEN--Oakland, CA Sep. 2014 to Nov. 2014

Talked to hundreds of people a day about issues facing low-income communities with solutions

Top10% performer in terms of convincing absentee ballot voter to vote in both quality and quality

Encouraged the civic participation of Asian American immigrant communities in California

SEO, SEM Analyst &Customer Service Specialist,Ublove.com Seoul, South Korea Sep. 2010 to Feb. 2011 Ublove.com is an online dating website serving more than 10 countries in 5 languages.

Created optimization strategy and implemented mandarin plan

Monitored website keyword portfolio and produced detailed campaign performance analysis.

Increased paying members 100% within 6 months by releasing ads on over 300 websites and GoogleAd Words

Troubleshooting and timely resolution for creating a better user experience

Sales Representative, Korea Telecom Seoul, South Korea Mar. 2008 to Sept. 2008

Korea Telecom offers diverse international phone cards.

Targeted major universities and conducted regional market research to identify prospective customer and developed sales plan and post

Sold over 200 phone cards to students utilizing face-to-face direct sales and partnership sales

Co-founder, Every China Website Seoul, South Korea Dec. 2009 to May 2010

Every China aims to promote worldwide Chinese language teaching online.

Set up and organized the overall orientation and targets by conducting SWOT analysis and comprehensive market analysis of environment background, internet market conditions and growth, market positioning of the business model, consumer group and competitors, etc.

Did market research to set the target market and business model and adopted the “5P”

Contact this candidate