HSIN-YANG LAI
Master of Marketing
A highly motivated graduate student works on an academic paper regarding demand planning. Passionate about supply chain management. My strength is the data analysis and communication skills I have gained from internships and projects that enable me to identify growth opportunities and drive innovation in development.
Email: [email protected]
Phone: 0988162226
Work Experience
Merchant Operations Intern, Shopback
Jun 2022 - Dec 2022, 6 months
- Enhanced 5% of revenue by using Pivot Table and multiple excel functions to analyze data and compare different reports to resolve operational issues.
- Visualized data into information that can be used to take appropriate action by utilizing Pivot Table.
- Optimized workflow for the whole department by using Python and Confluence and saved 30% of the time.
- Developed strong B2B and cross-functional communication skills by cooperating with 5+ merchants.
- Yielded 1 million dollars in revenue by setting up more than 200 merchants' integration with ShopBack.
- Communicated with merchants and coordinated with internal departments to solve issues efficiently and improve 5% of customer service.
Campus Ambassador, SPONYA
Mar 2021 - Jun 2021, 3 months
- Negotiated with the merchant and made the company's exposure increase by 10%.
- Bargained with the merchant and saved 20% of the company's cost.
- Launched Watsons' project and boosted the product's exposure to more than 400 people in less than one hour.
Accounting Intern, AILLIO
Feb 2020 - Aug 2020, 6 months
- Improved work efficiency by applying ERP, Woocommerce, and Quickbooks.
- Built financial reports and maintain daily tasks by utilizing Excel.
- Set up accounting information successfully for all orders from Feb to Aug.
Activities
Student Association, Chief Director of Planning
Sep 2018 - Jun 2019
- Sharpened adaptability to solving emergencies.
- Organized three large-scale activities, which had nearly 300 people come.
- Developed great cross-functional communication skills by cooperating with the marketing
department for a 100-person event.
Projects
IPA Analysis
Conducted market analysis and proposed operational and marketing strategies for three food delivery companies in Taiwan by utilizing R language to build a web crawler, execute data cleaning, and analyze data.
Education
Sep 2021- Jul 2023
National Chung Hsing University
Master of Marketing
- Research: Building a purchasing and inventory control model for perishable goods.
(Utilizing Excel functions and Solver to attain the best purchasing and discount solution.) - Statistics course: Came out first in the class.
Sep 2017- Jun 2021
National Taipei University
Bachelor of Business Administration
Certification
- SQL (Coursera)
- Python (Coursera)
- Tableau (Coursera)
Skills
- Project Management
- Business Administration
- Logistics Management
- Data Analysis
Tools
- Excel: Solver, Pivot Table, Index, Vlookup
- Google doc/sheet/slide
- Tableau
- PowerBI
- PowerPoint
- Metabase
- SPSS
- Confluence
- Trello
- Python
Language
- GMAT: 680 (2021/8)
- IELTS: 7 (2022/3)
