- Calculated accounts payables and receivables at the end of every month to plan the pricing of event spaces- Produced financial statements to guide future marketing strategies, solving 4 months of promotional cost overruns- Coordinated a 300-person "Koi" event to increase reputation and strengthen relationships with other businesses, resulting in 37.42% increase in business volume and 32.31% in weekday room usage in December 2022

- Assisted in holding the 2022 Mid Autumn party with 500 people, acting as the backstage props, docking actors, and communicating with the rehearsal work- Organize rewarding events for members who joined our discussions; introduce Chinese culture to the local students- Joined meetings once per week and recorded the note for activities- Assisted President in promoting the activities we organized, such as Lunar New Year and Homecoming

- Leveraged 20+ SQL scripts with over 500+ rows in Google BigQuery for Other Part Analysis, MTO, and Assembly Projects, resulting in analyses with Pivot table, one-page report, and visualizations- Enhanced the SLA Order Audit sheet, developed an automated tracking system for Suppliers off parts, and optimized the Weekly Business Review metrics through App Script in Google sheet, GBQ queries, and Python- Completed SQL scripts required by seven projects with the corresponding analyses, repairing the bugs and data errors of related datasets, and helped the team to shorten Service Level Agreements from 10 days to five days- Reversed $8K worth of erroneous supplier credits for “Other Part” analysis in the first month, saving approximately $100K annually

- Developed Scrapy models and Web Crawler to establish a database for UberEATS restaurants- Analyzed virtual and physical restaurants on UberEATS by using Python libraries such as Pandas and NumPy to distinguish between duplicated addresses- Created visualizations to compare the rating and influence of virtual and physical restaurants

- Spearheaded background research of BeiGene and ACM Research by analyzing financial statements, product lines, marketing situations, and the global market- Analyzed companies’ Form 10-K for the most recent five years, implemented SWOT Analysis to compare the data with competitors in the market- Applied Tableau and Excel to provide data visualization to the Strategy Department- Independently drafted six reports that were included in two business analysis reports of BeiGene and ACM Research

- Guided customers to open accounts and fund investments with the company's investment advisers.- Enhanced communication skills by accompanying investment advisors to negotiate with clients.- Supported fund sales by communicating with customers, guiding them through the investment process, and introducing funds to help make investment decisions.- Handled over 110 customer receptions.

- Communicated effectively with students and parents in English, assisting with AP & TOEFL course selections and securing contracts worth an average of 20,000 RMB.- Practiced Japanese Speaking and Writing through shadowing classes and managed the public account in the Marketing Department at PalmDrive Inc.