Hanyang Sun Email & Phone Number

Shenzhen, Guangdong Province, Cn

Qingdao, Shandong, China

• Learning the tools: Learned about the functions of Alibaba Data Bank and Strategy Center within a week including understanding the AIPL model, creating targeted potential consumer groups, summarizing consumer groups demographic information, analyzing the effectiveness of the targeted potential consumer groups, etc.• Converting to sales: Selected the consumer groups who already purchased Hisense TV in the recent months and let them get exposed to other Hisense home appliances in the… Show more • Learning the tools: Learned about the functions of Alibaba Data Bank and Strategy Center within a week including understanding the AIPL model, creating targeted potential consumer groups, summarizing consumer groups demographic information, analyzing the effectiveness of the targeted potential consumer groups, etc.• Converting to sales: Selected the consumer groups who already purchased Hisense TV in the recent months and let them get exposed to other Hisense home appliances in the TMall’s recommendation section to pull new consumers across product categories; Detected potential consumers who already added Hisense products to their carts, then used retargeting method to try to convert them from Interest to Purchase.• Evaluating results: Collected the data after Sept. 9th sales event and conducted VTA and CTA analysis of the targeted potential consumer groups and achieved a ROI of 56 in the first month; adjusted targeted consumer groups to further improve sales. Show less

Waltham, Ma, United States

• New education technology project: Conducted monthly data analytics for ACT Inc. regarding students feedbacks, usage rate, and geological difference of new education technology and wrote report, providing ACT data support to deploy new education technology effectively• Product development project: Hosted Converse Wear Test Program by designing customer feedback survey and analyzed students feedbacks after offering them chance to wear the unreleased Converse sneakers to provide advice… Show more • New education technology project: Conducted monthly data analytics for ACT Inc. regarding students feedbacks, usage rate, and geological difference of new education technology and wrote report, providing ACT data support to deploy new education technology effectively• Product development project: Hosted Converse Wear Test Program by designing customer feedback survey and analyzed students feedbacks after offering them chance to wear the unreleased Converse sneakers to provide advice regarding the pros and cons of comfortability and design of the unreleased sneakers to Converse product development department• Potential client filtering project: Conducted monthly potential client filtering research for Jameson CPA based on several indices(number of employees, number of CPA, founding year, etc) through multiple resources(ZoomInfo, Government database, linkedin, etc) to help the company discover potential clients and recorded potential client information in Salesforce Show less

Boston, Massachusetts, United States

Analyzed web traffic data and provided recommendations to improve website management strategy and user satisfaction • Data extraction and analytics: Used Google Analytics API to extract website traffic data of more than 1000 Massachusetts District Court websites and analyzed website traffic data by implementing data analytics skills in R Programming, Python, and Tableau; obtained key variables (pageviews, average browsing time, etc), sorted websites based on types, and filtered out the… Show more Analyzed web traffic data and provided recommendations to improve website management strategy and user satisfaction • Data extraction and analytics: Used Google Analytics API to extract website traffic data of more than 1000 Massachusetts District Court websites and analyzed website traffic data by implementing data analytics skills in R Programming, Python, and Tableau; obtained key variables (pageviews, average browsing time, etc), sorted websites based on types, and filtered out the potential problematic websites• Optimizing website management strategy: Detected website problems including information inaccuracy, low tutorial video usage, and delayed policy update of certain websites based on the result of data analytics and user feedbacks; provided detailed recommendations of adjusting websites structure and improving information update frequency to optimize website management strategy and improve user satisfaction• Communication and reporting: Understood the request of client, designed research questions, and discussed appropriate research methodology within project team at the early stage of the project; reported project progress to client weekly online and kept expanding and adjusting the scope of the project based on the feedbacks of client Show less

Guangzhou, Guangdong, China

Analyzed user behavior of Kuai and TikTok and provided recommendations to improve business strategy and profitability• Data extraction and cleaning: Extracted user browsing behavior data of Kuai and TikTok from China Mobile databaseusing SQL and cleaned the data using Python; visualized the data using Tableau and collected user behavior data of the two applications using public resources• Observing user behavior: Studied research methodology related to analyzing user behavior and… Show more Analyzed user behavior of Kuai and TikTok and provided recommendations to improve business strategy and profitability• Data extraction and cleaning: Extracted user browsing behavior data of Kuai and TikTok from China Mobile databaseusing SQL and cleaned the data using Python; visualized the data using Tableau and collected user behavior data of the two applications using public resources• Observing user behavior: Studied research methodology related to analyzing user behavior and dived deeper into the logic behind user and product; summarized key user behavior characteristics of the two applications and compared the characteristics by geological location, social channel, value preference, and consuming behavior• Providing recommendations: Analyzed the profit model and characteristics of China Mobile data packages and provided recommendations in report format regarding offering different data packages to different user segments to improve user attraction and expand the scale of potential users Show less

Master'S Degree, Business Analytics

Activities and Societies: Graduate Assistant at Center for Marketing Technology

Bachelor Of Science - Bs, Management Information Systems, General, 3.67

Activities and Societies: International Chinese Student Association