Run sql script setup project jobs

...Google Ads Conversion Setup - Google Ads Conversion Tracking in Google Tag Manager Setuo - Google Tag Manager Setup Ga4 - Google Analytics Setup Key deliverables: - Implement proper tracking of 'Click on ads' - Ensure seamless tracking of 'Click on ads' across all landing pages and ad campaigns - Provide insights and recommendations for enhancing ad performance based on data analysis - Troubleshoot and resolve any potential issues with the tracking Ideal Candidate: - Proven experience with Google Ads and Tag Manager - Strong understanding of ad performance analysis - Ability to implement custom tracking solutions - Excellent troubleshooting skills - Attention to detail and a data-driven approach Please share your relevant experience with Goo...

...ETL processes to support ongoing maintenance and scalability. - Collaborative and Rapid Execution: Work closely with the project manager and other team members to ensure alignment of the database design with business requirements and analytics goals, within the stipulated time frame. #Requirements: - Extensive experience as a Data Engineer, Database Architect, or similar role with a strong focus on rapid project execution. - Expertise in handling tight deadlines and delivering complex projects quickly. - Strong understanding of API integrations and experience with RESTful services. - Proficient in relational database design and development, preferably with experience in SQL and NoSQL databases. - Experience with ETL tools and processes under strict time constraints...

I am looking for a virtual CFO to assist me with financial forecasting and budgeting for my business in accounting. Key Responsibilities: - Provide expert guidance and support in creating accurate financial forecasts. - Develop efficient and effective budgeting strategies to align with our business goals. - Offer insightful recommendations on financial planning, risk analysis, and performance measurement. Ideal Candidate: - Proven experience in financial planning, forecasting, and budgeting. - Extensive understanding of accounting practices, particularly in the accounting industry. - Prior experience using Xero for accounting software is highly desirable. - Strong analytical and problem-solving skills. - Excellent communication and presentation abilities to convey financial information ...

AI Hustler Project Escrow Setup Work Progress Work to be done between 15th april to 19th april , 2024

I am looking for an expert in Doorbird system to help maximize the efficiency of my home unit, focusing specifically on: Access control: - Enable the system to control multiple doors and garage openers - Allow t...lock/unlock remotely - Add a keypad entry system for a streamlined user experience. Automation: - Automize processes where possible for ease of use Ideal Skills: - Extensive knowledge in Doorbird systems - Experience in automating security systems - Expertise in integrating varying access control systems, particularly with keypad entry systems and magnetic locks Your will help me document the current setup, explore technologies and products to purchase, make a plan incl. wire diagrams. Proven experience with home automation (doorbird a1018, doorbird ‎D2101) system...

I'd like some assistance in completing the customization and setup of my ongoing WordPress project. Looking for a freelancer with the following skills: - WordPress Design customization: Someone who can effectively change the color scheme of my website and add custom graphics to enhance visual appeal. - WordPress Plugin Installation: Must be proficient in SEO optimization plugin installation and setup to enhance the visibility of the site. Experience with WordPress and a keen eye for design are crucial for this project's success.

I am looking for an experienced freelancer to help me start on Google Shopping. Here are my specific needs: - New Google Shopping account creation: I don't have an existing Google Merchant Center account yet, so will need assistance creating one from scratch. I am hoping to find someone experienced in leading new users through this process. - Product uploads: My main product type will be books and media. Ideally, you have had prior experience uploading and listing this type of product onto Google Shopping before. If you can share examples of past work in this area, that would be excellent. The ideal freelancer for this job would be proficient in Google Shopping account creation and product listing. I am open to suggestions on how to make my Google Shopping start a successful one. P...

Hello! I'm looking for an experienced Person who can build the mobile device management (MDM) Server for iPhone device. Specifically, I need someone with expertise who can create a custom MDM solution. This solution must be capable of advanced user access control, including full control of devices, remote wipe capabilities, and more. The MDM functionalit... The ideal candidate has extensive experience developing mobile device management solutions and can create a solution that meets my needs in terms of the level of user access control. If you believe you can deliver the skills and experience necessary for the job, please reach out. I am excited to work with you on this project to build a customized solution.

