Enterprise, zCase Study
Monitoring & Reporting Bots for Services Company
trantorindia | Updated: January 19, 2021
The Client is one of the IT service companies based in CA, USA. The Client wanted to partner with a service provider to develop automation platform that could monitor and report employee’s activities to ensure people are working during work from home routine during Covid19 pandemic.
About the Customer & Problem Statement
The Client is one of the IT service companies based in CA, USA. The Client wanted to partner with a service provider to develop an automation platform that could monitor and report employee’s activities to ensure people are working during work from home routine during the Covid19 pandemic.
Key Challenge
- 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
Solutions
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
Key Value Add
- 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
The Client
Trantor brought in phenomenal value... agame changer that propels us to be able to work transprently in the new normal.
Chief Technology Officer
Project Highlights
- UI Path
- MS Excel
- Sophos
- My SQL
- Cisco VPN
- Sharepoint