Highlights:

Skills:Financial analysis, Data analysis, Excel, Tableau, SQL, Communication

Business Analyst 01/2022 - 06/2022
Bytedance Technology Ltd., Shanghai, Shanghai China
?Construct e-commerce business analysis dashboard, independently build daily dimensional performance dashboard, track the Gross Merchandise Value achievement of service providers from the perspective of type, industry, penetration rate, etc., and consolidate e-commerce data infrastructure ?Upgrade service provider capability model 2.0, participate in scoring method collation, model logic verification, service provider interview, typical case output and other links, output industry-specific capability evaluation model to help merchants improve operation capabilities in a targeted manner
--
Consultant 07/2021 - 12/2021
Ernst & Young (China) Advisory Limited, Shanghai, Shanghai China
?Responsible for the data asset value assessment module: Sort out and build models with cost method, income method, market method, comprehensive method, analytic hierarchy process and neural network; optimize the data analysis methodology according to previous case study research, and carry out the customized strategy for more than 9000 data assets under six categories of business industry; use the evaluation results to put forward rectification suggestions for the work and improve the data operation and management level of SFE.
--
Financial Analyst 03/2021 - 06/2021
General Mills, Shanghai, Shanghai China
?Responsible for the cost variance analysis of the company's supply chain; Classify the cost through the PivotTable; Pinpoint the changes and anomalies; Compose weekly and monthly financial analysis reports ?Prepare and review the capital budget and update the budget table monthly by rolling budget method; Monitor budget variances and communicate with other departments on budget usage ?Assist the supervisor to deal with the company's payment process, review and record more than 200 contracts every month
--

Washington University in Saint Louis 09/2022 - current
Saint Louis, MO, United States
Degree: Master's Degree
Major:Business Analysts
Major in Business Analysts with w/GPA of 3.98.

Login to view resume: Augustina Chen - 2023.1