Slow query mysql php jobs

I'm in need of an expert to optimize my WordPress database speed. The current issues I'm facing involve slow loading times and prolonged database queries. The following tasks are essential for fixing the site's speed: - Updating and optimizing plugins: The site is currently slowed down by outdated plugins. An experienced professional should be able to update and optimize these plugins to enhance the site's performance. - Database performance improvement: As my priority lies in improving database performance, the freelancer should focus on database queries and other related optimizations to ensure the site runs smoothly and efficiently. - Site speed score: The ultimate goal is to achieve a site speed score above 95. The hired individual should have a track record...

We're in need of a developer with SaaS experience to create a complete car rental management solution. Our top priority features include the facility for online reservations, vehicle tracking, and a payment gateway integration. An important component of our project is mobile application development, required for both iOS and Android platforms. The mobile apps must offer push notifications, location services, and a quick booking feature. Ideally, you have a proven record of delivering similar solutions in past projects.

As an online business owner, I'm experiencing slow loading times, large file sizes, and high server response times on my Wordpress site, and would like to do everything possible to improve my page speed score. To address these issues, I have already implemented some performance optimization techniques, such as minifying CSS and JavaScript files, enabling caching, and compressing images. For this job, I'd highly value your expertise in: - Additional Wordpress page speed improvements - Identifying areas that I might have overlooked - Further technical optimization techniques Being familiar with Litespeed Cache - the plugin I have used - would be a big plus. I am hoping to find a meticulous, experienced freelancer who can quickly and effectively enhance my site's perf...

... Key Tasks: - Redesigning the layout and appearance: The current layout isn't meeting my expectations, and I believe a fresh design will enhance user experience and engagement. - Implementing new features and functionality: I'm looking to add certain features to my website to make it more interactive and user-friendly. - Improving website performance and speed: The website is currently running slow. I want to fix this issue and ensure the site is fast and responsive. - Fixing Website Errors: The website is facing some technical issues that need to be resolved. Additional Details: - The specific features and functionality I want to add are yet to be finalized. We can discuss these in more detail over a call or through a document. Ideal Skills and Experience: - Profic...

It is necessary finish a project managemet application made in laravel. The change are: - make some change regard the flow, the links, the design, the ecommerce and report; - It is necessary experience in query, report charts, pivot builder and Business intelligence to change the reports that must have good design, many filter and cross. the charts must have drill down. Please answer only if have experiences in project management software and pivot-query-busienss intellegence. And show my the url of similar job made.

I'm looking for a skilled PHP developer to help me complete a landing page with order function and integrate Stripe payment gateway. Landing page is designed already and has some initial PHP code already. The landing page is part of our Affiliate program. Each Affiliate gets their own landing page with their own contact details displayed. Affiliates promote this page and earns a commission on each sale through the page. All this should be recorded in the DB. They way it should work is like this: The code should then take the "username" and use it as a variable to select the right Affiliate in the DB with the corresponding username. Now it takes the details for that Affiliate and shows on the landing page. You have to check that this works. 1. Check t...

I'm currently encountering connectivity issues with my existing Azure Virtual Networks specifically with connecting to the MySQL database. I have a main Vnet with my mysql database in there. I have a virtual machine in there too which can connect to the database I have a second vnet which is peered to the main vnet. I have a virtual machine in this vnet too. It can talk to the virtual machine in the main vnet, but cannot connect to the database. I need it to be able to, and I cannot figure out why. You can tell me how to do it and I can test, this doesn’t need to be a long project!

Notes---- pls Contact only if it is useful and you understand. Read first We are in search of a proficient Laravel/PHP developer to assist in the development of APIs for our upcoming matrimonial app. The backend infrastructure is based on Laravel, and we require the creation of several API endpoints to power core functionalities of the application. Notification API: Enable notifications for user interactions and events within the Code: Implement coupon code management for user promotions, including creation, validation, and : Develop APIs to manage user messages, including sending, receiving, deleting, and reading Active/Online: Track and display users' last active time and online Match: Calculate similarity scores between

