Work Experience
Operations Analytics Intern
Uncommon Goods2020 – 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 LLC2020 – 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
UniCareer2018 – 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 Company2017 – 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 Limited2014 – 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 Technology2013 – 2017
Bachelor of Science in International Tourism Management
Master of Science in Management and Systems
New York University2018 – 2020
Master of Science in Management and Systems
Master of Science in Integrated Marketing
New York University2018 – 2018
Master of Science in Integrated Marketing