St. Petersburg Housing Committee (Robin RPA)

2023: ROBIN software robots for St. Petersburg Housing Committee

The Housing Committee of St. Petersburg has introduced software robots based on the ROBIN platform, which automate the following processes:

1. Make changes to the regional overhaul program. The robot reads the text of the Word resolution, makes changes to the Excel table according to the text.
2. Winter/summer cleaning summary report. The robot receives a report in xlsx format from 18 districts from a mailbox, processes the report, and writes the data to a PivotTable. Sends a response to the sender of the report in the format: "Hello, your report has been accepted," "The report has not been accepted. Check the item "Small mechanization tools" or "Report does not correspond to the format," etc.
3. Search by TIN by purchase registers. Search for information on a specific TIN on the list of sites, formation of screenshots and a summary file for verification (contains TIN, organization name, screenshot).
4. Check the register of bona fide suppliers. Checks registry participants with the status "valid" on the list of sites, takes a screenshot in case of discrepancies and saves a link for verification by an employee in order to exclude a participant from the registry.
5. Tariff difference - check in GIS housing and communal services. The robot checks the list of MKD addresses in the Excel file for the correctly specified management company on the GIS housing and communal services website. In addition, for a correct search (an incomplete address is often indicated in the file), it accesses the Federal Information Address System site.
6. Tariff difference - check of acts. At each address or contract, the robot finds a signed certificate of reconciliation of tariffs in HTML format, analyzes, highlights in color the fields: contract number, date of conclusion, address, amounts.
7. Entering data into the IS "Resettlement of communal apartments" (GorZhilExchange)
8. Formation of priority list (GorZhilExchange)
9. Collect a summary report and distribute it to the MTA reports.
10. Distribution on the reports of the LFFM. The robot converts the daily acts received in xlsx format into pdf format and sends a weekly summary report with a weekly slice to the district administration.