Queries sql jobs

Hi, we require an SQL macro that we need to be able to delete EAN codes that have less than 8 numbers from the import. So EAN codes that have between 1 and 7 digits must be removed from the import. We use a software called StoreManager that uses SQL. The formulas entered in the software look like this IF([CSV_COL(16)]=0 OR[CSV_COL(16)]=‘’ OR[CSV_COL(16)]<0,‘’,[CSV_COL(16)]) Payment and/or Milestone after the problem has been solved.

...functionality. Key Responsibilities: - Enhancing the existing dashboard by adding new features and functionalities. - Ensuring that the dashboard has real-time data update and interactive capabilities. Data Sources: - The data sources for this project include databases (SQL, NoSQL) and local files (CSV, Excel). Ideal Candidate: - Proficient in Tableau with a proven track record of developing and enhancing dashboards. - Experience working with real-time data sources and interactive dashboard elements. - Understanding of SQL and/or NoSQL databases. - Familiarity with data visualization best practices. I am looking for a professional who is not only skilled in Tableau but also understands the importance of user experience in data visualization. Please provide some exam...

...you passionate about programming languages and eager to make your mark in the IT industry? Look no further! We’re hiring talented individuals to join our dynamic team. Position: Software Engineer Domain: Finacle (Banking) Location: Major cities in India and international locations Why Choose Us? Comprehensive end-to-end training in Unix/Linux, JSP, HTML, Core Java, Node JS, Node red, Oracle SQL, and PLSQL. Exciting projects in the banking domain Opportunities for growth and career advancement Terms and Conditions: Commitment: Minimum 3 years with us Training: First month (free accommodation), followed by competitive salary Performance-based increments from the second year onward Global travel opportunities Qualifications: - While we do not have any specific certificat...

I'm seeking assistance to implement Adsense for search on my informational website. Priority is to display ads that relevant to the visitors' search queries. Ideal Skills and Experience: - Proficiency with Adsense integration for search functionality - Strong understanding of search-related ads optimization - Experience with informational websites Job Deliverables: - Successful integration of Adsense for search - Displaying ads related to visitor search queries - Assurance of minimal disruption to User Experience through the integration process

I'm seeking a seasoned resume writer, with a knack for crafting resumes focused on the IT industry and a comprehensive understanding of executive-level priorities. - Your target audience will be, primarily, senior decision-makers in IT recruitment. - Also, the resume must highlight my skills as an Architect. Ideal Candidate: - Proficient in resume building for executives. ...Your target audience will be, primarily, senior decision-makers in IT recruitment. - Also, the resume must highlight my skills as an Architect. Ideal Candidate: - Proficient in resume building for executives. - Knowledge of the IT industry (java Full Stack development) and architect roles. - Excellent communicator with collaborative editing skills. - MongoD...

...analyst with expertise in SQL and R to conduct a thorough review and testing of a recently completed data analysis project. The successful candidate will be responsible for evaluating the accuracy and completeness of the work, ensuring all requirements are met, and identifying any potential issues or opportunities for improvement. Responsibilities: Review the SQL queries and R scripts used in the project for accuracy and efficiency. Test the data outputs to ensure they align with the project requirements. Verify that all analysis reports are complete and adhere to the specified guidelines. Provide a detailed report outlining any issues found, confirming requirement fulfillment, and suggesting any potential upgrades or improvements. Requirements: Proven expertise...

...with creating engaging and SEO-optimized content for the site. - **SEO Optimization:** You'll need to possess a strong understanding of SEO practices to ensure the website ranks well in search engine results. Marketing Channels: - **Social Media:** Your role will include managing the social media profiles of my E-commerce store. You'll be expected to create engaging content, respond to customer queries, and grow the social media following. - **Search Engine Advertising:** The ideal candidate should have experience in managing advertising campaigns on search engines, particularly Google Ads. Your aim will be to drive traffic to the website and increase sales. This role requires someone who can balance the technical aspects of website management with the creativity need...

