PW

Peiyuan Wang

Operations Analytics Intern · Uncommon Goods

Jersey City, NJ

Work Experience

Operations Analytics Intern

Uncommon Goods

2020 – Present

• Extract, manipulate and analyze operations packages and shipping data and finish ad-hoc analysis requests using PostgreSQL • Own, manage, design Tableau dashboard to analyzing, modeling and visualizing data for operations and analytics team • Calculate operations metrics through Pivot Tables and other formulas and create weekly report for management team • Improve efficiency of warehouse inventory automatic check from 30 minutes to 10 seconds using Python Pandas • Developed a scalable machine learning model to predict the future productivity of packers and pickers

Data Analyst Intern

The Wright Star LLC

2020 – 2020

• Wrote SQL queries to retrieve relevant data stored in PostgreSQL database to be used in data analysis activities • Cleansed up data format, missing values, duplicates, and data logic to ensure data is error-free and ready for statistical analysis • Performed daily market analysis to determine market rents and price trends through Excel based on modeling • Conducted in-depth company/industry research and supporting quantitative analysis to identify potential investment opportunities • Owned and launched a lease review tool in Tableau to enable portfolio managers to track lease expiration and project deadlines

Digital Marketing, Analytics Intern

UniCareer

2018 – 2018

• Increased websites visit by 8% through conducting SEO strategies, and used Google Analytics to monitor the performance • Managed the company social media platforms to improve brand awareness, customer creativeness and activeness • Created customer segments based on user behavior data through cluster analysis, validating assumptions via iterating A/B testing and presented test findings to stakeholders and identified potential customer groups • Collected sales data and conducted data cleaning and statistical analysis in Excel and Python to develop monthly weekly reports • Analyzed viewers' clickstream for marketing emails and identified right time and messages to convert newsletter readers to clients

Marketing and Public Relations Intern

Ritz-Carlton Hotel Company

2017 – 2017

• Provided PR and social media counseling and support for strategic campaigns, events • Initiated customer research by implementing and running analysis in Salesforce. The research findings have been applied in marketing strategies and successfully helped on increasing the customer conversion rate • Managed and track brand marketing and social budgets to ensure effective budget use

Product Analyst Intern

AIA Group Limited

2014 – 2014

• Worked on pricing modeling & advance data analysis including predictive modeling, loss ratio and regression analysis using Excel • Developed and maintained weekly monitoring PowerPoint in identifying performance gaps on state, region, and countrywide levels • Cooperated with product management team on new product introduction, participated in filling of state rollout and implementation

Education

Bachelor of Science in International Tourism Management

Macau University of Science and Technology

2013 – 2017

Bachelor of Science in International Tourism Management

Master of Science in Management and Systems

New York University

2018 – 2020

Master of Science in Management and Systems

Master of Science in Integrated Marketing

New York University

2018 – 2018

Master of Science in Integrated Marketing