SQL Jobs

I'm in need of an expert who can create a Power BI dashboard. Key Components: - The dashboard should integrate with Excel spreadsheets that contain our inventory data. - The primary goal of this dashboard will be to monitor and analyze instances of inventory loss. The ideal freelancer will be experienced with Power BI and data visualization, with a strong background in inventory management systems. You should have a proven track record in working with Excel spreadsheets and creating insightful monitoring dashboards. Your understanding of inventory management principles will be crucial in making this project a succes

I am looking to develop a comprehensive web application with features like 3D modeling, body scanning, measurement calculations, and integration with e-commerce platforms. The ideal freelancer will have experience in: - Al/machine learning. - 3D modeling - Photogrammetry - Tailoring web applications for a e-commerce. - Creating user-friendly, interactive interfaces - Implementing features that enhance customer experience and streamline shopping processes Please demonstrate your proficiency in these areas when bidding. Your task will be to translate my specific needs into a practical and attractive web application that boosts customer engagement and drives sales.

I urgently require a proficient SQL Server expert, particularly conversant with SQL Server 2012. My primary challenge is recovering deleted records. Ideal Skills: - Comprehensive understanding of SQL Server 2012 - Expertise in data recovery processes Experience Required: - Proven track record in database recovery - Past work with SQL Server 2012 Your immediate availability for this project is essential. Please, only serious and experienced candidates should bid.

I'm in need of a website developer with a flexible skillset, considering the purpose and type of the website and design preferences were not specified: - Since the type of the website wasn't chosen, it's likely that we may have to go through a few iterations before landing on the final product. You should have experience with developing a variety of website types including but not limited to E-commerce, blogs, and portfolio websites. - The purpose of the website is also open-ended, so freelancers with a background in creating websites that serve multiple purposes such as sharing information or content, selling products or services, and showcasing portfolios or projects would be ideal for this task. - In terms of design, you will be expected to bring your own creative idea...

I'm in need of a specialist in data analysis, specifically predictive analysis. The purpose of this project is to generate a sales forecast derived from publicly available data. The resulting prediction should aid in budget planning, identifying sales trends, and setting sales targets. IN NEED OF A DATA ANALYSIS PROJECT FOR PREDICTING SALES Ideal Skills and Experience: - Expertise in predictive analysis - Proficient in analyzing publicly available data - Indepth understanding of sales forecasting - Strong statistical and mathematical skills

I'm in search of a professional and dexterous home assistant and sitter who can competently handle a number of responsibilities. It’ll be 6 days a week. And 3-5 hours per day. Tasks and Responsibilities: - Able to follow instructions. - Computer literacy. - Manage home. Home Management: In addition to the above, the successful candidate will assist with household inventory management, maintaining comprehensive records and ensuring that everything is in its rightful place. Ideal Skills and Experience: - Demonstrated experience in home sitting and assistance. - Exceptional organizational and management skills. - An eye for detail, especially when dealing with inventories. - Good communication skills. - Ability to follow orders. This is a demanding j...

I'm looking for an experienced professional who can create a custom Microsoft Excel spreadsheet for me. This spreadsheet will be designed to generate GUIDs (Globally Unique Identifiers) in a random fashion. The GUIDs will be used for database record identification. Key Requirements: - Development of a custom Microsoft Excel spreadsheet. - Implementation of a random GUID generation mechanism. - Ensuring the functionality for database record identification. Ideal Skills & Experience: - Proficiency in Microsoft Excel, particularly in custom formula creation. - Strong understanding of GUIDs and their usage in database systems. - Previous experience in developing similar solutions. I'm looking for someone who can deliver a well-functioning and efficient solution, as the generat...

I'm a beginner in Oracle Service Bus (OSB) and would like a thorough virtual training session on the topic. I'm looking for a skilled instructor who can guide me through the following areas: - Basic Concepts and Architecture: I need to understand the foundational principles of Oracle Service Bus (OSB). This includes how it works, its key components, and its role in service-oriented architecture. - Service Development and Deployment: I'm interested in learning how to develop services on OSB and deploy them effectively. This includes hands-on exercises and practical examples to reinforce the learning. - Troubleshooting and Optimization: I want to be able to troubleshoot any potential issues that may arise when working with OSB. Additionally, I'd like to understand ...