I'm in need of an expert who can proficiently answer queries related to the cardiovascular system in medicine. The focal points of our inquiry could range from the heart's anatomy, blood vessels or even cardiac diseases, as our specific topics are not strictly defined. The perfect candidate for this task would possess: - Extensive knowledge in various areas of cardiovascular medicine. - An ability to provide detailed explanations on diagnostic and treatment aspects. - Clear and precise communication skills. By clearing these queries, their knowledge will efficiently translate into our understanding of cardiovascular medicine. We look forward to sharing a productive dialogue with the right professional.

...com/file/LJsytcax2WmStFrLOWBgM6/FitApp?type=design&node-id=3-65&mode=design How it works: - The entire user journey is gamification. - The user chooses a project that has x days (screen 1). Then you must mark the completed days (screen 2) in the app to earn coins. - The coins are on the top bar (Fixed) and starts with 0 coins. - The number of user coins and complete days must be saved in a local sql-lite database. Summary: - Create app with Expo 50 and TypeScript; - The data must be saved in a local database. This project is offline, but there must be online synchronization support with the offline-first approach. Save user coins, projects and days complete; - Number of days on screen 2 must be dynamic, according to what is selected by the user; - Create a service wh...

Seeking a developer with experience in C# and SQL for a predictive artificial intelligence project. Your role will involve developing a model to predict user behavior on a vending machine, utilizing data stored in SQL Server. Proficiency in artificial intelligence is required. Please don't send a bid to later try to increase it. Will be declined.

Stepping Back Through Data I have a table of orders, lets say. I'm trying to find all the "Completed" orders, and then step back through other "Cancelled" orders for the same Customer, that were created within 72 hours. The trick is, I want to keep stepping back until I don't find anymore orders (the 72 hour window will now be based on the last order found). Also, the logic should stop if it finds another "Completed" order for the same customer. I've included a test table and data, as well as an expected output. CREATE TABLE #Order ( OrderID int, CustomerID int, OrderDate datetime, OrderStatus varchar(25) ) INSERT INTO #Order VALUES (1, 1, '02/15/2024 07:00 AM', 'Cancelled') INSERT...

I need a talented SQL developer to create a stored procedure that will automate the process of marking certain items as 'picked up' in our Microsoft SQL Server database. This script should essentially replicate the functionality of our existing Windows application, performing the necessary changes in the database to reflect this status. Key Requirements: - Strong command of SQL and experience in Microsoft SQL Server is essential. - Familiarity with Windows application development is a plus, as this script should mirror the behavior of our existing front-end tool. - Previous experience in creating SQL stored procedures for automating database actions is highly preferred. - Attention to detail and the ability to trace SQL commands accurate...

Title: Charles Prox...understanding of networking concepts, HTTP, and HTTPS protocols. - Knowledge of web development technologies, such as HTML, CSS, and JavaScript. - Experience in mobile app development and testing would be a plus. 3. Communication and support: - Excellent communication skills to effectively understand and address my requirements. - Availability for ongoing support and timely response to queries or issues. - Patience and willingness to provide guidance and training as needed. 4. Problem-solving and analytical skills: - Ability to analyze network traffic and identify potential issues or vulnerabilities. - Proactive approach to troubleshooting and finding solutions to optimize performance. Conclusion: If you have a solid understanding of Cha...

I need a custom bot that can operate within ChatGPT, utilizing my custom PDF resources to provide accurate and relevant responses. Key Requirements: - The bot should be able to search all of my PDF documents simultaneously. This is crucial as the information I will be querying could be spread across a range of resources. - The queries the bot will be handling will be full-text. This means the bot should be able to understand and respond to complex, multi-sentence questions, and not just simple keyword-based ones. Ideal Skills and Experience: - Experience in developing chatbots and familiarity with ChatGPT. - Proficiency in creating and implementing systems for data retrieval from PDF documents. - A strong understanding of natural language processing and the ability to create syst...