...engines. Optimize site images through alt tags, file names, and image sizing. **Content Enhancement**: Review and enhance existing content to better align with SEO goals and keyword integration. Suggest additional content topics that can attract more traffic and support SEO objectives. **Technical SEO Audit**: Perform a full technical SEO audit to identify and fix issues such as broken links, slow page load times, and crawl errors. Ensure the website is mobile-friendly and accessible across all devices.5.**Backlink Strategy**: Develop and execute a backlink strategy to enhance domain authority through high-quality links from reputable and relevant sites. **SEO Tools and Analytics Setup**: Set up and configure Google Analytics, Google Search Console, and any other necess...

we are looking for a senior experienced PHP developer with a minimum of 15 years of experience Skills and Experience MUST HAVE: - 15+ years of core PHP development experience. - Proficient in Laravel framework. - highly knowledgeable in php programming and experience SQL Injection prevention/fixing - Finding and Securing any loop holes in the system - **must be an independent developer, not an agency! - must be able to work on github - lastly making sure platform is mobile responsive Must have experience in social media or multi-user platform, chat system, ecommerce platform *******We will only hire independent freelancer. If you are an agency, if you are a marketing person or project manager and will delegate the work to someone else, meaning, will subcontract the...

I'm looking for an experienced ethical hacker to test the security of my PHP-based website. I particularly need to ensure the website is compliant with OWASP Top 10 standards. Key Requirements: - User Authentication Testing: Verify the strength of our user authentication methods. The chosen freelancer should be able to effectively identify and exploit vulnerabilities in our user login process. - Authorization Controls Testing: We need thorough testing on the authorization controls in place to ensure that only authorized users can access specific resources. - Input Validation Testing: We need someone who can identify any weaknesses in the input validation of our website. This is crucial in preventing common security vulnerabilities like SQL injection and cross-site scripting. ...

In my current VB.Net Windows application, I'm experiencing issues with the WhatsApp API I use. It's been taking far too long to send messages and it's a...far too long to send messages and it's affecting the user experience. I am seeking a skilled developer with proven experience in VB.Net and WhatsApp API: - Familiarity with VB.Net Windows applications - Experience in debugging and solving performance issues - Comfortable working with WhatsApp API - Understands best practices for improving message delivery speed The goal is simple: rectify the slow message-sending issue in my WhatsApp API integration without causing any disruptions to other functionalities. If you're ready to swiftly address this issue and better my application's performance, I invi...

...Experience: - Proficient in game development, particularly in creating MMO games. - Strong command of 3D design and development, with a focus on realistic art style. - Prior experience in implementing multiplayer and social features in games. - Ability to create a user-friendly and engaging quest-based gameplay system. Needed to make the game web-based (run in browser) optimize to make lightweight and slow network work progressivly javascript based is required, core code must be clear ES6 oop ui that enable editing the world in general and manage props and objects from a database allow login in game and enable microphone to a specified distance near the location of player If you possess these skills and have a portfolio that demonstrates your expertise in these areas, I would b...

I need a specialist who can significantly improve the loading speed of my WordPress e-commerce website. • The major issues slowing down my site are large image sizes, render-blocking resources, and slow server response time. • The focus should be on these areas, though any other ancillary issues which may be found should be addressed as well. • Ideally, I'm looking for a professional with extensive experience in web performance optimization, particularly those familiar with the inner workings of WordPress and Woocommerce. • Remember, I'm only willing to pay for achieved results and problem resolution.

Project Duration: 1-2 Days Project Budget: $50 Project Type: WordPress Project Level: Standard Project Overview We have a custom WordPress plugin that automatic creates a new featured image for each newly published post by: - Randomly picking a background image from a set selection - Overlaying the Post Title on top But we noticed the process is quite slow, taking up to a minute for each post & taking up significant server resources. We want the performance significantly improved to the highest standard. 5* FEEDBACK WILL BE LEFT FOR YOU

Project Deadline: 1 Day Project Budget: $50 Project Type: PHP (8.2 and above) Server Type: Linux Ubuntu Project Overview: We have an existing PHP script that calls the OpenAI API & outputs the response in decoded JSON format. We want to add Replicate API () to the script so we have the option of using the Replicate API instead of the OpenAI API. A user should be able to specify which API the script should use via a line in the code. So... - Currently: Script uses OpenAI API - New Version: Script uses both OpenAI API & Replicate API The output format from Replicate API must match the OpenAI API response, as the output is used in an existing Web App. New API Documentation:

I consider my self a linux user with more than 10 years of experince. I have having some issues with a linux server running mysql. From time to time it stops responding. I am unable to find the root cause. Therefor i need a linux guru to connect to my anydesk/teamviewer and debug with me till we find the error and fix it. We have various logs in the system so it will be helpful to debug

...Development needed to accommodate the expected volume of registrations Development to prevent IP bans Detailed feature description: Member Login Sign-up Permission assignment Individual inquiry Immediate rank crawling Tracking target management Individual input Bulk Excel upload & download Keyword-based crawling On/Off Deletion Background crawling of tracking targets Naver Place keyword (1 daily query) Rank change history Generate a shareable URL (reset every week) Display in a popup from step 3...

Here is a list of zip files on a US Govt website. You must write a Python program that uses a network library to download each zip file on this site, then find each .csv file in the zip archive, and copy each .csv file in each zip archive to a hard drive directory on the local windows machine. The directory will be "C:/MedicareDownloadFiles". The files cover the years 2017 to 2024. You may not hardcode file names ... you must extract the filenames from the above https URL. The fee for this will be $30. You must have it done within 60 minutes. Thanks for participating!

URGENT, Need expert PHP, JS developer for my wordpress website it have a lot of errors after restarting my server.

...believe the potential for growth is significant. I'm looking for someone who can help in the following areas: - Shopify Store Management: Primarily to ensure the store is optimized for sales and help with product uploads and categorization. - Store Review: A comprehensive review of the current store to identify areas for improvement. - Fixing: Addressing current issues on the website such as slow page loading speed, broken links or errors, and design/layout issues. - Ad Campaign Assistance: I'm trying to reach young adults (18-24), professionals (25-34), and parents (35-44). Assistance with crafting and executing ad campaigns targeted at these specific demographics would be highly valued. Ideal candidates should have: - Proven experience in Shopify store manage...

I'm looking for a skilled developer to migrate our Java-based desktop application onto the AWS cloud. The project involves: - Hosting the existing Java-based desktop application on an AWS cloud instance. - Implementing a multi-user access system. - Integrating a MySQL database component. - Developing a Python-based web interface for users to change settings. The ideal candidate should have: - Proficiency in Java, Python, and MySQL. - Prior experience with cloud hosting, particularly on AWS. - Knowledge of user access control systems, particularly Discretionary Access Control. - A good understanding of desktop-to-cloud migration. - Strong communication skills and attention to detail. We need a developer who can take a Java based desktop application and host it on a...

I'm experiencing performance issues within my IoT-based platform, mostly coming from slow query response times, excessive storage consumption, and challenges with insert operations after compression. I'm looking for an experienced TimescaleDB expert to optimize this. - Optimize slow query response time - Reduce excessive storage consumption - Fix insert operations after compression The ideal freelancer for this project is someone who has extensive experience in TimescaleDB, particularly in query optimization and compression features. Unfortunately, I'm unable to provide the number of tables in the platform, but I need someone who is capable of handling extensive data and complex structures. If you've dealt with this before, you�...

I'm in need of a PHP Developer for a new project. The parameters and required skills are fairly open, as I've not declared any specific frameworks or preferences. Ideal candidates include those who possess: - Broad knowledge of PHP across various frameworks. Although Laravel, CodeIgniter, and WordPress were the options given, these indications were not selected, thus creating an open space for any skilled PHP professional to apply. - Experience in both website and web application development. There's an opportunity to work on several PHP development projects, potentially ranging from website building, application creation, to API integrations. - An impressive design eye. I've left the space open for any design style you're confident wit...

I'm searching f...searching for a skilled PHP developer to upgrade my project from PHP 5.6 to PHP 8.2. Main functionalities: - User authentication - Database management As part of the upgrade process, I need to: - Access the source codes - Utilize effective debugging skills, ensuring all functionalities of the software are kept intact and continue to work efficiently and effectively once the upgrade is complete. Specific skills needed: - Strong knowledge of PHP 5.6 and PHP 8.2. - Excellent debugging and problem-solving skills. - Prior experience in upgrading PHP versions is a plus. I would appreciate it if you could keep all functionalities and no extra feature or module needs to be added or removed in the upgraded version. Let'...

