EndorsedendorsedCompleted

Robotic Process Automation Tool for Outdoor Advertising Company

Services Covered:

Custom Software Development • Robotic Process Automation (RPA)
Project hero — replace with case study imagery
Industry
Industry

Advertising & Marketing

Duration
Duration

21 months

Budget
Budget

10K - 49K

Start Date
Start Date

1 January 2021

Team Size
Team Size

1-5

Engagement Model
Engagement Model

Onshore

Project Capability Score (PCS)

gauge meter
75/100
Good

Project Capability Score (PCS) estimates how capable Mitigate is of successfully delivering a project like this, based on its past experience, track record, and ability to handle similar work. Learn more about PCS


Client

JCDecaux Latvia

mapRiga, Latvia

Project Summary

Mitigate developed a Robotic Process Automation (RPA) tool for an outdoor advertising company to automate weekly government submissions. The solution was built with Ruby on Rails and a Chromium-based browser engine, integrated with the client's SharePoint, and deployed to AWS serverless. The client saved four hours of manual work each week and the project was completed on time and within budget.

Key Challenges

  • Weekly manual submission to the government system requiring about 4 hours of copy-paste work
  • No APIs available in the government system, preventing direct automation

Project Deliverables

  • Robotic Process Automation (RPA) tool built with Ruby on Rails
  • Chromium-based browser automation engine
  • SharePoint integration for storing advertisement images
  • Deployed on AWS using serverless services

Project Solution

Mitigate conducted a research phase to evaluate options and proposed a Robotic Process Automation approach. They built the RPA tool using Ruby on Rails with a Chromium (Google Chrome) browser engine, integrated it with the client's SharePoint for image storage, and deployed the solution to Amazon Web Services using serverless services. The team consisted of 1 project manager and 2 software engineers.

Project Outcome

  • Saved 4 hours of manual work each week
  • Project completed on time and within budget
  • Client trained on storing and structuring files for automated processing

Platforms

  • CloudCloud
  • WebWeb

Tech Stack

  • Ruby on RailsRuby on Rails
  • Amazon Web Services (AWS)Amazon Web Services (AWS)
  • ServerlessServerless
  • Microsoft SharepointMicrosoft Sharepoint

Client Endorsement

Overall Review Rating

5star5 out of 5 stars

Timeliness

Cost Rating

Willing to Refer

Quality of Deliverables

“The project was completed on time and within budget. Thanks to the new robotic process automation tool built by Mitigate, the client saved four hours of manual work per day. The team also taught the client how to store and structure their files in order to process them automatically using the tool.”

Laima Romberga

IT & Marketing Project Manager

Note: This endorsement is based on publicly available client feedback from external review sources.

More Projects by Mitigate