...balancing both functionality and aesthetics The final product should be a clean, sleek, and easy-to-navigate website, reflecting the minimalistic style while providing exceptional user experience. My expectation is for a thorough, detailed-oriented professional who can capture my vision and translate it into a fully functional portfolio site. Things to be done Load an API data into on premise SQL server database Client will do some data calcution The new data will be available in the database and needs to be show in website with some base UI. Project involves show some other API data on the website as well Need not have a lot of experience in UI design but need experience showing data into a page. Website would look like this --- Odds data should

I am in need of a versatile individual who can expertly manage my social media accounts and provide basic video editing. Here's what I'm loo...provide basic video editing. Here's what I'm looking for: - Mastery in handling Facebook, Instagram, and Twitter. - Experience in creating engaging social media content. This includes posts that are visually compelling and text that provokes interaction. - Ability to schedule posts and efficiently manage content calendar. - Proactive in engaging with followers, reacting to comments, and answering queries. For the video editing part, you don't need to be Spielberg. I just need someone skilled in making clean cuts, good transitions, and basic color grading. If you're a social media maven who has a keen eye for ...

I am in need of a versatile individual who can expertly manage my social media accounts and provide basic video editing. Here's what I'm loo...provide basic video editing. Here's what I'm looking for: - Mastery in handling Facebook, Instagram, and Twitter. - Experience in creating engaging social media content. This includes posts that are visually compelling and text that provokes interaction. - Ability to schedule posts and efficiently manage content calendar. - Proactive in engaging with followers, reacting to comments, and answering queries. For the video editing part, you don't need to be Spielberg. I just need someone skilled in making clean cuts, good transitions, and basic color grading. If you're a social media maven who has a keen eye for ...

... - Implement stock alert mechanisms to notify users when inventory levels fall below a certain threshold. - Alerts can be sent via email, SMS, or displayed within the software dashboard. This software solution would require a database backend to store all relevant data and a user-friendly interface for easy interaction. You could develop it using Microsoft Access, incorporating forms, queries, reports, and VBA (Visual Basic for Applications) for automation and customization. Consider consulting with stakeholders and users throughout the development process to ensure the software meets their specific needs and requirements. Additionally, thorough testing and refinement will be crucial to ensure the software operates smoothly in real-world scenarios. Key Features and Requi...

...should scan the website and extract relevant data for processing. * Extracted data should be stored in a database for future reference. AI Model Integration: * The application should integrate with an AI model capable of answering questions based on the scanned website data. * Preferably, use a free or cost-effective AI API for this purpose. * The AI model should provide accurate responses to user queries based on the scanned website data. Chatbot Integration: * Develop a chatbot feature that can interact with users and provide responses using the AI model. * The chatbot should be modular and easily integratable into other websites as a microservice. * Integration should be seamless with popular website platforms like WordPress, Drupal, etc. User Interface: * Design an intuiti...

We are looking for someone to take a T-Shirt mockup from a supplier and make a Photoshop action the shirt transparent so it can be used in an online customiser with the background colour set. This should retain highlights and shadows, and work correctly to show the correct colour through when any colour is set as the background. You can see an example of how this should work in t...from a supplier and make a Photoshop action the shirt transparent so it can be used in an online customiser with the background colour set. This should retain highlights and shadows, and work correctly to show the correct colour through when any colour is set as the background. You can see an example of how this should work in the attached files (we have original and completed files). Any queries p...

I've run across an issue in my WordPress / WooCommerce site that I'm not sure how to fix. I keep getting the error: "WordPress database error Commands out of sync; you can't run this...". This error is not related to specific actions or queries on my site. It's clear I require someone skilled in problem-solving and debugging with: • Extensive WordPress and WooCommerce experience • Clear understanding of WP databases and commands • Proven ability to address and correct site errors Please, I need this problem solved urgently. Your expertise and prompt attention to this will be greatly appreciated.

