Uml sql queriesJobs

...CodeIgniter 4, ensuring all features and functionalities remain intact. Optimize SQL Queries: Review and optimize all SQL queries to handle heavy loads efficiently. The current system experiences performance issues during peak times, and the new version should resolve these. Fix Bugs and Security Issues: Identify and fix any existing bugs and security vulnerabilities in the current project. Ensure the new version adheres to the latest security standards. API Integration: Connect the backend with the frontend using APIs. The APIs should be well-documented, secure, and efficient, allowing seamless communication between the backend and frontend. Requirements: Proven experience with CodeIgniter 3 and 4. Strong knowledge of SQL query optimization. Expe...

...geo-location feature with map integration to track delivery drivers and shipment status. Customer Satisfaction: Monitor customer feedback and ratings for deliveries. . - **Customer Management**: A comprehensive customer management system is essential to handle orders, complaints, returns, and inquiries. - **Support System**: Ticketing System: Integrated ticket system to manage customer support queries and issues. Chat Support: Real-time chat support for immediate customer assistance. Call Center: Call center integration to handle customer inquiries and support calls. - **Points System**: Customer Loyalty: Implement a points system where customers can earn points on purchases, which can be redeemed for rewards or converted to wallet credit. - **Mobile Apps**: iOS and Android D...

Hi there! I'm seeking an expert in Python and VBA who can develop a real-time data statistical analysis tool for use on Windows. The tool must be able to process financial data. Though the format of my data wasn't specified, please be ready to handle a diverse range of formats, including but not limited to CSV files, SQL databases, and Excel files. Skills and Experience: - Mastery of Python and VBA - Experience with statistical data analysis - Familiarity with financial data - Proficiency in handling diverse data formats. - Skill in working on Windows OS. Ultimately, I require a reliable system for my ongoing financial data analysis needs. Your track record of similar successful tasks will be a plus.

I'm seeking an expert in Python and VBA who can develop a real-time data statistical analysis tool for use on Windows. The tool must be able to process financial data. Though the format of my data wasn't specified, please be ready to handle a diverse range of formats, including but not limited to CSV files, SQL databases, and Excel files. Skills and Experience: - Mastery of Python and VBA - Experience with statistical data analysis - Familiarity with financial data - Proficiency in handling diverse data formats. - Skill in working on Windows OS. Ultimately, I require a reliable system for my ongoing financial data analysis needs. Your track record of similar successful tasks will be a plus.

...(credit cards, PayPal, etc.) Order tracking and history Payment Gateway Integration: Integration with major payment processors like Stripe or PayPal Secure transaction handling Rating and Reviews: System for buyers to rate and review sellers and products Display of ratings and reviews on product and seller profiles Messaging System: Direct messaging between buyers and sellers for negotiation and queries Notification system for new messages and updates Price Tracking and Market Analysis: Historical price data and trends for products Alerts for price changes and new listings Detailed price history, including a 12-month history of trade range, sales, price, average sale price, last sales, current sales, current bids, and current ask price Authentication and Verification: Option...

I'm looking for a talented artist to create a minimalistic cartoon character based on a paperclip with arms, eyes and legs for my project. The character will convey a focused emotion and will be illustrated in two different scenarios. There will be more work if the first 2 are suitable. - Climbing out of a cardboard box. - Picking up li...more work if the first 2 are suitable. - Climbing out of a cardboard box. - Picking up litter. The character should exhibit a unique blend of simplicity. This project is perfect for freelancers with experience in character design and a knack for minimalism. Particle knowledge of conveying emotions through characters would be desirable but not mandatory. Feel free to reach out if you have any queries. See the picture for the sort of thing I...

...system that generates reminders for clients' appointments. * Personalized Booking Page – Each client should have their own dedicated booking page. A standout aspect of this site is the Resources section, which must include: * Regularly updated articles and blog posts about relevant therapy topics. * A catalogue of recommended books and resources. * A comprehensive FAQs section addressing common queries about the practice and therapy in general. Ideal Skills and Experience: Freelancers should have proven experience in web development, with a portfolio showcasing their ability to create engaging, user-friendly interfaces. An understanding of the therapy industry and appointment-based businesses would be beneficial. Experience integrating automatic reminder systems, blo...

