Summary
Overview
Work History
Education
Skills
Languages
Timeline
Generic

Hujiazhou Shen

St. Louis,MO

Summary

Detail-focused Data Analyst with knowledge in data warehousing, process validation, data visualization, and business needs analysis. Organized and dependable candidate successful at managing multiple priorities with a positive attitude. Willingness to take on added responsibilities to meet team goals.

Overview

2
2
years of professional experience

Work History

Business Analyst

Ephlux
06.2023 - Current
  • Attended department meetings to report on findings and to brainstorm and share new ideas with other team members.
  • Enterprise Division/Swift Product Line (App Automation Platform) Led market analysis for Swift product line, culminating in comprehensive and updated Competitive Analysis Report for 2023, offering valuable insights into Swift's market positioning.
  • Conducted Pricing Competitive Research study for Swift and its key competitors and delivered its pricing strategy findings, facilitating competitive advantage in industry
  • Currently participating in more tasks...

Student Data Assistant

Washington University John M. Olin Library
09.2022 - 03.2023
  • Library Space and Building Operations Management (LSBOM) Collected daily Library operation data using WashU Library spreadsheet (7% of 2022 data collected)
  • Led team of three student assistants in cleaning Library weekly operation data using SQL, and all 2022 Fall data cleaned
  • Proactively Analyzed Library weekly operation data with Tableau, presenting insights via weekly dashboard reports to head, resulting in the identification of two underutilized rooms.

Brand Analyst

AirMedia
04.2021 - 08.2021
  • Led team of four in creating 2021 airport advertisement product videos using Excel and Adobe PR (32 airports, completed before departure)
  • Independently created 2021 Q2 product performance report using SQL and Tableau for AirMedia's Q2 partner meeting
  • Presented airport advertisement products to three customer companies using PowerPoint and Tableau, resulting in two new clients
  • Assisted in customer targeting and advertising campaigns for AirMedia's TikTok live-streaming sales (7 sales)
  • Contributed to designing new AirMedia website landing page via survey analysis, successfully incorporating new features.

Education

Master of Science - Business Analytics

Washington University in St Louis
St Louis, MO
12.2023

Bachelor of Arts - Media Art Production, Marketing Communication

Emerson College
Boston, MA
08.2022

Skills

  • Data Analytics: Python (NumPy, Pandas), SQL, Tableau, Power BI, MS Excel, A/B Testing, Swift for JD Edward
  • Machine Learning: R (Classification, Regression, Clustering Modeling)
  • Others: Marketing Analytics (NumberAnalytics, Excel), Digital Marketing, Cloud Computing (AWS), JD Edwards, Enterprise Application Integration
  • Certifications: Ephlux SWIFT Certified Consultant

Languages

English
Full Professional
Chinese (Mandarin)
Native or Bilingual

Timeline

Business Analyst

Ephlux
06.2023 - Current

Student Data Assistant

Washington University John M. Olin Library
09.2022 - 03.2023

Brand Analyst

AirMedia
04.2021 - 08.2021

Master of Science - Business Analytics

Washington University in St Louis

Bachelor of Arts - Media Art Production, Marketing Communication

Emerson College
Hujiazhou Shen