Responsabilități:

Project:
A system for monitoring the authorities' work with the population.
We collect a large amount of information from social networks, categorizing them into incidents, in order to quickly respond to complaints.
in order to promptly respond to complaints.

Responsibilities:
- Developing and maintaining microservices on FastAPI and Django.
- Writing complex SQL queries

Accomplishments:
- Designed and implemented a solution to fix the problem of duplicate blogs in the system.
Analyzed and implemented an algorithm to correctly remove duplicates, which significantly
reduced the load on the system and improved its performance without violating the relevance of the data.

- Optimized complex SQL-queries by changing the structure of the SQL-query and creating new indexes.
creating new indexes, accelerating the construction of reports on incidents, including reports for monitoring SLA fulfillment.

- Successfully solved the problem of integration with VK API. Conducted diagnostics of problems and proved that
the error was on VK's side, and then got a fix from their side.

- Solved a difficult task of creating a report on overdue incidents. Faced
a lot of bugs and problems related to saving the history of incidents. Fixed
the system for saving response timeframes, where previously there was confusion with the archived and
the current time of the incident before it was overdue.