PeopleSoft Reports Developer

Sr. Employee Business Intelligence, Reporting Analyst & HRIS Administrator

Proficient in operating SQL, Alteryx, Crystal Reports, Tableau, VBA, Visual Basic, Microsoft Office Suite, WorkDay, PeopleSoft, Ceridian Products, ADP Products, PayChex Systems, Cognos, and PRO-Business.

Developed automated Employee Wage Statement process for FLSA and Wage Changes, using Corporate and State specific forms, and automating Portable Document File encryption for secure distribution.

Converted Legacy HR/Payroll data from acquired Company to load into SQL Server for reporting purposes.

Created User Excel Input Form and Database process for uploading Payroll transactions for over 25,000 employees bi-weekly, saving the Payroll Department over 12 hours of manual effort from 6 employees during each bi-weekly pay cycle.

Reduced Company costs by over $500,000 annually, working with Insurance Department to revise and create reports for Workers Compensation Audits.

Developed Benefit comparison reports to align WorkDay, PeopleSoft, and Vendor supplied information; reducing errors and manual labor.

Created Paid Parental Leave database process for Benefits Department, eliminating manual effort of staff to process for Payroll. Reduced turn-around time for Payroll remittance from 2 days to 2 hours each bi-weekly pay cycle.

Uncovered and resolved major 401k discrepancy that put the plan at risk with the Federal Government.

Created multiple specialized reporting initiatives to assist the CFO and Accounting Department with business decisions for Fiscal Year, along with specialized End of Year reporting.

Converted Company Human Resource and Payroll Systems employee information from Ceridian to ADP to facilitate Bi-Weekly Payroll processing and employee Human Resource information maintenance.