...proficient in Websocket and SQL, who can help me with an automation project. Key requirements: - Profound knowledge in Python, including advanced topics and best practices. - Strong understanding of Websocket and SQL. - Experience in automation tasks would be highly beneficial. - Ability to adapt to different mentoring methods, such as video calls, live chat, or in-person sessions. Your tasks: - Mentor me through the automation project, providing guidance and support. - Help me understand and implement Python, Websocket, and SQL concepts effectively. - Adapt to my preferred session mode, whether it be video calls, live chat. Ideal skills and experience: - Proven expertise in Python, particularly in automation applications. - Experience working with Websocket and...

Looking for experienced computer programmers skilled in Python for a web development project. Skills and Experience Required: - Proficiency in Python programming language - Strong knowledge of web development concepts and frameworks - Experience in buil...project. Skills and Experience Required: - Proficiency in Python programming language - Strong knowledge of web development concepts and frameworks - Experience in building and maintaining web applications - Familiarity with front-end and back-end development - Ability to implement responsive design and ensure cross-browser compatibility - Good understanding of database management systems and SQL - Knowledge of version control systems and agile development methodologies Timeline: The project is expected to be completed within ...

I'm in need of an experienced developer who's well-versed in ASP.NET a...well-versed in ASP.NET and VB.NET. The project involves the event pages i need where user can login and acess the event throught calender with specific functionality.. i will share feature to slected one ... Ideal Skills and Experience: - Proficiency in ASP.NET & VB.NET is a must, with a proven track record of projects involving user authentication and database integration. - Strong understanding of SQL Server databases and how to effectively integrate them into a .NET environment. - Experience in implementing user authentication systems that cater to both roles and individual accounts. This project requires a developer who can deliver secure and efficient user authentication and database inte...

...specializes in data, coding, and career development bootcamps for students, working professionals, and career changers. We are looking for a skilled inbound sales specialist to help us grow our business. Key Responsibilities: - Identifying and contacting potential leads who are interested in switching or starting their career out as a data analyst, data scientist, or data engineer - Addressing any queries or concerns the prospects might have about our services. - Qualifying and converting leads into customers, ensuring they understand the value and benefit of our bootcamps. Ideal Skills and Experience: - Proven track record in inbound sales, especially in the education or bootcamp industry. - Excellent communication skills to effectively engage with a diverse audience. - Unders...

I require a skilled freelancer with experience in Amazon Web Services (AWS). We have a an ERP Developed on Laravel which is currently on a On-Premise Windows Server. We would like to move the application to AWS using a windows OS and SQL Server Database. Please guide as to which option would be better. The selected freelancer would have to set up a Windows operating system. Skills and Experience Required: - Proficiency in AWS, - Demonstrated experience deploying Please ensure to include examples of your previous AWS work in your bid. Your ability to efficiently handle tasks in the AWS environment is paramount for this project.

We've developed an MS Access database front end with a SQL Server back end. Now we need to install both of these with government agencies in South America whose IT people only speak Spanish. We provide written installation instructions in English. Our clients can only meet the contractor online for server installations during business hours in American time zones. This is periodic work, installing databases whenever clients request them. At present we have six clients in the queue. The applicant must guide and troubleshoot each installation online in fluent Spanish. The successful applicant will have a record of relevant database work. We're a university-based not-for-profit.

I'm looking fo...to build my website. I will provide the template. I will provide the design idea and you implement the design, so you will not have to worry about that, but I do need assistance implementing it into WordPress. Specifically, I expect: - Implementation of my provided design into the WordPress platform - Creation of an e-commerce feature for my online products - A custom contact forms for client queries I have a specific WordPress theme in mind, details of which I will share after hiring. Ideally, you have extensive experience in WordPress, particularly in building e-commerce sites, and in working with custom themes. Your expertise in my theme would be a huge plus. I'm also looking for someone who's communicative, as I value clear and consistent commu...

