A leading US restoration contractor leverages PreludeSys’ Salesforce integration capabilities to automate their process

About Client

The client is a national leader in restoration, environmental remediation, and reconstruction process, providing comprehensive recovery services to address environmental hazards

Client Requirement

As the nation’s leading restoration contractor, the client’s employees were working at multiple locations where they procure a variety of materials for their daily operations. This data had to be handwritten in ‘Material requisition form.’ Someone had to later manually enter this data into the enterprise application, Sage 300 ERP. This manual input led to data inaccuracies, duplication of effort and loss of time. This eventually triggered frequent setbacks to their schedules and resulted in inefficiencies and project delays. The client approached its technical team for a solution. Their lean in-house team was under duress to quickly come up with a plan to automate the entire process.

Solution

PreludeSys’ technical team performed a thorough assessment of the client’s technical environment. Salesforce was used as a sales and marketing tool and housed their customer database. The Client was using Jitterbit to integrate their invoicing application with Salesforce. Sage ERP was their enterprise tool. PreludeSys advisory team identified that more than 50% of data written in the ‘Material requisition form’ pertained to customer information and was being pulled out from their Salesforce instance. Since Jitterbit is a renowned API integrator and as the client was already using it in-house, PreludeSys advisory team proposed to develop the “Material Requisition Form” in Salesforce and integrate that with Sage 300 ERP using Jitterbit.

Benefits
  • Since a lot of data got auto-populated, form filling time, came down by 70%
  • Employees experienced 40% faster task resolution
  • Overall project efficiency increased by 35%
  • Cost-effective solution because the integration was planned using an existing tool like Jitterbit