I'm intending to launch an online course aimed at enhancing the skills of sales professionals. To promote it effectively on platforms like YouTube and Facebook, I'm seeking a highly cost-effective, patient, and experienced individual proficient in crafting and managing ads. Requirements. 1) Help me create promotional video (advertisement) 2) Run the ads. 3) He/she will be responsible for analyticals and retargeting ads Start your bid with the amount you're bidding. For eg. If you are billing for $20, start your message with $20 and then write "Hi" Someone who is very patient with questions and willing to help me see my online course.

I'm looking for a seasoned Python developer with specific experience in image especially video analysis to create a script that can process a full mp4 video and identify the positions of noise in the video. The idea is to scan the video, locate identify the different type of noises and their value and externalize this findings into a json file Key Requirements: - The script (OOP based) should be able to read a video in mp4, mkv, mov format. - The library used for reading the video is not fixed. You can choose from libraries like (e.g. OpenCV, PyAV, or MoviePy, but the solution should be compatible with both Windows and Linux (and mac) - The output should have details of the signal, the different type noises, the common ratios and finally the values ... - the frame numb...

I need assistance in creating a Python script that can dial a number through a VoIP service using the VCDial setup I have. The code should also play a pre-recorded message when the call is connected. The operating system I am using is Windows. Key Requirements: - Develop a Python script that can interact with the VCDial setup for dialing numbers. - Integrate the functionality to play a pre-recorded message once the call connects. - Ensure the script can run smoothly on a Windows environment. Ideal Freelancer: - Proficient in Python programming, with experience in telephony and VoIP setups. - Familiar with VCDial or similar systems. - Able to work effectively on Windows OS. - Prior experience in creating automated call systems or call centers wou...

I need a staging website created on Magento, with some specific customizations needed right away. The project involves: - Installation of Magento - Connecting the domain - Custom creation of header and footer as per provided design (focusing on Menu navigation) - Setting up a category page and product page - Installing a theme you'll be provided with - Installing some necessary modules - Redirecting non-www to www Please note that this project is on an urgent basis. I am looking for a freelancer with a strong understanding of Magento, experience in creating custom headers and footers, and the ability to complete the work within a short timeframe.

Please answer with ‚I used meltano and I can help’ if your bid is not bot generated. I'm in need of a Meltano expert to guide me through the setup process and provide a comprehensive document of the steps outlined. Key Responsibilities: - Guiding through Installation and setup - Configuration and customization for specific needs - Being available for troubleshooting and bug fixing The ideal freelancer for this project should have: - Proven experience with Meltano - Excellent communication skills - Ability to provide clear, detailed documentation of the process

I am in need of a skilled Linux and Bash Script expert to help me with my current project. Although I haven't specified exact tasks or goals, I am seeking assistance in the following areas: - Linux installation and configuration - Bash scripting and automation - Troubleshooting and debugging I expect the successful freelancer to have a deep understanding of Linux systems and be proficient in Bash scripting. Your past work and experience in similar projects will be valuable. Please detail how you can assist and your approach in your application. Thank you.

...understanding of or an interest in historical research and filmmaking. Key tasks: - Comprehensive research on the topic of black inventors - Writing a captivating script that highlights pivotal moments and key figures - Narration and production, ensuring to bring the story to life Ideal Skills: - Previous experience dealing with historical documentaries or similar projects - Strong research skills and resources - Excellent scriptwriting and narrative skills - Ability to deliver high-quality audio for a radio documentary Given that there is no strict timeline, quality and attention to detail are paramount in this project. The intent is to craft a captivating, informative, and accurate piece that pays due homage to the often unrecognized black inventors t...

Project Background: We envision an innovative platform designed to transform how organizations, including startups, nonprofits, researchers, and small businesses, search for and apply for grants and funding. By leveraging advanced AI technologies and a user-friendly interface, aims to simplify and enhance the funding acquisition process. Objective: The primary objective of this project is to develop the Minimum Viable Product (MVP) for using the Bubble platform, incorporating the capabilities of the Perfect AI Software Template. This MVP will validate the concept by offering essential functionalities such as AI-driven funding opportunity matching, interactive user profiling through an intelligent quiz, and efficient application assistance. Scope of Work: The project

I'm seeking an experienced .NET developer with over 4 years of expertise in C# programming and SQL databases. Key Responsibilities: - Enhancing existing software application - Adding new functionalities The ideal candidate should possess: - Strong experience in C# programming - Solid knowledge and practical experience with SQL databases Be ready to dive into the project and help us bring significant functionality enhancements to our existing software. Your experience and skills in C# and SQL will be invaluable in this task.

