Gazprom Expo / Documents and procurement workflows
A platform for registers and procurement documents
An internal platform for registers, forms, procurement documents, and automated data validation.
Product Designer and Full-stack Developer
What was manual
Registers, spreadsheets, and documents were handled manually. Input, validation, storage, and processing results lived in separate parts of the workflow.
What the platform brought together
The platform connected the user interface, REST APIs, PostgreSQL, document processing, and local text analysis in one web workflow.
Data and file validation
Business rules validate required fields, relationships, statuses, and allowed transitions before state changes.
Excel import separately validates file structure, data types, required columns, and rows.
Platform interface
I designed workflows for registers, forms, documents, and validation results.
Interface states show required fields, file errors, and allowed transitions before data changes.
My responsibilities
REST APIs for registers, documents, processing results, and reporting data.
Business rules and validated Excel import.
Integration of FastAPI, React, PostgreSQL, document processing, and local text analysis.
Consistent API errors, reference-data caching, and structured logging.
Stack
- Python
- FastAPI
- PostgreSQL
- SQLAlchemy
- Alembic
- Redis
- Pydantic
- Docker
