• Extracted data from multiple data sources, like Yahoo Finance, Morningstar and compared with 10-k’s Financial Statements into Excel to find the most accurate resource • Researched about the revenue forecasting methods and stock price forecasting methods and sum them up in a 50-page report. Template model for the forecasting methods, like straight-line method, linear regression and moving average using Excel. • Developed a stock evaluation model that scores financial indicators based on thousands of stocks from corresponding industries to find the range and also filter out those unhealthy data using Python

• Provided information to thousands of international students, faculty, and staffs, coming from China, India, Canada, Europe, etc., regarding to I-20, Visa status, CPT, OPT, Stem OPT, etc...• Assisted in data entry and filling essentials to the ISSS department recording process in Excel and ISSS website• Worked with university staffs to plan and successfully execute events, like Orientation and New Year Festival, from plan-making, event property preparing, event assistant during the event, and the event closing

• Simulated price of gas and electricity using Geometric Brownian Motion and simulated the gas losses and electricity output when the company operate the three units by using Quadratic Function to reach cost-efficiency• Predict future electricity and gas prices using Monte Carlo simulation to predict the option value for the next period

• Validated the international automobile industry credit rating for the international settlement department• Researched credit ratings for clients based on country of origin and creditworthiness• Negotiated with clients about the contracts related to the letter of credit, letter of guarantee, and bill of exchange• Organized 500+ international settlement documents utilizing Excel, using PivotTables, INDEX/MATCH• Participated in monthly online meeting to learn the updated information from the Head Office of Bank of China, and discuss the unusual cases with other branches of Bank of China

• Contributed new ideas for 10 events each semester, like the Casino Night• Worked with other members to plan and execute events from plan making, event property preparing, event stage setting, event assistant during the event, and the event closing• Reached out to invite students to join our events through clubs connection, Facebook, Snapchat, poster

• Utilized Wind Financial Terminal, which is similar to the Bloomberg in the U.S., to collect and verify data of various stocks traded on the Shanghai Exchange• Analyzed stock performance using financial ratios and forecasted future price trend• Assisted in periodic budgeting and projections of revenue, profit, and cash flow• Coordinated with program members and attended weekly meetings