Contact person: Business Client

Phone:Show

Email:Show

Location: Nairobi, Kenya

Budget: Recommended by industry experts

Time to start: As soon as possible

Project description:
"Financial Reconciliation System - Development Project

Project Overview

We are seeking an experienced development team or individual developer to build a robust Financial Reconciliation System that will resolve differences in cash account balances across multiple platforms. This system will automate the matching of transaction records between internal systems and external payment providers through a configurable pipeline approach.

Project Scope
Core Functionality

The system must support:

- Batch Processing: Create and manage reconciliation jobs comparing two datasets
- Multi-Stage Pipeline Execution: Sequential processing through configurable reconciliation stages
- Automated Matching: Match transactions using multiple criteria (Transaction ID, Amount, Date, etc.)
- Manual Reconciliation: Allow users to manually specify or amend matches
- Data Aggregation: Group transactions by reference and aggregate amounts
- Comprehensive Reporting: Export matched/unmatched transactions with detailed analytics

Key Features Required
1. Reconciliation Pipeline
Sequential stage execution (no concurrent processing)
Configurable pipeline stages via enum array specification
Support for multiple matching methods (ID match, amount match, date range, etc.)
2. Match Management
Capture matching method used
Track amount matching status (boolean flag)
Record transaction count per match
Manual match creation/editing/deletion
View all transactions within a match
3. Data Management
Create/delete reconciliation batches
Import/delete datasets
Search and filter capabilities:
Filter by date range
Search by Transaction ID, Account Number, Customer Phone, Customer Name
Export functionality for matched and unmatched transactions
4. Reporting & Analytics
API to view non-matching transactions
API to summarize non-matching transactions (count, total value, cashflow in/out)
Audit logging for all matching actions
Reconciliation status tracking (RECONCILED, UNRECONCILED)

Technical Requirements
Technology Stack
Backend: Spring Boot 3 or higher
Language: Java 17 or higher
Database: PostgreSQL
Architecture: RESTful API design
Database Design
Entity-Relationship diagram provided
Support for Batch, Dataset, Transaction, and Match entities
Proper indexing for performance optimization

Deliverables
- Fully functional backend system with RESTful APIs
- Database schema implementation based on provided ER diagram
- API documentation (Swagger/OpenAPI preferred)
- Unit and integration tests (minimum 80% code coverage)
- Deployment documentation and setup instructions
- Source code with proper version control (Git)
- Sample data import/export functionality

Project Documentation Provided
- Complete design specification document
- Sample dataset for testing
- Sample reconciliation pipeline structure
- Entity-Relationship diagram
- Detailed functional requirements

Ideal Candidate/Team Profile

Required Skills
- Strong experience with Spring Boot 3+ and Java 17+
- Proficiency in PostgreSQL database design and optimization
- Experience building financial/accounting systems or reconciliation tools
- RESTful API design and implementation expertise
- Understanding of transaction processing and data matching algorithms

Preferred Skills
- Experience with batch processing and pipeline architectures
- Knowledge of financial reconciliation best practices
- Familiarity with audit logging and compliance requirements
- Experience with data import/export functionality (CSV, Excel)
- Frontend development skills (if UI is required)

Project Timeline
-5-10 Days" (client-provided description)