SYSTEMS AND METHODS FOR COMMUTE ANALYSIS AND MODELING

• US 20160321590A1
• Filed: 04/28/2015
• Published: 11/03/2016
• Est. Priority Date: 04/28/2015
• Status: Active Grant

• Current Assignee: ADP, Inc.
• Original Assignee: ADP LLC (ADP, Inc.)
• Inventors: Bangali, Kishore, Havaldar, Sachin V., Rind, Marc, Wang, Xiaojing
• Granted Patent: US 10,474,978 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06Q 10/06393 Score-carding, benchmarking or key performance indicator [KPI] analysis

Abstract

A method and system for analyzing employee retention across an enterprise based on commuter modeling is disclosed. The method can be implemented in a computer system which includes: mapping longitudinal and latitudinal coordinates of address information of a plurality of employees and a work location onto a map, which shows a predefined geographic location encompassing the work location surrounded by the longitudinal and latitudinal coordinates of the address information; obtaining calculated analytics data of employee turnover rate for the plurality of employees based on a commute distance from the work location to each of the longitudinal and latitudinal coordinates of the plurality of employees; and graphically overlaying the analytics data of the turnover rate for the plurality of employees onto the map to show employee turnover rate for different segments of the map.

Claims

1. A method implemented in a computer system comprising:

mapping longitudinal and latitudinal coordinates of address information of a plurality of employees and a work location onto a map, which shows a predefined geographic location encompassing the work location surrounded by the longitudinal and latitudinal coordinates of the address information;

obtaining calculated analytics data of employee turnover rate for the plurality of employees based on a commute distance from the work location to each of the longitudinal and latitudinal coordinates of the plurality of employees; and

graphically overlaying the analytics data of the turnover rate for the plurality of employees onto the map to show employee turnover rate for different segments of the map.

2. The method of claim 1, wherein the graphically overlaying of the analytics data of the turnover rate occurs upon selection of the work location.

3. The method of claim 1, wherein the obtaining of the analytics of the turnover rate is extracted from a database using an application program interface (API).

4. The method of claim 1, wherein the longitudinal and latitudinal coordinates is obtained using a geocode service API.

5. The method of claim 1, further comprising obtaining employee information including the address information from a database by extracting the employee information using an API.

6. The method of claim 1, wherein the map is obtained through a JavaScript charting library and the latitudinal and longitudinal coordinates is plotted onto the map using a geo-JSON specification.

7. The method of claim 1, further comprising using a jQuery to plot additional information onto the map.

8. The method of claim 1, further comprising plotting additional information onto the map including at least forming a line connecting each of the longitudinal and latitudinal coordinates of each employee to the work location.

9. The method of claim 8, wherein the additional information is a plurality of concentric circles at certain radii from the work location and employee turnover rate is calculated and graphically shown for each of the concentric circles based on the longitudinal and latitudinal coordinates falling within each of the concentric circles.

10. The method of claim 9, wherein the employee turnover rate is represented as a percentage of termination within each of the concentric circles.

11. The method of claim 9, wherein the concentric circles move based on a selection of a new work location, and wherein the longitudinal and latitudinal coordinates fall within each of the moved concentric circles such that a predictive model is created to determine how many employees would have terminated employment based on a commute distance from the new work location.

12. The method of claim 9, wherein the lines connecting each of the employees to the work location signifies different metrics associated with each of the employees.

13. The method of claim 12, wherein the different metrics comprise employee status including at least one of new hire, current employee, terminated employee and employment information.

14. A computer system for generating an employee retention model comprising:

a hardware memory device that stores program instructions; and

a processor that executes the program instructions and causes the computer system to;

map longitudinal and latitudinal coordinates of address information of a plurality of employees and a work location onto a map, upon selection of the work location;

extract analytics data of employee turnover rate for the plurality of employees associated with a commute distance from the work location to each of the longitudinal and latitudinal coordinates of the plurality of employees; and

generate an overlay of the extracted analytics data on the map which graphically represents employee turnover rate for different segments of the map centered about the work location,

wherein the program instructions are stored on computer readable storage medium for execution by a CPU via computer readable memory.

15. The computer system of claim 14, wherein:

the longitudinal and latitudinal coordinates of address information is obtained using a geocode service API; and

the analytics of the turnover rate and employee information including the address information is extracted from a database using one or more APIs.

16. The computer system of claim 14, wherein the map is obtained through a JavaScript charting library and the latitudinal and longitudinal coordinates is plotted onto the map using a geo-JSON specification.

17. The computer system of claim 16, wherein the processor that executes the program instructions causes the computer system to further plot additional information onto the map including at least a line connecting each of the longitudinal and latitudinal coordinates of each employee to the work location and a plurality of concentric circles at certain radii from the work location which is representative of the different segments of the map centered about the work location.

18. The computer system of claim 17, wherein:

the concentric circles move based on a selection of a new work location,

the longitudinal and latitudinal coordinates are plotted with respect to the moved concentric circles; and

the processor that executes the program instructions causes the computer system to further calculates and graphically shows, in an overlay format, how many employees would have terminated employment based on a commute distance from the new work location.

19. The computer system of claim 17, wherein the lines connecting each of the employees to the work location signifies different metrics associated with each of the employees.

20. A computer program product comprising computer readable program instructions stored on non-transitory computer readable storage medium, the computer readable program instructions causing a computing device to:

extract address information of a plurality of employees from a database using one or more service APIs;

convert the address information into longitudinal and latitudinal coordinates using geocode service APIs;

upon selection of a selectable work location provided on a map;

plot the longitudinal and latitudinal coordinates of the plurality of employees onto the map, surrounding the selectable work location;

extract an employee termination rate for the plurality of employees associated with a commute distance from the work location to each of the longitudinal and latitudinal coordinates of the plurality of employees;

draw defined segments on the map which centers about the selectable work location and which includes at least some of the longitudinal and latitudinal coordinates within the defined segments; and

post data of the turnover rate for each segment of the map graphically showing a percentage of the employee termination rate for each segment based on the commute distance.