Langzhuo (Aaron) Bi

Project Manager Intern - Southeast Asia Regional Operations

• Consolidated and analyzed weekly revenue data from Four key channels (e-commerce, physical stores, RoboShop, and BTC) for overseas subsidiaries, delivering comprehensive revenue reports to senior management.
• Monitored and documented the overall project progress of Indonesia's first national flagship store, ensuring seamless communication and coordination across departments, while providing real-time updates on project milestones.
• Utilized advanced Excel functions (pivot tables, charts, VLOOKUP, etc.) to perform profitability analysis for the Singapore subsidiary, identifying underperforming products and proposing actionable solutions for improvement.
• Participated in overseas meetings, synthesized key insights, and prepared comprehensive meeting minutes and follow-up documentation for executive review.

Customer Service Assistant

• Operated point-of-sale systems to process cash and card transactions with accuracy and efficiency.
• Managed inventory restocking and shelf organization to ensure product availability and store cleanliness.
• Provided prompt assistance to customers, resolving inquiries and supporting smooth store operations.
• Collaborated with team members to maintain operational workflow in a fast-paced environment.
• Demonstrated responsibility by handling end-of-shift cash reconciliation and compliance procedures.

• Analyzed a large dataset from MetroMart's supermarket chain, focusing on sales, customer demographics, and product performance across multiple regions in the United States.
• Created interactive dashboards using Microsoft Power BI to showcase key data insights, including state-wise revenue, profit analysis, and top- performing products.
• Addressed key business questions related to revenue and profitability, identifying underperforming regions and products, and providing actionable recommendations for business strategy adjustments.

Ticket Attendant

• Managed ticket sales and ensured accuracy in handling payments, contributing to a smooth and efficient operation.
• Collaborated with event staff to ensure clear communication and resolve any customer inquiries or issues quickly.
• Demonstrated attention to detail and customer service skills in a fast-paced environment.

Event Planner

• Planned and executed the university's first badminton competition, managing event logistics and schedules.
• Recruited and trained volunteers, coordinated social media promotion, and liaised with sponsors.
• Successfully increased UQCSSA's social media followers by over 1,000 and secured sponsorships from over 20 renowned companies.