Business Analyst Intern

• Oct 2023 - Present

Finance Department Intern

• Jan 2022 - May 2022

-Collected financial data (operating income, loan, etc.) and employee data from sub-branch banks, used pivot table in Excel to classify then summarize data into different tables for the monthly and quarterly reports. -Utilized python when summarizing data, which improved work efficiency by 60%. -Collected all original certificates from other departments every month. Checked more than 300 original certificates according to regulation, filled in the accounting vouchers according to the corresponding subjects showed in certificates, with an accuracy of 100%. -Helped financial director to make more than 200-page PowerPoint slides for employee training according to a new issued regulation to improve employee’s efficiency. Show less

Marketing Research Intern

• Dec 2019 - May 2020

-Collected and sorted out data of more than 100 valid car usage questionnaires. -Used Excel to process, analyze, and visualize the customer preferences, captured user persona, and studied customer consumption behaviors to help brands locate target customers. -Gathered and compared data of competitive products’ models and prices in Excel. Concluded the car purchasing tendency under the new energy and COVID-19 through text analysis and completed a report. -Coordinated with other departments to look for the top 5 Apps in loading and updated the data and icons in EXCEL. Analyzed young people’s preference for APPs. Show less

marketing analysis intern

• Jun 2019 - Nov 2019

-Calculated and compared the indexes (e.g., the sales growth of different cars, quarter-on-quarter and year-on-year growth rate) in different regions according to the sales data to detect the unusual fluctuations and completed a 300-page quarterly market research report. -Tracked trending events and new models in the automobile industry. Collected macro metrics and indicators and summarized them into analytical dashboards for the downstream decision-making process. -Calculated and compared the indexes (e.g., the sales growth of different cars, quarter-on-quarter and year-on-year growth rate) in different regions according to the sales data to detect the unusual fluctuations and completed a 300-page quarterly market research report. -Tracked trending events and new models in the automobile industry. Collected macro metrics and indicators and summarized them into analytical dashboards for the downstream decision-making process.

Finance Intern

• Dec 2018 - Feb 2019

-Responsible for the management and checking of daily income and expenditure -Responsible for the development and storage management of checks, money orders, invoices and receipts -Collect and review original credentials -Assist in processing reconciliation data -Responsible for the management and checking of daily income and expenditure -Responsible for the development and storage management of checks, money orders, invoices and receipts -Collect and review original credentials -Assist in processing reconciliation data