I'm seeking experienced UML and OCL modelers to conceptualize my full system information and transcribe the model for the USE (.use) tool. Key tasks include: - Conceptualize the entire system model using UML and OCL - Transcribe the model for USE tool - Create necessary UML diagrams: Class Diagram, Use Case Diagram, Sequence Diagram Ideal skills would include expertise in UML, OCL, and system modeling. Familiarity with the USE tool is essential.

I'm in need of a proficient expert who can assist me with running queries on DuckDB using data originating from Amazon S3. This task primarily involves: - Interacting with semi-structured data such as XML and JSON - Processing a substantial data volume ranging from 1GB to 1TB The ideal freelancer should have the following capabilities: - Deep understanding and experience with DuckDB and Amazon S3 - Strong skills in handling and querying semi-structured data - Experience in managing and processing large volumes of data Please note: it's critical that the freelancer have experience with managing these sorts of tasks previously and has a solid understanding of large volume data manipulation.

I'm seeking a professional to provide advanced technical support for my desktop software that runs exclusively on Windows. Specifically, 2016 windows office and current outlook, not recognizing Recent emails, calendars, and inbox sub folders Key Responsibilities: - Offerin...issues Ideal Candidate: - Proven experience in providing technical support for Windows software - Strong knowledge of how desktop applications work - Excellent problem-solving and communication skills - Ability to work remotely and respond to support requests in a timely manner - Familiarity with software debugging tools and techniques - A patient and customer-oriented approach to handling user queries Your involvement will play a crucial role in enhancing the overall user experience and satisfaction wit...

I am seeking the expertise of a professional engineer to create 2 sets of stamped engineering plans for a 7-10k elevator boat lift. The desgin should incorporate: - 20 degree angle lift secured to a seawall, indicating a balance of strength and flexibility. - Weight capacity between 5,000 - 10,000 lbs, t...indicating a balance of strength and flexibility. - Weight capacity between 5,000 - 10,000 lbs, to cater to a diverse range of boats. The ideal candidate should have: - Extensive experience in marine engineering - A proven track record with designing boat lifts - Familiarity with the local codes and regulations in Pasco County. For a smooth working relationship, the ability to respond promptly to queries and meet deadlines is crucial. Detailed and clear communication is also ...

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.

...programmer who is well-versed in SQL Server 2019. The primary task is to ensure that new columns added to the database are correctly displayed in the Excel report generated by the application also fix some minor areas that will discuss in detail Key Responsibilities: - Troubleshoot and fix the issue of new columns not being displayed in the Excel report - Ensure that all relevant data is correctly fetched from the SQL Server 2019 database - Implement a seamless solution that does not affect the overall functionality of the application Ideal Skills and Experience: - Strong proficiency in C# programming language - Expert knowledge of SQL Server 2019, including stored procedures and functions - Prior experience with similar tasks involving Excel report generation fro...

...three main objectives would be: 1. **Data Processing & Model Training:** - You'll need to clean and preprocess data within Stack AI - Also, train and evaluate models for maximum performance. 2. **Implement Google Search and ChatGPT Workflow:** - Familiarity with Google Search API and its integration into ChatGPT is a must. - Implement natural language processing to handle user queries - Design an intuitive and user-friendly interface to facilitate user interaction with the search process. 3. **Professional Recommendation Creation:** - Lastly, your task is to create a recommendation system using Stack AI that will offer professional suggestions to users. The ideal freelancer would have substantial experience with data cleaning, modeling, and integ...

Looking for a skilled web designer and developer to work full time on our customers...will include graphic design, HTML/CSS coding, JavaScript and Bootstrap programming in Spanish and English Key Responsibilities: - Develop and maintain websites using HTML, CSS, JavaScript and Bootstrap using our proprietary CMS. - Implement interactive features and dynamic content using JavaScript. - Optimize images for fast loading. Must be strong in responsive design using CSS media queries. Skills and Experience: - Proficiency in Graphic Design software. - Strong experience in HTML/CSS. - Proven track record in JavaScript programming. - Ability to work creatively and proficiently. - Excellent communication and collaboration skills. - Strong Spanish and English speaking and writ...

