Alice Zhou Email & Phone Number

San Francisco Bay Area

San Francisco Bay Area

- Developed a partnership quarterly report tool which includes conducting scope discussions, designing the user interface and coding the backend.- Developed and improved processes and systems to derive meaningful information from complex accounting datasets of large sizes by using tools including SQL, SSIS, PowerShell and Tableau.- Implemented automation processes to replace repetitive tax reporting procedures, decreasing potential human errors.

San Francisco Bay Area

- Consulted clients on tax analysis issues, which resulted in a large amount of tax savings.- Conducted complex employment tax calculations for more than 30 clients by analyzing their employees’ tax backgrounds and creating shadow payroll models.- Completed the appropriate state and local employment tax notifications to establish employment tax liability for withholding and unemployment tax purposes for clients.- Verified the domestic state tax landscape and prepared summary matrices that are used to map transactions.

- Collaborated with cross-functional teams to analyze Shu Uemura monthly sales data and developed Excel models to identify product trends for the line manager to improve sales forecasting. - Conducted monthly sell-out reviews by using pivot tables to pinpoint anomalies for Clarisonic products. - Created an Excel database template to record costs, vendor codes, and internal order amounts for testers and products. - Assisted three line managers in the financial and marketing planning processes by participating in Key Account and Marketing meetings to brainstorm brand development plans for future implementation.

Master’S Degree, Accounting

Activities and Societies: MSA Graduate Assistant: Selected by computer business technology faculty at Kelley School of Business.

Bachelor’S Degree, Accounting And Finance