Week 9 Worklog

Week 9 Objectives:

  • Implement security layers including Frontend RBAC and Data Isolation for project members.
  • Architect and deploy an asynchronous processing pipeline using AWS SQS to handle high-latency OCR and validation tasks.
  • Develop complex data merging logic (“Invoice Dossier Merge”) to synchronize XML and AI-extracted invoice data.

Tasks to be carried out this week:

DayTaskStart DateCompletion DateReference Material
2Project - Authorization & UI/UX:
• Implement Role-Based Access Control (RBAC) for AppLayout and frontend routing
• Enforce Data Isolation for members on Dashboard and Validation pages
• Refactor backend validation error messages for clarity
• Improve UploadInvoice UI and row selection features		09/03/202609/03/2026
3Project - Architecture & Bug Fixing:
• Configure system settings for the Super Admin panel
• Set up environment configs for AI/OCR, Validation, S3, and Security
• Investigate and resolve PostgreSQL foreign key constraint errors		10/03/202610/03/2026
4Project - AI OCR & Validation:
• Integrate AI OCR JSON output into the system
• Map out data processing plan for extracted information
• Implement data extraction and validate business logic for image/PDF uploads		11/03/202611/03/2026
5Project - Async Processing (AWS SQS):
• Design and implement async validation flow using AWS SQS to mitigate timeouts
• Apply SQS Producer-Consumer pattern and Polly policies for resilience
• Use SemaphoreSlim to manage concurrent processing		12/03/202612/03/2026
6Project - Frontend Async UX:
• Develop Phase 1 of Frontend UX for asynchronous validation
• Implement smart polling mechanisms and real-time status indicators		13/03/202613/03/2026
7Project - Refactoring & Data Merge:
• Major backend service refactoring and code cleanup
• Implement “Invoice Dossier Merge” (XML accurately overrides OCR data)		14/03/202614/03/2026

Week 9 Achievements:

  • Successfully mitigated API timeout issues by transitioning to a resilient SQS-based asynchronous architecture.
  • Enhanced the user experience with real-time status indicators and smart polling mechanisms for batch processing.
  • Strengthened system security and data integrity through RBAC, isolation, and robust error handling.