Sql 2005 stored procedures jobs
... Design and implement API integrations using CloudQuery. Be able to write DBT transformations. Extract and manipulate data from various data sources (SQL, NoSQL, APIs, etc.). Ensure the integrations are scalable, efficient, and maintain high performance. Collaborate with our team to understand requirements and provide technical solutions. Write clean, maintainable, and well-documented code. Troubleshoot and optimize existing integration solutions. Desired Skills and Qualifications: Strong NodeJs skills Ability to read Python & Go code Abiltiy to write DBT transformations Strong experience with CloudQuery and its features. Proficient in SQL and database management systems. Solid understanding of API integrations and web services (REST, GraphQL, etc.). Experience with ...
...will use this QR code to check in at the fair. - The app will display a map of the fair (which should be an image stored online) along with a list of exhibitors. - When a visitor visits an exhibitor's booth, they will use the app to scan the exhibitor's QR code for check-in. - The app will provide a list of stands that the visitor has checked in to. - Visitors can also vote for the most creative, innovative, and best-service stand. 2. **Exhibitors**: - Exhibitors must register in the app, and a **QR code** will be associated with their profile. - The app will display the fair map (an image stored online) with the location of their booth (the address will be stored in a database managed by the fair organizers). - Exhibitors can view a ...
I'm looking for a skilled .NET developer with experience in JSON, MS SQL, AJAX, and HTML to help me migrate my existing website to a new template. The specific features that need to be migrated are the design layout and content pages. To give some context, the primary objective of this migration project is to enhance the functionality of the website. An ideal candidate should be well-versed in enhancing user experience and updating design aesthetics. Your role will be pivotal in ensuring that the new template not only preserves the existing features but also improves the functionality. The key difference I'm aiming for in the new site is faster loading times. This means that you should be able to optimize the site's performance and ensure that the migration process ...
I need an expert in to develop three essential methods/functions in C#, detailed below. - `MoveWindowToFrontAndBack`: This function should be able to move a window to the front and back, without hiding and unhiding it. The window should retain its previous position, which must be stored in a variable. you can only use nsrunningapplication - `GetRunningApplicationWindow`: This function should retrieve the window of the nsrunning application. It's important to note that this method should only work for `nsrunningapplication` and not `sharedapplication`. - `MoveMouseOnWindow`: This function needs to move the mouse over the window passed as a parameter. Your deliverables for this project should include: - Working and tested C# source code. - Detailed instructions on how to im...
I'm seeking an experienced professional who can help me verify specific documents from the European Sleep Research Society in Germany. - The task involves collecting and validating particular documents from this organization. - You should have detailed knowledge of the procedures and requirements for document verification, ideally from the European Sleep Research Society or similar organizations. The purpose of these verifications will be disclosed to the successful applicant. Please share your past experiences in document verification, especially in a similar context. Looking forward to your proposals.
...treatment processes within the industry. 2. Quantitative Analysis: Conduct extensive analysis on the gathered data. Key metrics of interest are water consumption per ton of steel produced, water recycling rates, and energy consumption for water treatment. 3. Life Cycle Assessment (LCA): Delve into the steel manufacturing processes. Understand and document the usage and flow of water within these procedures. 4. Qualitative Analysis: After the metrics have been crunched, I want an interpretation and presentation of the data in an understandable and accessible format. 5. Case Studies: Find and present case studies that would help illustrate your findings and assertions. Ideal candidates should have prior experience in conducting comprehensive studies and have a good understandi...
We are working on a power converter board and looking for an expert in MCU stm32. We are using the stm32G474ret6 and having several issues that we are not being able to explain . The main issues are : startup state of MCU systick clock for hal_delay non functional Debugger resetting MCU in middle of operation code not stored in memory after powercycle . We are looking for somebody that is very used with stm32 MCU and know about electronic schematics and circuit for mcu integration on PCB .
I have an existing simple Android app written in Kotlin. I have a need to make some minor adjustments to it. It interacts with a Googl...a driver's "diary" from firebase and allows the driver to mark that he has arrived. The driver can capture some photographs of the delivery and then mark that he has finished. This data is then sent back to firebase. I need a few small enhancements: 1. mark a job as "completed" in a separate date/time field 2. allow the user to "scan" a document rather than taking a photo. This would then be stored as a PDF. a scanned document provides better clarity than a photograph. This would be mandatory and photos optional 3. ensure it operates correctly "offline" ie in areas without mobile coverage. Data then ne...
...rental system e) Online car rental system The final submission should include: 1) Report describing the project that includes: a. Introduction b. Web site design c. Web site development: the main files created: articles, categories, modules, and database. d. Screenshots of the website e. Conclusion f. References 2) One folder that holds all the subfolders of categories, articles, menus, modules, SQL 1 files, videos, banners, and images....
...and appealing, incorporating modern UI/UX principles to ensure user engagement and retention. Deliverables: Mobile application compatible with iOS and Android, incorporating all the functionalities listed above. Backend server and database setup for managing live classes, user data, and device integrations. Comprehensive documentation including setup guides, API documentation, and maintenance procedures. Source code and build instructions for future updates....
I require a skilled 3D animator to create an educational video focused on the surgical procedure of Fibroid Embolization. This project is crucial in educating medical practitioners and students about this specific operation. The ideal candidate for this job would possess: - Proficiency in 3D animation - A strong understanding of medical terminology and procedures - Specific experience with creating surgical animations - A keen eye for detail and realism. The aim is to create a high quality, instructive and visually engaging animation that accurately portrays the surgical procedure.
I am in immediate need of a Python expert who can extract data from external website and store in an MS SQL database. freelancer with extensive experience in data extraction from varied sources would be highly desirable. The skills and experience required for this job includes: - Extensive knowledge on Python-based data extraction methods - Proven experience with managing and manipulating MS SQL databases - Ability to adapt to multiple and potentially unexpected data sources - willing to work via anydesk for final installation of the project Given the urgent nature of this project, only those who can demonstrate a commitment to quick turnaround times need apply.
I'm in need of an experienced architectural designer to work on a residential project. A flair for modern design is essential. The project envisages a m...project. A flair for modern design is essential. The project envisages a multistory building, requiring a person with a proven track record in designing modern residential properties. Ideal skills: * Degree in Architecture or a related field * Experience with CAD software * Portfolio of previous modern, multistory residential designs * Knowledge of local safety regulations and construction procedures Primary Responsibilities: * Developing detailed designs based on my preferences for a modern, multistory residential building * Delivering final design within agreed timeframes * Ensuring adherence to architectural standards...
...Minimum of 10 years' practical experience in cybersecurity, preferably with recognized companies. Proficiency with various cybersecurity tools and programming languages. Expertise in identifying and mitigating risks, threats, and vulnerabilities. Technical Skills: Hands-on experience with Security Information and Event Management (SIEM) tools. Proficiency in Python, Linux, and SQL. Knowledge of CIA Triad, governance, risk analysis, compliance, and business continuity planning. Familiarity with Linux and Windows server configuration, Active Directory, network architecture, operations, and security. Experience in areas such as Wireshark, email security, wireless security, cryptography, port scanning, cloud security, and virtualization. ...
I require a proficient developer to build a robust face recognition system to enhance the security of my web pl...security of my web platform. This feature is expected to be implemented as a mandatory measure for all users, specifically on the login page. Ideal Skills and Experience: - Proficient in web development - Prior experience with integrating biometric systems, particularly face recognition technology - Strong understanding of data privacy and security protocols - Experience with user authentication procedures and systems. Tasks and Deliverables: - Develop a face recognition system for the website - Incorporate the system into the login page - Ensure this feature is mandatory for all users - Prioritize security and user data protection - Provide updates and maintenance as...
I require assistance to reschedule my existing appointment for a US tou...existing appointment for a US tourist visa as I need earlier suitable date. This task requires careful attention to detail to ensure no mistakes are made that could potentially delay the process. Key Task Includes: - Seeking an experienced individual proficient with visa procedures who understands the rescheduling process thoroughly. - I expect a smooth handling of the rescheduling with no errors or issues, as any delay could disrupt my travel plans. Ideal Skills/Experience: - Prior experience in handling visa appointment procedures, ideally for US tourist visas. - Understanding of the intricacies of appointment rescheduling. - Familiarity with handling confidential information, given the sensitive na...
I am seeking an experienced software developer with expertise in creating robust web application...analysis for better decision making Needed Functionality: - Inventory management system: The application should keep accurate track of the inventory levels and alert the users when restocking is needed. - Payment management: The application should be capable of processing payments, invoices, and balancing accounts. Ideal Skills: - Proficiency in back-end and front-end development - Knowledge in SQL for database structure - Understanding of payment gateways The successful freelancer should exhibit strong understanding of cloud infrastructures and advanced data security measures. Experience in creating similar systems would be a significant advantage. The simpler the application UI, t...
I'm currently experiencing problems with an existing Matlab project related to image processing. An issue has arisen with the code failing to read images as expected. The task will involve you looking inside the mechanics of the current program, identifying the source of the ima...toolbox. - Strong skills in Matlab debugging. - Experience in identifying and fixing the root causes of scripting errors. - An ability to work efficiently and quickly. Additionally, it would be beneficial if you have: - Prior experience troubleshooting 'Image Reading' issues in Matlab. - An understanding of the image processing workflow. This job requires a fine understanding of image processing procedures in Matlab and excellent debugging skills to tackle the underlying issue. I look for...
We are a Singapore company, and we are looking for someone who can assist in setting up a company in China. Key Tasks: - Business Registration: The primary task is to guide and handle all the necessary steps involved...Business Registration: The primary task is to guide and handle all the necessary steps involved in registering our company in China. This includes completing all the legal paperwork and ensuring compliance with local regulations. Ideal Skills and Experience: - Proven experience in setting up companies in China. - A good understanding of the necessary legal documentation and business registration procedures in China. - Good communication skills and the ability to guide us through the process in a clear and concise manner. The quotation you give us must include ALL...
I need an experienced developer with proficiency in both Vue.js and .NET, capable of delivering the pro...applications. - **Project Details** - The developer is expected to create an enterprise application with an interactive UI. - I place a significant emphasis on an engaging, usable and intuitive interface. - **Timeline** - The project needs to be completed ASAP. So, I'm looking for someone who can dedicate sufficient time immediately. -** Vue.js 2 and 3 experience ** with .Net Web API and sql server required on expert level Ideal candidates can demonstrate previous experience working on similar projects and have a strong understanding of UI/UX principles. this a NDA Project and no code will be share and is a remote work, NO PHP folks needed or bid on this proje...
I'm seeking a professional to design and develop an Android app that will serve as a voting system similar to those used in congress. The app will be integrated with a web-based database ...database to store voting information. Here's what I need: - App Platform: The app should be developed specifically for Android. - User Interaction: The app should allow for voting with user registration. This means users will have to create an account before they can vote. - Database Security: The database should be secured with two-factor authentication. This is important to ensure that votes are stored securely and can't be tampered with. I'm looking for someone with experience in Android app development, database integration, and cybersecurity. Please provide an estimate...
... but tailored to our specific needs, including custom graphics and a unique logo that represents our brand identity. KEY REQUIREMENTS Languages and Frameworks: - Frontend: Expertise in HTML5, CSS3, JavaScript, and experience with frameworks like React.js or AngularJS. - Backend: Proficiency in server-side languages such as PHP, Python, or Node.js, with database management using SQL or MongoDB. - CMS Experience: Capability to integrate and customize content management systems (CMS), preferably WordPress or Drupal. Design and Graphics: - Creation of a unique logo and custom graphics that reflect our brand and the services we offer. - Design a responsive and accessible website that adjusts smoothly to different screen sizes and devices. - Clear and intuitive navigation system
I'm urgently in need of a qualified developer to create a pipeline utilizing DBT and SQLLITE. T...appropriate error logging and handling mechanisms Ideal Skills and Experience: - Strong proficiency in DBT and SQLLITE - Experience with data pipelines, specifically involving text file processing - Familiarity with data transformation techniques - Quality assurance and bug fixing capabilities Deliverables: ● A DBT project containing models for company_analytics and skills_analytics tables. ● SQL scripts or DBT models to process JSON files and populate the analytics tables. ● Instructions for running the DBT command to process the data and execute data quality checks. ● Documentation on adapting the pipeline for continuous file deliveries and suggested additional data quality me...
I need a power BI expert with deep knowledge of DAX query to help me retrieve specific metrics about product inventory. Key Requirements: -Retrieve product ID, Quantity and Location -Gather specific production data includin...production number. Ideal skills: -Proficient in DAX query language -Comprehensive experience with Power Bi -Excellent attention to detail -Previous experience in inventory data management will be a plus. What to do: I need to get a query in DAX (Power Bi) that gives me the same result as what I show in the excel file ( table ( column in yellow)). The excel file was obtained from the attached SQL query () The two screenshots show the power bi tables. I need to get a new column in power bi that shows me the results like in the yellow column in Excel.
I am looking for a skilled developer to create a Windows-based application that can interact with a remote database. The application should primarily focus on retrieving and generating website sitemaps based on different criteria. The ideal candidate should have: - Proficiency in Windows application development - Strong experience in working with databases, particula...in working with databases, particularly remote databases - Knowledge in data retrieval and data update functionalities - Ability to understand and incorporate additional requirements as the project progresses Please note that the selected freelancer may need to provide examples of past work and project proposals. Note: Application should be able to connect different type of databases such as MS SQL Server, MySQL, O...
I am in need of expert help to scrape text data from specified websites. After the data has been collected, the next step is to clean the data, ensuring that it is in the appropriate format for use. The final output should be managed and stored in a Database Management System. The ideal freelancer for this project should have: - Proven experience in web scraping, specifically text data from websites - Advanced skills in data cleaning to ensure the data is usable and well-structured - Capabilities to manage and store the cleaned data into a Database Management System Please provide any relevant examples of previous work in web scraping and data cleaning and provide details about how you plan to carry out this project.
I have the SQL file and main images of my current Wordpress site, and am looking for a professional to migrate and set it up on the new hosting account. We have the hosting account set up and will share the files with a dropbox link. Key Requirements: - Migrate current Wordpress site to a new hosting account - Setup and configure Wordpress in the new hosting environment - Ensure all site functionalities are working post migration - Provide login credentials for the access to Wordpress Please note: - There are no custom changes or updates needed during the migration - The new hosting environment is fully compatible with Wordpress Ideal Skills: - Proficient in Wordpress migration and setup - Knowledgeable in SQL databases and file handling - Experience in configuring hostin...
...The form needs to be integrated with Contact Form 7 plugin - Should support multipage logic for better user experience - Collect and store user-provided data including: - Name and contact information - User input and preferences - Additional comments and feedback - Implement a method to save all incomplete form data. This data should be: - Sent to a designated email address - Stored in a specific page inside WordPress dashboard, already configured Furthermore, I require the setup of an export mechanism for this incomplete data, specifically in a CSV format. This CSV should: - Have separate columns for each field to ensure easy data processing - Include timestamps for each form submission for traceability and analysis. The ideal candidate should be proficient...
Please Sign Up or Login to see details.
I'm looking for a proficient and creative graphic designer to create a flyer to advertise our junk removal services. Key Requirements: * Should include our logo, product images and company information * Flyer to effectively communicate our junk removal services * Redirect audience attention toward our environmental-friendly procedures * Must be versatile for both print and web distribution * Captivating and professional design that presents trustworthy and reliable service The flyer will be distributed to the general public, hence it must be designed in a way that is engaging to diverse audience ages and backgrounds. Ideal skills: * Proficiency in graphic design software * Understanding of marketing strategies * Experience in creating product/service advertisement ...
As a business user, I need assistance with the configuration of SS...WebPortal using Report Server Configuration manager and I am able to run SSRS reports from the Web UI. The project requires the following: 1. Automatically Scheduling of SSRS reports with default parameters. 2. Exporting the outcome of SSRS reports in a given folder every time a scheduled report runs I am experiencing the following issue while scheduling: Error: The SQL Agent service is not running. This operation requires the SQL Agent Service. You will need to help get rid of this error and set up scheduling and exporting of reports as mentioned. You will be required to get on a video call and help me set up the above over the call since this is a secured environment. Also, this needs to be executed...
... we're seeking a talented freelancer who can design an effective Power BI Dashboard to integrate various data sources including Excel spreadsheets, CSV files, and SQL databases. The ideal freelancer would: - Have extensive experience with Power BI and DAX language integration. - Demonstrate an excellent grasp of designing dashboards that report on KPIs. - Be well-versed with creating DAX calculations in the Power BI environment. We require the dashboard to focus on specific metrics, therefore, a strong understanding of reporting on KPIs using DAX language is a must. Additional Skills: - Proficient in Microsoft Excel and SQL databases. - Understanding of data integration and reporting. - High attention to detail. We're excited to collaborate with a dedicate...
...We have three different algorithms for matching a resume with jobs on the website. They are coded in python. You have to create the APIs for webapplication. Then you create the Website which has 2 user types. Job Seeker and Employer. Login to use (home page) Job seeker will upload their resume details using a fixed form. Employer can post as many jobs using an upload job form. The data is stored in a table. On clicking the Find Jobs button (after uploading resume) or Find Profiles (for each job posting uploaded) the results page will show the ranked results (either job or resume depending on user). Home Page - Login SignUp buttons only...no design or banner or random stuff. Profile Page - Form Filling page with resume details. Resume Form Page Job Description Page Simple D...
I need a Power BI expert with deep knowledge of DAX query to help me retrieve specific metrics about product inventory. Key Requirements: - Retrieve Product ID, Quantity and Location. - Gather Specific Production Data including t...number. Ideal Skills: - Proficient in DAX query language - Comprehensive experience with Power BI - Excellent attention to detail - Previous experience in inventory data management will be a plus What to do: I need to get a query in DAX (Power BI) that gives me the same result as what I show in the excel file ( table (column in yellow)). The Excel file was obtained from the attached SQL query ( ) The two screenshots show the Power BI tables. I need to get a new column in Power BI that shows me the results like in the yellow column in Excel.
...for the Snipepay Payment Plugin: WooCommerce Integration: Develop a payment plugin to integrate Snipepay into WooCommerce, allowing users to choose Snipepay along with existing options like PayPal and GoUrl for payments. Deliverables: A fully functional WordPress plugin for hosting management. A Snipepay payment gateway plugin for WooCommerce. Skills Required: Proficient in PHP, JavaScript, and SQL. Experience with WordPress and WooCommerce plugin development. Strong understanding of RESTful API integration. Knowledge in payment gateway integration, specifically Snipepay, PayPal, and GoUrl. Excellent problem-solving skills and attention to detail. Project Timeline: Please provide an estimated timeline for completion with your bid. Budget: Your bid should include the total cos...
Hi Yasar W., I noticed you posted a following project ( https://www.freelancer.com/projects/sql/SQL-Expert-Needed-for-Data/details )
I require a freelancer with strong accounting knowledge, specifically in job costing, to help me transcribe the steps and procedures from a job costing video into clear, written instructions. You will need to watch and understand the content then transcribe it with meticulous care and attention to detail.
...from backup Activate 2. change the name of to 3. add the alias domain 4. Add the prt for and cname record for @ cloudfare , now i do manually 5. create the ssl for and have to do some sql sql command to change the Admin name , Instance name -- now i do manually 7. env file need to be updated 50% mile stone will be created at the time of awarding the project, All payment will be released as soon as satisfied with your work and fit to my requirements. If you are interested, please send me a message so that we can discuss... Thanks...
I'm looking for a developer who's proficient in C#, MS SQL Server, Dot Net, and XAMARIN to work on an already existing application. Need to improvise and add amend few things. Pls note we can pay maximum INR 4,000 for the work.
I am seeking an experienced Dynamics CRM 365 developer with Virtual Entity expirence. I have got few virtual entity tables link to Azure SQL database. One table has got 1:M relationship with another. In my form, I am trying to populate custom view in lookup field of this virtual entity lookup. I tried it in two different ways but it doesn't work. Method 1: I created fetchXML and link two tables, I get the result but issue is records don't filter in query. I tried this method with advance find as well, and again records don't filter according to criteria for virtual entity. in Advance find, if I try to select the columns from second table then I get error. Methos 2: I tried to create Fetch XML query and use addCustomView method. This method works if filter criter...
...from backup Activate 2. change the name of to 3. add the alias domain 4. Add the prt for and cname record for @ cloudfare , now i do manually 5. create the ssl for and have to do some sql sql command to change the Admin name , Instance name -- now i do manually 7. env file need to be updated 50% mile stone will be created at the time of awarding the project, All payment will be released as soon as satisfied with your work and fit to my requirements. If you are interested, please send me a message so that we can discuss... Thanks...
We have a laravel web API for a native mobile frontend. We need some fixes completed. Our code is stored on bitbucket currently. To demonstrate your ability to work with laravel, git and bitbucket, please push a boilerplate laravel app to bitbucket and post the link here. Here is an example boilerplate Responses that do not include a bitbucket link will be ignored.
We need Oracle resource who are expert in below skills and having 8+ years of exp. Mandatory Skills: *• Need candidates with extensive experience in data migration across CRP, SIT, UAT, and GoLive phases in Oracle Fusion ERP implementation, utilizing ETL tools. * Experience in SQL Server, T-SQL, and SSIS Job Responsibilities: Data Extraction: * Extract data from various source systems, including flat files, spreadsheets, legacy databases, and external APIs. * Develop and optimize SQL queries and scripts for efficient data retrieval. Data Transformation: * Perform data cleansing, validation, and transformation to ensure data quality. * Convert data from source formats to Oracle-compatible formats. * Apply business rules and data mapping for aligning source data ...
...need of a professional with expertise in SQL and database creation to help me with the following tasks: - Create tables: Your main tasks will be creating tables for the entities of Users, Products, and Orders. - Write queries: I need you to write SQL queries that will allow me to seamlessly interact with the database. Specifically, I'm looking for someone who can: - Design and implement a solid SQL database structure that encompasses the entities I've mentioned. - Create tables efficiently and logically. - Write clear and effective SQL queries that correspond to the database structure. - Ensure that the database is optimized, both in terms of performance and storage efficiency. Ideal skills and experience for this job include: - Proficiency in ...
...need of a professional with expertise in SQL and database creation to help me with the following tasks: - Create tables: Your main tasks will be creating tables for the entities of Users, Products, and Orders. - Write queries: I need you to write SQL queries that will allow me to seamlessly interact with the database. Specifically, I'm looking for someone who can: - Design and implement a solid SQL database structure that encompasses the entities I've mentioned. - Create tables efficiently and logically. - Write clear and effective SQL queries that correspond to the database structure. - Ensure that the database is optimized, both in terms of performance and storage efficiency. Ideal skills and experience for this job include: - Proficiency in ...
I'm looking to upgrade my current system, perhaps keeping the current Opencart (V1.52) system and working with it where possible... unless its deemed a rebuild is cost effective. The opencart system we use has been added and modified over time, hence it...Kashflow API no other 3rd parties form what we know 4. Any other 3rd party systems (including internally) that the website communicates with (sending data either way) and any data grabs. NO 5. Confirmation of payment gateways used. Realex (redirect to payment interface), PayPal 6. How the databases (products, customers, orders) are stored and if the data can be exported. Standard OC table structure… yes it can be exported as SQL data dump and all the products to stock link via the export f...
I'm seeking integration of a basic customer support chatbot that's fully integrated with Zendesk. The ideal freelancer for this project should have significant experience in chatbots and Zendesk integration. Here are my requirements: - The chatbot shoul...that's fully integrated with Zendesk. The ideal freelancer for this project should have significant experience in chatbots and Zendesk integration. Here are my requirements: - The chatbot should focus on handling tickets for complex issues. -the ticket system should generated the response using algorithm - The information from the users should only be used for the duration of the chat and not stored. A developer with expertise in AI, chatbot programming and thorough understanding of Zendesk API would bode well...
Need help with a simple task that involves writing simple SQL statements and completion of the relevant ER diagrams. This task is in the context of simple data analysis. To be completed within 2-3 days.
I have a running Python file, who parse data from xml and insert it into sql server. Currently it isnt working. need an expert in python, who can fix it and upgrade few things as well.
...documents I have from these institutions. Key Responsibilities: - Verify the authenticity of my identification documents, university certificates, and employment records from the respective institutions. - Provide a detailed report on the outcome of the verification process. Ideal Skills and Experience: - Prior experience in document verification services is highly desirable. - Knowledge of the procedures and systems of the institutions in Sasolburg and University of Pretoria. - Strong attention to detail and ability to accurately evaluate the authenticity of documents. - Excellent communication skills and ability to provide a clear, concise report on the verification process. Please note that due to the sensitivity of the information, I will only consider freelancers with a v...