USCIS Site Scanner - US Government Website

Overview

The client, one of the most prestigious law firms in the United States of America, mainly dealing with immigration practices, wanted support for web automation.

The business needed to constantly check, verify and update the status of records from USCIS (United States Citizenship and Immigration Services) receipts.

Problem Statement and Challenges

The client deals with conglomerates and Fortune 500 firms, helping them with the solution for immigration and other related services.

To maintain their edge and retain clients, they required efficient systems to help with a smooth flow of information across various channels. This is why they requested to switch to RPA automation from the manual processing of USCIS records. '

With the automation in place, the client expected real-time delivery of updates on open cases. This helps them effectively share the information with their clients and saves time wasted with manual efforts to extract and showcase the same data set.

Solution

After gathering the requirements, we started the first phase of RPA Bot implementation, wherein the bot gathered all the required information needed to access records from the USCIS website.

The bot would directly fetch the data for open cases from the production database and feed it to a temporary excel sheet, which it uses to maintain the integrity of the production database.

In the second phase, the bot would then extract details of the open cases from the USCIS website by referencing the receipt details. Afterward, the data extracted would be stored in SQL Server Management Studio (SSMS) for validation.

Lastly, the production database is updated according to the information from the USCIS website. This process is scheduled as per the client's requirement.

Moreover, email automation for alerting the concerned individuals is implemented for each process step. This means that the concerned individual overseeing the process gets updated in real-time. The alerts work in case the systems find an exception or in the occurrence of failures.

SQL Server Management Studio (SSMS)
Digital Workforce RPA Bot
Web Scraping With Site Scanner
Email Alerts and Automation
Updating Production Database
Data Validation and Integrity Checks
Secured Data Processing
UiPath

Results and Success Criteria

By handling the complex extraction process for case details and manipulating the production database, we ultimately enabled real-time updates and transparency, empowering the client with the efficiency they wanted.

Additionally, we escalated the development comparatively in a short span while dealing with multiple sensitive databases and complex logic building. This resulted in a quick implementation saving the client a sizable number of employee hours, otherwise wasted with prior workflows.