**Job Description:** **Title:** Development and Implementation of an Outgoing Predictive Dialer System **Description:** We are seeking an experienced freelancer to develop and implement a robust outgoing predictive dialer system for our call center operations. The ideal candidate will have a strong background in telephony systems, database management, and CRM integration. The dialer should support dynamic caller ID, IP whitelisting, multiple campaigns, and a minimum of 10 representatives. **Responsibilities:** - Develop an outgoing predictive dialer system that integrates with our existing telephony infrastructure. - Implement dynamic caller ID functionality. - Ensure the system supports IP whitelisting for added security. - Configure the dialer to handle multiple campaigns simultaneou...

As I am looking for an experienced Android app developer, I have a vision for an educational app that helps learners to access educational content with ease. Detailed walk through will be provided on call as I have the front end concept simulation ready. However here are some... Key Project Features: - User login & Registration: We require a secure user login and registration setup that protects the user's data and ensures only registered users have access to our app. - Requires Map integration and working with object on a map (google maps/mapbox, etc). - Implementation of Modal screens. Ideally, the freelancer should have a robust experience in the development of Android apps. The freelancer should be well-versed in creating apps that offer user-friendly interfaces and sea...

Looking for help in modifying an existing python script and related sql database table The current script - (1) scrapes company financial data from website and populates database (2) scrapes news related to keywords from google news (3)sentiment classification of news items (4)pushes data to sql database The company names and keywords are currently hardcoded in the script Requirement- (1) Company names/urls/keywords (will be provided) to be put in master table in the database (2) The script to loop through and scrape the relevant data and put in database

I need a reliable professional to help me with monthly inventory updates from the dealers and the sales department. Key Tasks: - Quantity Update: Ensure all stock levels are accurately reflected in our records. - Product Description Update: Make sure all product descriptions are up-to-date and accurate. - Product Code, UOM (Kit/Vials), Rupee Value: Cross-check and update product codes, Unit of Measure (Kit/Vials) and Rupee Value accordingly. Format: I have a specific format that the inventory updates need to be in. You will need to use this template to ensure data consistency and compatibility with our existing systems. Frequency: This is a monthly task and I would need your support on an ongoing basis. Ideal Skills: - Proficiency in inventory management. - Attention to detail and acc...

I'm in need of a web-based job card system that will allow the creation and editing of digital job cards. There is also a requirement for quotes, parts / inventory, archived jobs, and customer management. 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 export completed jobs to CSV file for automated invoice generation in Quickbooks Online. We will also require the system to import the customer database from Quickbooks in CSV format. Key Functionalities: - Creation and Editing of Jobs - Ability to use system on-site / remotely through the use of iOS or Android web browsing. Some - Ability to select a simple job status from a drop-down combo box eg. In-progress, waiting for ...

exactly similar to this f-system

I'm seeking a skilled professional to help me understand the basics of the Zig programming language, specifically in relation to MySQL/MariaDB. I would like assistance in the following areas: - Learning how to incorporate MySQL/MariaDB within Zig projects

use Oracle PL SQL teach me how to install free Oracle DB on my local windows 11 acceptance: I can run your code on my computer ; all code work on my computer when I run it by myself You have 2 days *****you provide code to simulate input data -> transactions data *****you provide SQL code to calculate per day summary for each day for each product for each store for 3 years SIMULATION data for 3 years 100 products 20 stores 5 USA states randomly 30 to 170 transactions per day for given product for usual price randomly 200 to 600 transactions per day for given product for promotion random dates and prices promotion for 30 promotions per year , each promotion happen for 7 to 15 products, for example promotion at may 10, 2023 happen for product ids: 34, 65, 12, 78, 5, 23, 41. Wh...

We need to create a compatible web application for android / IOS with backend and database. The application you want to build is the typical social contact network (tinder, peanut, etc.) But very simplified: A user can perform the following actions: Register and create his profile, filling out a minimum data or at least some fields or options Search other registered users based on search criteria Add selected users to his favorite list Open a chat with registered users Set up his email or password. As a summary, there would be approximately 8 screens: Registration, Home, Profile, Search, Results, Chat, Favorites, Settings Contact to know the requirements and technical details deeply Do not hesitate to contact us with any questions or concerns.

