Business Application · Automation and Traceability
Quality Claims Automation
Application for automating the analysis and traceability of quality claims using PDF and Excel documents.
The project
Business application developed to automate the processing and analysis of quality claims. The system allows users to upload the documentation associated with a claim, including port quality data, claim details, delivery notes, and information about vessels in port, so that data from different sources can be linked and cross-checked.
End-to-end project development: application architecture, processing and automation logic, frontend, user management, document processing, result persistence, statistics, and deployment.
Architecture
Modular architecture consisting of a Django application for the user interface and Python services for business logic and data processing, organized and deployed using Docker Compose. Sensitive settings and environment-specific configuration are managed through environment variables.
Processing
The system receives PDF and Excel documents associated with each claim and processes them to extract and link the required information. Port quality data is cross-checked against vessel-in-port information to establish traceability, then compared with the quality data stated in the claim. The analysis results are compiled into a report ready for review and subsequent entry into the claims register.
Development
Backend
Frontend
Database
Features
- User authentication
- Separate administrator and employee roles
- PDF document uploads
- Excel file uploads
- Automated document processing
- Cross-checking of port quality data
- Cross-checking against vessel-in-port data
- Goods traceability
- Comparison of port quality data with claim data
- Automated report generation
- Storing results in PostgreSQL
- Historical record of processed claims
- Record lookup
- Statistics visualization
- Claims and results listings
- Preparing results for entry into Excel
Statistics
Statistics system based on records stored in PostgreSQL. The application queries processed claim results to generate statistics and display aggregated information about activity and outcomes.
Users and authentication
Authentication system with separate access profiles for administrators and employees, allowing available functionality to be tailored to each user type.
Security
Access control through authentication and permission management for the different user roles.
Administration
Administrative features for user management and for controlling access to information and functionality intended for administrators.
Infrastructure
Technologies
Highlights
- Business process automation
- Modular architecture
- Automated PDF and Excel processing
- Cross-checking data from multiple sources
- Goods traceability
- Automated comparison of quality data
- Report generation
- Persisting results in PostgreSQL
- Historical claims register
- Statistics based on actual register data
- Results listings and lookup
- User system with different roles
- Deployment using Docker Compose
Deployment
Application deployed using Docker Compose, with components organized as independent services and environment-specific configuration managed through environment variables.