Vba azure sql database jobs
I'm in need of a web-based job card system that will allow the creation and editing of digital job cards. Both employees and managers will need access to the system, with an admin login section for authorization of completed job cards. We would like the system to link with Quickbooks Online seamlessly, either through Zapier or an SQL database connection. This will allow completed job cards to be sent to Quickbooks for automatic invoice creation. Managers can then authorize on Quickbooks before sending. Key Functionalities: - Creation and Editing of Job Cards: The system should enable the easy creation and editing of job cards through a user-friendly web form by both employees and managers. Employees can then select their name from a drop-down combo box if they have wo...
...insights and trends within the data. 3. Chart and Visualization Tools: Develop interactive and informative charts, graphs, and visualizations based on geofenced data. Utilize tools such as Tableau, Power BI, or similar platforms to convey insights effectively. 4. Cloud Platform Automation: Utilize cloud platform databases (e.g., AWS, Google Cloud Platform, Azure, etc.) to store and manage geofenced data efficiently. Automate database processes to streamline data handling and access. 5. Quality Assurance: Conduct thorough testing and validation of geofencing solutions, data integrations, and visualization tools to ensure accuracy and reliability throughout all stages of these processes. 6. Documentation and Reporting: Document processes, methodologies, and results effec...
I need a comprehensive angel investor list for North America in an Excel spreadsheet. The list should cover all the necessary details for each investor, including but not limited to: - Name and contact information - Investment preferences - Industry expertise - Geographic preferences - Industry preferences - Investment stage - Average Investment Amount - Membership model - Membership fees There are additional questions we would like answered. PLEASE READ THE ATTACHED DOCUMENT FOR ALL INFORMATION SOUGHT. The ideal freelancer should have experience in compiling such lists and should be able to deliver a well-structured and detailed Excel spreadsheet. The list should be easily navigable and professional, making it easier for me to reach out to potential investors. Given that I'm ta...
...runtime error in my ChatGPT Excel VBA script, specifically during data analysis. I need an experienced VBA developer to help me identify and resolve the issue. Key aspects of the project: - Debug a runtime error: The issue is occurring during the data analysis process. You'll need to identify the root cause of the error and implement a solution to ensure the script runs smoothly. Ideal skills and experience: - Proficient in Excel VBA: You should have a strong command of Excel VBA, particularly in handling data analysis tasks. - Debugging experience: Prior experience in identifying and resolving runtime errors in VBA is essential. - Familiarity with ChatGPT integration: While not mandatory, previous experience with integrating GPT models int...
I'm in urgent need of a Microsoft Azure expert who can assist with designing, deploying, and managing our Azure infrastructure. The tasks involved are crucial and require an experienced professional who can handle them with efficiency and accuracy. Key Responsibilities: - Designing Azure infrastructure: This involves creating a blueprint of the entire setup including virtual machines, storage accounts, virtual networks, and other resources. - Deploying Azure infrastructure: Once the design is finalized, the admin will be responsible for implementing the infrastructure based on the design. - Managing Azure infrastructure: After successful deployment, continuous management is required to ensure everything runs smoothly. The admin should be able to ...
ChatGPT is generating VBA to automate Excel data manipulation and other actions. As a VBA EXPERT, you will debug the code when it doesn’t do exactly what it was asked to. The project is being built module by module. There are about 6 modules.
...looking for an experienced MySQL database developer. The central point of the project is database management. • The main responsibility of the developer will be to create a database, and a form page in HTML • and link the form to the database Experience in the field of database and Mysql is necessary. , the form must be elegant and well displayed on laptop and tablet screens. the objective is when entering a reference in the form all the data in the row of the database table will be displayed in the form. if the reference number does not appear in the database the web page generates a message. The successful candidates will illustrate these skills throughout their portfolio in relation to previous projects. If you are self-...
...multi-lingual, multi-currency platform. • Integrate and manage third-party services and APIs, including news feeds, currency converters, and Chat GPT. • Design encrypted communication systems for secure email interactions between customers and third parties. • Automate database updates and manage structured databases for different user types. • Collaborate with frontend developers to ensure system consistency and reflect design changes. Requirements: • Profound knowledge of PHP and Laravel framework. • Strong experience with SQL database management, design, and optimization. • Ability to implement APIs and manage external data integrations. • Understanding of encryption and secure communication protocols. • Ability to wo...
...various tasks within Excel, reducing manual work and minimizing errors. - **Data Visualization**: The software should also have the capability to visualize the data from my local files. The visualizations should be in the form of static charts and graphs. Ideal Skills and Experience: - Advanced Excel Skills: You should have extensive experience with Excel, including creating complex formulas, using VBA for automation, and chart creation. - Data Visualization Expertise: A strong understanding of data visualization techniques and tools will be beneficial. - Software Development: Experience in developing bespoke software within Excel would be advantageous. Please note that while the visualizations need to be created using Excel, I'm open to suggestions for automating spreadsh...
...will share data to an SQL server. This needs to function within a SAAS environment with subscription per device. Main features include: - Admin and User Modules - Managed subscriptions per device - Real-time data alerts In the Admin Module, the following functionalities should be available: - User Management: Admin can manage and monitor users - Device Permissions: Admin can determine how much data a user can view - Monitor Device Data: Admin can view data from all devices - Payment Module: Ability to process transactions For the User Module, users should be able to: - View specific device data as permitted by the administrator - Receive alerts via data changes - Make payments for their subscriptions The ideal freelancer would have experience with IoT systems, SQL data...
I'm currently facing an issue on my website where frequent database connection errors are appearing. I'm seeking a knowledgeable and experienced professional who can address this problem diligently and efficiently. Key tasks will include: - Identifying the source of the database connection error. - Implementing a robust solution to eradicate these errors permanently. The ideal freelancer for the job is someone with: - Proficient understanding of database maintenance and troubleshooting. - Proven experience in debugging and fixing similar issues. - Ability to work independently and communicate progress effectively.
I have a database that I need to be cleaned up. The main task is to remove duplicate entries. Key Points: - Main Task: The primary goal of the data cleaning project is to remove duplicate entries in the database. - Handling Duplicates: The duplicates should be automatically deleted, not merged or manually reviewed. Ideal Skills & Experience: - Database Management: A strong background in database management is crucial for this task to ensure the data is processed correctly without compromising the database integrity. - Data Cleaning: Experience with data cleaning processes, especially in handling duplicate records, is important. - Automation: The ability to automate the deletion of the duplicates efficiently and accurately is essential. Please bid...
I need a software that checks me in real time an entire database of amazon ASINs in .csv format (3,000,000 asins) , and when the price of one of the asins falls below a price I choose it should notify me on telegram , all with the use of proxy .
I'm looking for an API developer who can help me with a project. The ideal candidate should be Responsibilities: Design and implement highly flexible, asynchronous, secured and scalable API Build and modify high-performance APIs and programs using C#, .NET Core based on architecture frameworks and guidelines Prepare API Collection and Documentation Co...GraphQL and gRPC is an added advantage Knowledge of Web Services and understanding of service-oriented architecture (SOA) Proficiency with common API development frameworks/tools, including .NET Core 6+, MS Visual Studio, XML, JSON, TFS, GitHub, Postman and IIS Experience in integration of external systems, third-party APIs, payment gateways and cloud services are added advantage Knowledge in MS SQL Server and DB First appro...
...due the data in the database) developer to create a set of scripts that will synchronize data between my AuctionWizard2000 database and my Opencart (cubecart, oscommerce) database. I have a python script done by previous contractor who dropped the project for the personal reason, so there is no issues with source and target db structures, mapping of the fields. etc. Need an to refresh and do an extra polish. My specific requirements are as follows: 1) Learn the structure of AW 2000 database (old Paradox format, but work fine via Windows ODBC) - download here setup exe file, install it, run trial, restore inventory database from the link I will provide and use this data for the export-import. Paradox DB files are in database folder. 2) Lear...
I can help you with azure widget development as per your requirement.
...collaboration. You will be primarily responsible for backend development and Database management, but also need to handle some Frontend Development tasks. Key Responsibilities: - Backend Development: You should have a strong understanding of Node.js, and be able to build efficient, scalable, and secure backend systems. - Database Management: Proficiency in database management is crucial. Experience with both SQL and NoSQL databases will be a plus. - Frontend Development: While the primary focus is on backend, you should also have some experience with frontend technologies to assist with the development when needed. Ideal Skills: - Proficient in Node.js - Strong background in Backend Development - Experience with Database Management - Basic understan...
...can consistently deliver weekly blog posts on technical subjects such as Microsoft Powerplatform use cases, Azure products, and software connectors. These are the specifics: - Length: Each blog post should be 800-1200 words long. This length is integral in ensuring comprehensive conversations on the chosen topics. - Audience: You will be crafting content for both technical and non-technical audiences. So, your writing must be versatile enough to clearly communicate complex technical concepts to non-technical readers while keeping it engaging and informative for those with a technical background. Ideal Freelancer: You should have a strong understanding of Microsoft Powerplatform, Azure products, and various software connectors. Previous experience in technical writing is...
I'm seeking an adept vb.net coder to design a desktop-based GST billing software that primarily integrates with SQL Server. While there aren't any specific features I've outlined, I'm hoping to work with someone who's knowledgeable about the typical functionalities of GST billing software. This expertise will be critical in shaping the software's development. Critical skills and experience required: - Strong proficiency in vb.net - Familiarity with SQL Server - Previous experience designing billing software - Understanding of GST's impact on invoice generation, tax calculation, and inventory management
My project requires an experienced Java SpringBoot developer with a strong understanding of Kafka for asynchronous communication. The ideal candidate should also have: - Proficiency in building and managing REST APIs, focusing on CRUD operations - Ability to integrate with external APIs and service data repository calls - Expertise in crafting and handling SQL queries, preparing for moderate traffic and frequent daily queries - Competence in setting up batch schedulers - Proficiency in sending email notifications This project offers an excellent opportunity to apply and enhance your Java SpringBoot and Kafka skills.
I'm looking for a proficient WordPress developer to create a comprehensive relational database for my event marketplace website. This database should not only manage the product inventory but also store a range of user information and details about outdoor activities. Primary Responsibilities: - Developing a robust database to efficiently manage outdoor event organizer product inventory by sector, action, activity, and geo-location. User Information Storage: - The database should be designed to store personal identification and geo-location details of the users, including but not limited to their name, address, and contact details. - It should also be capable of storing users' preferences, which includes their preferred outdoor activities, preferre...
I am in need of an expert who can create a Virtual Machine (VM) in Azure utilizing Ubuntu Preferred Skills: - Experience setting up VMs in Azure - Comfortability with varying versions of Ubuntu - Ability to work with minimal direction by making recommendations where details have not been specified.
I'm seeking a seasoned FileMaker Pro developer to help address a few challenges with my database. The issues I'm currently experiencing include: - The 'Copy' feature is not functioning as expected. It's failing to accurately copy and paste records along with their associated data. - The 'Time Clock' element is encountering problems with incorrect calculations or logging. - The 'Sort' feature has not been set up properly to ensure consistent and correct sorting of data. Your primary task will be to rectify these issues and ensure the database is working smoothly. Ideal candidates should have: - Proven experience in developing and troubleshooting FileMaker Pro databases. - A keen eye for detail and problem-solving ski...
I am in need of a Programmer who is experienced in Python, Machine Learning , SQL and have working knowledge of full stack development. We need someone who can help us training a LLM coding assistant. You would not be working on coding side of LLM, you would be working mainly on creating conversations for a programming problem to train LLM. Ideal Skills and Experience: - Proven expertise in Python programming and Django framework - Hands-on experience with Scikit-learn library for model training - Demonstrated knowledge and experience in Machine Learning and AI Model Training - Working knowledge of ReactJS & NodeJS If you think that you fulfill above criteria. I would be more than happy to talk to you.
...product teams to define and refine system architecture, ensuring seamless integration across AI and blockchain components. Requirements: Bachelor’s or Master’s degree in Computer Science, Artificial Intelligence, or a related field. Strong proficiency in machine learning, deep learning frameworks, and blockchain technologies. Extensive experience with server management and cloud platforms (AWS, Azure, Google Cloud). Proficient in containerization and orchestration tools (Docker, Kubernetes), and infrastructure as code (Terraform, Ansible). Excellent coding skills in Python, C++, Solidity, or other relevant programming languages. Demonstrated capability in managing full lifecycle software development and system deployment. Excellent analytical, problem-solving skills,...
I require a database model diagram based on a description I will provide. The diagram should serve as a basic overview, capturing key tables and relationships within a relational database. Key Requirements: - Relational Database: The diagram should be tailored for a relational database system. - Basic Overview: The scope of the diagram should be limited to key tables and relationships, providing a clear, high-level representation of the database. Skills and Experience: - Proficiency in database design and modeling - Experience with relational databases - Ability to translate abstract descriptions into structured database models Please note that I do not require documentation on the database model diagram. The focus here is on the...
I'm looking for a skilled freelancer who is proficient in setting up Azure Speech Services for my application. The primary objectives of this project are to configure Azure for speech-to-text transcription for real-time transcription of meetings and implement text highlighting functionality in the application. Key Requirements: Azure Speech-to-Text Configuration: Set up Azure Speech Services to ensure accurate and efficient transcription of audio recordings. The freelancer should have expertise in configuring Azure Speech Services for optimal performance and accuracy. Text Highlighting Implementation: Implement text highlighting functionality in our application. When users play recorded meetings, the corresponding words in the transcript should be ...
I'm looking to move my MS-Access database to Azure Cloud. It's currently less than 1GB in size. The process will involve a few key aspects: - **Database Migration**: The primary task is to lift-and-shift the existing database to the Azure platform without any data loss or corruption. - **Data Backup and Recovery**: One of the main security requirements is to ensure that data is backed up regularly and that a robust recovery plan is in place. It's worth noting that there aren't any specific Azure services that need to be integrated, nor any special security measures beyond the data backup and recovery. The ideal candidate for this job should have experience in Azure cloud services and database migration. They sh...
I'm seeking a highly skilled fullstack developer who is proficient in PHP, .NET, and especially SQL for diverse web application projects. Your primary role will be equal focus on both front-end and back-end development on multiple platforms, including WordPress and PHP. Mandated Features: * Database Integration - Structuring, optimizing, and ensuring smooth functioning of databases within applications. * API Integration - Implementing third-party APIs comprehensively. Ideal Skills and Experience: * Proficient in PHP, .NET, and SQL. * Strong experience with WordPress. * Proven full-stack capabilities. * Expertise in Database and API integration. * Good problem-solving abilities and attention to detail. We're expecting high quality work with minima...
I need a skilled Power BI developer to support me with key aspects of my project. Your tasks will include: - Data modeling and visualization - Creating insightful dashboards - Generating detailed reports You'll need to connect and work with data from Excel spreadsheets and SQL databases. So, competency and experience with these data sources is crucial for this project. I'm looking for an intermediate Power BI developer. You should have a solid understanding of Power BI functionalities and the ability to translate data into clear visual insights.
You can got through my freelancer.com profile. I am a fulltime fr...Distributed systems Machine Learning: Deployment Pipelines, Production management Data and Model Pipelines Neural Networks, Deep Learning, Algorithms Applied ML, Network Models Cybersecurity: IDS, SIEM tools, Network Security Linux, Cloud Computing, Cryptography Risk and Incident Management Database security Data Analytics: Tableau, Data Visualization Predictive Modeling, Kaggle EDA, Regression Analysis Project Management, Communication Additional Skills: Docker containerization Cloud platforms (AWS, Azure, GCP) Version control (Git, GitHub) CI/CD tools (GitHub Actions) The cover photo should be stylish and depict me . I am a generative ai specialist with a track record of execellence. looking forward t...
...will be essential to provide a comprehensive analysis. - Data Visualization & Reporting: Building a robust reporting system will be necessary for clear, concise insights. - Automation & Migration: Implement RPA to automate repetitive tasks and ensure a smooth transition from PowerBI to Tableau. Skills Required: - Proficiency in PowerBI, Tableau, MicroStrategy, Excel, RPA, Data Bricks, Postgres SQL, and Python. - Experience in automating business analytics workflows. - Strong understanding of data cleaning, integration, and visualization. - Proven track record in successful migrations between data visualization platforms. I'm looking for someone who can take ownership of this project and deliver it with high precision and efficiency. A proactive approach to proble...
I'm in search of a seasoned DevOps consultant with strong expertise in Kafka and Akka. The role centers around the design, implementation, and...implementation, and monitoring of our cloud-based infrastructure on AWS. Strong scala programming skills and experience with Scala frameworks such as Akka. Efficient in designing and developing REST API’s. Experience with SQL and NoSQL databases. Proficiency in software design patterns and principles. Experience with version control tools such as Git. Good understanding of Agile methodologies and a collaborative mindset. Excellent problem- solving and analytical skills. Experience in unit testing (eg. JUnit/ Mockito). Experience in cloud- based environments such as AWS or Azure. Experience with Kafka and Elasticsearch. ...
...Angular. Experience in interfacing with hardware devices and integrating them into web applications. Strong understanding of relational databases and experience with database management systems like MySQL or PostgreSQL. Knowledge of RESTful API design and development for seamless communication between front-end and back-end components. Excellent problem-solving skills and ability to work in a fast-paced, collaborative environment. Preferred Qualifications: Previous experience with invoice generating applications or financial management systems. Familiarity with cloud-based solutions and deployment platforms such as AWS or Azure. Understanding of agile development methodologies and version control systems like Git. Ability to provide valuable insights and suggestions for o...
...must have experience in developing RESTful APIs. You should be able to design and implement API endpoints that are efficient and scalable. - Integrating SQL Databases: In this specific project, we're focusing on SQL databases - MySQL and PostgreSQL. Your expertise in database integration should be strong. You should be able to design database schemas that align with the overall structure of the project and implement effective data retrieval and storage mechanisms. The ideal candidate for this position should have: - Proven experience working with Java Spring Boot - A solid understanding of RESTful API development - Extensive experience with SQL databases, particularly MySQL and PostgreSQL - Strong communication skills, as you'll be required...
I am seeking a skilled individual for data entry into an SQL Database. This project involves: - Converting digital non-structured data into SQL format - Inputting the converted information into an SQL Database accurately The ideal freelancer will: - Have SQL Database knowledge and expertise - Show proficiency in handling non-structured data - Demonstrate attention to detail and accuracy Experience in data entry, particularly into SQL Databases, would be greatly beneficial for this role. Your responsibilities will not only include converting and entering data but also ensuring its accuracy and consistency. I expect a high degree of meticulousness and precision from you.
...experience to help me build a software solution. The primary goal of this system is to manage a variety of business activities, such as managing schedules, tracking project progress, and more. Key Features: - **Database Management**: The software should primarily focus on data storage, retrieval, and basic data manipulation. Database Management Functionality: - **Data Reporting and Analytics**: Developing the capability to generate detailed reports and perform basic analytics on the stored data will be crucial. Ideal Skills: - Strong experience in Codeigniter - Proficiency in database management - Understanding of data reporting and analytics - Ability to create user-friendly interfaces This project will be a great fit for you if you're looking to work on...
I am creating a disruption tracking sheet for Disaster Recovery. I am in need of an Excel VBA expert who can create an efficient macro for me. Your task will be to create a macro that will primarily deal with: - Copying Affected systems from each incident, to the tracking page. - Sort tracking page maximum allowable disruption time - Need to add a manual entry for the time of the incident, and the maximum allowable outage time should have a countdown to how long until it is breached. - Macro should run automatically every 30s or so. If you have a good understanding and experience working on Excel VBA scripting, specifically in creating macros, this job is right for you. An in-depth knowledge of disaster recovery protocols and incident tracking will be a plus point. Please ...
I'm looking for a skilled Azure professional who can help us integrate our Flask APIs with Azure App Services. These APIs are the backbone of our application and provide proprietary functionality; they must be accessible and operate seamlessly from the Azure cloud environment. Key Requirements: - **Azure Expertise**: Proficiency in Azure App Services is paramount. You should be able to set up and configure the app services to work effectively with our Flask APIs. - **Flask API Understanding**: A solid knowledge of Flask APIs is essential for this project, as you'll be working to ensure that our proprietary functionality remains intact and optimized in the cloud. - **Integration Skills**: The ability to effectively integrate the Flask APIs with ...
I'm seeking a skilled web developer who can update a music store. I would like to add an auction page, contract management and generator feature. I have updates to user login and music management. Please have experience with audio players and being able to play music while playing an additional mp3 audio tag at a lower volume. Being familiar with ecommerce and using paypal, and stripe for payments. See the attachment for details. Ask all of your questions in the discussion board so everyone knows the question and answer. Please do not submit a fake bid amount and completion time as that will disqualify you. We can discuss everything in the clarification board. We will communicate in chat after I select you as the winner. Thanks!
...accomplish With our team always here to help Ability to communicate and solve exciting tasks will be essential. We all collaborate together closely, work at same time with real time communication very important Experience: 1. PHP and related such as CodeIgniter, Laravel, .. 2. JavaScript and other front end technologies 3. Mobile App Cross Platform is plus for upcoming challenge 4. PostgreSQL, My SQL, etc. Work Requirements: 1. One Dedicated Programmer working on project 2. Agreed upon start finish each day to work at same time as our team 3. In addition to this site time tracker, Live Screen Sharing when paid hourly In your response: 1. Confirm agreed to above work requirements 2. Resume, Skill Listing, Example work 3. What days and times can you work in your time zone ? 4....
...of a seasoned software engineer with specialization in Artificial Intelligence, Machine Learning, MS Copilot, Cloud Computing (Azure), MS Power Platform, SQL Server, iOS, Android, and comprehensive Microsoft technologies. Preference will be given to candidates in the USA time zone. Key Details: - Main Objective: The main goal of this project is to develop a new software application. - Platforms: The application will be developed for Web, iOS and Android. Ideal Skills & Experience: - Proficient in Artificial Intelligence and Machine Learning with a proven track record in similar projects. - Expertise in MS Copilot, Cloud Computing (Azure), MS Power Platform, SQL Server, iOS, Android, and Microsoft technologies. - Prior experience in developing cross-pla...
I'm looking for a professional with a deep understanding of SQL injection to help me identify vulnerabilities in a MySQL database. If you're experienced in this area, I'd be glad to work with you. Key Expectations: - Identify vulnerabilities: Your primary task will be to thoroughly test the database for potential vulnerabilities, considering various injection techniques. - No access: Since I don't have any access to this database, I'm looking for someone who can perform this task remotely. You'll be expected to provide a detailed report on the vulnerabilities identified, so I can address them with my database administrator. - Change database values: Additionally, I'd like you to demonstrate the ability to change...
Need a Plugin/App to Transfer Google Sheet Data to Database via Webhook URL Description: We are looking for a skilled developer to create a custom plugin or app that seamlessly transfers data from a Google Sheet to our database whenever changes occur. The plugin/app should be able to detect any modifications in the Google Sheet and trigger the transfer process automatically. The data transfer should be facilitated through a webhook URL provided by us. Requirements: 1. Develop a plugin/app compatible with Google Sheets that can monitor changes in real-time. 2. Implement functionality to extract data from the Google Sheet and send it to a specified database via a webhook URL. 3. Ensure the plugin/app is secure, efficient, and scalable. 4. Provide clear documentation and...
...View page during invoice creation in Laravel. 24. Implement company filter and action links for quotations based on type on the Invoice listing page in Laravel. 25. Disable automatic PDF creation when viewing data; display data in HTML view instead in Laravel. 26. Develop a calculator for estimating materials, ensuring compatibility with the old CRM and website in Laravel. 26a. Update the Enquiry database to save enquiries from the website Estimate Calculator form in Laravel. 27. Work on integrating a map to visualize data in Laravel. 28. Implement CRUD functionality for Email Templates in Laravel. 29. Allow selection of email templates within the current module and associate specific module items with them in Laravel. 30. Integrate SMTP for email sending in Laravel. 31. Enable e...
Google big query - for writing sql queries for the complex data
I'm seeking an expert in .NET framework for a project that involves setting up a multi-tenant database. My preference is to have a separate database for each tenant, with the databases themselves being simple and containing only a few tables. Key Responsibilities: - Develop a multi-tenant functionality in .NET entity framework - Implement a separate database for each tenant - Design a simple database with few tables Ideal Skills & Experience: - Extensive experience in .NET Framework - Proven expertise in multi-tenant database setup - Proficiency in designing simple databases
...of data structure, the scraped data should be organized and stored in a Google Sheets according to categories. This approach allows for a more coherent and systematic pattern for data analysis and representation. The ideal professional for this task should possess: - Proficiency in web scrapping - Expertise in Python or other relevant programming language - Experience with Google Sheets and database creation - High attention to detail - Demonstrable ability to classify and categorize data. The goal of this project is to track changes over time, based on the data scrapped. This requires a design that will facilitate easy updates and quick overview of changes. Hence, knowledge and experience in data visualization will be an added advantage. I've added a few screenshots of...