We have a program on C# written on Visual Studio. We want to modify the current program, which read bar codes on a warehouse, for other sections of the company. On this project we will like it to get information from different Oracle tables. Job is to use the original code that we provide and make modifications to adapt to our new requirements.

Hi, I am looking for expert to connect SQL database togoogle looker studio so we can analise data and creat reports, it is a long term coopartion. Please provide implementation cost and hourly charge. Best.

I need expert help with SAP Business One, particularly in understanding and rectifying some persistent issues that are affecting my operations. These issues mainly revolve around: - System Crashes & Freeze-ups: The system often becomes unstable, causing disruptions. - Data Inconsistencies: I am also experiencing inconsistencies in the data. While there were no specifics about the type of data inconsistencies, understanding of common errors in SAP B1 would be a strong asset. Proficiency in troubleshooting, problem-solving and detailed knowledge of SAP B1 is crucial for this role. Your responsibilities will include diagnosing the issues, fixing bugs, and ensuring smooth operations. Experience with similar work would be highly appreciated.

I'm in need of a skilled developer with strong experience in NodeJS, React, and Next/NestJS. The project I have in mind is a custom web application that will require: - Search Functionality: The application will have a search feature that allows users to find specific content or items efficiently. This will require robust search algorithms and user-friendly interfaces. - Payment Gateway Integration: The application needs to support payment processing. You'll need to integrate a payment gateway to handle transactions securely and seamlessly. Your experience in SQL will also be valuable to ensure efficient data management and integration with the web application. Please provide examples of your past work that demonstrate your expertise in these areas. I'm looking for a rel...

I'm looking for a professional who help finish a custom Tableau dashboard. Key Requirements: - The dashboard will display custom data. - The dashboard should have data filters that allow users to interact with the data, specifically in the form of dropdown menus. - Charts should be easy to understand and navigate. Ideal Skills and Experience: - Proficiency in Tableau: The ideal candidate should have a strong background in creating Tableau dashboards with complex data sets and interactive elements. - Data Visualization: A good understanding of how to present data in a visually appealing way is crucial. The ability to communicate complex data effectively is a plus. - User Experience (UX) Design: A good understanding of how the end user will interact with the dashboard is key. The fre...

I'm in need of an intermediate level mentor to guide me on XML and XSD through Zoom. I want to explore these technologies further and their practical applications. Key points: - Intermediate level expertise: I'm looking for someone who can provide me with in-depth understanding and hands-on experience in XML and XSD. - Zoom sessions: You need to be comfortable with conducting mentoring sessions over Zoom. Please ensure good communication and screen sharing abilities. - Live Screen Sharing Feedback: I prefer feedback to be given in real-time during our sessions. This will allow for immediate clarification and implementation of suggestions. Ideal skills and experience: - Proficiency in XML and XSD. - Prior mentoring or teaching experience. - Excellent communication and presentat...

I need a skilled developer to integrate our custom in-house software with Oracle TimeCard. This is to allow for automated time entry. Key Requirements: - The integration should allow for automatic time entry from our custom in-house software to Oracle TimeCard. - The system should also enable the creation, updating, and deletion of timecard information in Oracle TimeCard. Ideal Skills: - Proficiency in Oracle TimeCard integration. - Experience with automated data transfer between systems. - Strong understanding of custom software integration.

I'm seeking a proficient Access Database designer to build an advanced and fully functional task management system. Key Features: - Data Entry Forms: These should be user-friendly and designed for efficiency. - Reporting and Analysis Tools: I need to be able to easily track productivity and analyze task-related metrics. - Data Validation Rules: The system needs to ensure the accuracy of inputted data with stringent validation rules. Structure: The database should consist of 5-10 interlinked tables for comprehensive task tracking and management. Ideal skills and experience for this job would include: - Extensive experience with Access database design, specifically around task management systems. - Strong ability to translate user needs into functional system features. - An understa...

