Yanjing Wang

Business Analyst Intern at Magic Lamp Consulting Inc
  • Claim this Profile
Contact Information
Location
Worcester, Massachusetts, United States, US

Topline Score

Topline score feature will be out soon.

Bio

Generated by
Topline AI

0

/5.0
/ Based on 0 ratings
  • (0)
  • (0)
  • (0)
  • (0)
  • (0)

Filter reviews by:

No reviews to display There are currently no reviews available.
You need to have a working account to view this content.
You need to have a working account to view this content.

Credentials

  • Hootsuite Platform Certification
    Hootsuite
    Apr, 2023
    - Sep, 2024
  • Learning GitHub
    LinkedIn
    Apr, 2023
    - Sep, 2024
  • PCAP – Certified Associate in Python Programming
    Python Institute
    Apr, 2022
    - Sep, 2024
  • SQL for Data Science
    Coursera
    Nov, 2021
    - Sep, 2024

Experience

    • United States
    • Fundraising
    • 1 - 100 Employee
    • Business Analyst Intern
      • Jul 2023 - Present

      • Assisted client in creating Tableau dashboards for sales, demonstrating their 600% margin improvement. • Created a questionnaire for a non-profit organization and prepared to collect data for customer profiling and pricing strategy. • Used Google Analytics and HubSpot Analytics tools to help track and analyze the metrics of client marketing campaigns and generated reports to evaluate the effectiveness of marketing efforts. • Assisted client in creating Tableau dashboards for sales, demonstrating their 600% margin improvement. • Created a questionnaire for a non-profit organization and prepared to collect data for customer profiling and pricing strategy. • Used Google Analytics and HubSpot Analytics tools to help track and analyze the metrics of client marketing campaigns and generated reports to evaluate the effectiveness of marketing efforts.

    • United States
    • Professional Training and Coaching
    • 1 - 100 Employee
    • Operations Analyst Intern
      • Jun 2023 - Present

      • Collaborated on the Operations Analyst team, leveraging Python (pandas, scikit-learn) and Advanced SQL for streamlined data analysis and modeling. Improved workflows, reducing processing time by 20%. • Applied Python for comprehensive statistical analyses, including advanced regression models, to assess competition. Evaluated key metrics and impact of variables for Woo Juice, Worcester. • Implemented RFM model to segment customers, profile behaviors, analyzed purchase frequencies, and identified a 9% growth trend in life cycle spending through data-driven strategies. • Conducted competitor analysis and wrote a SWOT analysis to determine customer demand, pricing, sales. • Generated presentations and reports for insights and competitive analysis from collected data. Show less

    • United States
    • Higher Education
    • 700 & Above Employee
    • Research Assistant
      • Jun 2023 - Present

      • Supported a Texas Company in organizing logistics database and strengthening data relationships. • Created ETL pipeline to store data in MySQL warehouse and automated geolocation plotting in Tableau.• Conducted extensive data scraping and analysis using Python, leveraging request, regular expressions, and pandas to identify retail store locations, and envisioned geographical distribution in Tableau.• Engineered 92%-accurate carbon emission quantification using a precise General Linear Regression model for the Texas Company B2B shipping, validated through rigorous error analysis. Show less

    • Graduate Assistant
      • Feb 2022 - Present

    • Graduate Teaching Assistant
      • Jan 2023 - Aug 2023

      Teaching Assistant – Python Analytics Programming, Data Management & SQL for Analytics • Weekly meetings with the professor to discuss course assignments, labs improvements.• Grading Python labs, homework, midterms, and finals. Helping students projects.

    • NEDSI Competition Participant
      • Apr 2023 - Apr 2023

      We built several machine learning models, integrated learning, etc., such as XGboost, RandomForest, and logistic regression to predict the probability of coronary heart disease in the town of Framingham over the past decade. The results of the models were then implemented through visualization tools and explained in poster form. In final, we won the first place in the graduate team. We built several machine learning models, integrated learning, etc., such as XGboost, RandomForest, and logistic regression to predict the probability of coronary heart disease in the town of Framingham over the past decade. The results of the models were then implemented through visualization tools and explained in poster form. In final, we won the first place in the graduate team.

    • United States
    • Strategic Management Services
    • 1 - 100 Employee
    • Student Volunteer
      • May 2022 - Jun 2022

      Attended the conference as a student volunteer, took care of the logistics of the conference and organized the list of people and materials. Attended the conference as a student volunteer, took care of the logistics of the conference and organized the list of people and materials.

    • Financial Advisor
      • May 2020 - Apr 2021

      • Optimized web pages for search engines, increasing client investment resources by 30%. • Organized and updated MS Access database, inserted macros in Access database creation window. • Optimized web pages for search engines, increasing client investment resources by 30%. • Organized and updated MS Access database, inserted macros in Access database creation window.

Education

  • Clark University
    Master's degree, Business Analytics
    2022 - 2023
  • Shanghai Maritime University
    Bachelor's degree, Economics
    2016 - 2020

Community

You need to have a working account to view this content. Click here to join now