Financial Analyst
CurrentData handling- payroll data & adjustments (as needed), compensation changes, retro pay calculations, hours worked, overtime data, bonuses, and reimbursements.Data visualization- utilized interactive dashboards in Excel to visualize payroll data, calculate average rates for each property, and compare sets of data for balancing and to determine if there were any discrepancies or outliers.Data cleaning- used advanced Excel functions to properly format sheets for uploading data.Data sorting- utilized Excel pivot tables & graphs in order to organize payments by property and states the property serviced, as well as increase overall organization & efficiency.Prepared and processed payroll for 5,000+ employees (Exempt, Non-Exempt and Multi-State) using Lawson, Infinium and Workday systems.Communication- responsible for responding to daily inquiries from internal & external parties regarding tips & compliance, garnishments, and taxes- federal & state.Performed payroll transactions related to garnishments- set up, interrogatories, weekly transmittal of payments, refunds, and attorney-court correspondence.