Freelancers using SQL in Brisbane CityFreelancers using SQL in Brisbane CityDeveloped a web-based job tracking system for a waterproofing business, allowing clients to monitor project progress through a secure web portal accessed via unique QR codes.
The waterproofing business needed a way for their clients to track the status of ongoing projects without constant phone calls or emails. They wanted something simple, accessible, and secure.
Built a full-stack web application where each job gets a unique QR code. Clients scan the code and are taken to a secure portal showing real-time progress updates on their project. The backend handles job management, status updates, and client authentication.
Key features include QR code generation linked to individual jobs, a secure client portal for real-time project tracking, an admin dashboard for managing jobs and updating statuses, and a web-based interface accessible from any device.
Python for backend logic, SQL for data management, and web technologies for the client-facing portal. Built a desktop application for managing repair jobs, designed for small businesses that need to track incoming repairs, parts, costs, and customer information in one place.
The application features a clean interface for logging new repair jobs, tracking their status through completion, managing customer records, and generating reports. All data is stored in a SQL database with full CRUD operations.
Key features include job intake and status tracking, customer and parts management, cost calculation and invoicing, and reporting for business insights.
Built with Python for the application logic and UI, and SQL for persistent data storage.