App para elaborar presupuestos fuera de la tienda. actualmente tengo un sistema de escritorio elaborado en sql server para facturacion. El sistema Funciona perfecto y tiene la opción de realizar cotizaciones pero quiero incorporar una app para realizar las cotizaciones de los clientes foráneos ya que tengo un empleado que los visita semanalmente y me toca estar transcribiendo los pedidos. Seria una app que permita cargar los inventarios y los clientes al momento de estar en la tienda Y luego poder realizar los pedidos o cotizaciones offline cuando se este fuera. Para luego cuando llegue a la tienda hacer la actualización o descarga de pedidos. que tan dificil es hacer la app para android y para ios.

We are seeking an experienced freelance developer to design and develop an online service booking platform targeted at legal professionals. The project includes creating both a web application and a mobile application for service providers. Responsibilities:Design and develop an intuitive user int...booking system with calendar and availability management. Implement secure payment systems and automatic notification features. Ensure compatibility between the web and mobile to best practices for security and data protection. Required Skills:Proven experience in web and mobile in front-end and back-end technologies (e.g., React, Node.js).Experience with SQL or NoSQL understanding of UX/UI design to meet deadlines.

...standards of code quality and push for continuous improvement. **What You Need:** - BS/MS in Computer Science, Engineering, or related field. - 2-3 years of full-stack development experience, with significant focus on mobile apps. - Strong proficiency in Flutter or similar, front-end technologies (HTML5, CSS3, JavaScript), and backend development (Node.js, Django). - Experience with databases (SQL & NoSQL), cloud services (AWS, Google Cloud, Azure), and versioning tools like Git. **Why Join Us?** - Flexible working hours and a chance to work in a dynamic, fast-paced environment. - Continuous learning and professional development opportunities. ? **Apply Now!** Send your resume, a cover letter, and work samples/portfolio demonstrating your expertise relevant to the role. ...

...user login/signup, in-app messaging, push notifications, photo and file upload. Advanced features should also include GEO Fencing, QRCODE/Barcode scanning and face recognition. The app should be supported by SQL and allow user details to be saved and retrieved from a database. Furthermore, the app needs to integrate with Google services like Maps and Calendar. The design of the app should be minimalistic but seamless for easy user interface. Therefore, a developer with design skills would be perfect for this task. - ESSENTIAL SKILLS: - Android app development - Knowledge of SQL - Minimalistic app design - Experience in GEO Fencing, QRCODE/Barcode scanning, Face Recognition - API integration with Google services This project will require rigorous testing to...

I'm in need of a skilled developer with strong experience in NodeJS, React, and Next/NestJS. The p...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 reliable, communicative individual who can deliver a high-quality...

...diagram, relational schema, database dump, SQL files, and queries for a library database system. Requirements: - ER Diagram: An ER diagram is required with rationalities similar to the example provided in this link: - Relational Schema: Develop a relational schema that effectively models the database. - Database Dump: Provide a database dump for the system. - SQL Files and Queries: The project should include a set of SQL files and queries that effectively interact with the database. - Managerial Queries: Develop a minimum of 20 managerial queries that will be used to analyze and manage the library database. Deadline: This project must be completed by Monday. Ideal Skills: - Proficiency in database design and SQL - Expe...

I am excited to apply for the part-time Software Developer position. As a third year computer engineering with solid background in both front-end and b...Development: Skilled in HTML, CSS, and JavaScript, with experience in and Tailwind CSS. I focus on creating responsive and visually appealing user interfaces. Back-end Development: Proficient in Python and Node.js, with a track record of building robust APIs and microservices. Database Management: Experienced with MySQL and MongoDB, capable of designing efficient database schemas and performing queries. Full-Stack Development: Able to integrate front-end and back-end systems seamlessly, handling state management, authentication, and real-time data. UI/UX Design: Knowledgeable in using Shadcn and other tools to enhance user experie...

...accountant who specializes in both US and Canadian tax laws, particularly for dual citizens, to get my taxes in order promptly. Responsibilities: File Canadian tax returns for the years since obtaining US citizenship in 2020. Ensure compliance with both Canadian and US tax laws and regulations. Provide accurate and timely filing of all necessary documents. Assist with any additional tax-related queries or issues that may arise during the process. Provide guidance and support for the green card sponsorship process concerning tax requirements. Requirements: Licensed and certified accountant with expertise in both US and Canadian tax systems. Proven experience working with dual citizens and understanding the intricacies involved. Excellent knowledge of tax treaties and regulation...

