Data warehouse design sql 2005 jobs
...size, comprising less than 1,000 records. This data includes text, numeric, and categorical data types. Key areas to focus on include: - Identifying and rectifying missing values. - Removing duplicate entries. - Addressing inconsistent formatting. This task calls for a strong understanding of data handling, especially dealing with different data types. Proficiency in data analysis software and keen attention to detail are crucial for identifying and correcting these errors effectively. Your expertise should ideally include the use of Python, R, or SQL for robust data cleaning. Previous experience in undertaking similar data cleaning projects is a definite bonus. Please be prepared to walk me through your approach to tackling t...
For my project, I am seeking an expert in OpenAI and SQL capable of handling data analysis and providing insightful solutions. The main focus is on natural language processing, specifically text classification, to efficiently categorize customer support tickets. Ideal Skills: - Extensive knowledge in OpenAI and SQL - Prior experience in Machine Learning model development - Proficiency in Data Analysis - Experience in NLP, especially Text Classification This involves a high level of responsibility, so proven experience is indeed required. Your expertise to customize and optimize solutions to deliver efficient text classification will be of great impact. Please submit your resume for consideration or with explanation of what you have done in this area.
I am doing a bulk import from a CSV into a temporary table. I am validating the data already. I am at the point where I am doing the insert. I am getting the following error An error occurred while validating the uploaded CSV file. Error Executing Database Query. [macromedia][SQLServer JDBC Driver][SQLServer]INSERT failed because the following SET options have incorrect settings: 'ANSI_PADDING'. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or filtered indexes and/or query notifications and/or XML data type methods and/or spatial index operations. I need a SQL Server Expert to help me resolve this error and any other error that may come up with getting the import to work. You will not be given access...
Store URL: I need professional assistance with a few key tasks related to my Shopify store. More specifically, I want someone to: 1. Handle the process of migrating my store from the Dawn theme to the Warehouse theme, ensuring that all elements transition smoothly and that the final design looks clean and functional. 2. Configure my product feed on the new warehouse theme using SOAP APIs, as this will be essential for the stock sync app to function properly. Experience with SOAP APIs is key, specifically in relation to Shopify and its applications. 3. Address the misrepresentation policy violation issues I've been having on Google Merchant Center. I need someone who knows how to navigate these types of challenges and improve my store's compliance. The i...
I need a proficient freelancer who exhibits excellent expertise in SQL Server and SSIS. Key tasks include: - Writing intricate SQL database queries - Designing and implementing ETL processes Specific features for these tasks must include data validation and cleansing to ensure the highest quality and most reliable data possible. You'll be handling structured data such as SQL and spreadsheets. The ideal freelancer would have extensive experience in handling and manipulating structured data, with a strong foundation in error handling, logging, and performance optimization.
I am seeking a seasoned developer to create an efficient Postgres 16 database for classifying several data entries into 500+ distinct classes. This database will be instrumental in organizing a wide variety of information based on shared attributes. Key features: - Store a minimum of 50000+ data entries - Capability to classify entries into 500+ predetermined groups, based on shared attributes Necessary Skills: - Proficient in SQL and PostgreSQL - Experience in developing databases for SEO data classification - Exceptional attention to detail for error-free classification.
I am seeking an expert in MEAN stack who can serve as a trainer. This role is particularly geared towards participants with an advanced u...Key focus areas of the training include: - MongoDB: Deep coverage on document databases, high performance, high availability, and easy scalability. - Angular/React Instructional lessons on building web applications, single-page applications and rendering them on server side. - SQL: Introduction to SQL within MEAN stack context, querying document databases and utilizing SQL features for server-side development. The ideal applicant for this position should have extensive experience in MongoDB, Angular.js and SQL, with a distinct ability to convey complex principles in a digestible way. Prior experience in teaching or train...
I'm seeking a proficient coding expert to restore source codes and databases from my C# project. A Fiery C# expert with a proficient understanding of SQL Server databases is an ideal candidate for this task. • The key restoration areas require comprehensive knowledge and expertise in the following: - User Interfaces: Regeneration of the original user interface. - Data Processing Functions: Reestablish the components that handle data processing. - Security Elements: Restore the functioning of the security protocols. Due to the complexity of the task, proven experience in similar projects is a must. This project is perfect for those passionate about problem-solving and delivering efficient, effective solutions.
In this project, I am seeking a skilled professional to execute the task of API scraping using Python. The ideal freelancer needs to ...the task of API scraping using Python. The ideal freelancer needs to have: - Strong command of Python language for web scraping. - Abundant experience with API scraping. Once the API data is scraped, the freelancer should efficiently store this information in an SQL database. Thus, knowledge of SQL databases is crucial for this project. Here are the key tasks included in this project: - Implement Python-based API scraping. - Store the extracted data into an SQL database. Candidates who have proven experience in managing similar projects will be preferred. Ample knowledge of Python, API scraping and SQL databa...
I'm in need of a seasoned SQL professional to enhance and refine the current SQL database behind our startup app. I've got the tables ready but there are key areas we need improvement: -Optimization of table structures -Boosting data integrity -Improvements to query performance Our app is a cross-platform solution designed to provide food, pharmacy, store, and market delivery services. Therefore, proficient understanding and skills in creating and maintaining high-performing databases for such platforms are essential. I wish for this database to run on iOS, Android, and Web. It is crucial that the professional hired for this project can effectively test the improved database on my server across all these platforms. Leveraging your expert skills to create...
...expert to assist with fixing errors and bugs inside our Power BI reports/dashboards. The ideal candidate should have experience building PowerBi datasets using various data sources including SharePoint, Excel, and SQL Server. Additionally, the Power BI data engineer/analyst should be able to validate data integrity, map out any changes made for future reference, and optimize any inefficient processes. Specific Requirements: Fixing bugs and errors inside Power BI reports Updating SQL scripts, DAX language, and custom measures inside of Power BI to ensure optimal performance and accuracy of data displayed Designing and documenting data maps of the problems encountered, and the fixes implemented. Work must be done within the US Before be...
I'm looking for expertise to set up a workflow using Windows Power Automate in order to synchronize data. The key task involves the alignment of data across different databases. Key Requirements: - Profound knowledge in Windows Power Automate platform - Experience in manipulating and synchronizing data in databases - Quick learning capabilities, because the exact type of databases to be worked with is yet to be specified. However, proficiency in SQL Server, MongoDB, and PostgreSQL can be advantageous. Skills Demonstrated: - Windows Power Automate - Database management - Data synchronization - Quick Learning - SQL Server/MongoDB/PostgreSQL (optional) A fine understanding of data synchronization and a keen eye for detail will be necess...
I'm looking for an expert developer, with mastery in Visual Studio (preferably the 2022 edition) and C#, to build an application that stores data from an Excel file in a SQL database. The aim of this project is to use the stored data for reporting purposes. Here's what I need: 1. Technical Proficiency: - Strong expertise in C# - Proficient in Visual Studio 2022 - Working knowledge of SQL Server 2. Project Specifications: - Development of an app in Visual Studio (C#) that imports Excel file data - Shifting this imported data into a SQL Server database - The solution should be optimized for data reporting Make sure to provide your previous working experiences related to this project. Looking forward to a ...
Hello! We dropship on eBay, Amazon and Etsy and need a small warehouse in the US and labeling service. In fact we need a person who will receive the packages from marketplaces repack and put labels on it and ship to fulfillment center. Sincerely, Angelina
I WILL DELIVER THE SOURCE CODE IN WPF (Visual Studio 2019) OF THE SCREEN DESIGN. The project consists of programming a desktop screen in C# and WPF code from Visual Studio 2019 .NET 6 framework for Windows 10/11 and tables in SQL design fully compatible with SQL Server management studio v 18.7.1. The WPF screen need some minor changes of titles and position of text boxes. I am going to deliver instructions and general details in PowerPoint. Also, images of the SQL tables with their columns fields and descriptions will be sent in the PowerPoint. The deliverable must include the following: 1.- C# and WPF source code 2.- The SQL tables used in the program have to be generated automatically when running the executable for the first time. We need to t...
Hi I need proper python developer,SQL and ansible roles and github for my automation task
I am looking for an experienced SQL developer to create a robust database for the purpose of storing and retrieving my data. This will include incorporating information about users, transaction records, and product details. Key Tasks: - Set-up and configuration of a SQL database - Designing data models that precisely fit the data to be stored - Developing effective storage procedures and security protocols The ideal freelancer will have an extensive background in SQL database development and a deep understanding of data modeling and security. As the database will need to be updated frequently, the ability to design for high-tempo data changes is crucial. Your history of efficient, safe, and convenient data storage so...
I'm looking for a skilled freelancer to assist with the adjustments needed for prestashop 1.7 warehouse API module. The module needs to be adjusted following a recent shipping module upgrade.
I'm in need of an expert to design a Langchain chatbot with SQL. Though the primary function of this bot isn't clearly defined, I'm inclined towards having a focus on SQL database integration. Key Responsibilities: * Designing a robust Langchain chatbot. * Ensuring smooth SQL integration. Ideal Skills and Experience: * Demonstrable experience with chatbot development and SQL database integration * Meticulous attention to fixing issues with MSSQL.
...mobile applications for a cutting-edge CRM + ERP system with integrated telecommunication services. Key Responsibilities: Collaborate with cross-functional teams to understand project requirements and deliver high-quality solutions. Design and develop responsive web applications using .NET Core ASP and a modern JavaScript framework (React, Angular, or Vue.js). Build cross-platform mobile applications using .NET MAUI. Implement secure and scalable backend services, utilizing Microsoft SQL Server (or PostgreSQL) for structured data and MongoDB for flexible data. Develop RESTful APIs for seamless integration with third-party tools and services, particularly for telecommunication services. Ensure optimal performance, security, and reliability of the CRM + ERP sy...
...on the data from our Sage ERP 300 system. Key Project Requirements: - Intricate understanding of Data Visualization. The ability to present complex data in an easily understandable and systematic format is critical to this project. - Knowledge in creating Dashboards and Reports. Your task will be to establish meaningful and intuitive dashboards and reports within PowerBI, based on Sage ERP 300 data. - Mastery in Real-time Data Updates. It is essential to integrate a real-time update feature to keep the dashboards updated with the latest data from Sage ERP 300. - Proficiency in handling SQL Databases. Our foremost data source for this project will be SQL databases, an expertise is required to accurately extract and utilize ...
...best-in-class design patterns implementation as MVC, MVVM? We are a start-up software house that creates software for automatic point of sales and tailored software solutions for several different small companies that are running into digital transformation. Our mission is to enable smart and seamless integration of digital systems to improve the efficiencies of different commercial activities. Responsibilities: As a Full Stack Developer, you will: • Start from the ground up and build something great which will drive the digital transformation of our customers • Lead a fundamental transformation within the automatic point of sales industry and the tailored software development • Develop tailored software solutions for more than 500 customers aro...
Scope of work for the Project: ERP System for an Agricultural Company Objectives: • Connect all branches, departments, and projects under one umbrella. • Create a warehouse management system. • Create a sales management system. • Create a customer relationship management system. Outputs: • An integrated ERP system that connects all branches, departments, and projects under one umbrella. • An interactive and easy-to-use user interface. • Compatibility with mobile devices. • Accurate and up-to-date reports and analysis. Deliverables: • A ready-to-use ERP system. • A user manual. • User training
We are in need of a Freelancer to carry out a simple task. No previous experience required, training will be provided. The service consists of a cargo and documentation audit. The freelancer must visit a factory and/or warehouse to complete this task in person. The process consists of taking photos of the products, confirming quantities, verifying documents, and supervising loading. Documentation must be carefully filled in throughout the process. Fluency of the local language is required. You must have full availability all day on inspection date. The training session is 1 hour and will be scheduled a few days prior to the first task. Exact date will be confirmed before inspection. This is a recurring task based on performance.
I urgently require a logistics expert with strong proficiency in warehouse operations. Though my current inventory management system is not specified, I am aiming for substantial improvements in warehouse efficiency that will ultimately streamline the entire supply chain process. This position will entail developing, implementing, and overseeing innovative strategies to ensure seamless and efficient operations. Ideal Candidate Qualities: - Strong background in Supply Chain and Logistics - Extensive experience in warehouse operations - Proven record of implementing successful warehouse optimization strategies - Able to start immediately If you meet these requirements and can deliver quality results promptly, I encourage you to bid on this project. Your proposa...
Very Basic Code I'm looking for an PHP Debugger who can work with me on my Windows development environment. Your expertise will be crucial for improving and maintaining the current code. Key Requirements: • Deep understanding of PHP, JavaScript, and HTML/CSS and sql • Familiarity with Windows operating system. • Prior experience with phpmyadmin is desirable. To execute this project, you will need to dive deep into the code, hence prior experience with similar projects is highly preferred. Your ability to identify, isolate, and fix issues in the PHP code will be crucial in this role.
I'm currently undertaking a course that requires a deep dive into data visualization. To complete this, I am seeking a skilled professional who is proficient in Tableau, SQL, and Power BI. Your role will include but not limited to, the following: - Creating comprehensive reports and dashboards tailored to the needs of my course project. - Carrying out data analysis and visualization, interpreting the data for clarity and easy understanding. Ideally, you have extensive experience in Tableau, SQL, and Power BI with a deep understanding of data analysis but most importantly extraordinary data visualization skills. Knowledge of query optimization is an asset. Additionally, if you have experience in the academic setting, that...
...includes allocating resources such as MS SQL databases and ensuring server security. Website Maintenance: Regularly monitor the website for uptime, performance, and security. Take necessary actions in case of downtime or security threats. Software Updates: Apply software updates, security patches, and perform necessary migrations to keep the website up-to-date. Code Deployment: Work closely with our development team to upload and deploy updated code to the server. Performance Optimization: Identify and address performance bottlenecks to ensure the website runs smoothly. Subscription Management: Evaluate and recommend suitable subscription plans based on website requirements and traffic. Backup and Recovery: Implement regular backup strategies and ensure data and code...
...a member of a team working with a specialized Postgres SQL database, I need someone proficient in SQL to conduct a walkthrough on writing complex queries, over a Zoom call. During the walkthrough, we'll be focusing deeply on: - Syntax and formatting - Managing associations using Joins - Writing Subqueries and nested queries My main aim is to understand the structure and formatting of these queries, how to establish relationships across various database entities using joins, and understand the use and function of sub-queries and nested queries. The functionalities of tables and fields in the queries are also a crucial part of this project. Ideal qualifications would be: - Extensive experience with SQL - Ability to explain complex SQL concepts clearly ...
As a representative of Porshtal, I require a competent, experienced developer to construct an ERP system focused primarily on our Inventory and Warehouse department. The successful freelancer will possess excellent technical skills in creating an ERP system that includes: - Inventory tracking - Order management - Warehouse layout optimization Additionally, I desire an integration of other departments and functionalities into this system, specifically: - Sales and Customer Relationship Management (CRM) - Production and Manufacturing - Supply Chain Management A deep understanding of these areas is invaluable for this project, ultimately producing an ERP system that is both comprehensive and beneficial to Porshtal's operations.
I have an on-going project which has been built using ASP.NET MVC, AngularJS and MS SQL Server in Microsoft Visual Studio 2022 and Grunt. I want to add one functionality which consists of several pages on, namely, Behavior page with 3 sub tags. Same UI, Same logic, and nothing more! What you should do: - Desing tables for Behavior logic in MS SQL Sever. - Build UI parts using AngularJS (Must follow same principle in the project like naming and componenting while doing this.) - Implement server logic in C# and ASP.NET MVC. You can find the reference here. Also, check the attachment to get confirmed, as well. Please, only apply if you can finish the task using Visual Studio 2022 within 2 weeks. Thanks for your consideration.
hello, hi need a data scientist specialised in time serie , i ruinned a trading bot the last 11 month on 22 pair , i have a data base on excell of 36000 exemple. i can see that it's working well during a time and not , and it working again , so there is differente wave, i would like to work on it to evaluate the percentage that a trade to be successfull studing this different wave and few other parameter like risk reward and hour in the day. I am seeking a top-notch Data Scientist who can confidently apply techniques such as ARIMA, Exponential Smoothing, and various Machine Learning algorithms for a complex time series analysis project. REQUIRED SKILLS: - Proficiency in at least one of these programming languages would be advantageous: Python, R, or ...
I am in need of a...Administrator (DBA) who can focus primarily on SQL optimization for my project. While the specific tasks were left open, emphasis will be placed on effective SQL optimization to enhance our database operations. * Ideal Skills and Experience - Specialized in SQL optimization - Broad DBA experience - Familiarity with Database Design, Data Backup and Recovery, and Database Performance Tuning would be beneficial Please include your previous experience in your application, especially your experience in SQL optimization and other DBA-related tasks. A proven track record in these areas will significantly increase your chances of being selected. I am looking forward to working with an experienced DBA who can enhance our da...
I'm seeking a Synapse Expert that will help me to check to data quality of parquet file : number of rows, columns order, data type... It should be done without Spark or Databricks only using sql script in serverless.
We are building a data warehouse which will gather data from different endpoints holding the same database (40+ servers). This data warehouse will live on AWS The data will be sent from the servers to S3 and then processed by AWS Glue The data lives on a SQL server DB on all different servers (schema is the same) We already have the plan laid out, we just need a devops / solutions architect to take the lead Proeficcient on: Batch / Powershell scripting AWS Glue AWS S3 AWS RDS AWS VPC / networking
...develop a "control panel" where we will manage technical service for the devices. If we fit at the budget level in the first instance, we will have a meeting for more details. Please indicate budget, agenda availability and estimated time for its development. For a preselection of the Backtend Programmer we are taking into account the following requirements: Program in languages: Java JavaScript SQL Python C# PHP HTML/CSS Previous proven experience working on frameworks, backends and frontends (to ensure integration). Experience working in a team. Experience reading Flowcharts and working with specific objectives. Is required: Immediate availability to start Agenda availability for the coming weeks Offered: Meetings to clarify any point. Seriousness, real project...
<SQL> SELECT o.sales_order_number AS 'Order', AS Container, t.tag_id AS Tag, IFNULL(, 'ALL') AS Priority, Pickup_Location AS Origin, Delivery_Location AS Destination, DATE(Delivery_Time) AS Delivery_Date, Tender_Time, Pickup_Time, Depart_Time, Arrival_Time, Delivery_Time, Deliver_Driver AS Driver, m.Business_Unit, AS Party_Name FROM summary AS m LEFT JOIN tag AS t ON m.tag_row = LEFT JOIN priority AS p ON = LEFT JOIN shipment_packing AS k ON m.tag_id = LEFT JOIN shipment AS s ON = LEFT JOIN table_order AS o ON s.buy_order = LEFT JOIN business_unit ON CAST(m.business_unit AS SIGNED) = LEFT JOIN party ON = WHERE Deliver_Driver IS NOT NULL and Delivery_Time
...generation: First, gain insights and a feeling for our niche B2B target groups, such as logistics planners of large ecomm or industrial shippers. Next, do re-search and surprise us with your ideas for how to convey the USPs of a general contractor for warehouse automation online. Growth hacking and automization: Nurture new and existing lead pipelines along the customer journey. This also includes media bookings such as advertorials or newsletter slots Automize and leverage reports and analytics to continually improve performance of lead gen campaigns Design, produce and maintain digital assets (e.g. landing pages, follow-up mails, presentations, LinkedIn ads, etc.) for the entire HÖRMANN Intralogistics Unit as well as the individual locations Your profile for ...
We have a parking management system, where sometimes we see 30 vehicle in month get access to no card login, which should not be the case, We need an expert who can access it on share screen and fix it asap. Changes required only in SQL server stored procedures only.
We are looking for a skilled full-stack developer with experience in C# and .NET Core developer to join our team for a stack development project. The ideal candidate should have a strong understanding of both front-end and back-end development, as well as proficiency in C#, .NET Core, SQL Server and Azure Cloud. Skills Required: .NET, C# Programming, Full Stack Development, Azure, SQL Server
We have one job currently available. Modern Warehouse Design: Aerial View Artist Impression, Elevations, bulk and location details.
...customization of a PHP script, specializing in data reporting, analytics and Bulk Inventory upload Script bought from Codecanyon Ideal Skills: - Proficient with PHP and SQL databases - Prior experience with analytics-related scripts - Understanding of data privacy and security measures - Ability to optimize for performance and scalability Experience Requirements: - Portfolio showcasing past work with PHP, especially in data-centric applications - References or testimonials validating expertise and reliability Freelancers should provide a detailed proposal outlining their approach, timeline, and any suggestions for script improvements. I value clear communication, timely delivery, and a passion for building robust PHP solutions. Ready to enhance our ...
we need a freelancer to carry out a simple task. It is about verifying that a shipment matches against a packing list. The Freelancer must go to the factory or warehouse where the shipment is located, count the products and take photos according to a manual that we will send; stay in the factory or warehouse until the containers are filled out and take pictures of the loading process according to the manual we would provide
We're looking for a talented and dedicated Full Stack Web Developer to j...our platform. • Implementing Server Side Logic: Harness your skills to deliver solid server-side solutions and ensure the functionality of our platform meets the project requirements. • Managing the Database: Utilisation of the Microsoft Database/SQL to effectively manage and organise information on our platform. Ideal Skills and Experience: • Extensive knowledge in HTML, CSS, JavaScript required. • Mastery in Node.js/Express.js, React.js, and Microsoft Database/SQL or other similar database platforms necessary. • Proven experience in UI design, server-side logic implementation, and database management. We look forward to working with a skilled professional who ...
I'm in immediate need of a skilled Data Science professional to collaborate on various tasks. Here's what I'm looking for: - Mastery in **Python**, **R**, and **SQL** - Comfortable with **data cleaning and preprocessing** - Capable of conducting **statistical analysis** - Experienced with **machine learning modeling** Ideal applicants should demonstrate: - Proven track record with relevant **past work** - Substantial **experience** in similar projects - Ability to craft a **detailed project proposal** Your expertise will play a crucial role in the success of my project. If you possess the skill set mentioned and are available for immediate start, I look forward to your proposal!
I'm in need of a competent web developer skillful in ASP.NET webforms, JavaScript, and familiar with techniques such as Fetch and AJAX. The project involves building a comprehensive hotel management system with a SQL server database. Key functionalities required are: * Booking Management - the system will need to handle a volume exceeding 50 bookings a day efficiently. * Inventory and Room Management - keeping track of hotel supplies and managing room distribtution. * Customer and Account Management - managing customer details and accounts in an organized manner. * API Integration - this is necessary for booking from an external website, the API should provide real-time booking updates and show availability and rates. * website must be RTL. * with Code Source If you have pr...
I'm looking for developers to stand-up our events and services platform. The application has already been thoroughly designed in Figma, with extensive prototyping ...features and conditions, but the logic for each is relatively simple, as is the UI/UX. We are not creating a new or ground-breaking technology, we are simply consolidating and simplifying existing mechanisms to create a unique and efficient solution. Integrations and API's: - Stripe - Contacts, Calendar, and Location data - SMS/Email/Push notifications required - AWS Hosting (anti-spam, and security features included via AWS) Expected programming experience: - Python - SQL - Mobile application development - AWS certified would be a plus, but we can out-source the hosting management if needed. If in...
...Backend Developer with established skills in Node.js, who also had experience in handling both SQL and NoSQL databases. The primary purpose of the project is to fetch Indian market IPO allotment status. What i want is a system where i send users PAN number and it fetches me the data whether IPO is alloted to user or not. I want something similar to narada app Key Responsibilities: - API Integration: Besides strong Node.js skills, experience with API integration is crucial. As most of the data will be served from external sources, fluency in API handling is crucial. - Database Management: The developer should be able to comfortably work with both SQL and NoSQL databases, managing and optimizing data flow as necessary. Ideal candidates will possess...
...for warehouse inventory management. The ideal candidate should have a proven track record of developing similar apps. Here are my project requirements: - **Core Features**: The app must facilitate inventory management within my warehouse business. - **Functionality**: Although the key functionalities question was skipped, I would expect the basics such as: - Intuitive UI for inventory cataloging - Secure data handling - Search and filter capabilities - **Additional Capabilities** (Preferred, based on industry standards): - Barcode scanning integration - Real-time inventory updates - Order processing and management workflow **Skills and Experience**: - Proficient in Android app development - Experience with inventory database integration - Familia...
