Katherine Guillen
Real Floors, Inc
Kennesaw,GA
2
years of professional experience
Achieved improved operational efficiency by implementing data-driven solutions in compensation analysis and payroll management.,Delivered actionable business insights through the creation of executive dashboards and robust workforce reporting.,Enhanced compensation and workforce analytics tools by auditing HRIS and payroll data in collaboration with HR and finance teams.
Work History
HR Specialist, Compensation & Total Rewards
10 Months- Manage end-to-end payroll for 900+ employees, including multi-state payroll processing, timekeeping audits, salary adjustments, commissions, and tax compliance.
- Perform payroll reconciliation and compensation reporting using advanced Excel functions (Pivot Tables, XLOOKUP, VLOOKUP), ensuring data accuracy and timely reporting.
- Develop automated HR reporting tools using Google Sheets, pivot tables, dynamic formulas, and data visualization to improve reporting efficiency and reduce manual processes.
- Conduct benefits audits by reconciling employee elections, payroll deductions, and vendor invoices to ensure accuracy, compliance, and operational efficiency.
Payroll Administrator | Contract Work
9 Months- Managed payroll and HR support for 900+ employees by verifying timecards, resolving discrepancies, ensuring accurate payroll processing, and serving as a bilingual (English/Spanish) point of contact for payroll inquiries, Paycor access, employment verifications, and unemployment claims.
Office Administrator
6 Months- Supported daily office operations, including timekeeping, payroll support, employee record maintenance, and administrative coordination.
Education
SHRM-CP
No Degree - Business Administration, Marketing
Coursework Completed
Skills
Compensation Administration
Compensation Analysis
Multi-State Payroll
Payroll Reconciliation
Benefits Administration
Workforce Analytics
Dashboard Development
Executive Reporting
HRIS Data Management
Proficient in Microsoft Excel And Google Sheets
Compliance: FLSA
ACA
EEOC
Process Improvement/Workflow Optimization
Timeline
HR Specialist, Compensation & Total Rewards
Real Floors, Inc
09.2025 - CurrentRead More
Payroll Administrator | Contract Work
PEPL (Real Floors, Inc)
11.2024 - 08.2025Read More
Office Administrator
ReVamp Flooring
04.2024 - 10.2024Read More
Kennesaw State University
No Degree from Business Administration, Marketing
Read More
Society of Human Resource
SHRM-CP
Read More