...(Australian Dollars). Responsibilities: - Data entry and file management: The ideal candidate will be responsible for inputting, updating, and maintaining data accurately and efficiently. - Email and calendar management: Handling and organizing emails and managing calendars, scheduling appointments and meetings. - Customer service and support: Providing excellent customer service, addressing queries and concerns. Software and Tools: - Microsoft Office Suite: Proficiency in Word, Excel, and PowerPoint is required. - Vettrak Student Management System: Experience with this software is beneficial but not mandatory. - Dropbox: Familiarity and experience with file management on Dropbox. - Facebook and Instagram. Ideal Skills and Experience: - Previous experience in administration, d...

MUST READ FIRST =============== MUST HAVE - Blazor experience of at least 3 years - Latest version of .NET & SQL Server - At least 1 hour of availability between 6:00PM and 11:00PM EST - Your price is the one that you REALLY want to have with 10% +- NOTE - APIs will be provided (you will not develop APIs) - No development will be done on My Computer. - DO NOT APPLY if your fees can exceed 10% or your bid PROJECT I have C# Blazor Web App that works using SQL Server Database & using APIs at the same time. For the functions that use the database, I want to replace them with the APIs 1- Make code debuggable. 2- Error message appear with no details, need to make the error message has Show More to display the details of the error. 3- Load Codes from APIs instead of...

I need an artist to create a unique invitation for my son's birthday. I want a nautical theme centered around cruise ships and sea life. The color base should majorly be blue. As for design style, I am open to any cool and eye-catching concepts. - Skills Required: Graphic Design, Photoshop, Illustrator - Experience: Designing exper...life. The color base should majorly be blue. As for design style, I am open to any cool and eye-catching concepts. - Skills Required: Graphic Design, Photoshop, Illustrator - Experience: Designing expertise - Personal Traits: Creative mind, attention to detail, cool and fun design approach Inside the image there will be some text (location address, hour, kid's name, etc.) I am open to any queries regarding the project. Looking forward to...

I...communication through contact forms and live chat support for instant customer interaction and feedback. Key Features: - Corporate Information Display: The website should effectively showcase our company's profile, services, and expertise in the technology domain. - Blog/News Section: Regularly updated blog or news section to keep visitors informed. - Contact Forms: Enable users to reach out easily with queries or collaborations. - Live Chat Support: Real-time assistance to enhance user experience and foster engagement. Skills and Experience: - Proficient in web development with a strong portfolio of corporate websites. - Previous experience in integrating blog or news sections on websites. - Skilled in implementing contact forms and live chat support for seamless user...

I'm in need of a professional who is skilled in both graphics and Power BI. Let's collaborate to convert raw data into clear, visual and interactive dashboards. Here are the specific needs for this project: Power BI Tasks - Effectively perform Data modeling, Data visualization and dashboard creation using Power BI - Work with various data sources that include Excel Spreadsheets, SQL databases, Online APIs, and Azure Graphics Tasks: -Even though I didn't specify any graphical needs, any creative approach or design skills you can bring to the project to enhance the visual aspect of the data would be appreciated. Ideal Candidate - Proficient in Power BI - Experienced in working with multiple data sources - Has a knack for graphic design - Detail-oriented and data-dri...

...months to 15 months Position open: 2 Data scientists Key Responsibilities: - Perform data analysis and visualisation on trading or stock market data - Use your data science skills to provide valuable insights - Ensure the accuracy and efficiency of your predictive modeling Ideal Skills and Experience: - Proven experience in trading or stock market data analysis - Proficiency in Python, R, and SQL - Strong analytical and problem-solving skills - Prior experience with predictive modeling and algorithm development - Ability to handle a variety of data sizes and formats, as the size of the data may vary If you have previous experience in the trading industry and can confidently handle data analysis and visualisation, this opportunity is perfect for you. Your work will play a vita...

