AFTIS - Automated Financial Transaction Ingestion System
AFTIS (Automated Financial Transaction Ingestion System) is a Python-based solution designed to automatically process BCA bank PDF statements and convert them into structured database records. The system provides a seamless workflow for financial data ingestion with robust error handling and monitoring capabilities.
Specifications
- Backend Framework: Python with REST API
- Database: PostgreSQL for transaction storage
- Containerization: Docker & Docker Compose
- File Processing: Automated PDF parsing and data extraction
- Monitoring: Configurable inbox monitoring system
- Error Handling: Comprehensive troubleshooting and logging
- File Management: Automated file organization and cleanup
Key Features
- Automated Processing: Continuously monitors designated folders for new BCA PDF statements
- PDF Data Extraction: Intelligent parsing of BCA bank statement formats
- Database Integration: Structured storage of transaction data in PostgreSQL
- REST API: Clean API interface for data access and system management
- Docker Deployment: Containerized architecture for easy deployment and scaling
- Error Recovery: Robust error handling with detailed logging and troubleshooting guides
Milestones
- System Architecture
- Designed containerized architecture with Docker and PostgreSQL integration
- PDF Processing Engine
- Implemented intelligent PDF parsing specifically for BCA bank statement formats
- Database Schema
- Created optimized database schema for financial transaction storage
- Automation Framework
- Built configurable inbox monitoring and automated processing workflows
- API Development
- Developed REST API endpoints for data access and system management
- Documentation and Deployment
- Created comprehensive troubleshooting guides and simplified Docker deployment