I'm looking for a skilled individual who has a good understanding of Mechanical Engineering and Data Science to help me set up a database that records ...database to store the collected sensor data - Analyzing the data primarily for predictive maintenance using statistical analysis Ideal Skills: - Mechanical Engineering background - Proficiency in working with On-Board Diagnostic Tools - Strong experience in statistical analysis - Knowledge of database management systems and data analysis tools - Experience in predictive maintenance is a plus This project requires attention to detail, analytical thinking, and the ability to translate the sensor data into actionable insights for predictive maintenance. If you have the required skills and experience, I look forward to reviewing...

...designed for visitors to either submit a form or place a phone call. I am looking for a skilled professional to help me set up conversion tracking specifically on the Google ad. Key requirements include: - Setting up conversion tracking on the Google ad. - Tracking both form submissions and phone calls on the landing page. - Coordination with my existing Google Analytics setup on the website. The ideal candidate for this project should have: - In-depth knowledge of Google Ads and conversion tracking. - Experience in setting up conversion tracking for both form submissions and phone calls. - Familiarity with Wix websites. - Expertise in coordinating Google Ad conversion tracking with Google Analytics. I'm looking for someone who can ensure that the tracking is accu...

I'm in search of an amateur actor who is aged 20 years or older, to play a leading role in my school project. Here's what you should know: - Your Experience: As this is a casual endeavor, no professional acting experience is required. However, you should be comfortable taking center stage and carrying a narrative. - Your Role: In the project, you'll be the centerpiece, bearing a significant portion of the script. You'll portray various emotions and, potentially, multiple aspects of a complex character. Ideal skills and experience: - Experience in amateur theater or similar productions - Ability to take and apply direction - Good memorization skills - Comfortability with performing in front of an audience - Reliable and committed to meeting rehe...

I need a talented VB.net developer with a strong background in SQL Server. Key Responsibilities: - Develop software applications using VB.net - Efficiently manage databases - Designing, coding, testing, and debugging software applications using VB.NET. - Calling third-party API - Payment gateway integration - Stored Procedure Ideal Candidate: - Proven experience in VB.net development - Strong familiarity with SQL Server - Good problem-solving skills - Ability to work independently and meet deadlines. Please provide relevant work samples in VB.net development and describe your experience with SQL Server.

I'm l...and is experienced in WordPress. - Strong understanding of the WordPress plugins ecosystem and knowledge on how to extend its functionalities. - In-depth knowledge of SEO and how to enhance it on a WordPress website. Key Tasks: - Develop a WordPress plugin that targets SEO enhancements. - Test the plugin for compatibility issues and fix any bugs, ensuring it works harmoniously with our existing setup. - Understand our needs and respond to them by customizing the plugin where necessary. Please note that the function to be added to the site leans heavily towards SEO enhancement capabilities. Therefore, a proven track record in developing SEO related plugins is a must. Your proposal should demonstrate a clear understanding of SEO principles and their implementation on a ...

I'm looking for a professional videograp...edit a series of podcast episodes for me. - Session Length: The ideal candidate must be available for a full 8-hour day filming. - Episodes: The project scope includes recording and editing 1-5 episodes. Additional projects may be available based on successful collaboration on the initial series. - Style: The videographer must be adept at the interview style of videography. - Skills and Experience: Experience in podcast production, video editing, and interview-style videography is required. A portfolio showcasing similar projects would heighten your chance to win the bid. You'll need to provide all the necessary filming equipment, manage the setup on location, and perform a fully polished and edited video outcome. Can�...

I'm looking for a professional interior decorator with excellent tastes to furnish my small-sized apartment. The project predominately focuses on the living room and bedroom. The attached pictures belong to the model. With the exact design.

As a business looking to optimize an existing site, I am searching for a talented individual to assist me in achieving a 90+ page speed score. The site also needs the addition of e-commerce functionality, specifically WooCommerce. Key requirements for the job include: - Proven record of achieving high page speed scores on WordPress sites - Expertise in WooCommerce integration and setup - Ability to provide e-commerce site optimization suggestions. It's a plus if you have the following: - Experience with theme selection and customization. Although a specific theme hasn't been selected, I am open to recommendations that would benefit the page speed and overall user experience of the site. I look forward to seeing your past work on WordPress and WooCommerce integrations...

