Monitoring & Reporting Bots for Services Company
Trantor brought in phenomenal value... agame changer that propels us to be able to work transprently in the new normal.
Business problem
Aggressive and agile customer business needs.
Multiple systems were required to be monitored
Unavailability of API’s to pull data automatically
Scaling fast at short notices to support customer business growth
Establish culture connect in geographically distributed teams
Solution delivered
Trantor allocated a dedicated RPA team to the project which followed its proven six-step methodology and worked with business stakeholders to define the processes into series of actionable steps which were then automated by RPA developers. We delivered the following solution to the client :
Built POC on extracting VPN connections logs using its web interface in 2 days
Built POC to extract structured data from Sophos firewall monitoring application in just a week’s time
Built monitoring bots to exports desired data from various applications (firewall, VPN server,
Sapience monitoring tool, etc. into MS Excel)
Insert exported data into central MySQL database
Monitoring intranet login logs and send the data to the MySQL server
Schedule MySql reports being generated & emailed every 3 hours
Results
Owned Bot Development
Continuous Process Improvements
Lead Data Governance
Agile approach from POC to Production
E2E Testing & UAT Support to Client
Zero Defects on Production
Delivered Customer Delight
UI Path
MS Excel
Sophos
My SQL
Cisco VPN
Sharepoint