I have a MySQL database that needs exporting. All user data, product data, and transaction data are required to be exported. Key Tasks: - Export all MySQL user data - Export all MySQL product data - Export all MySQL transaction data The final export should be in Excel format. This is not a job for beginners. You should have prior extensive experience with large database exports and MySQL. It would be a big plus if you're familiar with handling sensitive user and transaction data. As the project involves substantial data, confidentiality and data security are non-negotiable. Please include samples of similar database exporting projects you've completed.

We're looking for a programmer skilled in scraping and converting APIs into PHP or Python code (reverse engineering)! If you have the following skills, join us: 1. Proficiency in JavaScript: Ability to work with this popular programming language and fully interpret and modify codes. 2. Knowledge of Cryptography: Ability to understand and use cryptographic algorithms and methods to comprehend how data is encoded and to transform unencrypted data. 3. Familiarity with Progressive Web Apps (PWA): Deep understanding of PWA structure and methods to bypass installation on iOS. 4. Experience with network monitoring and traffic analysis software such as Fiddler: Ability to use these tools for analyzing network traffic and related information, including identifying and addressing PWA...

...integrate a Dymo printer into my system. Here's a breakdown of the project: - **Integration**: I need the Dymo printer to work seamlessly with my Access 2013 database. The goal is to automatically print stock labels based on query results. This means you'll need to set up the system to take the query output and send it to the printer for label creation. - **Printing Specifics**: The labels I need printed are stock labels. The process should be automated, so the labels are generated and printed without manual intervention. The labels will be printed based on the results of a query in Access and some limited entry from the operator with such things as qty of labels and which of 2 labels (it's the DYMO LabelWriter 450 Turbo) with slightly different fie...

Hi Dears, I am looking Laravel Expert on hourly basis. He should be able to improve the quality of code. Also, he should have experience to improve the performance of Laravel website. While bidding; kindly mention: 1. Your per hour rate 2. Previous Laravel Projects 3. Previous Laravel Projects detail where you improved Laravel Project/API Performance 4...am looking Laravel Expert on hourly basis. He should be able to improve the quality of code. Also, he should have experience to improve the performance of Laravel website. While bidding; kindly mention: 1. Your per hour rate 2. Previous Laravel Projects 3. Previous Laravel Projects detail where you improved Laravel Project/API Performance 4. Previous projects where you improved MYSQL performance f...

**Project Title:** Transfer and Enhance PHP/Mysql/Ajax Team Organisation Tool to Flutter Web App **Project Description:** We are seeking a skilled developer to assist in migrating an existing PHP/Mysql/Ajax Team Organisation Tool to Flutter, with the aim of releasing it as a web application. The primary objectives of this project include implementing a robust user authentication system, enhancing work organisation capabilities through calendar events, introducing user profile management for self-updating special user data, incorporating team management by assigning role models such as Teammember, Teamorganiser, Controller, Boss, and Admin, adding communication options to send team emails, chats, SMS, and WhatsApp messages, including timestamp functions for each...

I need an experienced programmer to develop a custom-built website for a Loadshedding scheduler. The project has a high priority and needs to be completed as soon as possible Before 20 May 2024 Basics Summary: The Load shedding Scheduler System is a comprehensive solution designed to address the challenges associated with managing and implementing load shedding in an efficient and organized m... - Understanding of e-commerce and secure online payment methods. - Ability to work under tight deadlines and deliver high-quality work. I'm looking for someone who can start immediately and commit to completing this project promptly. Please provide your relevant experience and a proposed timeline for the project. for skills required on this platform i can only put 5 but include Web Hosti...

As the system architect for a Laravel-based platform, I have been tasked with implementing a highly-functional environment for our users. I possess a wildcard SSL but req...tasked with implementing a highly-functional environment for our users. I possess a wildcard SSL but require assistance in setting it up on DigitalOcean. I am interested in applications from freelancers who: - Have experience with the DigitalOcean ecosystem - Ability to utilize the wildcard SSL certificate on the Laravel site - Proficient with cron jobs Additionally, we would like the GD Library PHP extension enabled for cron jobs. Prior experience with this task will be beneficial. Please share your related experiences and availability. Successful completion of this project may lead to more related jobs in t...

I'm looking for an experienced PHP developer to work on a new E-commerce website. The project involves: - **Website Development**: You'll be responsible for creating a complete E-commerce platform. This includes setting up the necessary pages, product listings, and a user-friendly interface. - **Database Management**: Besides building the site, you'll also be in charge of managing its database. This involves ensuring data integrity, proper storage, and efficient retrieval. Ideal candidates for this project should have: - Proven experience in PHP development, specifically in E-commerce platforms. - Strong database management skills. - Understanding and experience with payment gateway integrations.

I'm seeking a skilled Shopify developer to assist with optimizing my store's speed and creating a preorder page. Requirements: - **Shopify Speed Optimization**: The main issue I'm experiencing is slow page loading. I need someone who can identify the root cause of this and improve the overall speed of the website. This is crucial to enhance the user experience and reduce bounce rates. - **Preorder Page Development**: The goal of this page is to generate immediate sales. It should feature product descriptions and a countdown timer to create a sense of urgency among customers. The page should be visually appealing and user-friendly, encouraging customers to make a purchase. Ideal Candidate: - Proficient in Shopify development - Experienced in speed optimization tech...

Hi please let me know if someone is able to finish a project with PHP and do me a web app panel for api calls on servers, and also email automations.

I require a Linux WHM expert to assist with a critical data recovery issue. Specifically. Suddenly our mysql stop working. We had a dump of data but we need to solve the mysql issue or reinstall it (we can provide WHM and root access), and upload the data dump. Key Responsibilities: - Troubleshoot and resolve the MySQL data recovery issue. - Ensure the retrieved data is accurate and complete. We would like to know why this happends, to avoid it happends in future, by checking server logs. Ideal Skills and Experience: - Extensive experience with Linux WHM. - Proven track record in MySQL data recovery. - Understanding of data security and privacy best practices. - Prompt and effective communicator.

...experienced Shopify app developer to create a specialized app for me. This app should have the following functionalities: 1. Select the Order Date and time slot in the local delivery 2. Select the store pickup address for order 3. Very Pincode for local develiry is available or not this pincode? Require Skill - Shopify Order Edit - Shopify Webhook - REST API - Node.js and React.js - MySQL and Postgres - Javascript, HTML, CSS, Jquery A critical feature I require is the ability to gather specific information with each order. This should include: - The ability to select an order date via a calendar date picker. - Collect and record this order date. Ideal candidates for this project should be experienced in the development of Shopify apps, with a particular e...

I'm seeking a professional to help migrate my existing Grafana 8 alerts to Grafana 10. Your proposal should include detailed project plans and timelines for completing the following tasks: - Alert Configuration: This includes setting up and configuring alerts based on specific metrics, thresholds and conditions. - Alert Rule Mappi...alert notifications to ensure they are received by the relevant parties promptly and efficiently. Ideal candidates should have: - Extensive experience with Grafana and its alerting system - A proven track record of successful alert migration projects - Excellent communication skills and a proactive approach to problem-solving. While not mandatory, experience with Prometheus, Elasticsearch, and MySQL would be a plus given the data sources we'...

..., and its MySQL database on Cloudways. I'm looking for a professional to transfer both the frontend and backend to DigitalOcean. I need help in setting up the server and transferring the database as well. Key Project Requirements: - Transfer existing Angular project from to DigitalOcean - Move existing MySQL database hosted on Cloudways to DigitalOcean - Set up the server on DigitalOcean for hosting the Angular project - Transfer and configure the MySQL database on DigitalOcean - Ensure the migration process is smooth and without downtime - No manual deployment used, so expertise in this area is crucial Ideal Freelancer: - Proficient in Angular for frontend transfer - Experienced with setup and configuration of servers on DigitalOcean - Skilled in MySQL...

I'm in need of a skilled Shopify App Developer to create an innovative, new application that specifically includes an 'Order Date' feature. Key Function: - The primary function of this app needs to be the ability to select an order date. Additional Requirements: - The app must be...'Order Date' feature. Key Function: - The primary function of this app needs to be the ability to select an order date. Additional Requirements: - The app must be easy to use and intuitive. - Requires seamless integration with my Shopify store. Ideal Skills & Experience: - Shopify App Development - UI/UX Design - Knowledge of eCommerce and order processing. - Node.js and React.js Expertise - Mysql and Postgres - Javascript, HTML, CSS, Jquery Looking forward to dis...

Custom Task Management System By ARABIC Language RTL , From Scratch SDLC To Deploy. I have Some Screens to understand Most Requirement> Requirement: PHP Laravel 11 MySQL Jquery CSS Bootstrap All Must be the last versions.

We have a device which is transmitting using JT808 , we want to capture that transmission and write in a mysql db. We will not provide documentation on JT808. Do NOT bid if you do not have experience with this protocol. If you have worked before with this protocol, please give a brief explanation of what you did.

I'm facing an issue with my PHP website, wherein some data is missing or malfunctioning on my custom work page. Additionally, I need assistance with customizing the website design - specifically the PHP code. I'm in search of a professional who possesses strong skills in PHP, UI/UX design, and has a good understanding of bespoke web design. It is essential that the freelancer be detail-oriented and able to identify areas of malfunction swiftly. This project will involve: - Debugging the current PHP code to identify and fix issues with data missing or malfunctioning on the customized work page. - Modifying the existing PHP code as part of the website design customization. A portfolio showcasing similar projects where you identified and fixed is...

I need an expert PHP developer with a strong background in developing compilers for higher level languages. Specifically, I'm looking for someone that could create a C and C++ compiler using PHP. No exact functionalities were established, but I would like to use the compiler for developing web applications. Key Responsibilities: - Creating a PHP compiler that processes C and C++ code - Ensure it's functional for web application development Ideal Skills: - Strong PHP knowledge - C and C++ programming - Compiler creation experiences - Web application development understanding Even though the detailed specifics of the project were not established, we can clarify those during our consultation process once I've chosen the right freelancer for this ...

I need a reliable web developer to urgently fix some errors on my website. Your main task will be to address the following issues: - Fix broken links on the home page - Address slow page loading - Restore missing address details The fix is required within a week, so I need someone who can quickly and effectively identify and resolve these problems. Good communication skills and a track record of completing similar tasks within tight timelines are a must.

I'm on the hunt for 2 or 3 talented PHP freelancers who are ready and willing to work with me for 10 to 20 days due to a sudden result of project overload. Here's what you'll be working on: - PHP Development: You'll be using your coding skills to build and modify web applications. - Web Development: Using PHP, you'll create user-facing elements to meet client needs. - Database Management: You'll ensure that the data storage and retrieval systems are effective and efficient. You'll ideally be familiar with the Laravel and CodeIgniter frameworks and use them to execute the projects. While I’m open to all applicants, I am particularly looking for those at an intermediate level who have some experience in handling complex projects...

...license key must validate properly in Excel Template PRO. Besides, your work must include: * Order form * Implementing a MySQL database to store all generated license keys. * Building a response system that displays license keys on a 'Thank You' page after purchase. * Setting up an automated email system that sends emails to the customers with their unique license key and a download link to Excel Template PRO. * The email system should also forward invoice details to the buyer with a copy to the site administrator. + The Coder has to create a Macro in my Excel Template to validate License keys connecting to our DB. Ideal applicants will possess: * Proficiency in Python and MySQL. * Experience in API development and integration. * Ability to create unique, veri...

I'm facing an issue with my PHP CURL function where I'm unable to connect to a remote server. This error is specifically coded as 'CURLE_SSL_CACERT (60)'. Key Points: - Need to resolve SSL certificate validation issue causing Error 60. - The project is running in my local development environment. Skills/Experience Required: - Strong experience with PHP and CURL. - Expertise in SSL certificate handling in PHP. - Familiarity with local development environments.

Project Deadline: 1 Day Project Budget: $40 Project Type: PHP (8.2 and above) Server Type: Linux Ubuntu Project Overview: We have an existing PHP script that calls the OpenAI API & outputs the decoded JSON response. We want to add Replicate API () to use the meta-llama-3-70b model & add a flag to the code to allow us to choose whether we want the PHP script to use OpenAI or Llama 3 (70B). The output format from Replicate API must match the OpenAI API response Reference File: 5* FEEDBACK WILL BE LEFT FOR YOU

I'm in need of an expert with outstanding knowledge of Gluster Configuration, Forge Laravel, Linode, and nginx configuration to help deploy my Laravel application. You will employ the Forge Laravel server operating system for this project and will be required to set up a MySQL database to work in concert with my app. I'm looking for someone with: - A solid understanding of Laravel application deployment using Forge - Proficient skills in server configuration with nginx - Extensive knowledge of MySQL databases and their integration with Laravel projects - Experience with Linode If you are proficient in these areas, then you're the person I'm looking for. Please shoot me a bid and let's get to work!