Enterprise, zCase Study

Monitoring & Reporting Bots for Services Company

trantorindia | Updated: September 19, 2022

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

Next Steps

If you want to discover more about Trantor Inc. Services, Please Contact sales@trantorinc.com.
Download

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

Tech Stack Used:

  • UI Path
  • MS Excel
  • Sophos
  • My SQL
  • Cisco VPN
  • Sharepoint

  • Text Hover