A complete study for EB2-NIW (Employment-Based Second Preference, National Interest Waiver) cases must contain a series of essential elements to demonstrate that the applicant meets the necessary criteria to obtain this visa in the United States. These criteria generally include: Personal documentation and biographical information: This includes passport, marital status information, employment and education history, among other personal documents that confirm the applicant's identity and qualifications. Petition letter: A detailed letter that presents the applicant's case, highlighting their accomplishments, experiences and how they benefit the United States. The letter must explain why the applicant deserves an exception ...
I'm seeking a skillful writer to create a persuasive sponsorship letter, intended for individual investors with the purpose of financial support. Ideally, you'll have experience in finance and know how to present a new business in an attractive light. Key components of the letter will include: - A clear articulation of my business's vision - A compelling case for why financial support will help realize this vision. Your draft will incorporate both these aspects seamlessly to result in a deeply engaging and convincing appeal. Prior experience in writing business pitches, especially those targeted at individual investors, will come in particularly handy.
...OpenAI's API. My main requirement is to enable this chatbot to successfully read and interpret data extracted from Excel tables which represents regular trips that leave a specific day of the week and have different prices based on the departure date. The objective is for the chatbot to respond to user queries based on: - Names and their associated values within the Excel tables - Date and time records - ChatGPT to successfully understand and return correct data for a query like this: "I have a couple that wants to go on a trip in august, what trips do you have?" --> this returns a list / table of trips with their prices for that month. What I will need is the following: - The exact ...
I want to sell a mini refrigerator and two warming ovens which are each similar in size to a mini refrigerator. I need you to… - receive the items from a delivery guy with a truck, and then - clean the appliances with soap and water, and then - take photographs and videos of them, using an ordinary mobile phone, to represent the appliances accurately and attractively, and then - store these appliances securely until I sell them, and then - give them to another delivery guy with a truck. The items are currently in storage in the Dallas area.
I need a software development company to build a custom application to be used on a Windows platform. This application is aimed at generating reports from tally using data analytics . It will be an tax audit software ( am an CA ). I will retail the software. I have already prepared working model in power query. Ideal skills for this job include: - Advanced knowledge in software development - Familiarity with tally tdl - I want excel pivot table like UI - Expert in web scrapping and ETL function - knowledge of sql server ( I will provide raw data in sql ) - Good understanding of data management - Ability to convert this into single exe file - give me control panel . as I want to sell it furhur - on few areas AI may be used - int...
...looking for a skilled MERN stack developer to create a web application that converts an existing Excel workbook into a functional online tool. This job will involve building data entry capabilities based on two forms with 18 separate fields each. These fields will then run a query from a static table of security controls, with the results outputted into a downloadable Excel workbook. The ideal candidate should have: - Strong experience with MERN stack (MongoDB, , React, and Node.js) - Proven experience in transferring excel functionalities into web applications - Proficiency in implementing server-side security measures, specifically in: - User Authentication - Data Encryption - Audit Logging If you possess these skills...
I am in need of a well-crafted recommendation letter for a scholarship application. The letter is intended for my supervisor with whom I've worked for a span of 1-3 years. Ideal candidates should have: - Extensive experience in writing recommendation letters, particularly for scholarships - Exceptional written communication skills - Ability to convey my credibility and capability convincingly - Proven track record in producing successful scholarship letters is a huge plus. The letter should showcase my strengths, contributions and commitment over the last couple of years, and why I am a strong contender for receiving this scholarship. It should be professionally crafted and compelling enough to help swing the d...
I would like a simple logo that is to be used for a birthday event. It is a three letter initial plus a number combined in a way that looks original and reflects the person in question.
More details: What programming language should be used for building the Quantum Neural Network? Python What information should successful freelancers include in their application? Detailed project proposals What level of experience in Qiskit is required for this project? Intermediate
Hi, I need a script that can, from a multi-config assembly with a few multibody parts themself with many configurations, 1, identify identical bodies within the assembly's all configurations. 2, give each unique body its own part number and description based on the main multibody parts name. 3, save a linked part, unfold it if needed (non-sheet metal feature bend) and make a DXF file for laser cutting. Problem: Changing body does not change cut-list custom properties so you have to find a away around it. As many bodies are the same but a hole might have been moves slightly, the only way i can think of is to generate body names based on its center of mass point, if that is even possible. Lets talk and see what is possib...
I'm looking for a seasoned SQL developer with an extensive background and demonstrated expertise in MySQL. My project involves pinpoint optimization of specific tables in my database system. Ideal candidates should: - Have a mastery of query optimization techniques in MySQL - Have a keen eye for identifying inefficiencies within tables - Be able to implement successful solutions to enhance performance Individuals with extensive experience in analyzing and improving the performance of specific MySQL tables will be more suited for this task. This is not a general optimization assignment; hence, a careful, detail-oriented approach is paramount.
Hi, I want someone to write a quick SQL query to extract from our dataset
I'm cu...experiencing some difficulties with my React Native Expo SQLite, namely it is not importing the tables from the precreated file and its not creating/updating another table entries with the information it needs to. , thus I'm open to suggestions, strategies, or proven methods. Additionally, both the insert and update functions require optimization. IDEAL CANDIDATE: Would be a seasoned React Native developer with an in-depth understanding of Expo SQLite. A background in database structuring could prove instrumental with the current project challenges. Understanding of complex query execution is a must. KEY TASKS: - Diagnose and resolve current SQLite issues - Advise on SQLite schema implementation - Optimize the Insert and Upda...
...excited to share more about the unique political movement I'm leading, "Make Amsterdam Great Again." In our effort to create positive change in Amsterdam, we've taken a distinct approach to address the safety concerns faced by politicians on social media. To ensure the safety of our leader, we've decided to represent them through an avatar. This avatar serves as the public face of our movement, providing a layer of security amidst the increasing threats faced by politicians online. While the movement is, in fact, led by a human, the public will primarily interact with and recognize the avatar. Our focus is on engaging the community and addressing ten key points to improve and enhance Amsterdam. The...
i want a dating app...all details will be mentioned in messages
On visual code studio, give the codes of the following website.
...experienced developer to implement and optimize indexing. Your task will involve creating indexes for improved data lookup efficiency on various columns, beyond the primary key. This role demands a deep understanding of indexing strategies and their impact on database performance. I will share you our existing system as well. Skills Required: Strong proficiency in database design and optimization Experience with indexing and query performance enhancement Knowledge in handling large datasets and memory management Proficiency in Python or relevant programming languages used in our project Familiarity with version control systems, preferably GitHub Your contribution will be crucial in elevating our database's analytical capabilities and query performance....
I am in urgent need of an expert PostgreSQL consultant who can assist with functions centered around data storage, retrieval, query optimization, and possibly data migration as well. Please include the following details in your application: - Past work experience dealing with PostgreSQL projects - A detailed and customized proposal for my project I do have a finite deadline for this project. Therefore, applicants who can commit to punctual completion will be strongly considered. Your experience and demonstrated ability to perform within PostgreSQL is essential.
Hola!! Me gustaría crear un dashboard en power bI . Los datos deben salir de reportes de excel que se envía a un email todos los días . Me gustaría que los datos sean recogidos en power query ( aqui pido recomendacion si es mejor otra herramienta), después sean limpiados ( no se aqui si con dax )y unidos a través de python o power query si es necesario y traspasar los datos a power bi . La idea no es que tu hagas todo esto , sino que me tutorices y guies dándome clases . Necesito especializarme en todas estas herramientas ( Power Query , Power BI, SQL, data cleaning python) y terminar mi proyecto Pagaría por hora de clase que nos vinieran bien a ambos claro y ES IMPRESCINDIBLE ...
-- ONLY DEALING WITH ODOO DEVELOPER WITH JAVASCRIPT EXPERIENCE. NOT AGENCIES --- Hi! I do have a code with javascript who doesnt work. Could you help? i would like to create a simple button in odoo v16 inhered in crm_lead_form where, when i hit it, should put a black overlay and over the black overlay shows the name of the user in typewriting one letter a time. Then, after 20 seconds, close the overlay automatically
I'm urgently in need of a highly skilled chrome extension developer to create a unique browser tool. This extension should possess certain features: - It has to be able to capture audio in the background. - It should continue capturing audio even if the user closes the popup menu. - The extension must be compatible with Manifest v3. Upon successful capture, the recorded audio should firstly be saved locally on the user's device, and secondly, an automatic upload to a designated cloud storage should be executed. Ideal candidate would have proven experience in JavaScript or a background in creating chrome extensions. Familiarity with use of APIs to connect with cloud services would be a bonus, as the project ...
I want to enhance my icon logo and banner. The current text is volcano lava text. What I want is to replace the base of the first letter "i" with a volcano. The dot above the volcano representing the dot of the i should still be the universe. It can be a new image of the universe, though it should look like a universe in a circular dot shape image as it is now. The text needs to be just clearer and more crisp and sharp. The lava colors are good and this can be discretionary as if the colors font are changed; a new novel font is highly preferred. Logo icon: i, as is, but with the base of the i being a volcano image and the dot still being a universe Text / banner: "intellicated", as is bu...
Please use the website for official logo that we want to use on the back of the shirt, however we are not using the word "Trailers" just Criterion. On the front of the Shirt the word Criterion is to be split into 3 rows with 3 letters each row, covering roughly 70% of the front of the shirt. Stacked one on top of the other in Block Lettering, I need the letter renditions in Gray, Pink, Blue, Black, Red, White, Purple, Turquoise and Pink etc... : CRI TER ION Then on the back of the shirt near the shoulders of the shirt, the actual Criterion Logo should be used/pulled from their website, and used on the back of the shirt. Then, below the logo on the back of the shirt it should say: "Quality Comes Standard" in somewhat smaller lettering. ...
...Note: This position is hourly-based and not for a fixed fee. If you are looking for fixed fee projects, kindly refrain from applying. Our agency is seeking enthusiastic individuals to collaborate with as Junior Freelance Web Assistants. In this role, you will have the opportunity to contribute to exciting projects across various industries. As a Junior Freelance Web Assistant, you will primarily be responsible for tasks such as copying elements, resizing and renaming images, updating content, and making other adjustments as needed. Responsibilities: Copying elements from one place to another within WordPress websites Resizing and renaming images to fit specific requirements Updating website content as instructed Making minor adjustment...
...developer with a proven track record, who can assist me with audio stream capture from different websites, randomly chosen from a specified list. Key requirements for this project: - Chrome API proficiency: The successful freelancer should be adept in working with Chrome API, as the extension needs to work seamlessly with Chrome. - Past Experience: Evidence of past work and successful Chrome extension development projects. - Audio Capture: The ability to capture audio effectively from specified sites, even after the popup menu has been closed. - Specialization: The Chrome extensions should be designed for Manifest v3. - Preferred Audio Format: The extension should capture and download audio in WAV format. I encourage all applicants who possess these skills...
...following changes and addition to my website The website is complete about 80-90%. A lot of changes are minor and some require just changing the settings and can be done in few hours and the rest could take few days or maybe more, depending on your experience and expertise with such websites. 1. 5% >Capital letter to be removed from most of the pages >Arrow to go top of the page. Only Arrow. No box that hides a part of website. >Logo Could have link to Home Page. >Some more Boxes could go Blue on Hover like MAKE AN OFFER box on Car details page. >Loan Calculator Box to be renamed as Model Specification and I should be able to upload a PDF or JPEG there. The link to upload this document has ...
...in a bold and expressive way. For this, colors have to lean towards dark and moody hues which illustrates the depth of my artistry. The second logo is for my company; I envision a concept layered with meaning. The logo should subtly incorporate elements of clouds and flames to depict the duality and connection between heaven and hell. Arist name is " ShowMan" case sensitive Company Name is " Hell in Rhymes " with a literal subliminal meaning can be religious or not Hello all. Please look at the first two current top rated photos. I am looking for more detail. Similar to the two current rated photos "hell" with the letter H and E combined with each other and then in the middle the own "in" w...
We are seeking content creators! We are looking for individuals skilled in making social media buzz. We are planning to start offering tea ceremony experiences for foreign tourists visiting Japan. The location is in Yokohama, and the tea ceremony experience will be provided by my grandmother, who has 40 years of experience in tea ceremony. To promote this experience, we need someone to assist with marketing, and we are recruiting for this position. We are particularly interested in team members who excel in social media management and marketing in the tourism industry. We have video materials available, so we would like someone to edit videos and create content that appeals to foreigners visiting Japan. ■ Instagram ■ Facebook
I'm seeking a talented professional to transform a hand-drawn diagram of my pharmacy into a high-quality, easy-to-understand document. The focus of this project is to map out workflow tasks and enhance the staff’s understanding of their individual roles and responsibilities. Your task will include: - Incorporating a workflow route: On the current diagram, certain paths mark the flow of the job. It is important that these are clearly illustrated and easy-to-follow on the final document. - Highlighting employee responsibilities: Each workstation has different tasks. These functions need to be clearly outlined to improve understanding and efficiency. - Labelling each workstation: There are multiple workstati...
I need a specialist to develop a unique Android application for me. This app will have one key functionality - clicking on specific points on the mobile screen at intervals of every specific time interval. I should also have the liberty to choose the particular point on the screen where the app will click and also particular time period. Ideal candidate should: - Have solid experience in and Android development - Understand how to achieve seamless and constant clicks on set screen coordinates While it was skipped in the original questions, it'll also be helpful to discuss what happens after the click is performed. Please add this to your cover letter.
Hello, I am doing my thesis experiment on loading design and I need a website for that. Loading design animation needs to be placed on a booking website (flight/train/accommodation/ does not matter) in between the search query and displaying of search results. Website does not have to fully work, it just needs to look real and serve the purpose of experiment. Participants will be asked to conduct some basic task on the website - such as e.g., "book a flight ... ". The booking does not have to fully work, the main purpose is just to let people click through the website and display loading design. The website will be used only for the experiment. Therefore you could almost fully re-use some other project you ha...
...prominently, allowing visitors to explore vehicles and their specifications. Implement lead generation forms strategically throughout the site to capture new customer leads effectively. Develop a robust backend system for managing contracts and invoices for each customer. Target Audience: Businesses such as retailers, logistics companies, and other hire companies. Visual Preferences: Incorporate your existing logo and branding guidelines. Ensure mobile compatibility is a top priority for seamless user experience across devices. Key Features and Functionalities: Vehicle showcase: High-quality images, detailed descriptions, and filtering options. Lead generation forms: Strategically placed forms to capture leads. Customer account management: Al...
...are looking for a highly organized and proactive Executive Assistant to support our executive leadership team. This is an opportunity to join a dynamic and fast-growing organization in the [industry/niche] sector. Responsibilities: Manage executives' calendars and schedule appointments, meetings, and travel arrangements. Assist with email correspondence and prioritize incoming messages. Prepare and edit documents, presentations, and reports for executive review. Coordinate and facilitate communication between internal teams and external stakeholders. Conduct research and compile data to support decision-making processes. Handle confidential and sensitive information with discretion and professionalism. Provide administrative support as needed, i...
We are looking for a talented translator (German must be the first language) to accurately convey a 1500-word motivation letter into German. The document is a letter of intent to join an airline company as a pilot; it is therefore vital that the translation retains the strength of the original text while ensuring the language and tone fit the aviation industry's context. I already have the translated text from Google Translate and DeepL, I want to make sure it is properly done. Kindly check the attachment. My budget is max 15 USD
I'm in immediate need of a MySQL expert to assist me with a query. Skills: - Expertise in MySQL - Strong problem-solving skills Only for avaialble freelancers now.
I need a seasoned graphic designer with a knack for illustrative design work. This project consists of two main tasks: • Logo Design: I require a creatively designed, illustrative logo that would represent my brand's identity aptly, ringing true to its values and vision. • Website Design: Along with the logo, I need a visually appealing, easy-to-navigate web page that also incorporates illustrative elements. Although there is no finite deadline, I appreciate efficient work and timely updates regarding the progress made. Experience in creating illustrative logos and website designs is a must for this project. I would like to use the Motel sign for the main webpage. I was hoping to add the letter S to...
I’m looking for a logo that would be an idea based off the images posted We Ride At Dawn is for domestic abuse and sexual assault survivors.
roject Title: Develop a Natural Language Ordering System for a Restaurant Using Dialogflow Project Overview: We are urgently seeking a skilled freelance programmer proficient in Dialogflow and natural language processing (NLP) to develop a conversational ordering system for our restaurant. The project aims to create a seamless and intuitive experience for customers to place orders using natural language commands through various channels such as chatbots or voice assistants. Key Responsibilities: Collaborate with our team to understand the restaurant's menu, ordering process, and customer preferences. Utilize Dialogflow with a focus on NLP to design and develop conversational flows and intents tailored t...
...following changes and addition to my website The website is complete about 80-90%. A lot of changes are minor and some require just changing the settings and can be done in few hours and the rest could take few days or maybe more, depending on your experience and expertise with such websites. 1. 5% >Capital letter to be removed from most of the pages >Arrow to go top of the page. Only Arrow. No box that hides a part of website. >Logo Could have link to Home Page. >Some more Boxes could go Blue on Hover like MAKE AN OFFER box on Car details page. >Loan Calculator Box to be renamed as Model Specification and I should be able to upload a PDF or JPEG there. The link to upload this document has ...
Come do some interesting GIS programing. *** Please no AI responses. *** Please respond by telling me what is a 3-4. **Requirements:** - Proficiency in spatial SQL -> MUST for complex data query and retrieval. The ability to perform spatial analyses and geometric operations is crucial. - Expertise in creating engaging, interactive maps that can visualize spatial data and analyze spatial patterns on a global scale. This would involve dealing effectively with diverse data sets and potentially large volumes of data. - Strong background in PostgreSQL and PostGIS, with proven experience in writing advanced spatial queries. - Experience in web map development, with a portfolio of previous projects involving visual data exploration and user interaction. - ...
...Description: Are you a coding conjurer with a passion for fantasy sports and a knack for weaving digital wonders? If so, we've got the perfect cauldron for your creative concoctions! We're on the lookout for a Full-Stack Web3 Developer to sprinkle some magic on our fantasy sports platform, where users build dream teams on social-fi platforms. Your First Few Missions: Login Flow Enchantment: Wave your wand and revamp our login flow to make it smoother than a perfectly executed spell. Users should glide in and out like ghosts through walls. Polygon Portal Creation: Harness the power of Polygon to expand our platform's horizons into the realms of lightning-fast transactions and gas-less wonders. Let's make Ethe...
We need a new API that will efficiently request and retrieve customer data from our MySQL database. The API development should be done using PHP. API should contain 2 query parameters: data_serie device_serial It should return a value. Quite simple, as it could reuse some code.
...consultation against a prop firm that is wrongfully denying a payout of over 120k. The company is based in Australia, I would like to start by creating a letter that outlines the legal issues they will face if they continue to deny my payout. Key Issue: Payout is being denied by the company because of a rule that is listed in terms and conditions. Before completing registration with the company, their support employee who’s job is to provide clarification about rules and t&c wrongfully misinformed me about the rule which led to the termination of my account and denial of my payout. They are stating that because their employee gave the misleading information, they are not responsible and can proceed with the pay...
I have an issue on my WordPress website where with each page load, several queries are being sent to a page that does not exist. When you delete the nav menu, this issue goes away. However, when you create the menu again, the issue returns. I need help troubleshooting this, because we obviously need a nav menu - but the constant duplicate queries to a page that doesn't exist are hurting our performance.