...need of a skilled and experienced sales representative to drive chandelier sales, both in-store and online. Key Responsibilities: - Promote and sell high-end chandeliers, aiming to boost revenue and build a loyal customer base - Monitor and respond to online sales inquiries and ensure swift delivery of products - Provide exceptional customer service, ensuring each customer's needs are met and queries are answered promptly - Utilize strong online marketing skills to increase the visibility of our chandeliers online Key Skills Required: - Proven experience in luxury goods sales is a must. You should be able to demonstrate an understanding of high-value products and how to effectively sell them. - Strong online marketing skills are crucial - you will be responsible for incre...

I need assistance in pointing my Namecheap domain to my WordPress site and migrating it. I currently have a wedding planning website hosted on WordPress. I'm seeking a skilled professional who can help me with the following: - Domain Pointing: I need my domain with Namecheap to be configured to point to my WordPress site WITH SITEGROUND. This includes setting up the necessary DNS records, ...all the content, functionality, and design elements are correctly transferred. Ideal candidates for this project should have: - Proficiency in managing and configuring domains via Namecheap - Expertise in WordPress website management and migration - A track record of successful website migrations with minimal downtime - Strong communication skills to guide me through the process and address my ...

...few countries we need you to replicate for more different countries, each country will consists about 8 google sheet types and some types may have dozen or up to few hundreds google sheets. Then some of the data needs be transferred and stored to SQL and taken from SQL by API also. This is team work, you will be working with bunch of server guys and python guys. So you need to possess these abilities and criteria : 1. Able to make google sheets fast, make editor for the GS fast and send all of the Google sheets ownership to me. 2. Able to work on SQL and API. 3. Able to collaborate as a team. 4. Agile, fast delivery, and responsive 5. Integrity, Honesty, Independently initiative, responsible, straight forward, loyal, modest, discipline, emphatically fair, hard wor...

Please Sign Up or Login to see details.

...this project should have proven experience in time series forecasting, Python programming, and developing interactive dashboards. A solid grasp of data visualization principles would be a plus. The output should be in a form of a python file with 4 models above and related dynamic visualizations. The text preprocessing is required and can be done in any necessary technologies (HADOOP/SPARK,NOSQL/SQL databases) - screenshots of the bash code are required....

I need a proficient HTML developer to construc...files. No video file uploads are permitted. - Auto-Response: Configure the form to send an automated reply once a customer fills it out. This reaction should reassure the client that their message has successfully been received. - Database Utility: Arrange for all submitted information through the form to be securely stored in a database. This will streamline tracking and handling of client queries. Details of the DB structure will be provided. - Security Measures: Implement Captcha security to filter out any potential spam or automated entries. - Skills Required: Deep understanding of HTML, CSS, JavaScript, and server-side scripting languages. Familiarity with database management and maintaining website security protocols is al...

I'm searching for an expert in Visual Studio 2022, MS SQL, and VB.net, for the main objective of maintaining and updating an existing software application. Key tasks: - Primarily, the project will involve optimizing the application's performance. Skills and experience: - Experience with Visual Studio 2022, MS SQL, and VB.net is a must. - Proven expertise in software optimization. - Knowledge of system maintenance and updating.

I have a 500MB XML file that I need loaded into SQL across approximately 20 tables. I'm in need of a Python script to handle the transformation. The script will need to handle normalization of the data. Key requirements: - Develop a Python script to read the XML file and transform the data into a normalized structure across 20 tables. - You will need to create the SQL tables as part of the normalization process. - Experience with large data transformations and SQL is vital.

... - Connect: Link the home page with another page that opens through the navigation bar. Ensure the transition is seamless and the user experience is smooth. - Chatbot Integration: I have a chatbot that's been designed to work with the ChatGPT API. I need it to be integrated within the content of the website. The chatbot should be able to provide product/service information and answer customer queries. The integration should be user-friendly and should not interfere with the design and functionality of the website. Ideal Skills: - Proficient in React - Experience in connecting separate pages in a React website - Familiarity with chatbot integration and APIs - Ability to ensure a seamless user experience - Strong understanding of website design and functionality The successf...

