Category
HR Management
Technology
Submitted By
Laura Abeyta-Martinez, Laura.Abeyta-Martinez@cu.edu, Sr. Business Systems Analyst
Project Team
Laura Abeyta-Martinez, Laura.Abeyta-Martinez@cu.edu, Sr. Business Systems Analyst
Kym Calvo, kym.calvo@colorado.edu, Assistant Vice Chancellor, Compensation & Talent Acquisition
Peter Dodge, Peter.dodge@colorado.edu, Senior HR IT Business Analyst
Van LePage, Van.lepage@cu.edu, HCM Developer
Richard Escamilla, Richard.escamilla@cu.edu, Production Support Professional
Natan Tuchman, Natan@colorado.edu, HR IT Program Manager
Project Description
CU Boulder Campus required a secure integration file that would capture active regular employee compensation data and job history, and an upload and transmission process from HCM to their Payfactors vendor. The transmission had to comply with the vendors organizational and data requirements. Payfactors is a compensation management system tool that assists in capturing and delivering employer validated compensation data to provide more accurate, reliable, diverse and dynamic data to determine the market price value of jobs based off the current industry and location.
The CU Boulder Campus was using an HCM system-built query to capture current demographic data by utilizing other customized demographic information that would capture employee information such as work history, job history, years of service, job titles, work experience, current job experience, pay information, performance ratings, etc., and then spent at least 32 hours per month manually formatting and manipulating the data into a comprehensive file to upload to the Payfactor’s system.
Project Efficiency
The team was able to comply with the Payfactors organizational requirements by the team’s creation of an automated, secure integration and transmission process that captured ALL employee data in a format that is readable and useable in the Payfactors system. This automation also delivers it on a pre-determined schedule that is sent daily with current data, and on an as needed basis. The current automated process now saves at least 32 hours per month at an annual savings of 384 hours in the time spent to properly format the data. Additional human costs would amount to an hourly rate of $55 per hour which multiplied by 384 is $21,120.
Project Inspiration
This automated integration can be used by other CU campuses if desired. Other campuses who choose to use Payfactors as their vendor, can capture diverse and dynamic compensation data to assist them in understanding competitive pay trends while adapting to today’s changing talent environment. This will assist in guiding them in making more efficient and scalable pay and equity decisions for the future. Our integration can support their needs and offers an extra set of hands in an automated fashion.
What Makes You Happiest about this Project?
Happiest about this – All of the team was happy about the ability to deliver this new automated integration and the many human hours that were saved is synonymous. There were many hours of system testing and regression testing to accomplish this huge undertaking! Additionally, this integration bridged a gap between two customizations, that were previously completed i.e., Position Compensation and Employee Experience pages that pulls data into the integration further allowing for more comprehensive reporting.
Note: Payfactors was recently acquired by Payscale.