I'm in need of an experienced SQL Server data warehouse designer to help with a project of integrating and consolidating data from different sources. Key requirements: - Expertise in SQL Server: You should be able to design, implement and optimize data warehouse solutions on SQL Server. Understanding data warehouse design principles is essential. - Data Integration: You'll need to work with some of our developers / power users to source data and establish automated integration; experience with integrating relational databases and APIs from web services is crucial. - Data Consolidation: You should be able to create a cohesive, consolidated dataset from these different sources applying appropriate design principles. - Medium-sized project: The data needing integration and consoli...

I'm searching for a professional who is proficient in SQL coding specifically for MySQL database design. PowerShell scripting or similar would also be beneficial. This is a basic level project taking existing Local government procedures and converting them into SQL based processes. An example of which would be creating a import procedure for traffic count data that is presented in a text format (example attached) Ideal Skills: - Experienced with MySQL Database Design - Well-versed in SQL coding - Ability to simplify complex instructions - PowerShell for anything not possible in SQL This project will demand creativity and intelligence to design procedures that simplify data entry processes. Please only bid if you can offer solutions according to the basic complexity level spec...

I am experiencing slow query processing and management issues with large tables in my MySQL database, primarily storing transaction data. I am seeking a DBA specialist to diagnose and resolve these bottlenecks and improve the overall performance of the system. Ideal Skills and Experience: - Proven experience in MySQL database administration and optimization - Knowledge of query execution plans and optimization techniques - Proficiency in managing databases with 10-50 tables - Experience in handling databases primarily housing transaction data Tasks include: - Investigating and diagnosing slow query performance - Optimizing handling of large tables - Implementing necessary changes to enhance overall database performance.

Data Specialist: The Data Specialist is responsible for providing information that is in databases, organizing and assembling the information so that teams can make decisions using data. Responsabilities: > Access database. > Create dashboards and analysis according to the demand of the business areas. > Update and automate dashboards that need frequent updating. > Provide suggestions of improvements in business areas. Requirements: > Mandarim is a must > SQL > Office Package > Database usage At Shein, we believe that diversity is the force that drives innovation. We are committed to creating an environment where all voices are heard, valued and respected. All our vacancies are inclusive for people with disabilities, women, black people, LGBTQIAPN+ commu...

I need a skilled professional who's an expert in Azure Data Factory (ADF) development, SQL, Power BI, and ADF monitoring. Key Tasks: - Creating data pipelines - Building data transformation workflows - Integrating with SQL databases Power BI Usage: - Visualizing data through interactive dashboards - Creating data reports and analytics - Real-time monitoring and alerts ADF Monitoring: - Tracking data pipeline performance - Monitoring data integration processes - Setting up alerts and notifications for job failures. Ideal Skills and Experience: - Expertise in Azure Data Factory (ADF) development - Proficiency in SQL, Power BI, and data visualization - Strong background in monitoring ADF performance - Experience setting up real-time alerts and notifications - Proven track record in ...

I'm in need of a skilled developer who is experienced with inventory management systems, report production, analytics, user access control, and Windows-based applications. This job involves maintenance of a warranty return tracking software, with specific attention to: - Inventory management: Ensuring that the software effectively tracks the inventory of returned products - Reporting & Analytics: Enhancing the software's capability to generate insightful reports about warranty returns. - User access control: Improving the control measures for different user permissions within the software. - Ticket creation, Data Import and Export: Aptitude in handling these features are considered a plus. The overriding purpose of this software is to track and manage warranty returns effec...

I'm in need of a professional who can help me create a portfolio website, with a focus on my data entry skills and experience. This website will serve as a key tool in my job applications, showcasing my abilities and attracting potential employers. Key components of this project include: - Design and development of a professional and visually appealing website. - Emphasis on data entry as a core skill set. - Content creation that highlights my experience in web development. Skills and experience required: - Proven experience in web development and design. - Understanding of effective portfolio design and content. - Familiarity with showcasing data entry. This is an exciting opportunity for a creative professional to make a real impact on my job prospects. Looking for a freelancer w...

I need an adept SQL developer proficient in crafting SQL queries for various tables within our database. The task entails generating four queries, each encompassing approximately 20 conditions that must be met. Utilizing ChatGPT, could you assist in devising these queries?

