Leading disaster management firm improved their productivity using PreludeSys integration expertise

About the client

Our client is a leading disaster management firm based in California, USA. They specialize in restoration, environmental, and reconstruction services following natural and man-made disasters and have an unwavering commitment to customer service. Their services include emergency response, asbestos removal, mold remediation, biohazard clean-up, contents cleaning and restoration, pack-outs, and reconstruction services. The company operates out of 20 nationwide branch offices with over 1200 employees and serves hospitality, government agencies, financial institutions, and other industries in the United States.


Client challenges

As the nation’s leading restoration contractor, the client’s employees worked at multiple locations, procuring various materials for daily operations. This data had to be handwritten in ‘Material requisition forms’, which had to be later manually entered into the enterprise application Sage 300 ERP. Due to the extensive process, their enterprise needed more efficiency in assignment processing and material requisitioning. Manually processing XactAnalysis assignments via FTP and XML files led to errors and slowed workflows.There were challenges in the manual processing of XACT assignments, where the data was stored as zip files in an FTP path.

These manual interventions led to complexity in processing the data and created more errors in the processes; there were also gaps in mapping the relations between the tables in Salesforce. Additionally, field agents relied on paper-based material requisition forms, causing data inaccuracy and delays. They required a partner who could automate the entire process to address these challenges.

Solution

Our expert team did a thorough assessment of the client’s technical environment and then implemented the following activities:

  • Unified job creation: Leveraging MuleSoft’s data integration capabilities, we created a single module to integrate jobs and assignments between Salesforce and Xactware seamlessly.
  • Real-time integration: We employed API-led connectivity to facilitate real-time data exchange.
  • Automated data flow: To eliminate manual data processing, PreludeSys designed and deployed API driven integrations.
  • Streamlined data delivery: Salesforce now utilizes the Jitterbit APIs to receive data in the required format, eliminating the need for manual file retrieval from the FTP server.
  • Process optimization: Following integration completion, redundant tools, and duplicate processes were identified and decommissioned, further streamlining the client’s workflows.
Results at a glance
Form filling time, came down by 70% Employees experienced 40% faster task resolution Overall project efficiency increased by 35%
Benefits
  • Enabled business automation and eliminated manual processes for Xact assignments.
  • Decommissioned existing content management system.
  • Reused single job creation module for Xactware and and Google Drive integrations.
  • Cost-effective since the original API design was planned using an existing tool like Jitterbit.
Technology

MuleSoft, Jitterbit, Xactware, XactAnalysis