• Created cross-departmental budget from scratch that encompassed all general ledger accounts and each with two dimensions (department and location) to enhance data utility and provide additional insights for financial analysis.• Developed and managed self-service financial dashboard using SQL and Tableau to examine company’s financial health and track each sector’s actual result vs. budget, enabling users to manipulate with multi-level filters.• Identified reporting and system issues by executing various SQL queries in the database and communicated detailed findings with database developers to facilitate the fixing process.• Introduced Tableau to the company and created multiple dashboards to support sales and accounting departments.• Conducted supply chain analysis for decision in buying new distribution center. • Performed data testing for business acquisition to help pinpoint any errors in the migration of inventory and financial data.• Responsible for designing and updating regular daily/weekly/monthly reports for the leadership team, including sales by business segment (e-commerce and stores), sales by location, and sales by category.• Provided collection support by building report to detect uncharged invoices and utilizing SQL to find the overall impact and cause of each specific situation.

Served over 120 students for college level accounting/economics/statistics classes.• Courses taught: Micro/Macro Economics, Econometrics, Elements of Statistical Methods, Cost-Benefit Analysis, Financial Accounting, Managerial Accounting, Cost Accounting, Business Law, etc.• Customized course materials based on each group of students’ learning habit and knowledge level, helping them achieve their educational goals.• Synthesized complex subjects into digestible pieces of information and communicated efficiently.

Worked as a tutor and teaching assistant for multiple classes in the business department.• Assisted students with class assignments, exam preparations, and term projects during weekly office hours.