I'm in need of an experienced SQL Server data warehouse designer to help with a project of integrating and consolidating data from different sources. Key requirements: - Expertise in SQL Server: You should be able to design, implement and optimize data warehouse solutions on SQL Server. Understanding data warehouse design principles is essential. - Data Integration: You'll need to work with some of our developers / power users to source data and establish automated integration; experience with integrating relational databases and APIs from web services is crucial. - Data Consolidation: You should be able to create a cohesive, consolidated dataset from these different sources applying appropriate design principles. - Medium-sized project: The data needing integration and consoli...

This should be simple for an experienced dev. Need portfolio of flutter dev to apply. Existing code base in place. I am currently in search of a proficient Flutter developer to incorporate a series of changes, mainly focusing on my existing project's UI. Key tasks include: - Updating the color scheme: A primary focus would be to shift the interface to a darker theme. Besides, I am interested in integrating elements of a custom color scheme, which I will provide. - Rearranging the layout: The current layout needs some reorganization. It may involve adding/removing sections based on our requirements. The positioning of various elements within the interface also needs tweaking. This is not just about modification; the potential candidate needs to evaluate the backend code to ensur...

I have a high-complexity T-SQL stored procedure used for data analysis that I need translated into PySpark code. The procedure involves advanced SQL operations, temporary tables, and dynamic SQL. It currently handles over 10GB of data. - Skills Required: - Strong understanding and experience in PySpark and T-SQL languages - Proficiency in transforming high complexity SQL scripts to PySpark - Experience with large volume data processing - Job Scope: - Understand the functionality of the existing T-SQL stored procedure - Rewrite the procedure to return the same results using PySpark - Test the new script with the provided data set The successful freelancer will assure that the new PySpark script can handle a large volume of data and maintain the same output as the present T-S...

Our existing CGI script is encountering issues when importing the exam's section breakdown from a .dat file. Due to this, we are unable to import the breakdown of results per section of the exam into the SQL database. We are seeking a proficient developer who can: - Analyze our existing CGI script and identify the cause of the breakdown import issue. - Provide actionable advice and steps to troubleshoot and resolve the problem. - Ensure the script effectively imports the section breakdown from the .dat file as intended. The ideal candidate for this project should have: - Extensive experience in CGI scripting and SQL database management. - Proficiency in handling and troubleshooting data import/export issues. - Ability to work quickly and efficiently, as we need this prob...

I'm seeking a skilled data architect for providing consultation and recommendations on a Statement of Work (SOW) that involves data warehousing, ad hoc reporting, complex SQL formation, and more. The primary purpose of the project is to streamline and enhance our data storage capabilities. By integrating new data into our warehouse on a monthly basis, we aim to improve our decision-making and business performance through enhanced data access and analysis. Key responsibilities include: - Reviewing and providing recommendations on the SOW for data warehousing - Offering expertise on ad hoc reporting and complex SQL formation - Helping to streamline data storage and improve decision-making - Ensuring the architecture can support monthly data integrations Ideal candidates should have: ...

 We are seeking a highly skilled and experienced individual to fill the role of Database Architect/Lead Developer specializing in Netezza and Oracle databases. The ideal candidate will be responsible for designing, implementing, and maintaining database solutions that meet the needs of our organization. This role requires strong technical expertise in both Netezza and Oracle platforms, as well as leadership capabilities to guide a team of developers. Responsibilities  Design and implement efficient database solutions for our organization, leveraging Netezza and Oracle technologies.  Lead a team of developers in the implementation and maintenance of database systems.  Collaborate with other stakeholders to gather requirements and define database architecture to meet business needs.  O...

I am looking for an expert in SSRS to set up a solution to track our daily financial transactions. The primary goal for this solution is to provide us with a simple, user-friendly way to access and track these transactions on a daily basis. Key requirements include: - Set up and customize the SSRS solution to track daily financial transactions - Ensure the solution is optimized for daily use and can handle the volume of transactions - Implement a system that would automatically send the daily reports to a specified email address Ideal skills and experience: - Proven experience with SSRS and setting up similar solutions - Strong understanding of financial data and tracking requirements - Ability to create automated reporting and email functionality I am open to suggestions and recommend...

I have to transfer data and tables from oracle to postgres.

