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.

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.

- 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.

Master’S Degree, Accounting

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

Bachelor’S Degree, Accounting And Finance