What processes can Uibot apply to banks?

According to the previous project experience, nine application scenarios of bank RPA in banking industry are summarized for reference.

The first type: peer reconciliation.

The flow chart is as follows:

Because it involves the online banking login of the bank, the security of password storage is very important in automation, and at the same time, it must be able to identify the secure password login of the bank. Some banks can't recognize the interface elements behind the pop-up box, and some even need soft keyboard input.

UiBot's key box perfectly solves these two problems. It can not only store passwords in it (it can store 30 different password combinations) with high security, but also simulate password input without identification elements or soft keyboard (at present, the new key box only supports UiBot). In addition, some banks login will involve verification code, which is basically a combination of four to five English numbers. Generally, OCR can recognize it, but the pass rate is not very high, and a third party can also be used.

The second type: bank general branch reconciliation.

The flow chart is as follows:

The details of A/P and A/R transactions prepared by each branch are reconciled with the consolidated statement of the head office.

The third type: banks declare value-added tax.

The flow chart is as follows:

Every quarter, banks have to declare value-added tax and calculate the distribution of various taxes in various tax agencies. The amount of data is about150,000 to 500,000. In this process, it is very important to choose the appropriate data processing method. Although it has always been said that the array processing effect is fast, when the data volume is large and the processing is complicated, according to the business logic requirements, the custom data processing in Excel will become faster.

The test shows that it takes 8 to 12 minutes to process hundreds of thousands of data with array, while it takes 65 seconds to 90 seconds to customize data processing with Excel, which is more suitable for business logic.

The fourth type: query and download information of bank stamp card and account balance table.

The flow chart is as follows:

Because different accounts have different download permissions, it is necessary to download different information tables from one account to another in turn, and then process the data to generate reports. The precautions in this process have been introduced in the last article. (RPA dry goods window process automatic processing method)

Fifth, the bank inquires about the internal multi-account balance.

The flow chart is as follows:

In the core teller system of the bank, a large number of internal account balances are queried and the query results are generated into reports. This process is very consistent with a characteristic of RPA problem solving: manual batch repetitive operation.

Sixth: the automation of checking the authenticity of bank bills.

The flow chart is as follows:

You need to insert a tax tray to log in to the VAT platform, and the bill is valid for one year. Therefore, in the case of a large amount of data, it is difficult to download all the billing information of the past year, especially during the busy period. The failure rate of downloading for one year is very high, and it is impossible to download all the billing information at once. After testing, about 6000 pieces of bill information can be downloaded at a time, so it will be downloaded in batches according to the size of the bill and then merged.

On the other hand, the recognition rate of OCR cannot guarantee 100%. Therefore, when the customer defaults to true, the special ticket can be refluxed according to the bill information downloaded from the VAT platform to improve the accuracy of key information, and then the authenticity can be verified with the correct matching information, so that the full face information can be obtained through the interface (when there was no interface earlier, the verification code was basically identified through a third-party coding platform, because the verification code has a combination of colors and Chinese and English numbers, and the pass rate is not high. The problem of internal and external network isolation, if the bank allows VPN, it can solve the problem of internal and external network through VPN, otherwise the attachment information needs to be transmitted by mail.

The seventh contact: the credit certificate of the trade and finance department of the bank.

The flow chart is as follows:

Because the customer's mail attachments should be specified, for the convenience and efficiency of process automation, the qualified customer's mail should be placed in the designated inbox according to the mail rules, and then the attachments should be specially treated in this inbox.

On the other hand, some data cannot be verified in the early stage. Therefore, if non-compliant information is reported in the system, it will be judged according to whether the data is wrong, and then the error information will be reported in the original email and returned to the customer for information modification.

Eighth: third-party risk control monitoring of banks

The flow chart is as follows:

Using UiBot's Work Runner, the robot will automatically trigger operation in the early morning of every working day, go to the financial websites of major enterprises to grab financial data, generate financial risk analysis reports according to preset financial rules, and notify business personnel by email. Business people will receive such an email in the morning of the next working day, and they don't need to spend a lot of time grabbing data from major financial websites for data analysis after work, which saves valuable working time for business people in the morning and carries out more meaningful creative work.

Ninth: PCRM system performance import

The flow chart is as follows:

Classify the prepared Excel file information according to the business performance, and then upload the classified performance files to the corresponding performance interface in turn through the PCRM system. This kind of file batch classification and uploading is one of the most suitable scenarios for RPA, which has obvious effect on improving the work efficiency of bank employees.

Through the nine application scenarios of RPA in the banking industry, we can see that improving the office efficiency of employees is to improve the operational efficiency of enterprises in the context of the new era of rapid technological changes. When the efficiency comes up, the competitiveness of enterprises will naturally be stronger. More importantly, with the help of RPA, the improvement of employees' office efficiency will leave more time for creative work, which will inevitably bring two changes:

1, employees' happiness satisfaction has improved (low turnover rate, achievement-oriented career development);

2. The benefits of enterprises have improved rapidly.

It can be seen that in today's increasingly fierce competition, RPA is the key weapon for large enterprises to improve their competitiveness and efficiency. Go to UiBot