The automation was motivated by the company's need to optimize costs related to UiPath licenses, which were high. Faced with the availability of existing SS&C Blue Prism licenses, we made the strategic decision to migrate some of our robots, requiring significant refactoring.
This transition resulted not only in a noticeable reduction in operational costs but also in substantial gains in efficiency in the processing time of each robot item.
The shift to SS&C Blue Prism not only met budgetary demands but also significantly enhanced the overall effectiveness of automation, promoting a more efficient and cost-effective approach to executing automated tasks.
We began the process by focusing on understanding the scope through existing UiPath developments and available documentation. Once the process scope was defined, a thorough review was conducted in collaboration with business users to identify any gaps left by the previous solution. Additionally, we utilized the Blue Prism capture tool for enhanced efficiency in process mapping, resulting in significant time gains. It's noteworthy that SEFIP data was frequently generated in Excel spreadsheets by the business area for the robot's consumption.
The solution was designed using Blue Prism as the main platform, complemented by the strategic use of Excel to feed the queues. The process was divided into three distinct stages:
SEFIP Software:• Responsible for registering employees and companies, covering all months and retroactively spanning 5 years.• Generation of the .SFP file to feed the queue for the second process.
CAIXA Portal:• Uploading the .SFP file generated in the first process.• Registering with the vendor base, spanning all months and retroactively covering 5 years.• Generating a final file to feed the queue for the last portal.
ELAW Portal:Comprehensive processing of all cases, including analysis, file compression, and consolidation into a single file.
Efficient submission to the ELAW portal, resulting in a significant improvement in processing speed and ensuring greater security. Excel spreadsheets generated by the business area played a crucial role during various phases of the process.
The process and its subprocesses were automated using Excel for information manipulation from SEFIP, as well as interaction with CAIXA and ELAW portals. After generating and analyzing employee and company records, the data were sent to the portals for processing. During this flow, we implemented robust traceability to ensure each step could be monitored. Excel spreadsheets, generated by the business area, were a primary data source for the robot during the construction process.
During development, we conducted a comprehensive testing approach to ensure project quality. This included:
The project implementation occurred smoothly, and to ensure a seamless transition, go-live sprints were conducted. These sprints were designed to closely monitor system performance and evaluate key indicators, allowing for continuous analysis of deliveries and identification of areas for improvement. Excel spreadsheets generated by the business area were fully incorporated into the delivery process, ensuring that the robot could consume them efficiently and accurately during production environment operation.
During this project, we faced the crucial challenge of gaining acceptance from the finance team for our improvement proposals. We aimed to optimize operational efficiency and address gaps in the previous tool, UiPath.
To overcome this, we conducted a detailed analysis of financial processes, identifying points of inefficiency and shortcomings. We developed proposals based on concrete data, highlighting measurable gains.
This technical and collaborative approach was pivotal for the successful implementation of changes, resulting in enhanced efficiency and addressing identified gaps.
The project had a significant impact on optimizing operational efficiency and addressing identified gaps in the previous tool, UiPath. The implementation of the proposed improvements resulted in more efficient and measurable financial processes. Tangible gains were observed in terms of speed, accuracy, and operational cost reduction.
Furthermore, the technical and collaborative approach employed facilitated acceptance from the finance team, ensuring a smooth and effective transition to the implemented changes. The practical application of detailed analyses and data-driven proposals contributed to a more robust operational environment aligned with the organization's efficiency goals.
In summary, the project's impact was positive, bringing substantial improvements to financial processes, strengthening operational efficiency, and establishing a solid foundation for more effective operations in the future.
Certainly! Something important the community should know about our Blueprint is the significance of continuous collaboration and communication with the involved teams. Throughout the project, the technical and collaborative approach was crucial in overcoming challenges and ensuring acceptance of the proposed improvements.
Furthermore, I emphasize the relevance of a detailed analysis of specific processes and grounding proposals in concrete data. This not only strengthens the validity of the suggestions but also provides a solid foundation for measuring the impact of implemented changes.
The application of continuous monitoring tools, such as dashboards and key performance indicators, can be valuable to ensure that improvements continue to bring measurable benefits over time.
In summary, collaboration, a data-driven approach, and continuous monitoring are key elements for success when implementing a similar Blueprint. These are principles that can be valuable for others deciding to try the same Blueprint in their own projects.
------------------------------Wagner VasconcelosAnalista de Inteligência Operacional SêniorVia VarejoAmerica/Recife------------------------------
Thank you Wagner for the excellent summary!
You're welcome! I'm glad I could provide a helpful summary for you. If you have any more questions or need further clarification, feel free to ask.
------------------------------Wagner VasconcelosAnalista de Inteligência Operacional SêniorGrupo Casas BahiaAmerica/Recife------------------------------
------------------------------Jack LookSr Product ConsultantBlue PrismOriginal Message:Sent: 01-25-2024 09:56From: Wagner VasconcelosSubject: Refactoring UiPath Bot to SS&C Blue Prism with Capture Assistance
@Wagner Vasconcelos this is so detailed, and such a good story. Thanks so much for sharing!
One question from me is around the refactoring / redesign piece. You mention overall efficiency gains after the project was complete, how did you deliver that through the redesign? What was missing from the original automation that you corrected?PS - I absolutely love how you reinforce the value of collaboration here 💙
Thank you for appreciating my story!
The significant efficiency improvement in the refactoring/redesign project was achieved through close collaboration with the business area. During the analysis of the previous automation, we identified some gaps in the navigation of certain steps. By working together with the business team, we understood that there was a more effective and faster way to access certain navigation contexts within the application.
Building on this insight, we implemented strategic changes in the redesign, optimizing the interaction between the robot and the application. This collaboration was crucial to address the gaps in the original automation and resulted in noteworthy efficiency gains upon project completion.
------------------------------💙 Michael(I'm part of the SS&C Blue Prism Community Team)Original Message:Sent: 01-25-2024 09:56From: Wagner VasconcelosSubject: Refactoring UiPath Bot to SS&C Blue Prism with Capture Assistance
Thank you for the positive feedback, Leonardo!
I'm glad you liked my project.
The biggest challenge during the migration process was undoubtedly ensuring that the processing time for each employee case was minimally equalized. In UiPath, the average was 11 minutes per case, and with the transition to Blue Prism, we were able to reduce that time to 9 minutes. Although the gain was not very high at low volume, considering the high volumes of data, we were able to scale the saved hours effectively.
------------------------------Leonardo SoaresRPA Developer Tech LeaderBridge ConsultingAmérica/BrazilOriginal Message:Sent: 01-25-2024 09:56From: Wagner VasconcelosSubject: Refactoring UiPath Bot to SS&C Blue Prism with Capture Assistance