Client

The customer is a Belarusian leading provider of legal services for business. Established in 2014, the organization helps companies collect debts, draw up contracts, keep documentation, and settle a dispute under the pre-action protocol.

Project goal

When a law firm turned to Arateg, it maintained all records in Google Docs and Microsoft Excel. There were no templates for creating documents—claims, contracts, etc.—and no reliable data access control. In addition, data search and vetting often consumed a lot of time. As a result, making a report could take up to 2 weeks.
Cooperating with our custom web application development company, the client aimed to develop an ERP system to automate reporting, control back payments, collect and store information about debtors.

Project summary

Project duration

4 months

Team

a backend developer, frontend developer, UI/UX designer, quality assurance engineer

Technologies

PHP, Laravel, React, Docker, RabbitMQ, Amazon Elasticsearch Service, PostgreSQL

Solution

First and foremost, our team collected and analyzed the company’s requirements to understand its business-specific needs. Then, our software experts draw up a technical specification, so that it would be easier to estimate the work scope, meet the customer’s expectations, and verify the compliance at the end of the project.
As a web ERP system had to collect large amounts of data, help employees handle claims and generate reports, it was important to make it easy-to-use. For this purpose, we developed an intuitive user interface using React and provided convenient navigation with the help of user cards, filters, etc.
Another crucial task was to automate the process of creating reports and documents. To address this issue, our specialists designed 15 templates while also customizing them to the needs of the client and stakeholders. As a consequence, the system included more than 60 templates, which significantly simplified and streamlined the work of agents.

When building a web ERP system, our team solved the following challenges:

  1. An ERP software system had to maintain and aggregate a continuously growing amount of data to generate reports —each containing millions of lines— without any delays or failures .
    Using RabbitMQ, we split data processing into parts—instead of handling the whole information flow at once—and put these tasks on a queue. To ensure the maximum speed of data aggregation, our software developers run them parallel.
    By employing RabbitMQ message-broker software, our engineers also increased the overall performance of an ERP web application.
  2. Since a web ERP system had to store large volumes of sensitive data, it was important to ensure security .
    With the purpose of protecting sensitive information, engineers at Arateg added features such as user authorization, two-factor authentication, and data access control.
  3. As Excel spreadsheets had different structures and formats, their unification in the ERP database had to be provided.
    To address this challenge, our developers built a specific mechanism for transferring tables and columns from Excel spreadsheets to the ERP software system while ensuring their unification.

The key features of a web ERP system

  1. Data search by name, address, email, phone number, date, etc.
  2. User base
  3. Aggregation of debtor and payment data
  4. Data downloading in Excel spreadsheets
  5. IP telephony
  6. Audio recording
  7. Report generation
  8. Claims (storage, creation)
  9. Notes
  10. Data access control
  11. User registration and authorization
  12. User authentication
  13. Background tasks that optimize the ERP system functioning: auto closing of unused registries and auto backups every 3 days

Result

Our custom ERP software development company created a web application that allows generating reports, handling claims, preparing various documents, collecting and storing the information about debtors (e.g., name, last name, personal contacts, what amount of debt was repaid, what amount of debt remains to be paid).
With the delivered software solution, the client reduced the time to make a report from 2 weeks to less than 10 minutes. In addition, the organization became able to easily control payments and provide the security of sensitive data. At the moment, we provide post-launch project maintenance.

More case studies you may like

We’d love to work with you

Drop us a line about your idea, project, or challenge.

We’d like to discuss how we can help you.

We’ll add your contact details provided in this form to our CRM to contact you regarding the request. For more information, please visit our Privacy policy.