Magento 2.4.3 p1, API and SQL coding

Description: Please note. The developer I am looking for must know what he is doing. I just had a developer who has spent 2 days on a simple api that should take 4 hours. And... Do not take me for a fool. I check the code. I ask you to make comments in the code when you work and also ask you to push code to git. There will be NO access to the server. If you ask for payment outside I will report you immediately. Please give cost and timeline for EACH task. Phase 1: Bug 193, 161 (only finding path), 230, 229, 231, 245 Phase 2: Bug 190, 188 Phase 3: Bug 189 Work via git only. Not on the sever Priority: 1. BUG 193 change api 118 "Separate the parts in the banners so the app can link to skus properly API 118 reworked response which contains - banner image url - promotional text - sku or campaign number current response of API 118 is not like that can be used to create banners in the app, because the object ""banner_content"" contains html code which is impossible for us to extract banner url from that html code" 2. BUG 161 Amasty module group notification to mobile 1) Adding country code group to `customer groups` dropdown & create a new field for country code input by extending amasty module to our custom module DONE 2) On executing that campaign, then getting a list of all users for that country group. DONE 3) Sending push notifications to mobile for all users in that group. DONE 4) sharing the URL and testing it. TODO 3. BUG 230 Stripe must have the customer code in the magento database so we can store and retrieve it so we can retrieve cards from stripe. 4. BUG API should store and retrieve the country code when the user is adding its address to the customer information screen. 5. BUG 231 Missing VIP points when the product is clicked on in the store It should be the SKU API, API 110 6. Bug 245 price is wrong in review filter and then it is listed 7. BUG 190 - This may be paused and waited for a few weeks. Languages on pages "Languages to be added: German, Swedish, Danish, Norwegian, Finish, French, 1) Separate site settings setup for each language and configuration settings for each language. 2) Header and footer design update to same as like for english language to other languages. 3) Need to recreate product with same options for each language. 4) Need to recreate pages, widgets, blocks for each language and link them like in english language. 5) Need to add translation file for all languages and add all phrases used in the site. 6) Change in all places of phtml, php, and js files the translation process. Link: [login to view URL]" 8. BUG 188 Website performance "The site is slow Must be Ranking B or C [login to view URL] 9. BUG 189 Optimising API speeds for colours "SPECIAL case for this is available under signed [login to view URL] work is expected tro be divided into SQL code (the feeders) and into MAgento with search as part one, if no product is available then execute SQL scripts) 1) Adding Feeding and Repeater scripts in SQL procedure so that it loops through each row in `defcolourfacearea' table and calculate central colour and find the matching products and make entry in new table. - 16 hours. 2) Create CRON to detect new product is added and execute SQL procedure. - 1 hours (it is one line of code execution only) 3) Updating API 65, 63c, 6365, 93, 91 to fetch from new table if data exists in that, else run procedures and then save them in new table. - 10 hours.