I need a skilled developer to implement branch-wise record access control in my existing application. Currently, all branches can see each other's records, which is a critical security and data privacy issue that needs immediate resolution. Current Problem Users from one branch can access/view records from other branches No proper data isolation between different branches Need to implement branch-specific data access control Each branch should only see their own records Required Solution Core Requirements: Add Branch ID to all relevant database tables where records need to be isolated Implement automatic branch filtering - when a user logs in to a branch, they should only see records belonging to that branch Modify existing queries to include branch_id in WHERE clauses Update all CRUD operations to respect branch boundaries Ensure proper branch_id assignment when creating new records Technical Implementation: Add branch_id field to all necessary tables Modify existing queries to filter by branch_id automatically Implement middleware/routing logic to enforce branch access Update forms and data entry to include proper branch_id assignment Ensure existing records are properly mapped to correct branches Security Considerations: Prevent cross-branch data access Validate branch permissions on every request Implement proper authorization checks Ensure no data leakage between branches Skills Required Database design and optimization Backend development (PHP/Node.js/Python/Ruby - specify your preferred stack) Query optimization and security Experience with multi-tenant applications Strong understanding of data isolation principles Deliverables Complete database schema updates with branch_id fields Modified application logic for branch-wise access control Updated queries and data access patterns Proper branch assignment for new records Testing to ensure data isolation works correctly