Talk to sales Try for Free
Bernice Wang

Bernice Wang

Product Data Analyst

Followers of Bernice Wang607 followers
location of Bernice WangNew York City Metropolitan Area

Connect with Bernice Wang to Send Message

Connect

Connect with Bernice Wang to Send Message

Connect

  • Timeline

  • About me

    Data Analyst, Junior Data Scientist

  • Education

    • St. John's University

      2018 - 2020
      Master of Science - M.S. Computer Science GPA 3.61

      Projects in St. John’s University:• Designed a ‘Library’ schema and performed MySQL queries to modify and update the database and carry out comprehensive data analysis. • Used Python to scrap documents from media websites and applied sentiment analysis to detect the topics of the documents to help the team for the “Automated Tagging of Content” project.• Cleaned up the dataset for exploratory data analysis in R and applied machine learning techniques to establish classification and… Show more Projects in St. John’s University:• Designed a ‘Library’ schema and performed MySQL queries to modify and update the database and carry out comprehensive data analysis. • Used Python to scrap documents from media websites and applied sentiment analysis to detect the topics of the documents to help the team for the “Automated Tagging of Content” project.• Cleaned up the dataset for exploratory data analysis in R and applied machine learning techniques to establish classification and clustering models to predict the customer segmentation and sales performance of a company in Black Friday and visualized the results on Tableau.• Used SPSS to create linear regression models of finance datasets to get the correlations of the variables.• Applied VBA to create an automated program for sending emails and to report the campaign performance results. Show less

  • Experience

    • BAIYUESUO Foreign Trade Company

      Jun 2013 - Oct 2014
      Product Data Analyst

      • Performed Keywords Research for Amazon accounts to optimize products page rank and increase products exposure rates.• Created dashboard and visualization report by using Excel to analyze the different performances of each product category.• Tracked historical sales and inventory performance by analyzing different business reports in Excel.• Optimized Amazon seller’s backend product data in Excel to increase sales performance.

    • Emadri

      Jun 2019 - Sept 2019
      Data Science Intern

      • Used Python to extract, clean and merge different data frames and perform Exploratory Data Analysis based on the features of the new consolidated table.• Built a Keras SoftMax model and applied text embedding technique in Python to predict the Google Shopping products labels in the Google taxonomy.• Created classification model in Python to automatically generate the product category labels and optimize the accuracy of the model.

    • Inbnetworks

      Sept 2019 - Jan 2020
      Data Analyst

      • Accessed ‘Tika’ library in python to extract text of PDF and PowerPoint documents, in order to help the team to clean up and consolidate the raw data.• Applied Natural Language Processing Toolkit ‘NLTK’ library to divide big quantity of text into single words and removed the ‘stop words’ for topics analysis.• Performed sentiment analysis to extract keywords of the text and built k-means clustering model to acquire the topics of each part of the content.• Visualized the results of the topics analysis by generating Word-Cloud in Python to anticipate the topics of each paragraph and the summary of the whole text file. Show less

  • Licenses & Certifications

    • Python for Data Science and Machine Learning Bootcamp

      Udemy
      Jul 2019