Operations Analytics Intern

•   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

•   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

Data Analyst Intern

•   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

Digital Marketing, Analytics Intern

•   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

Marketing and Public Relations Intern

•   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

Product Analyst Intern

Find out detailed information about Peiyuan Wang, Operations Analytics Intern in Jersey City, NJ

Peiyuan Wang: Operations Analytics Intern in Jersey City, NJ

Peiyuan Wang

Uncommon Goods

The Wright Star LLC

UniCareer

Ritz-Carlton Hotel Company

AIA Group Limited

Macau University of Science and Technology

New York University

New York University