Mengqing Li Email & Phone Number

Atlanta Metropolitan Area

Atlanta Metropolitan Area

United States

Data collecting process

Shanghai, China

• Utilized Pivot table and VLOOKUP to facilitate business analysis and prepared weekly dashboards and reports; presented business and market trends regarding sales benchmark data to management and Operation team• Achieved report automation by creating formulas for new templates in Excel, increasing reporting efficiency by 300%; finding data errors and recovered more than 10 million losses for the company• Offered technical support to manager on data and problems-oriented analysis report by using Salesforce and Tableau; shared data visualization with managers to help see monthly fluctuations and present• Coordinated with other departments to deal with product issues and customer complaints

Chongqing, China

• Cooperated with manager to prepare financial reports and perform due diligence on tax regulations, and identified strengths and weaknesses of company finance by using SWOT methodology• Utilized analytic methods to conduct business operation data analysis by identifying operating problems, proposing practical solutions, and working on systematic reports• Collected and integrated data for analysis on car industry, such as enterprise and public policy, and have a conversation with company manager to clarify data• Reviewed accounts payable and receivable with third party vendors and submitted correct checklist to audit manager• Collaborated with 8 team members to complete audit work of two IPO projects by managing production of audit papers

Master'S Degree

Bachelor Of Science - Bs, Accounting

Education record

Master'S Degree, Accounting