Zura Bokhua

Government survey application for infrastructure development project. Building a specialized survey application to manage property compensation assessments for infrastructure development in Georgia, handling comprehensive data for approximately 1,500 affected properties. Developed custom authentication and authorization system using Laravel's built-in components to deeply understand security mechanisms, session management, password hashing, and CSRF protection. Implemented role-based authorization using Gates and Policies supporting admin, surveyor, and reviewer roles with granular permissions for data access control and workflow management. Designed normalized MySQL database schema with 8+ tables, proper foreign key constraints, and optimized indexes for handling complex relationships between properties, households, members, and survey responses. Created dynamic, multi-section survey forms handling complex repeating data structures for household demographics, property details, income

E-commerce content management system for online jewelry business. Architected and developed Laravel 11 application with clean separation of concerns - REST API backend and React-based admin panel connected via Inertia.js, enabling seamless full-stack development workflow. Designed normalized database schema with optimized relationships and implemented eager loading strategies that prevented N+1 query problems, achieving average API response times under 100ms. Built comprehensive product management system with advanced media gallery handling automatic image resizing, optimization, and SEO-optimized metadata generation. Integrated Tiptap rich text editor with custom toolbar extensions and server-side image processing pipeline (resize to 1200px, 85% compression) reducing storage costs by 40%. Implemented multilingual content support for English, Georgian, and Russian using translatable models with fallback mechanisms, enabling easy content localization management. Developed role-based acc

Automated browser-based data pipeline for automotive listings using Laravel Dusk and headless browser automation. Designed a MySQL schema with deduplication and implemented configurable run schedules and error notifications for reliable deployments on a Linux VPS.