I currently have a PHP script that echo's the value of a MySQL db and results appear 3 to a page using Pagination. I'd like the script modified to filter results. There should be a drop down box on the page with the selections of the drop down corresponding to the table column and when selected only the rows with the value of the column appear while still only displaying 3 to a page with page back and forward controls. In the below example of a db table the drop down box would contain the selections 1, 2 and 3. When the used selects 1 then the page output would only display Bob, Jane and Sarah. This is an already existing page with css in the output. Name Address. number ------------------------------------------------------ bob bris...

... and bash scripts for a personal project. This personal project is focused on web scraping. The successful candidate will be tasked with scraping product information, news articles, and social media data. Exemplary knowledge of proxifying requests through nginx and formatting bash scripts that interact with Nodejs applications is a requisite. Mandatory Skills and Experience: - Advanced proficiency in Nodejs - Extensive experience with nginx reverse proxy - Expertise in formatting bash scripts - Proven experience in web scraping, with emphasis on scraping product info, news articles, and social media data The ideal candidate must be able to present a portfolio demonstrating their competence in web scraping using techniques mentioned above. This project starts i...

I'm seeking a highly skilled iOS developer who specializes in Moodle app customization. Your task is to conduct a seamless setup of the Moodle app on my machine, ensuring it operates flawlessly on the iOS simulator. Your responsibilities include: - Understanding my requirements and applying basic customization to the app: including the logo, color scheme, and fonts. - The version of Moodle in my current use: Moodle 3.2 Given that I have a strict deadline for the project, proven experience in Moodle app customization, and the ability to meet deadlines, is strongly preferred. Your ability to communicate clearly and promptly is also critical for the success of this project, so I'm looking forward to proper problem-solving discussions if they arise.

...professional to assist with my video project, which is centered around the creation of promotional content. Key Tasks Include: - Video Editing: You'll be responsible for polishing and enhancing the raw video footage. This includes tasks like trimming, adding transitions, and ensuring a high-quality final product. - Script Writing: Crafting engaging, persuasive, and informative scripts that perfectly complement the video content. - Transcription: Converting the audio content of the videos into written form. My primary goal with this project is to create compelling promotional content that captivates and engages the target audience. Ideal candidate for this project should: - Have prior experience in content creation, with a focus on video editing and...

I'm searching urgently for an experienced PHP architect who can construct a unique e-commerce shopping cart and accompanying admin panel. Key Responsibilities Include: ...process. - Developing order management and inventory tracking system within the admin panel to help me keep track of orders and product stocks. Skills and Experience Required: - Proficient in PHP programming - Experience in developing e-commerce websites - Solid understanding of databases and SQL - Familiarity with different payment solutions Although there is no specific requirement for payment method integration at the moment, the ability to seamlessly add these in the future is essential. My project requires immediate attention and the chosen freelancer needs to be able to commit and deliver u...

Assist in writing answers for 3 questionnaires for Grant application criteria for an Allied Health Company demonstrating the company's setup All answers for the criteria's are to be written within 750 word limits each. Assessment Criterion 1: Service delivery [750 word limit] Describe how your organisation will deliver the services in the identified ACPRs in the application. Assessment Criterion 2: Stakeholder Engagement [750 word limit] Describe how your organisation will cultivate or expand links with other service organisations, infrastructure and resources, including the Regional Assessment Services (RAS) and other relevant specialist services e.g. dementia supports. Assessment Criterion 3: Efficient and Effective Use of Grant Funds [750 word limit]

I am in need of a professional who can promptly install and customize a PHP script for me. The PHP script I need to be installed is purchased through codecanyon. You will install, test all functions and activate license on our server. Being somewhat urgent, my requested completion for this project is ASAP. I value efficiency and swift, quality work. Thank you

I'm in need of an experienced developer in Pine Script for the development of a trading strategy. The script will be used specifically on the TradingView platform, so familiarity with this system is a must. Key Requirements: - Pine Script Proficiency: Proven experience in developing complex and efficient scripts on TradingView. - Trading Strategy Development: Understanding of market dynamics and indicators to create a successful trading strategy. Previous experience in this field is a plus. - TradingView Platform: Experience in deploying scripts on the TradingView platform, knowledge of its limitations and capabilities. This project requires an individual who is not only technically proficient but also has a good understanding of trading strategies. If yo...

