Effective Payroll Processing system for Retail Employees using Databricks Ingestion Framework and Salesforce Approval Workflow

An effective payroll processing system is a hallmark of a well-functioning organization which provides key benefits like accurate calculations of wages, taxes, benefits, adherence to compliance & regulations and finally Improved Employee satisfaction along with low attrition rate. This paper proposes a solution for payroll processing by leveraging Databricks (built on Apache Spark which can handle massive datasets and perform complex computations) and Salesforce approval workflow (helps in review & routing of timesheet approval requests, enables quicker decision making, helps in tracking progress and status of timesheet approvals and provides comprehensive audit trail). In the proposed solution the databricks job will process raw data files containing employee information, retail chain hierarchy information, benefits information, employee task assignment information, login activity information, scheduling information etc. and prepare the timesheet dataset and pushes it into Salesforce connected App for approval process using out of the box bulk API 2.0 REST call. The solution saves lot of time for application maintenance team during the weekly payroll processing day, very adaptable to the new compliance rules, provides higher levels of satisfaction by compensating timely and helps higher management in making informed decisions. The proposed framework offers a resilient, scalable, secured and accurate solution which results in better analytics and workforce retention.