I am seeking a computer science graduate who is proficient in Python, specially trained in Chatgpt, to build a web-based AI application for my business. I need the application to be specialized in natural language processing and sentiment analysis, and subsequently serve as a recommender system to provide information and answer queries. Key Features: - Natural Language Processing: The system should be capable of comprehending textual data, extract relevant details and produce appropriate outcomes. - Sentiment Analysis: Enable the detection and understanding of sentiments within the processed text. - Recommender System: The goal is to provide customized information based on the user's interests or preferences. - Information Provider: The AI should function as chatbot, furnishin...

I'm looking for a seasoned AWS Data Engineer with over 8 years of experience to support me in handling data extraction and transformation tasks. Key Responsibilities: - Data Extraction: The engineer will be responsible for extracting structured data held in SQL databases. - Data Transformation: You will be required to transform the extracted data into a usable format for our analytics and reporting. Skills and Experience: - 8+ years of experience as an AWS Data Engineer. - Proficient in working with structured data, in particular, SQL databases. - Extensive experience in data transformation. - Expertise in AWS services, especially Amazon S3 and Glue. Your support will be essential in ensuring the smooth flow of our data processes. Please provide examples of your past ...

i have one php script which used to load in a few seconds now takes 4 minutes not sure why it suddenly lags need optimised - the mysql query hittin some bottleneck somewhere by looks of it

I'm looking for someone to integrate an existing machine learning model into a Discord bot. The bot should cater to three main functionalities - sending daily race predictions, responding to user queries about race outcomes, and providing real-time race updates. Key Requirements: - Integrate an existing machine learning model into a Discord bot - Implement a feature to send daily race predictions on a specific channel - Develop a query system that effectively responds to user queries about race outcomes - Enable the bot to provide real-time race updates Your Skills: - Proficiency in machine learning model integration with Discord bots - Experience in developing chatbots, particularly for Discord - Knowledge of horse racing and related terminologies - Ability to create...

I'm in need of a skilled developer who can work with Apache Superset, particularly in relation to MS...dashboards, and maps - Ability to translate moderate and moderately complex data into clear and engaging visual formats. - Ability to change the superset logo and bypass the auth - Customization: Customize and extend the capabilities of Apache Superset by developing custom visualizations, plugins, and filters. - Performance Optimization: Optimize the performance of Superset dashboards and underlying queries to ensure quick load times and efficient data retrieval. - Data Quality: Ensure data quality and consistency in all visualizations and reports. - Training and Support: Provide training and support to end-users to help them effectively utilize Apache Superset for their data ...

...subscriber-voter). As I mentioned above in web, the user must be able to see and edit only those fields for each voter. 4. FINAL-PARTY, FINAL-_VOTE, FINAL_VOTE_CERT serve as lookup tables (see access file attached) If more tables needed to be created you can do it. Not all relationships are created in MS Access file. You have to make them as needed. Reports, queries etc. will be created from administrator locally only. No need to view them online (reports and queries). We will give you access to a cpanel for the database and web interface We are open to any suggestion as far as the outcome will be the same. Ideal Skills and Experience: - Proficiency in database development, particularly web databases and Microsoft Access. - Strong skills in designing and implementing dat...

Vær venlig at Tilmelde dig eller Log ind for at se detaljer.

A business-centric, data-oriented, and analytical mindset. Comprehensive knowledge of data science concepts and disciplines. Knowledge of enterprise information management processes and methodologies. Skills in database design, data security, and data lifecycle ...considerations. . Combinations of experience and education will be considered on a case-by-case basis. Experience in data warehousing and governance. Practical experience in enabling data usability, availability, and efficiency. Experience in data management, quality, metadata management, and modeling. Knowledge of database systems: MS SQL Server, Oracle, or another commercial RDBMS required, Snowflake, or other non-relational database desired. Knowledge of SQL. Experience with scripting languages, especially Python...

I'm looking for an expert in Microsoft Power Apps to develop...the gathering and insertion of information into a database. Requirements: - Incorporate text inputs, dropdown menus, and date fields for gathering information. - The preferred database language is Microsoft SQL Server but SharePoint can be used as an alternative. Additional Information: - You don't need to worry about any additional features or functionalities. The main goal is to develop a basic, yet effective form for data collection. Ideal candidates should have experience in: - Microsoft Power Apps development. - Integrating Power Apps with databases, specifically Microsoft SQL Server. You should be comfortable working independently and be able to deliver a high-quality, functional solution w...