...the rebranding and extending of existing Codecanyon scripts. - **Script Rebranding**: I need a meticulous freelancer able to successfully rebrand scripts to brands of clients. - **Extending Scripts**: Your tasks also include extending Codecanyon scripts by adding extra functionalities, ensuring consistent, flawless operation , implementing APIs and adding the functionalities in the existing flutter app, testing, fixing any bugs to ensure smooth operations of the system. Pay : 1. INR1200/day or fixed amount as decided by our project managers, for 8 hours of work on anydesk/github for adding functions 2. INR 2000/project for rebranding+testing+fixing 2 Apps systems of codecanyon like professional apps. 3. INR3000/project for rebranding+testing+fixing 3 ...

I'm currently testing the project listing system and would like to invite freelancers to share their past work for my virtual project. The goal of this project is to gather an understanding of how freelancers present their previous work. You can apply by simply sharing your past projects.

I need a professional to set up the WooCommerce Zapier plugin for me. The tasks include: - Configuring plugin settings - Creating Zapier workflows for automated tasks - Mapping data between Woocommerce and other apps - Ensuring customer details remain in the database on my site In addition, I require assistance in transferring the WooCommerce account ownership on my site to a new WooCommerce account. Ideal Skills: - Proficient in Woocommerce and the Zapier plugin - Experience in setting up automation workflows - Familiarity with CRM and email marketing platforms such as HubSpot CRM, Salesforce, and Mailchimp - Skilled in account management and data migration Please bid if you're confident in completing these tasks efficiently.

Please Sign Up or Login to see details.

I'm looking for a skilled developer who can create a personalized Roblox script hub for the games Pet Simulator 99, Jailbreak, and The Survival Game. Key Requirements: - Decompilation: You'll be required to decompile the mentioned Roblox games and extract essential elements for the script hub. - Auto Farm Feature: Implement an auto farm feature within the script hub that works seamlessly across all the games. - Personalized Design: Design the script hub with a minimalist theme, ensuring it's visually appealing and user-friendly. User Interaction: - The script hub should offer a graphical user interface (GUI) for users to easily navigate and interact with. Ideal Skills and Experience: - Proficient in Roblox scripting and decompilation. - ...

I'm looking for a skilled developer to enhance the online appointment a...Reminders: The system should automatically send reminders to customers before their appointment. - Payment Integration: The system should facilitate payment for appointments. - **Payment Integration Details**: Although we're considering integrating an online payment gateway like PayPal or Stripe for the future, for now, we'd like to stick with offline cash payments. Ideal candidates for this project should have experience in: - Developing and integrating online scheduling and payment systems. - Working with Fittlebug or similar appointment scheduling platforms. - Creating intuitive and user-friendly interfaces. If you have experience in similar projects and can help us implement these fe...

The machine learning component of this hybrid profile creation system in a Flutter app involves integrating a TensorFlow Lite model, possibly using DistilBERT for its efficiency and effectiveness in natural language processing ...preferences over time. Machine learning algorithms can identify patterns in what features or content the user interacts with most frequently, allowing for automatic adjustments to the user profile based on predicted preferences. Both aspects work in tandem to ensure the user profile is a living entity within the app, constantly evolving and adapting based on direct input and observed behaviors. This setup not only personalizes the user experience but also enhances engagement by delivering content and recommendations that are closely aligned with the user�...

I'm seeking an expert to assist with the complete transfer from my current WooCommerce setup to my own account. The data size is between 1GB to 5GB. Key Requirements: - Expertise in WooCommerce: You should have a deep understanding of WooCommerce and its functionalities. - Data Migration Experience: Proven experience in transferring large data sets in WooCommerce efficiently and securely. - Ownership Transfer Knowledge: Familiarity with the process of transferring ownership rights in WooCommerce, ensuring a smooth transition without data loss or disruptions. Your role will be to handle the migration process while ensuring the integrity and security of all transferred data. I'm looking for someone who can guarantee a seamless transfer, recognizing the criticality of the ...

