Gazprom Expo / Documents and procurement workflows
Documents under control.
An internal platform for registers, forms, procurement documents, and automated data validation.
- 01React interface
- 02FastAPI backend
- 03PostgreSQL
- 04Document processing
- 05Local text analysis
- Company
- Gazprom Expo
- Role
- Fullstack Developer
- Focus
- Documents and procurement workflows
01 / Context
Context
Registers, spreadsheets, and documents were handled manually. Data entry, validation, storage, and processing results needed to become one consistent web workflow.
02 / My contribution
My contribution
- 01
Designed REST APIs for registers, documents, processing results, and reporting data.
- 02
Implemented rules for required fields, relationships, statuses, and allowed transitions.
- 03
Built Excel imports with structure, type, required-column, and row validation.
- 04
Designed cooperation between FastAPI, React, PostgreSQL, document processing, and local text analysis.
- 05
Introduced consistent API errors, reference-data caching, and structured logging.
03 / Solution
Solution
The platform split the user interface, API, storage, document processing, and text analysis into five coordinated components.
Validation happened before state changes, while Redis stored reference data and temporary file-processing statuses.
04 / Stack
Stack
- Python
- FastAPI
- PostgreSQL
- SQLAlchemy
- Alembic
- Redis
- Pydantic
- Docker