I'm searching for a developer who can build an automated document verification system to simplify the document management procedure in educational institutions. The system must include the following features: - Database Integration: Integrate with MySQL, our preferred database management system, to make document retrieval and management easier. - User Authentication: I want the system to authenticate users via Single Sign-On (SSO) using existing authentication platforms like Google and Facebook. This is to ensure a secure, seamless and user-friendly sign-in process. Proficiency in MySQL, SSO Integration, and system development is required. Prior experience in document management system creation will be preferable. The ideal candidate should understand the intricacies of data secur...

Looking for a Senior BDA with experience in. AZURE SQL SERVER. English mandatory. 1d per week helping to improve and maintain our main DBs.

I'm in search of a PHP Developer with a proven track record of developing comprehensive ERP Solutions for the construction industry. We will looking for a ready application something more or less similar to our requirement. A existing pre developed application. Wherein customization can be done. Key Modules Required: - Quotation - Purchase - Project Management - Materials Management - Stock/Inventory - Billing - Accounts - Reports - Project Management - Cost Estimation - Procurement Specific Features for Project Management: - Task Management: The system should allow for easy task assignment and monitoring. - Resource Allocation: It should have a robust system for allocating and tracking resources. Specific Requirements for Cost Estimation: - Integrated Cost Database: The system sh...

VeriCO2 is seeking an experienced developer to create a global scope 1, 2, and 3 emissions database as part of our automated quantification of scope 3 emissions project. The selected developer will be responsible for setting up the database, developing a user contribution system, and implementing security measures to ensure data integrity. Responsibilities: 1. Database Setup - Set up a database to store scope 1, 2, and 3 emissions data for global listed companies. 2. User Contribution System - Develop a system for users to contribute data via LinkedIn by signing up and providing their company's scope 1, 2, and/or 3 emissions. - Implement a security check to ensure the user's email domain matches the company name and send a verification email. - Allow users to download ...

I'm seeking a skilled C# developer to create a software solution aimed at processing data from a Winsock for a wifi connected Weight Scale and get the reading and put in a Microsoft SQL database.

I'm in need of a professional to optimize my PL/SQL code for better performance. The primary focus of this project is to enhance the overall efficiency of the code. Key Responsibilities: - Perform PL/SQL performance tuning to improve the execution speed of queries. - Implement bulk collect operations to enhance data retrieval efficiency. - Optimize the compilation of procedures for better code execution. I'm seeking someone with extensive experience in PL/SQL, particularly with performance tuning and bulk collect operations. Proficiency in procedure compilation optimization will be a bonus. Your expertise will play a crucial role in achieving the project's goals.

I'm in search of a PHP Developer with a proven track record of developing comprehensive ERP Solutions for the construction industry. Key Modules Required: - Project Management - Cost Estimation - Procurement Specific Features for Project Management: - Task Management: The system should allow for easy task assignment and monitoring. - Resource Allocation: It should have a robust system for allocating and tracking resources. Specific Requirements for Cost Estimation: - Integrated Cost Database: The system should have a vast and well-organized cost database. - Calculation Formulas: It should accommodate complex estimation formulas. - Reporting and Analytics: The ability to generate detailed reports and analytics is crucial. Ideal Candidate: - Should have a strong background in PHP ...

As someone who values efficient and cost-effective operations, I'm intent on leveraging the full potential of my Microsoft SQL Server database. The core of this project involves enhancing performance and decreasing cost. To enrich the function of my database, I'll need an expert who can: - Improve overall performance, guaranteeing smoother, faster operations - Implement strategies for cost reduction without compromising quality and performance The ideal freelancer will be someone with extensive experience in Microsoft SQL Server, superb knowledge in database performance enhancement, and proven strategies for cost-reduction. If you can deliver this, you'd be the perfect fit.

I'm looking for a professional who can support me in my Azure Data Factory project. My primary goal is to transform structured data and then load it into Azure SQL Database and visualize it in Power BI. Deal with incremental load, create table relation and contextual data. Skills and Experience: - Proficient in Azure Data Factory - Experience in working with structured data - Expertise in data transformation - Knowledge in loading data into Azure SQL Database - Ability to visualize data in Power BI