I need someone to optimize and run my fiverr profile. I am wordpress developer looking for clients on that platform. I need someone who has experience in running fiverr profile. ONLY APPLY IF YOU HAVE EXPERIENCE AND CAN 100% PROOVE IT! Before hiring you we will have a short interview. Max hourly rate is $3. DO NOT APPLY IF YOU DO NOT AGREE TO PRICE

...skilled consultant to help with a project regarding my website. I have Google Analytics installed on my WordPress site, but I want to rebuild it to better focus on tracking website traffic. I would also like to integrate a Consent Management Platform (CMP) via Google Site Kit to ensure I'm compliant with various privacy regulations. Key tasks may include: - Rebuilding Google Analytics to focus on tracking website traffic - Integrating a Consent Management Platform (CMP) via Google Site Kit Ideal skills for this project include: - Strong understanding of Google Analytics - Expertise in WordPress - Experience with integrating and configuring a CMP - Proficiency in setting up Event tracking in Google Analytics - A fully operational Google Analytics setup via G...

I'm looking for a skilled Shopify developer to help me set up a Shopify store, focusing on selling footwear. Key Requirements: - Attractive Design: The store should be aesthetically appealing to potential customers, creating a positive shopping experience and enhancing brand image. - Functionality: Essential features such as product search functionality and product recommendations should be incorporated. - Content: I'd also like a video showcasing the footwear to be included. Product Types: - The store will sell a variety of footwear including sneakers, sandals, innersoles and socks. Prior experience in setting up stores that sell these kinds of products will be an added advantage. Product Inventory: - Initially, the store will have between 50 to 100 products. Experience in ha...

Hi I have a python matplotlib script that allows user to scroll through a 3D image, in nifti file format. It has a slider that allows you to scroll through the z axis of the image. I would like for the image to have a text box that updates chosen coordinates that are selected by clicking on the image at a given slice. I would like for the chosen coordinates to only update if the user clicks on the canvas where the image is. I would also like for the text box to be outside the canvas and slider. If you have previous experience with Matplotlib, this should be no problem. Thank you!

I require an proficient developer to create a script that can send out automated emails through Gmail. This task should be accomplished with an appropriate scripting language for Gmail's environment. Key Requirements: - Send out notification emails. - The notifications will be for scheduled reminders and service status updates. - Targeted audiences are all users and selected groups. Relevant skills include proficiency in JavaScript (as Gmail Scripts commonly employs this language) and familiarity with Gmail's API. Knowledge of handling scheduled tasks and interaction with user databases is also beneficial. In short, I'm looking for a coding and Gmail expert who can automate the process of sending important reminders and status updates to our users. The system shou...

...shop on my website and have it connected to Fresha CRM, the system I currently use. This shop should have a sophisticated design that complements my brand image. Key Requirements: - Development of a product catalog with detailed descriptions and prices - Inclusion of a shopping cart and a seamless checkout experience - Integration of online ordering and payment functionalities - Payment gateway setup to accommodate credit card and bank transfer options - Customization to align with an elegant and sophisticated design style Ideal Skills and Experience: - Proficiency in e-commerce development and CRM integration - Strong portfolio of elegant and sophisticated web design projects - Previous experience with integrating payment gateways - Excellent understanding of user experience ...

We would like to hire a freelancer expert in development of Postgres Database and Synchronization of Data from our Headquarter to our Multiple Area Office (10 No.) and to Multiple Local PC (Around 300 Nos.) locations available in Network.

I am looking for an expert in RFID technology and .NET programming to integrate the RFID into our current weighbridge system. Key Details: - 3rd Party System was developed using .NET and it does support API or external interface connections. - The task will involve programming to fully integrate the system with RFID technology. Skills and Experience: - Proficiency in .NET programming & SQL Database - Previous experience with RFID technology - Knowledge of API integration - Experience with weighbridge systems would be a huge advantage. Your role will be to ensure the smooth functioning of the weighbridge system post-integration and provide us with a user-friendly, effective RFID solution.

...proficient in relevant software. - The goal of the video is to promote a product or service, so your work must be adapted to achieve this goal. - The target audience for this project is adults, so the style and content of the animation must be suitable for this demographic. - Audio narration is still in process, but our market is based on the same thing that this application does, for the Latin American market. - In short, we are looking for an animation that is very similar to the attached video, since the narration will be very similar as well. - If the animator requires the script in the language necessary to understand the content, please indicate it in the offer or send a message. If you have a strong portfolio of similar work and understand how