Zip code distance search mysql jobs
Hi Nurbek, small project to start. check attached zip file.
...involve creating a search table for users to access the daily prayer times at different locations. As an expert in this field, you will need to ensure that the search functionality is advanced enough to handle both city/locality and mosque name searches. Key Requirements: - Develop a user-friendly search table where users can access Salah times. - Implement search functionalities for both city/locality and mosque name. - Display the search results in a table format for easy understanding. Ideal Skills and Experience: - Proficiency in web development and database management. - Prior experience in creating searchable databases. - Familiarity with prayer time calculation and display will be a plus. We currently using a plugin table in wordpress to Disp...
I'm currently looking for experienced Cs-cart developers to assist with the development of a new site and Mobile apps ( theme unitheme of cs cart will be installed) we need auctions. Only Apply if you have experienced in cs-cart ( ) PHP software Mobile app code will be provided by cs cart Built using open source technologies, PHP/MySQL, Smarty, CS-Cart is flexible and highly customizable software making it easy to modify the program and extend its functionality according to your needs. Key requirements include: - Developing a brand new Cs-cart site from scratch. - Experience with online stores, especially those dealing with physical goods. - Implementing top-notch e-commerce features, including but not limited to product listings, categorization, and secure c...
Key Features: - University Search Tool: The website and app should come equipped with an intuitive university search tool. - Admission Requirements Database: A comprehensive database of admission requirements for various universities is crucial. - Scholarship Information: A database of scholarships to help students fund their education is also needed. - Student Profile & Document Upload: A platform for students to create profiles and upload necessary documents. - Student Timeline Planner: A tool to help students plan their application timelines. - Counsellor Profile & Meeting Booking: A profile for counsellors with the ability to see student application profiles, and a booking form to schedule meetings. - AI Chatbot: An AI chatbot for answering common queries. - Admin...
...السابقة الغات البرمجة: ثل Java، Kotlin لتطبيقات Android، و Swift، Objective-C لتطبيقات iOS.تطوير واجهة المستخدم (UI/UX): استخدام أدوات مثل Adobe XD، Sketch، أو Figma لتصميم وتطوير واجهة المستخدم.تطوير الواجهة الخلفية (Backend Development): معرفة بلغات البرمجة مثل Node.js، PHP، Python.استخدام أدوات التطوير: مثل Android Studio و Xcode لتطوير التطبيقات المحمولة.القدرة على التعامل مع قواعد البيانات: مثل MySQL، MongoDB، Firebase.مهارات الاتصال والتفاوض: للتفاعل مع العملاء وفهم احتياجاتهم وتوضيح المتطلبات.تفهم مفاهيم التصميم والتجربة: لضمان تقديم تجربة مستخدم ممتازة وملاءمة.قدرة على حل المشاكل: لتحديد وحل المشاكل التقنية التي قد تنشأ أثناء تطوير التطبيق.
As a business that is seeking to grow our online presence, I'm in need of an SEO specialist who can attentively focus on increasing my website traffic, improving search engine rankings and boosting online visibility. This task will optimally focus on the homepage and product pages of my website. Experienced professionals, with a solid understanding of SEO and proven track records in the field are preferred. Relevant experience can be demonstrated through prior roles or specific projects that illustrate your ability to dramatically enhance SEO performance. Key responsibilities for this role will include: - Conducting audits of the existing website structure specifically the homepage and product pages - Implementing strategic changes based on these audits - Continually monitor...
1) bharatiya nyaya sanhita 2023 pdf: 2) bharatiya nyaya sanhita pdf: 3) bns: 4) bharatiya nyaya sanhita: All backlinks will be for home page (root domain). Target URL: I want weekly and monthly work and backlinks report.
...our website, which is built using Umbraco, C# coding, and MySQL database, to a new hosting environment. **Project Details:** - **Current Setup:** - Website developed in Umbraco (Microsoft open-source CMS). - Backend: C# coding. - Database: MySQL. - Currently hosted on a Windows server with IIS. - **New Hosting Environment:** - Hostinger VPS with Linux OS. - SQL Server installed via command line (no GUI). - No Windows server or IIS available. **Issues Encountered:** - Umbraco runs well locally on the VPS but not accessible externally. - Unable to attach the website domain. - Issues uploading the website from a local machine to the VPS. **Requirements:** - Expertise in Umbraco CMS. - Strong knowledge of C# and MySQL. - Experience with migrating websi...
...phone hotspot, so I am willing to pay you to allow your machine to stay online and run as a peer. I want to contribute to the decentralized search network and also connect as a peer to your machine. This can be done in the background. You could continue using your computer for other tasks. Key Requirements: - Able to download the free software and install it on your machine - Keep your machine online (or most of the time) - You may have to configure your router or firewall to open port 8090. - Set up administration account with the password I specify. I am paying you to allow me to connect to your machine in the background, only for the peer-to-peer search and web crawling function. There is no way I know of that I could access anything else on your machine, just lik...
I'm looking for a skilled developer to create a Flask-based website connected with mysql. This website will be primarily for my personal development. Key Features: - Email Verification otp on login A simple website for our team to use with login option and it should have following features A form to manually update my database A search page to search in my database (For example :- for a student databases a page to add all the details of a new student manully and a page to search for students based on same criteria which shows the result in a table form) My budget is around 2000- 2500 rs Ideal Skills: - Strong experience with Flask: You should have a proven track record of developing websites using Flask. - User Authentication Expertise: Understandin...
I am in search of creative designers who excel at crafting whimsical, cartoon-style characters, specifically, rubber hose characters. While I have skipped specific details about design features and character attributes, I will be open to your individual style and interpretation. Key Requirements: - Proficiency in cartoon-style character design - Strong creative instincts - Ability to incorporate your individual flare while balancing the foundational aesthetics of rubber hose characters Please share your portfolio when bidding, especially any work related to cartoon style characters. This will help me assess if your style could be a great fit for this project.
...Scrapy) to extract data from relevant grant databases and websites (if possible, considering anti-scraping measures). Sites to be scraped: 2. Design a database schema to store the extracted data. 3. Write scripts to clean, transform, and load the data into the database. 4. Design a WordPress directory listing interface with search filters to display the grant information. 5. Develop a user interface to query and display the grant information based on customer criteria 6. Create a Python plugin for WordPress to automate the scraping work, using tools like WP-Python or PyWP. This plugin would allow for scheduled scraping, data updates, and integration with WordPress's database and user interface. Please note that this
I'm looking to develop a website that serves as a meeting point for recruiters and candidates, allowing them to interact through a variety of features. The site will primarily be focused on facilitating communication between users, with an additional search functionality to help users find suitable matches. Key Features: - Search functionality: The website should have a robust search feature that allows users to look for specific job roles, skills, qualifications or any other relevant criteria. This search should be based on keywords, facilitating a quick and efficient matching process. - Messaging: The platform should have a text-based messaging system enabling recruiters and candidates to converse, share more about themselves and discuss potential opport...
I am looking for a proficient Java coder who can design and implement a code that will graphically visualize the Critical Path Method (CPM) and Program Evaluation and Review Technique (PERT) networks in project management. Requested to implement a program in Java programming language and graphically visualize the network/graph generated as a result of executing the Critical Path Method (CPM) and Program Evaluation and Review Technique (PERT) in Project Management. Key functionalities include: - Generating CPM network - Generating PERT network - Graphically visualizing CPM network - Graphically visualizing PERT network The code should be designed to take input of project tasks, duration and their dependencies, creating a detailed and clear diagrammatic network. Skills a...
...Include: High-quality images of the villa and its amenities (logo and photos can be taken from our website ). A compelling tagline (e.g., "Experience Luxury by the Beach" or "Your Private Paradise Awaits"). Contact information (phone number, website, and social media handles). Colors and Fonts: Use sophisticated and inviting colors. Fonts should be clear and readable from a distance. Size and Format: The final design should be scalable to 16x8 feet and provided in high-resolution format (AI, PSD, or similar). Submission Guidelines: Submit your design in high resolution. Include a brief description of your design concept and how it aligns with the luxurious and exclusive nature of Villa Royale. Ensure your design is original and not infringing on any copyrig...
I'm looking for a skilled SEO expert to improve my website's rankings on Google. - Primary Goal: My main aim is to boost search engine rankings, particularly on Google. - SEO Strategies: I'm interested in both On-page and Off-page SEO techniques. The ideal freelancer for this job must have: - Proven experience in SEO and track record of improving website rankings - Expertise in both On-page and Off-page SEO strategies - A thorough understanding of Google's algorithms and ranking factors - Strong communication skills and ability to provide regular updates and reports on progress If you're confident in your SEO skills and can help me achieve my goal of better search engine visibility, please submit your bid.
...enabling all functionalities of the website. Chat Feature: Integrate Sendbird SDK/API to provide robust chat functionalities within the marketplace. Clean Code Practices: Adhere to industry-standard clean code practices to ensure maintainability and scalability. Required Features: Responsive Design: Ensure the website is fully responsive, providing a seamless user experience across desktops, tablets, and smartphones. SEO Optimisation: Implement on-page SEO best practices, including schema markup and integration with SEO tools, to enhance search engine visibility. Performance Optimisation: Focus on fast loading times through optimised code, image compression, and other performance enhancement techniques. Image Optimisation: Utilise modern image formats ...
I need to find someone to fix a wordpress website error containing 5000 articles and 404 products, suspected of being infected with malicious code due to containing many strange files. The admin page can still access the article product pages, but there is a 404 error
Gradeco has an intranet called GRADENET, and its created in php/mysql platform. Please look at uploaded file for the requirements. Feel free to ask questions.
...performance - Troubleshoot and resolve any technical issues that arise - Collaborate with our team to understand project goals and deliver results that exceed expectations - Stay updated with the latest industry trends and technologies to implement best practices Requirements: - Proven experience in WordPress and WooCommerce development - Strong understanding of PHP, HTML, CSS, JavaScript, and MySQL - Experience with theme and plugin customization - Knowledge of SEO best practices - Ability to work effectively in a team environment - Excellent communication skills and attention to detail - Ability to manage multiple projects and meet deadlines Preferred Qualifications: - Experience with RESTful APIs and third-party integrations - Familiarity with version control systems like Gi...
...Incorporate Google Maps powered dropdown suggestions for city and state inputs to enhance user experience. ** SEO and Security Setup: - Implement comprehensive SEO strategies to improve organic search visibility and ranking. - Set up SSL through GoDaddy to ensure the website is secure and trusted by visitors. ** Database Management: - Integrate Google Sheets with the MySQL database so that the rates can be updated weekly via Google Sheets instead of directly through the cPanel, simplifying maintenance and updates. - Ensure seamless data synchronization between Google Sheets and the MySQL database to keep the quote system accurate and up-to-date. ** Deliverables: - A fully redesigned WordPress website with a modern look and maintained content. - A ful...
I'm looking for a Dafny developer to support me in the completion of existing code. I need him to pass verification of the code by the instructions exactly. it requires knowledge in proofs, using lemmas. Key Responsibilities: - Complete existing code in Dafny - Conduct code verification and ensure it passes successfully - Ensure the code is coherent and properly structured Requirements: - Proficient in Dafny - Extensive experience with complex algorithms and data structures - Able to work with well-documented code and project requirements - Strong problem-solving skills - Excellent communication skills, as we will need to discuss certain parts of the code Prior experience with similar projects and a good track record of successfully...
...manipulation of the data for reporting purposes. The columns of data required, but not limited to are as follows: Order ID, Tracking ID, Product Name, Unit Price, Ship By Date, Deliver By Date, Purchase Date, Ship Date, Payment Method, Fulfillment Methods, ASIN, Quantities, Item Subtotals, Tax Total, Refund Total, Shipping Label, Shipping Cost, Grand Total, Status, Buyer Name, City Name, State, Zip Code, Tax Collection, Tax Responsible, SKU, Condition, Order Item ID, Package Type, Dimensions, Weight,<and any and all other information available is desired). I'm seeking a freelancer with experience in the Amazon Seller API to pull back data and metrics - all columns listed above of data related to Sales, Orders, Products, Customers, and beyond.… Your prima...
I'm seeking a Power BI expert to create a Territory Map of both Zip and State. Key Project Requirements: **Mapping:** Your task involves creating the map with both zip and state information. **Data Update:** The map should be updated periodically, not in real-time. I'm using ARCgis in Power BI to create maps. I can create a good map based on zip codes, or based on state, but I can't seem to figure out how to combine the two. Our CA territory is divided by zip code, but some states are considered one territory. So, I need to apply first a filter by zip code, and then a layer based on state on top of that. Attached is the territory map by zip code that I created with Power BI. I need it to look like that...
I have a pre-built 2D game engine ready and need a talented and experienced developer proficient in C++ to develop a simple game layered on it. Given that I have not chosen a specific genre, a puzzle, adventure, or arcade game are all possible directions for this project. I remain open to your creative suggestions, but I want to stress that it should be very be...Therefore, familiarity with this software is a must. - MUST know about Game Engine basics!! This is less about being hyper focused on game creating and more about understanding the building of game engines. I already have the game engine part created, I'm just having issues being able to apply the working keys and uploading images to create a window that displays the simple game. Will send the zip file containing ne...
Write mobile responsive html code. 222 words, 4 images. Some design work needed.
...create a fully responsive, user-friendly website for my moving company. This project involves a comprehensive set of requirements, including: - Service Details: The website should showcase our key services, including packing and unpacking, furniture assembly and disassembly, and courier services. - Pricing Calculator: The site should feature a sophisticated pricing calculator that accounts for distance-based and volume-based pricing. The calculator should be intuitive and easy for users to interact with. - Booking and Contact Forms: We need easy-to-use forms for customers to book our services and get in touch with us. - Security Features: Security is a top priority. The website should include SSL encryption, user authentication, firewall, anti-malware protection, two-factor auth...
I have a pre-built 2D game engine ready and need a talented and experienced developer proficient in C++ to develop a simple game layered on it. Given that I have not chosen a specific genre, a puzzle, adventure, or arcade game are all possible directions for this project. I remain open to your creative suggestions, but I want to stress that it should be very be...Therefore, familiarity with this software is a must. - MUST know about Game Engine basics!! This is less about being hyper focused on game creating and more about understanding the building of game engines. I already have the game engine part created, I'm just having issues being able to apply the working keys and uploading images to create a window that displays the simple game. Will send the zip file containing ne...
... Reward points management (adjust points, manage redemption) specific to each hospital. Product management for point redemption. Transaction management for cash withdrawals. Reporting and analytics dashboard. Technical Specifications: Backend: PHP Laravel framework. Frontend: Hybrid technology (e.g., React Native, Flutter). Database: MySQL or PostgreSQL. Secure payment gateway integration for cash withdrawals. Compliance with data protection regulations. Project Timeline: Detailed project plan and timeline to be provided by the company. Expected project completion within 3months. Payment Terms: No advance payments will be made. Payment will be released only upon successful del...
I am looking for comprehensive assistance in the job search process. Specifically, I need help with: - Most importantly getting a job - Optimizing my LinkedIn profile - Providing job coaching, which includes interview preparation, networking tips, and overall job search advice - Utilizing a recruiter's services to tap into hidden job market and discover unpublished openings - Utilizing an established referral network to increase my chances of landing a job - A Referral and Recruiter Note: The goal is securing a job I require professionals with 5-10 years of experience in job coaching, recruitment services, and referrals. Your expertise in these areas will be crucial for my success in securing a new position.
As a UK-based retailer, I am seeking a diligent individual to monitor the Estate Agent A website for new shop listing opportunities. My business is specifically interested in high-street store properties; thus, your search should prioritize these types of listings. Moreover, the new shop space should ideally be medium-sized, ranging between 500 to 1000 sq ft. The perfect candidate for this job should have: - Proficiency in online research - Familiarity with the UK real estate market - Exceptional attention to detail - Experience in real estate would be advantageous.
Each year we do a t-shirt for our American Football event called Champions for Charity. We need an illustrator to make us a new illustration for this year's shirt. Th...illustration should be of our mascot kicking a football (American football) over the stadium through the field goal posts (see attached sketch) 4. The stadium is already drawn, pull this from last year's file (attached ). Just need to change the year inside to 2024. 5. The illustration of the mascot kicking the football should match our previous styles, I will send a zip file with reference images from past t-shirts. We want the illustration to have some motion with the mascot kicking the ball. 6. We need this done within 24 hours. Can provide any assistance needed to meet that deadline.
We are using the VROOM Project front end for a route optimization tool. The code is open source You can demo it here - We have modified the front end to support uploading data in and XLS format instead of JSON. The data parsing is working but we are looking to improve the data validation to alert the user of specific problems with their data they are uploading. Input data: Sheet 1: Work Order Tab Name, Address 1, City, State, Zip, Technician Sheet 2:Technicians Tab Name, Starting Address, Starting City, Starting State, Starting Zip, Ending Address, Ending City, Ending State, Ending Zip Some of these fields can be blank. Useful validation for the user will be required. See this documentation regarding the json
...upload approved designs to Printify.com. - Ensure correct formatting and specifications for printing. - Manage the product listings on Printify and ensure seamless integration with our online stores. 3. **Online Store Management:** - Add new T-shirt designs to our online stores (Shopify, Etsy, etc.). - Write compelling product descriptions. - Ensure product listings are optimized for search engines (SEO). 4. **Marketing and Promotion:** - Develop and implement social media strategies to promote new designs. - Create and schedule posts for social media platforms (Instagram, Facebook, TikTok, etc.). - Manage email marketing campaigns, including designing newsletters and setting up automated workflows. - Conduct SEO and content marketing to drive organic...
...for are QR code scanning for attendance tracking and a robust reporting and analytics system. Key Features: - Android and Web Compatibility: The app should be accessible on Android devices and through a web interface. - QR Code Scanning: The primary function of the app is to scan QR codes for attendance. The UI should be intuitive and easy to use. - Reporting and Analytics: The app should have the capability to provide detailed reporting and analytics on attendance data. This includes but is not limited to: - Tracking attendance trends over time - Generating customizable reports - Exporting data - Visual representation of data I'm looking to have this project completed as soon as possible. Experience in developing attendance applications, particula...
...for a talented SEO expert to improve my website's visibility in search results, increase organic traffic, and boost conversions. As I'm uncertain about the current status of my website's SEO, I need someone who can conduct a thorough assessment and propose a comprehensive optimization plan. Key Responsibilities: - Conduct a detailed SEO audit to assess the current status of my website's SEO - Propose a comprehensive SEO strategy to improve website visibility, increase organic traffic, and boost website conversions - Implement on-page SEO, off-page SEO, and technical SEO improvements - Monitor and report on the performance of implemented SEO strategies Ideal Skills: - Proven experience in improving website visibility in search results, increasing organ...
I'm in search of a talented individual who can assist in the rendering of a modern kitchen design. The primary focus of this project is to accurately represent the cabinet type. Ideal for this project: - Proficient in modern kitchen design rendering - Eye for details, specifically cabinet types - Ability to work to deadlines and follow instructions meticulously What to include in your application: - Detailed project proposal with time schedules and possible benchmarks - Proven records on similar projects or samples of work are a bonus but not essential. Looking forward to collaborating with you.
I'm in need of a seasoned developer who's proficient in both Spring Boot and React, to assist in identifying and rectifying persistent runtime errors in my project. The issues primarily revolve around the frontend, with specific problems pertaining to JavaScript, user interfa...resolving runtime errors in similar setups. - Thorough understanding of JavaScript, particularly in the context of frontend development. - Proficiency in user interface design and page optimization. The main concern lies with the page navigation functionality, which is being impeded by the JavaScript errors, user interface, and loading/rendering issues. Your task is to meticulously review the code, pinpoint the root causes of these problems, and implement necessary adjustments to ensure smooth, e...
...efficiency of an existing Python code that I've been using for data analysis. The main areas to be addressed are: 1. Performance Enhancement: - Faster execution time - Ability to deliver more accurate results 2. User Flow Improvement: - Enhanced user interface for better interaction - Smoother transitions between functions - Clearer error messages to ease the debugging process 3. Additional Capability: - Incorporate built-in data visualization features to the code. Ideal skills and experience for this job include advanced Python programming, proficiency in data analysis and visualization libraries, and a solid understanding of user interface design principles. Your ability to fine-tune the system for enhanced performance while maintaining code...
I am looking for a professional PHP developer who can build a custom website for me, and integrate it with one APIs. - the API is already in use in other websites so ...as the one in the link above. We have already developed a basic frontend page with the form (input boxes and selectables) to collect the data that will be submitted to the API (json). Next step is store this data locally and submit it to the API. Final design we will take care later. Ideal skills and experience for this project include: - Proficiency in PHP, with a strong understanding of MySQL. - Experience working with various APIs, as you may need to integrate APIs into the site. - Strong communication and problem-solving skills, as you may need to troubleshoot any issues that arise during the integratio...
I'm looking for a professional to help me fix my sitemap on Google Search Console. Currently, I'm experiencing two issues: “Missing URLs in sitemap” and “Errors in sitemap.” Key Project Details: - Less than 10 pages are currently missing from the sitemap. - There have been no recent changes to the website that could have affected the sitemap. Ideal Freelancer: - Must have experience in resolving sitemap issues on Google Search Console. - Should have a good understanding of website structure and indexing. - Proficient in identifying and rectifying errors in the sitemap. - Strong communication skills to explain the resolved issues and ensure future sitemap stability.
I am looking for a skilled C++ developer to create a REST API for my...data retrieval and manipulation. - User authentication and authorization are required for this project, using existing APIs Database: - Although I don't have an existing database, I have specifications for it. - The API should connect to the specified MySQL database based on the provided specifications. Timeline: - The expected timeline for the project is more than 3 weeks. Skills and Experience: - Proficiency in C++ programming language and POCO framework - Strong knowledge and experience in developing REST APIs. - Familiarity with MySQL database connectivity and management. - Ability to understand and implement specifications for the database. Please provide examples of your previous work in dev...
I'm seeking an experienced SEO specialist who can take charge of monthly management and upgrading of my website. I have three main objectives to achieve: 1. Increase organic traffic: Enhancing the frequency and quantity of unpaid traffic that comes to my website from search engines. 2. Improve search engine rankings: Boosting my website's position on search engine result pages. 3. Enhance user experience: Revamping my website to provide users a smooth and satisfactory navigational experience. Focus areas include the Homepage and Blog page. Having vast experience in successful SEO management is mandatory for this project. I look forward to seeing tangible improvements and results.
I am reaching out to you today because I am facing a ...believe requires your expertise. After reviewing my site's performance metrics, I have encountered a significant challenge with the Largest Contentful Paint (LCP) specifically on mobile devices. According to the Google Search Console, my site is experiencing an LCP issue, where the loading time exceeds the recommended 2.5 seconds, adversely affecting the mobile user experience. The exact warning presented is as follows: "Warning: Needs improvement LCP issue: longer than 2.5s (mobile)" Understanding the importance of LCP in enhancing user satisfaction and potentially influencing search engine rankings, I am keen on addressing this issue promptly. I am seeking your professional services to diagnose and resol...
...project. Key Responsibilities: - Reviewing the code: I need you to provide feedback on my code and suggest improvements for better performance. - Tackling Problems: When I encounter issues, you're expected to help me solve them. - Data Preprocessing: Assist in optimizing data for model training. - Training and Evaluation: Aid me in efficiently training and evaluating my models. - Debugging and Error Handling: Help me in identifying and resolving code issues. Communication: - For code reviews and questions, we'll communicate through an instant messaging app. Ideal Freelancer: - Proficiency in PyTorch and deep learning model building. - Strong understanding of data preprocessing techniques and training methodologies. - Experienced in debugging ...
I'm looking for a custom add-on for Perfex CRM. The add...CRM. The add-on shall generate a graph that can be filtered by personnel and date. Key requirements include: - Display data: The graph should show the number of opportunities. - Chart style: The preferred style is a line chart. - Filtering: The graph should be filtered based on selected personnel and date ranges. Ideal skills for this project include familiarity with Perfex CRM, strong PHP and MySQL experience, as well as an understanding of charting libraries for graph representation. A professional who can work efficiently and deliver a user-friendly, visually appealing solution will be highly appreciated. There is a ready-made page similar to our needs in Perfex CRM. I just want it to be converted into a plugin with...
I'm seeking a Python expert to assist with small tasks to insert data & search data with the help of keywords
ITALIAN LANGUAGE MANDATORY. Starting from a list of 12500 Company names in excel, we need to fill in the other columns finding online: - website URL - Zip Code - VAT Number - Type of Industry (selecting it from the excel drop down menu)
I am looking to develop a Variable Message ...is that it will be SAAS-based, Multiple clients will be added based on plans and packages, and APIs of the devices will be integrated for the clients added. The user Manual for the software is attached, Please Go through the manual and get Details. For the software demo, please access: ViPlex 64 bit: (X64).zip 32bit: This project requires a skilled .NET developer with experience in developing software for the Windows platform. Previous experience with traffic management software or VMS systems would be a great advantage. Please provide a relevant project portfolio.
