I need some changes made to our in-house project-management portal, built on the standard LAMP stack (PHP 8, MySQL, Apache, Linux). 1. Name field split Inside the Linguist module the current single “Name” column has to become two columns: First Name (re-using the existing data field) and Last Name (new). When the migration script runs it should scan each record and try to separate the existing text intelligently—e.g., last token moves to Last Name, the rest stays in First Name—while leaving all current links to client accounts fully intact. 2. Richer pop-up profile Clicking a linguist’s name already opens a mini pop-up. Expand that window so it shows the full profile,. 3. Certificate upload & optimization Linguists must be able to upload three kinds of certificates: language-proficiency, translation/interpretation courses, and professional-membership proofs. Technical requirements: • Max file size 2 MB each • After upload, automatically run a lightweight optimiser—Ghostscript for PDFs, ImageMagick for images—to enforce ≤ 150 DPI, auto-rotate to portrait if needed, and strip unnecessary metadata. • Generate a 200 px thumbnail for every PDF/image and store it alongside the main file so the pop-up can display an instant preview. Core codebase is PHP 8; you will have SSH and Git access to a staging server. Please keep the database structure changes backward-compatible and provide a short migration/rollback script plus a README summarizing any new config entries (path to Ghostscript/ImageMagick, upload folder, etc.). Deliverables are considered accepted when: • All existing linguist records show correct First and Last Names after migration, with no orphaned links. • Pop-up displays the additional profile sections cleanly on both desktop and mobile. • Certificate uploads meet size, DPI and thumbnail rules, and errors are surfaced clearly to the user. We're a micro business and hence our budget is limited, but there will be no shortage of work. Let me know if you need schema diagrams or a test data dump before getting started.