I'm in need of an experienced ASTPP/Freeswitch developer to create an Interactive Voice Response (IVR) system for my project. The primary goal of this IVR system is to Play a pre-recorded message when a customer calls a DID, then route the call according to any routing rules configured on the dialplan. This means that the system needs to be designed to handle customer queries and direct calls to the appropriate department. Ideal Skills: - Proficient in ASTPP/Freeswitch - Experience in IVR system development - Strong understanding of customer support processes - Ability to design system for call routing The project is expected to be completed within a reasonable timeframe. A successful candidate will be able to understand the nuanced requirements of the system and develop ...

...assist with creating interactive dashboards and generating data visualizations. The selected expert will be expected to work with data from both Excel spreadsheets and SQL databases, so experience with these sources is crucial. I will be looking for an advanced level of expertise, as the job will involve complex data modeling and designing sophisticated, interactive visual reports. A strong understanding of data analysis and visualization techniques is essential. Key responsibilities and qualifications include: - Creating interactive dashboards - Generating data visualizations - Working with data from Excel spreadsheets and SQL databases - Demonstrable advanced level of Power BI experience - Advanced knowledge of data modeling - Proficient in designing sophisticated, in...

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 in...

...deploy our existing project to a new VPS using gitlab 2) Woocommerce -> continue long term development work on our existing custom plugin. Transfer the existing production woocommerce to this staging server. 3) ongoing long term development of our CRM app 4) gitlab Other components of our stack which are a HUGE ADDED BENEFIT if you can work on them -> .NET ASP, WEB API + MS SQL DETAILS HERE -> PRIORITY IS TO HAVE A DEVELOPER ON OUR TEAM (LONG TERM) THAT CAN FOR NOW ALSO WORK WEEKENDS AS WE HAVE SEVERAL EMERGENCIES TO FINISH URGENTLY. Someone who can efficiently manage Linux VPS and efficiently use GITLAB is critical. Initially we need part of the hours to be worked in the first weeks from 8:00PM- 2:00am UTC -3 (Brazil Time) later you can work on

...gitlab and code in ., .NET ASP, WEB API + MS SQL. We also have woocommerce and have developed and will continue to develop plugins, so PHP and understanding of woocommerce plugins is a plus but not a necessity. Prerequisites: For the long term project the *STARTING* wage will be as stated below. 1) Accept initial hourly rate of U$5.00 2) If awarded, accept and start work IMMEDIATELY 3) Have MINIMUM OF 20+ hours a week for long term ongoing support and development. 4) Work hours: predominantly 20:00 to 02:00 (UTC -3 Brazil TIME) 5) Be available to work on weekends. Our projects use: GITLAB so you need to be proficient and be able to use our existing pipelines and also create your own. Our stack: , ag-grid, C#, .NET API, MS SQL 2017 , WooCommerce digital product s...

I'm looking for a cross-platform mobile app developer to create an app focused on daily reporting. Below are some key details to be aware of: - ...and should be well-protected. - Please provide examples of similar cross-platform apps that you have developed. - Experience with reporting functionalities and/or data security is a plus. Features of the Application will be, Name and class of app is daily Class reporting Software 2. Select the class you taught today from class 3 to class 12 3. Select the topic 4. Upload videos, and queries. 5. Mark it as done partly done or not done 6. Integrate it with calendar 7. Mark holidays 8. Integrate GPS location in it Please respond with details on your experience, how you would approach this project and any relevant past works you ...

Hello, We are F12Design, a platform where customers and designers come together and collaborate on graphic design projects. We would like to build an interactive dashboard to make the workflow simple and effective. Here are a few things on our mind: Languages - (Please free to suggest your own) Backend - PHP, jQuery, and SQL Frontend - HTML, CSS, and JavaScript For Real-time Demo/Example - Please sign up for and check their dashboard ########################################################## Social Login/Create account (Separate customer and Designer Login) ########################################################### Customer Dashboard Order Handling -------------- Past Orders Order Requirements (Quiz* and additional comments) Order Updates Order Delivery Date Order Tracking

I am in need of an AI model that can convert text in images to answers, and I'm looking for someone with the right skills and experience to help with this personal research project. Key Requirements: - I need an AI model that can accurately convert text in photographs to answers. The model should be able to understand the text in the images and provide relevant responses to the queries. - The AI model should be trained to high accuracy standards, achieving results of 90% or higher. This level of precision is crucial for the success of the project. - The primary images that the AI model will analyze are photographs. The model should be specifically designed to handle and extract text information from photos. Ideal Skills and Experience: - Experience in training AI mode...

