 Mainly participated in the financial control of the company, updated daily the account status of the five major banks and the number of deductions and loans for retail and wholesale, performed a forecast of rolling cash flow by adjusting drawdown by account status and transfer between accounts to predict next week’s account flow. Collected weekly sales data of all Volkswagen models (50+), covering new and old cars, retail and wholesale, applied Excel Pivotable to analyze the sales growth for that week or month, visualized the company’s sales and growth during a certain period, and completed New Mobility Service weekly report; Combined market research with cash flow analysis to provide analysis reports on business margins and each product’s profitability to support the sales department.  Assisted colleagues to sort out data of over 400,000 past orders and contracts through Power Query for monthly settlement reports, including data integration, matching, screening, classification, calculation, etc.

 Daily recommendation of JingData App: recommended 5 projects at Angel round or seed round financing online daily, promoted them on App, website, and WeChat based on their business plans (BP) and project statements to increase the opportunity of financing. Recommended total number of 250 projects in 50 phases. Participated in the 1% Project Recommendation of JingData App: selected and recommended 5 high-quality projects to investors weekly. A total of 40 projects in 8 phases were launched. Designed the promotion plan for projects: summarized project highlights and collaborated with the design department to produce advertising materials for projects on WeChat, website and App daily to increase exposures of high-quality projects. Recommended The 1% Project among investors in 12 regions, screened more than 1,000 users daily through Excel, and selected potential clients for the Marketing Department; Contacted more than 3,000 customers, added about 500 new project parties during the intern, and assisted them to improve the project statement on the platform. Focused on the issue of losing users and low activity of existing users and suggested measures to achieve better user retention.

 Managed the information of 2000+ employees in the Beijing branch, used Excel to update lawyers’ professional information, created Beijing talent archive lists, and integrated with related information forms into a total table to upload the system. Screened resumes according to the recruitment requirements of each department, optimized resume screening process according to HR’s feedbacks. Recommended about 50 people for the interview and about 10 people for the final entry. Responsible for daily staff’s changes, renewal of employment contracts and information entry into the system, managed the new employee system and HR system, exported information and statistics of daily entry with an average of 50 people per week Recorded internship status of interns, managed internship evaluation forms, uploaded exit signature and transfer forms, sent contracts, and issued internship certificates; classified and organized files into volumes.

 Mastered more than 20 kinds of coffee practices in 2 days, received guests, collected cash, satisfied the needs of customers, updated product storage, and registered amount for the running bill.