Talk to us
Back to blogs
January 19, 2021Written by Trantor3 min read

Monitoring & Reporting Bots for Services Company

January 19, 2021Written by Trantor3 min read

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.

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.

  • 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

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

  • 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

Tech Stack Used:

  • UI Path

  • MS Excel

  • Sophos

  • My SQL

  • Cisco VPN

  • Sharepoint

Link copied