I'm seeking a skilled .Net developer to assist in developing a comprehensive retail system that has features such as user authentication and authorization, inventory and product management. Requirements: - Proficiency in C#, .Net, Entity Framework and SQL Server - Ability to develop a retail project from scratch - Strong understanding of user authentication and authorization - Experience in inventory management and product cataloging It's crucial that the chosen freelancer has prior experience in building online retail systems and a strong understanding of the retail business model. The ideal candidate should be able to deliver a secure, efficient and scalable retail project. Any experience with Angular/react/Node would be plus

...purpose of the site is to be informational, I'm specifically aiming to include the following: - An 'About Us' section: A detailed section that paints a clear picture of our brand and the services we provide. - Services: This section should clearly outline what we offer to our clients with easy navigation. - FAQs: Including a comprehensive, easy to understand FAQs section that addresses potential queries as they might arise. Ideal skills and experience should include: - Proven web development for professional audiences - Expertise in designing intuitive site navigation - Exceptional writing skills to help sculpt our ‘About Us’ and ‘Services’ sections - Background in developing FAQ sections for optimal user experience. I'm seeking...

I am in need of a freelance MIS Executive with strong skills in data analysis and database management. Responsibilities: - Conducting detailed data analysis using the provided tools - Proficiently manage and maintain a database Ideal Candidate: - Proficient in Microsoft Excel and SQL Server - Experience in database management and data analysis - Strong analytical skills - Excellent attention to detail This project requires someone who can work independently, has a good eye for detail, and can deliver high-quality results. A background in MIS or similar field would be a big plus.

...completion) Whereby; candidates can create a profile upload their CV, images or link to images and videos recruiters can search CVs with a Boolean type search functionality & save searches. Candidates and recruiters can message each other. Admin can manage the back end. Suggested technical skill set but not a complete one… • Cloud-based server solution • Azure or Single server solution • MS SQL Database (NoSQL document database might be more appropriate?) • OAuth • Payment gateway • .net We suggest design led development process where we sign off the look and feel of the web pages… the back end is for the supplier to advise the best scalable solution for the application. Please send your credentials/ skill sets and cost struct...

...managing user profiles, cataloguing orders, generating recommendations, and facilitating payment systems. 1. Implement a QR code as the entry point for users to access WhatsApp chat. 2. Utilize WhatsApp APIs to initiate chat sessions. 3. Employ Language Model (LM) capable of Hindi, English, and Hinglish for conversational interactions. 4. Integrate LM with backend logic for CRUD operations on a DB (SQL/NoSQL). 5. Store restaurant data including name, menu, pricing, and location details. 6. Capture user profile data such as name, preferences, allergies, and delivery addresses. 7. Manage user records and orders in the backend. 8. Prompt new users to provide necessary details. 9. Facilitate dish selection based on user preferences. 10. Display sorted dish options in sets of four ...

...complete backend integration. Tasks: 1. App Interface Setup in Bubble: • Develop a user-friendly interface with distinct areas for chat and media display. • Implement responsive design suitable for mobile devices, ensuring media areas can expand for better viewing. 2. Integration of Custom GPT: • Use API calls to connect a pre-built GPT model to the Bubble interface. This model will handle basic queries and simulate responses. 3. Media Triggers: • Configure the GPT to recognize and respond with specific media when trigger keywords are detected. 4. Timeline: • This dummy version needs to be completed and delivered within 24 hours of project commencement. Stage 2: Fully Integrated System Objective: Develop a fully functional app integrated with MongoD...

Description: I am looking for an expert in SQL and R programming for a detailed data analysis project. This project involves extracting, analyzing, and reporting on data from a sophisticated relational database setup. The ideal candidate should have a solid background in data science, with specific skills in SQL and R. Responsibilities: Efficiently query and manage data using SQL from a SQLite3 database. Apply R programming techniques for advanced data cleaning, analysis, and visualization tasks. Ensure data integrity and optimize data processing workflows. Analyze results to derive actionable insights and compile detailed reports. Document all processes and code in a clear and comprehensive manner. Requirements: Profound knowledge of SQL with experience in ...