INTEGRATION & AUTOMATION
Azure Integration Strategy & UiPath Process Automation
Client Overview
The Client is a leading provider of specific facilities management services across Australia, specialising in fire and security services.
At a glance
Client
Facilities management
Speciality
Fire and security
Integration
Microsoft Azure
Automation
UiPath RPA
Engagement Summary
The Client was facing several challenges around the integration between their various systems for various business processes across field service management and accounts receivable, leading to double data entry by field technicians and office staff, as well as data quality issues and a legacy system that was failing to integrate with other systems due to security constraints and batch ETL approaches.
The Client also provides call-out services to their customer base. To validate job completion and approve payment, most of their contracts require that the jobs are entered into the customers’ own systems. This was taking 5+ minutes to run the job, plus an additional 5 minutes per job to complete. The Client wanted to automate this manual process to save time and improve efficiency.
5+ minutes to run the job, then another 5 minutes to complete it.
Jobs had to be entered into each customer’s own system before payment could be approved.
Intelligent Pathways Value
Intelligent Pathways was engaged to design a solution to integrate several internal and external systems, with a view to reducing duplicate data entry, increasing data quality, eliminating failures and speeding up processes.
The architectural approach for this enterprise application integration is based on API-led, event-driven, serverless microservices, with continuous integration and monitoring and alerting. That reduces costs and administrative overheads while providing high visibility and scalability. The solution is built using Microsoft Azure Enterprise Integration Services and works effectively and securely around legacy security constraints.
Logic Apps
API Management
Service Bus
Event Grid
Cosmos DB
Azure DevOps
Job completion automation
A further engagement involved the automation of the job completion process using UiPath RPA (Robotic Process Automation). The solution leverages the UiPath Connector for Dynamics 365 and browser automation for the CityFM portal, and is based on the Robotic Enterprise Framework (REF).
As the solution is based on the REF, it automatically handles any errors and generates screenshots of the current state at the time of error. The solution was also enhanced to email a summary report at the end of the process, providing an overview of the days used to close each job and the status and, if applicable, failure details.
30 sec
Time to close a job, down from more than 10 minutes. Most of that is waiting for the CityFM portal to load.
Outcomes
Due to the integrations, accounts receivable debt collection turnaround times were reduced, customer onboarding time has reduced considerably, reliability of integrations increased significantly, fewer personnel were required to manage integration-related overheads, and data quality has improved with the removal of double data entry.
Debt collection
Accounts receivable turnaround times were reduced.
Customer onboarding
Onboarding time has reduced considerably.
Reliability
Integrations are significantly more reliable.
Less overhead
Fewer people are needed to manage integration overheads.
Data quality
Double data entry has been removed.