Hui Zhao

Experience

• 

  Arvato China

  Oct 2015 - Apr 2017

  Data Analyst

  Used to work in top 500 Germany - funded enterprise; CRM (Customer Relationship Management) Data Analyst. Work to make daily, weekly, monthly and other related reportsaccording to the sales data of each brand. Timely complete kinds of ADHOC reports to meet customer’ demands. Daily works also include listing pulling, campaign tracking, and campaign effect analysis. Skilled use of SQL to do data extraction and data analysis. Familiar with SQL SERVER database operations. Skilled use of EXCEL for data analysis, data processing and display.GAP ：GAP (one of America's largest clothing brand) is currently one of our largest CRM projects. Since it belongs to the Fast Moving Consumer Goods industry, Quantity and variety of reports are needed in very short times. SMS campaign to touch members weekly.ResponsibilitiesWe also use SQL SERVER to extract data, provide activity reports and lists for our customers which includes regular reports, temporary demand reports, and list pulling, etc.Ecco：ECCO is one of the world's top four casual shoes brand. It is headquartered in Denmark (domestic headquarters located in Shanghai). The main purpose of the CRM project is to maintain existing members and recruit new members. We help ECCO to contact with their members by SMS, We Chat, e-mails, birthday cards, coupons, activities and so on.ResponsibilitiesMain role is report making and list pulling, which includes monthly report and ADHOC report. What’s more, I also need to filter the list of qualified people according to the activity rules and track activity participation rates or repurchase rates Show less

• 

  Concentrix

  Apr 2017 - Jan 2019

  Data Analyst

  Responsibilities & AchievementOnsite Amore Pacific office. Responsible for innisfree data related work, including: 1. Daily report / Weekly report / Monthly report and other regular reports. 2. Monthly SMS / MMS list pulling, including the Campaign list, Promotion list, Coupon SMS list, and new store opening SMS . 3. Ad Hoc request from client, such as members, product or stores analysis data. 4.Tracking result report of SMS sending, Review customer engagement metrics on the campaign of last month ,by comparing with the SMS sending group and Control Group,We will analyze the effect of the SMS . 5. database maintenance and data cleaning. Show less

• 

  交通银行信用卡中心

  Feb 2019 - Jan 2021

  Data Analyst manager

  Data analysis manager in the IT department of the Bank of Communications Credit Card Center, the main work includes: 1. sas programming, according to the requests of the business or marketing team, provide the list of activities, including SMS, app push, and some other customer list.2. Provide list of reward documents, such as credit card annual fee list, reward list, etc.3. According to the requests of business departments, develop various regular reports such as monthly reports, daily reports, weekly reports and other statistical reports.statistical reports.4.Development and maintenance automation and compliance data. Show less

• 

  AMOREPACIFIC

  May 2021 - May 2022

  IT 经理

  2021/05-2021/10The labor contract is in Concentrix, onsite in Amore pacific office. Responsible for the analysis of crm data for Innisfree, with similar work like 2 years ago.2021/11-2022/05Joined the it department of amore.Responsible for the development of the brand like sulwhasoo and laneige in amore . Working in IT team of AmorePacific Group. 1. Analyze CRM related data, communicate with CRM team and in charge of different project. Make sure smooth implementation of the project.2. In charge of the WeChat social CRM developing ,communicate the requestsfrom crm team and send the request to the vendor, make sure each project finished bfore deadline. 3.project development of pos system. Show less

• 

  珍岛信息技术(上海)股份有限公司

  May 2022 - now

  高级数据分析师

  In Zhendao, mainly service for the brand 正官庄, which is a ginseng tonic brand in South Korea.1. Mainly responsible for the monthly, quarterly, annual reports .2. Access data from the SQL server database, save the data in Excel and draw charts. Then make a ppt chart to display.3. The monthly report dimension includes the analysis of new members, such as age, gender, region, etc; Analysis of purchased members, including sales of new and existing members and non members; The third part is the point analysis, adding points, consuming points, and points redeem. 4. Use tableau to make the monthly report data of Zhengguan, use tableau to connect to the sql server database, calculate all the indicators required by customers in tableau,make charts and dashboard. Then published to cloud as computers or mobile phones can reed the dashboard. 5. Summarize the reasons for the increase or decrease of the data, the reasons for the changes based on the actual business, for example, the covin 19 will lead to a decline in offline store sales, group buying activities will lead to an increase in sales and average spending. Show less