...automate my web search for bid opportunities (RFPs) for my telecom company. Currently, I rely on searching manually, but this process is time-consuming and not as efficient as I'd like. Key Project Requirements: - You will be responsible for setting up an automated search that looks for RFPs related to "fiber optic" or other telecom-specific keywords, which are due every May 2024 or similar queries. - This automated search needs to run every 2-3 weeks, ensuring that I stay up-to-date with new bid opportunities and future due dates. - You should have a deep understanding of web scraping and automation to accomplish this task. Additional Information: - I would like to receive notifications about new bid opportunities via email. - The project needs to be comple...

Se requiere un profesional que pueda diseñar un reporte en "SQL Server Report Builder". Este reporte, será modelo factura o pedido. Ya se cuenta con la consulta, y los parámetros de consulta (Fecha, desde - hasta), y también por número de documento (Desde - hasta).

Necesito generar deshboard y gráficos en Power bi desde 4 bases de datos • 1 base de dato en postgresql corporativa en aws • 1 base de datos en sqlserver en un servidor local • Google Analytics • Zendesk Son aproximadamente 50 gráficos personalizados con los que necesitamos hacer algunos dashboard de gestión. Es importante dejar documentado el trabajo y respaldadas las consultas en sql. Indispensable: • Dominio de Power BI • Experiencia previa en la creación de paneles para ejecutivos • Capacidad para integrar datos de bases de datos Indicar los accesos requeridos y los requerimientos tecnológicos para desarrollar el proyecto

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...

Here is a small NASDAQ project: 1) Recover data faster 7000 stocks => 3h for 1h30 / 90 min => 3500 stocks 9 min => 350 stocks. Maybe we could do multiple queries of 350 stocks? Because what is in place stops after 1800 files out of 7000. And obviously it starts again each time at the beginning when we restart... so it is always the same stocks which are updated. It would be better if the already downloaded data was not deleted, but kept and downloaded only the missing delta. This would allow us to have large data If we downloaded 1 year of data 7 days ago and we select 1 year, then only the last 7 days are downloaded, which goes faster. The data is then aggregated and deduplicated if necessary. 2) In the "indicator" section, be able to add, modify, delete existi...

...program that will retrieve an xls file from an email inbox in order to geocode the addresses present in the file via the Google Maps API and insert the geographic coordinates into an SQL table. You can follow these steps: 1. Retrieve the xls file from the mailbox - cron every hour 2. Normalize the xls file for integration into a MySQL table 3. Configure access to SQL database from JavaScript. 4. Insert data into table via SQL query 5. Retrieve addresses to be geocoded from the SQL table. 6. Use Google Maps API to geocode each address. 7. Insert the geographical coordinates (latitude and longitude) in the SQL table. Each line in the xls file corresponds to a delivery. The file has 15 columns. The column names are, in order: Shipment, Rush order, Mo...

I need assistance with scraping data from a website and delivering it in an Excel file. The specifics of the project are as follows: I am looking for a person who will conduct scraping sessions for our business on a regular basis. Desired skills are knowledge of screen-scraper software, sql, Someone with Python knowledge will be better. Willing to follow instructions. Not cramped up with other jobs or other side hustles. Need to have solid internet connection. Expected work takes 5-10 hours per week, once fully trained. Must be responsible. Able to accept PayPal. - The source of the data is a website. This means the freelancer needs to have experience in web scraping. - The data should be delivered in an Excel file. Proficiency in handling and formatting data into Excel is a mu...

Data Specialist: The Data Specialist is responsible for pr...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+ com...

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 - Pr...

...handling. - Strong problem-solving skills and the ability to work independently. ?️ Key Responsibilities: Design and develop the backend system using Core PHP, ensuring high performance and reliability. Implement secure authentication and authorization mechanisms to protect sensitive data. Integrate with external APIs and services to enhance functionality and interoperability. Optimize database queries and data storage to maximize efficiency and scalability. Collaborate with frontend developers to ensure seamless integration between the frontend and backend components. Conduct thorough testing and debugging to identify and fix issues proactively. Continuously optimize and refactor code to maintain code quality and improve system performance. Ideal Candidate: - Proficiency in C...