SQL Jobs

Busco a quien diseñe y ponga en marcha nuestros tableros de control en Power BI para una pyme. Alcance inicial • Crear dashboards interactivos que resuman las áreas de Ventas y Finanzas. • Priorizar visualizaciones con gráficos de líneas; si algún indicador lo exige, puedo aceptar otras vistas complementarias siempre que la narrativa principal se mantenga clara. • Conectar los tableros a mis datos ya organizados y dejar programada la actualización automática. • Documentar brevemente las medidas DAX clave y la lógica de cada página para que el equipo interno entienda los cálculos. Soporte continuo Acordemos un paquete de hasta 10 horas mensuales para mantenimiento: ajustes menores, incorpo...

Estoy por arrancar una migración con Informatica PowerCenter y necesito apoyo directo en la construcción de los procesos ETL. El conjunto de datos con el que trabajaremos está en Oracle y lo extraeremos desde una base de datos SQL; el objetivo es una migración limpia, controlada y auditable hacia el nuevo esquema. Qué espero de ti • Diseñar y desarrollar mappings, sesiones y workflows en PowerCenter que cubran todo el flujo de extracción, transformación y carga. • Incluir manejo de errores, validaciones de calidad y registro detallado de eventos. • Documentar cada mapping en el repositorio y entregar un pequeño manual de despliegue/rollback. Aceptaremos el trabajo cuando: - Todos los procesos se ejecu...

Ya tengo el diseño inicial de la interfaz construido con V0 de Vercel en Next .js. Ahora necesito que lo conviertas en una aplicación funcional que: • Reciba y almacene datos de usuario junto con los documentos que ellos mismos suban. El usuario deberá aceptar "términos y condiciones" ya que está subiendo información confidencial • Guarde todo en una base SQL; me da igual MySQL o PostgreSQL mientras quede bien estructurado y con migraciones incluidas. • Exponga un API REST para altas, bajas, cambios y consultas, de forma que mi equipo pueda consumirla sin fricción. • Ofrezca un pequeño panel interno (puede ser dentro del mismo Next .js) para visualizar y filtrar la información almacenada. ...

Proyecto: Ecosistema Disruptivo de Reclutamiento Ético (HR-Tech) Buscamos: Un perfil híbrido excepcional que combine la ingeniería de software de alto nivel con una mentalidad de crecimiento (Growth) y producto. Alguien capaz de construir desde cero una plataforma que gestione identidades verificadas, inteligencia de emparejamiento (matching) y una infraestructura de datos inmutable. 1. El Reto Técnico (Arquitectura y Desarrollo) El candidato seleccionado será el responsable total del stack tecnológico, asegurando que la plataforma sea rápida, segura y estéticamente impecable. Frontend de Nueva Generación: Implementación en React (TSX) con Tailwind CSS y Framer Motion. La interfaz debe ser "líquida", ...

Quiero reducir al mínimo los gastos de mi suscripción en Azure sin comprometer rendimiento ni seguridad. Necesito que revises conmigo, paso a paso y en tiempo real, toda la configuración de: • Máquinas virtuales • SQL Database/Managed Instance • Servicios relacionados (storage, networking, backups, etc.) Trabajaremos mediante sesiones interactivas en TeamViewer, AnyDesk y Microsoft Teams con audio. No se permite el uso de chats de IA para elaborar respuestas; la comunicación debe ser directa y durante la sesión. Flujo esperado: 1. Auditoría inicial: identificas consumos elevados, licenciamiento inapropiado y recursos infrautilizados. 2. Propuesta inmediata de cambios (tamaño, auto-shutdown, reservas, elastic ...

Título: Power App Model-Driven — Gestión de Pedidos de Libros Presupuesto: $200 - $250 USD (Precio Fijo) Descripción: Busco un desarrollador con experiencia en Power Apps (Model-Driven) y Dataverse para crear una aplicación sencilla de gestión de pedidos de libros. ¿Qué necesito? Tengo un negocio de venta y distribución de libros. Hasta ahora vengo manejando todo con un archivo Excel, pero ya me quedó chico. Necesito una Power App (preferiblemente model-driven) que me permita llevar el registro de mis clientes y sus pedidos, preparar las órdenes de compra a mis proveedores, y registrar los envíos que hago a los clientes (shipping log). Voy a compartir mi archivo Excel para que veas los datos que manejo actua...

Necesito crear un flujo automatizado que recolecte información desde bases de datos académicas sobre un tema específico, valide su exactitud por comparación de fuentes múltiples y la guarde en una base SQL estructurada. Alcance • Desarrollar un script en Python que rastree, extraiga y normalice datos académicos. • Validar cada registro con cruces automáticos entre al menos dos fuentes para reducir errores. • Cargar los resultados –texto y números– en tablas claras, con claves primarias y relaciones bien definidas. • Generar reportes de control de calidad en Excel o Google Sheets que muestren discrepancias y registros pendientes de revisión. • Implementar un mecanismo de actualizaci&...

Título del proyecto Interoperabilidad Historia Clínica Electrónica – SQL Server 2008 / Access 2003 Descripción Busco freelance para adaptar un sistema de salud existente desarrollado en SQL Server 2008 (compatibilidad 80) y Access 2003, para cumplir la Resolución 1888 de 2025 (Colombia) sobre interoperabilidad de la Historia Clínica Electrónica (HCE). El desarrollo debe permitir generar y exponer el Resumen Digital de Atención en Salud (RDA) a partir de la información clínica ya almacenada, garantizando interoperabilidad con otros actores del sector salud. Alcance Construcción del RDA desde la base de datos actual. Formato interoperable (XML o JSON según lineamientos). Implementación de u...

Federal Data Operations Specialist (Canonical Company Lists, Upstream of CRM) Engagement Type Contract / Part-time Remote Ongoing or project-based, depending on workload Engagement: Fixed-price, per-deliverable (project-based) Role ObjectiveGraviton builds outbound and CRM systems on top of canonical company role exists to create those datasets upstream of CRM, by correctly merging multiple raw data sources into clean, deterministic, company-level tables using stable , correctness, and discipline matter more than speed. Core Responsibilities You will: Merge multiple datasets with different levels of granularity into a single canonical table Enforce a primary identifier (e.g., UEI, CAGE, or equivalent) as the identity anchor Aggregate transaction-level data to the entity...

AI Automation for Finance Analytics AI / Machine Learning DO NOT BID IF BIDDING FOR 40-HOUR WORK WEEK WE ARE LOOKING FOR A CONSULTANT / BUILDER / TUTOR TO WORK WITH OUR TEAM 3-10 HOURS A WEEK TO BUILD THE SYSTEM JONITLY DO NOT BID FOR LONGER THAN THOSE HOURS. DO NOT BID FOR FULL-TIME WORK DETAILS OF WHAT I NEED HELP WITH I run a real estate private equity and hotel development platform. We want to replace manual analysis and reporting with a practical AI workflow. This is about extracting, comparing, and interpreting data. Excel and PowerPoint remain the source of truth. What we need: -Compare PowerPoint vs Excel and flag mismatches - Explain underwriting models and trace outputs - Compare legal/term sheets vs financial assumptions - Track document versions and changes - Summarize deal...

AI Automation for Finance Analytics AI / Machine Learning DO NOT BID IF BIDDING FOR 40-HOUR WORK WEEK WE ARE LOOKING FOR A CONSULTANT / BUILDER / TUTOR TO WORK WITH OUR TEAM 3-10 HOURS A WEEK TO BUILD THE SYSTEM JONITLY DO NOT BID FOR LONGER THAN THOSE HOURS. DO NOT BID FOR FULL-TIME WORK DETAILS OF WHAT I NEED HELP WITH I run a real estate private equity and hotel development platform. We want to replace manual analysis and reporting with a practical AI workflow. This is about extracting, comparing, and interpreting data. Excel and PowerPoint remain the source of truth. What we need: -Compare PowerPoint vs Excel and flag mismatches - Explain underwriting models and trace outputs - Compare legal/term sheets vs financial assumptions - Track document versions and changes - Summarize deal...

Looking for a Mentor – QA Automation / .NET Interview Preparation Hi everyone, I have an upcoming technical interview for a Test Automation Engineer (.NET) position and I’m looking for an experienced mentor who could help me prepare in a structured and efficient way. Goal: – structured interview preparation – strong understanding of concepts with practical examples – interview-style questions and mock interview sessions Topics covered in the interview: 1. Test Automation Framework Architecture (.NET) Layered architecture (Core / Business / Tests) Implementing a simple Test Automation Framework Page Object Model, Browser Factory, cross-browser support Integration with third-party tools CI-level parametrization and parallel execution Advanced topics: ...

I’m building a full-featured astrology site that does more than generate charts—it will actively guide astrologer through the ups and downs of planetary transits, mahadasha and antardasha phases. So that Astrologer can notify their client on good and bad transits, good and bad mahadasha, antardasha insights also provide insight into challenging and favorable time and then rely on an intelligent alert engine to tip them off before key moments arrive. Core scope • Planetary transit insights presented in an easy timeline view, calculated from a reliable ephemeris (Swiss-Ephemeris or equivalent) and my preferred ayanamsa. . KP method should also be applied to predicts good timing • Detailed mahadasha / antardasha breakdowns accurate to the second, with plain-languag...

I have several disparate sources holding our inventory information and I want it all pulled together into one clean, well-structured Microsoft SQL Server database file. The job is straightforward in principle: extract every piece of inventory data you can reach, reconcile duplicate SKUs or mismatched item descriptions, then load the final result into a single .sql or .bak file that I can restore through SQL Server Management Studio. Please preserve every existing field that carries operational value—quantities on hand, reorder thresholds, location codes, cost figures, and any audit timestamps—and normalise the schema where it clearly improves reporting speed or data integrity. If a field appears under different names in different systems, map it consistently; if you uncover ga...

Project: Full-Stack Developer for Anime Streaming Website (React + Go) Project Overview We are developing an anime streaming website and already have a functional front-end completed. The current goal is to improve the quality, responsiveness, and overall user experience of the front-end, while also building and refining a scalable back-end system. This is a two-month project, and payment is open for discussion based on experience and project scope. Front-End Requirements The front-end is built using ReactJS, JavaScript, HTML, and CSS. The work involves improving UI and UX quality, making the website fully responsive across all devices, optimizing performance, and refactoring existing code where necessary to enhance maintainability and visual polish. Back-End Requirements All anim...

I need an experienced QuickBooks hand to configure “jobs” (sub-customers/projects) inside my existing company file so I can pull a clean, one-page view of any individual job’s numbers. Right now everything sits under broad customer accounts, which makes it impossible to see revenue, expenses, and profitability per job at a glance. What I’d like you to do is hop into a screen-share, assess how the file is organised, and then: • create a sample job structure I can reuse • map the right income and cost accounts to it • turn on or fine-tune any preferences required for job costing • demonstrate how to generate the key report that isolates one job (Profit & Loss by Job or the closest equivalent in my version) Please record or docume...

I have a PHP-based website fully packaged with installation notes, environment variables, and an SQL dump. All files are sitting in a ZIP, ready to be uploaded to my existing shared hosting account (cPanel). What I need now is simple but time-sensitive: • Upload every file to the correct directory, keeping the documented structure intact. • Create and configure a brand-new MySQL database as described in the docs, import the SQL, and update the connection details in the config file. • Run a quick post-deployment check to confirm pages load correctly, forms submit, and no PHP errors appear. You will receive: FTP credentials, cPanel access, and the full documentation folder. Once the site is live and error-free I’ll sign off right away. If you have handled...

I need an experienced Oracle E-Business Suite Functional Consultant specializing in the Financials module. Key Requirements: - Configuration and setup - Troubleshooting issues - User training and support Focus Areas: - General Ledger - Accounts Payable - Accounts Receivable Ideal Skills and Experience: - Proven expertise in Oracle EBS Financials - Strong problem-solving skills - Experienced in training end-users

I need a data-savvy investigator to help me confirm whether social-media content is being deliberately down-ranked or hidden. My sole aim is to identify suppressed algorithms, with a particular emphasis on content-visibility suppression on major social platforms. You will design and execute an evidence-based study: gather relevant data points (public APIs, scraped feeds, or previously archived datasets), apply statistical or machine-learning techniques to spot anomalous reach patterns, and document any rules, thresholds, or signals that appear to mute posts. I am open to your preferred toolkit—Python, R, SQL, or specialty OSINT platforms—as long as the workflow is reproducible. What matters most is a clear, defensible methodology, transparent code, and a concise explanati...

I need a developer to design a SQL database and a small ERP-style system for my logistics company. This system will create goods dispatch notes based on specific parameters. Core Functionalities: - Calculate quantities to be delivered per item per day. - Calculate total of each item to be delivered per month per customer. - File upload capability. - Output goods dispatch notes in Excel format. - Accessible as a web app for different users - Dashboard to track progress of deliveries per month - Interface to modify the data and based on delivery needs - Capable of calculating and creating all the dispatch notes per week and per month Ideal Skills and Experience: - Proficiency in SQL and ERP system development. - Strong experience in database design. - Familiarity with Excel output generat...

Hiring: Lead QA Automation Engineer – IVR / Contact Center (Remote) Key Skill: Hammer Automation (Mandatory) ***If you have strong IVR testing and Hammer experience, we would like to hear from you***** We are looking for an experienced QA Automation Engineer with strong skills in IVR testing and Hammer to connect with one person and connect with him daily helping work Requirements min 5+ years of experience in IVR / Contact Center testing Strong hands-on experience with Hammer (must-have) Experience with Genesys Cloud or similar platforms Manual and Automation Testing experience API Testing (Postman / Rest Assured) SQL for database validation Experience with Azure DevOps / Jira Knowledge of Agile/Scrum methodology Must be willing to coordinate and work closely with anot...

I need a striking digital poster that will serve as the centrepiece of a product-launch email campaign. The goal is to make recipients instantly curious about the new release and click through to our landing page, so strong visual hierarchy and a concise, benefit-driven headline are essential. Scope • Single promotional poster formatted for email (max width 800 px, lightweight for fast loading). • Optimised JPEG/PNG plus the editable source file (PSD, AI or layered PDF). • Colours, fonts and any graphic elements must be compatible with common email clients; no heavy animations or scripts. Key points to feature • Product name and launch date • One short line of compelling copy (I’ll supply final text) • Prominent call-to-action button or gra...

looking for an experienced OT / Industrial IIoT freelancer to develop a small on-premise technical demo (PoC) related to an automotive Paint Shop (Pre-Treatment & E-Coat). The goal is to demonstrate a realistic Industry 4.0 data flow, fully on-premise, without modifying PLC control logic, and aligned with industrial cybersecurity best practices.

I’m running a web application on a custom-built PHP framework and it currently sits on an ageing database that I now want fully migrated to MySQL. The job is strictly a database migration—no codebase refactor is required at this stage—so the focus is on cleanly lifting all existing data structures and records into a fresh MySQL schema while keeping the application functional throughout the transition. What I’ll hand over: the current schema dump (or direct access if you prefer), sample data, and a brief outline of the application’s data flow so you can map dependencies accurately. What I expect back: • A MySQL-ready schema that mirrors the original structure, optimised where obvious gains are available (indexes, data types, constraints). • Reli...

I need a data analytics expert to analyze key datasets. Key requirements include: - Analyze sales, customer, and operational data. - Identify trends, make predictions, and improve efficiency. - Deliver insights for reports, business decisions, and strategy development. Ideal skills and experience: - Proficiency in data analytics tools (e.g., Python, R, SQL). - Strong analytical and statistical skills. - Experience in generating actionable insights from complex datasets. - Ability to communicate findings clearly. If you have a proven track record in data analytics and can work within my budget, I would love to hear from you.

I am looking for a talented developer or small team to build a "Website-as-a-Service" (WaaS) platform for my boutique agency. This system is for attorneys who need a high-quality website with integrated communications. The Scope: Headless WordPress Multisite: Set up a network where I can manually "clone" sites for new clients. 10 Master Templates: Build 10 high-end, clean attorney website templates using Elementor Pro or other. You may ask ai to generate 10 switchable attorney website templates. The color Switcher: After you've created the templates, Create a simple slide-in panel that allows users to pick from 20 pre-set color schemes (using CSS variables). Ask ai to recommend the color schemes or send me the templates and i can decide on the color schemes for yo...

I need a reusable ETL framework built inside Databricks notebooks, version-controlled in Bitbucket and promoted automatically through a Bitbucket Pipeline. All source data arrives via GraphQL APIs, so the job includes handling authentication, pagination, and schema inference before landing raw payloads in Delta tables. A dedicated cleaning stage must then standardise and validate the data before it moves on to the curated layer. The structure should be modular—ideally a bronze/silver/gold notebook hierarchy—so I can slot in new sources or extra transformations without touching the core logic. I also want a lightweight Python package (wheel) that wraps the GraphQL connector and can be attached to any cluster. Acceptance criteria • Parameter-driven notebooks organised by...

I have several months of raw sales data sitting in mixed Excel/CSV files and a small SQL dump. I need that information cleaned, organised, and explored so we can finally see what the numbers are really telling us. After the data is trustworthy, I want to zero-in on three priorities: revenue trends over time, customer acquisition and retention behaviour, and sales performance broken down by region. Power BI is my preferred canvas for the visuals. Please build an interactive dashboard that lets managers slice by date, product line, and region while keeping the layout simple enough for non-technical teammates. If you also know Tableau or advanced Excel, great, but the .pbix file is the deliverable that matters most. Once the dashboard is live, I’ll need a short narrative (one-to-two p...

I'm seeking a consultant based in Johannesburg South Africa, with strong experience in Power BI, Power Automate, and knowledge of Syspro for a 6-month engagement. The goal is to build tables and dashboards and automate some of our internal workflows. Key Responsibilities: - Building tables and dashboards in Power BI - Automating internal workflows using Power Automate - Connecting to SQL databases and Excel spreadsheets as data sources - Ensuring that both management and operational teams can effectively use the outputs Ideal Skills and Experience: - Strong expertise in Power BI and Power Automate - Proficiency in SQL and Excel - Familiarity with Syspro - Experience in creating user-friendly dashboards for management and operational teams Please provide examples of similar projects...

I need a Windows-based desktop program that follows each sofa, chair, or table we build from the moment it is sold right through to the truck leaving our dock. The flow should start with order entry, automatically raise the fabric purchase request, then guide the piece through cutting, frame-building, upholstery, packaging, and finally shipping. At every stage I want a clear status board and simple way to update progress so the whole team can see what is waiting, what is in work, and what is finished. A small local SQL database is fine as long as it scales to a few dozen simultaneous users; if you prefer another lightweight option, mention it and why. The interface must be straightforward—touch-friendly for the shop floor, keyboard-driven in the office—so staff can scan a barc...

Preciso construir um backend de inteligência artificial que leia, de forma autônoma, PDFs técnicos recorrentes — o material chegará quase sempre como textos e áudios convertidos em documento — identifique tabelas complexas, texto descritivo e especificações técnicas, grave tudo em um banco SQL bem estruturado e, por fim, disponibilize essas informações em uma conversa no WhatsApp. O fluxo ideal é simples: envio o PDF, o serviço o processa, normaliza cada campo no banco relacional e, quando eu fizer perguntas no WhatsApp, recebo respostas claras extraídas desses mesmos dados. Essenciais para o projeto: • Extração fiel de tabelas, parágrafos e campos de especific...

Our Magento 2 store suddenly refuses to complete the Product Price reindex and shows the familiar “no linked stock” message. Nothing was updated, no extensions were added, and I haven’t tried any quick-fix SQL scripts or CLI commands yet, so you’ll be starting with a clean slate. I’m looking for someone who has already wrestled with this specific indexing glitch and can get the catalog back to a fully reindexed state without disrupting live traffic. Acceptance criteria / deliverables: • Identify the root cause of the “product price index – no linked stock” error and document it briefly. • Apply the corrective fix (database clean-up, configuration adjustment, or code patch) on our staging site, demonstrate a successful bin/magent...

Looking for help to make and Setup account in POWER BI Pro

Por favor, regístrate o inicia sesión para ver los detalles.

My goal is to turn a messy collection of raw files into a clean, analysis-ready dataset hosted on Google Cloud so I can make faster, well-informed decisions. The data first needs three specific text-cleaning steps—removing duplicates, correcting typos, and standardising formats. Once those tasks are automated, the cleaned output should flow straight into a Google Cloud environment (BigQuery is ideal, but Cloud Storage plus Cloud Functions works too). After the upload, I want an exploratory analysis that highlights patterns, trends and any obvious outliers that deserve attention. Deliverables • Well-commented scripts or workflows that automate duplicate removal, spell-checking and format standardisation • A repeatable pipeline that loads the cleansed data into Google C...

I need every bit of information currently stored in my Tally company—masters, vouchers, inventory, bank transactions, statutory ledgers, the lot—pulled out once and delivered in a clean, tabular Excel workbook. The extraction must be fully automated (TDL, ODBC, or any method you’re comfortable with) so I can rerun it later, but this engagement covers a single execution and hand-over. Deliverables • An Excel file where each dataset appears as a properly labeled table, with field names matching Tally, dates and numbers intact, ready for analysis or import elsewhere. We will provide Tally data file. Let me know which approach you prefer (TDL, ODBC, etc.) and how quickly you can turn the finished workbook around. Please also advise your working days and hours.

Need help writing a 3-line script in Oracle 4GL based on pseudo logic related to VEE rules and VEE group. The deliverable is the script only, as testing and documentation will be handled separately.

React Native / Expo Developer Needed 7-Day Sprint to Polish & Ship a Mobile App (Non-Profit) We’re looking for an experienced React Native / Expo developer to help us finalize and ship an existing mobile app. This is not a from-scratch build — the app is functional and well underway. We need help refining performance, completing integrations, and preparing for release. Source code is ready and available immediately. About the App The app combines two core experiences: A daily puzzle game — grid-based, touch-driven gameplay with a short interactive sequence after completion. A utility layer — a simple request-and-claim flow where authenticated users can view, claim, and log activity via a dashboard. Current State Built with React Native / Expo (Expo Go t...

I need about three hours of guided, screen-shared help moving product data that currently lives in several related Excel sheets straight into my PostgreSQL database. No transformations are required—just a clean import exactly as the data sits now. During the session we will • create or confirm the target tables and column types, • choose the quickest import method (COPY commands, pgAdmin’s import wizard, or any tool you prefer), • load every sheet accurately, and • finish by writing a few SQL queries to verify row counts, join related tables, and pull sample SKU-level results. Deliverables for me at the end of the call will be: • a working, repeatable import script or step-by-step notes; • the example SELECT queries we ran together; a...

It is my college final year project Basis. This project focuses on the design and implementation of a distributed NoSQL database system capable of handling large-scale, dynamic data with high availability, scalability, and strong consistency. The system uses dynamic sharding to automatically partition and distribute data across multiple nodes based on data growth and access patterns. It incorporates replication and consistency mechanisms such as quorum-based replication or distributed consensus protocols to ensure data integrity even during node failures or network partitions. The project aims to balance the scalability and flexibility of NoSQL systems with the consistency guarantees of traditional databases. Performance, scalability, and consistency are evaluated under different worklo...

I’m looking for a reliable way to mirror my on-premise SQL database to AWS RDS in real time. The web service you build will capture every change that hits the local tables—customer information, inventory data, and transaction records—then push those changes up to the cloud with minimal latency. My priorities are: • Zero data loss and consistent state between the two stores, even when connectivity drops temporarily. • Latency low enough to feel immediate to downstream apps that rely on the cloud copy. • A straightforward deployment path: I should be able to install the service on a Windows or Linux host beside the local database, point it at the RDS instance, and watch it run. Deliverables 1. Source code for the sync service (language and framewor...

I want to replace several manual reporting routines with an end-to-end AI workflow that ingests data from our internal finance databases and live web sources, then produces clear, timely analytics for management. Reporting and analytics are the sole focus—no transaction execution—so the system must excel at pulling, cleaning, and interpreting numbers rather than booking them. We also want to compare legal documents vs term sheets and excel spreadsheets Data sources • Company databases (SQL, flat files, Excel exports) - Dropbox all our files are in drop box • Extensive web scraping for competitor benchmarks and investment-market signals If you have ideas for safely adding external financial APIs later, let me know, but the two feeds above are mandatory. - Th...

I’m spinning up a brand-new SA-MP roleplay server and need a complete Pawn script built entirely from scratch. The end result should feel as if it came out of a polished commercial package: clean, modular, thoroughly commented, and fully optimized for desktop and SA-MP mobile clients alike. Core systems I must have • MySQL-driven account and character handling (registration, login, persistent data) • Job framework with at least a fully functional Police-Officer career path (duty toggle, arrest flow, ticketing, rank promotion, on-duty perks) • Faction, gang, and turf logic that can scale without performance drops • Business ownership with Clothing-Store mechanics (inventory, cash flow, stock restock, employee ranks) • Admin suite that, at minimum, s...

I want a small-scale desktop application built in Java that I can dissect later for study. The core requirement is a clean Swing interface that performs the usual Create, Read, Update and Delete operations against a MySQL database. Think of something like a simple student, product or book manager: one main window with a table view and modal forms for adding or editing records. Please keep the code readable and tutorial-friendly. Inline comments that explain the reasoning behind key sections—especially JDBC connections, prepared statements, and event handling—are essential. Include a concise README that tells me how to import the project, run the SQL script to create the tables, and launch the application. Deliverables • Complete Java source code organised in packages &...

This project focuses on analyzing operational, customer, and outlet-level data for a Swiggy-associated food brand to derive actionable business insights and build interactive dashboards for decision-making. The objective is to track performance across outlets, understand customer complaints, monitor item availability, evaluate marketing campaigns, and identify revenue loss due to operational issues such as stock-outs and downtime. Scope of Work The project includes end-to-end data analysis starting from raw data understanding, cleaning, transformation, and visualization using Power BI and Excel. Key dashboards developed as part of this project include: Consolidated Complaint Dashboard To analyze customer complaints by category, outlet, time period, and severity, helping identify recur...

I need an experienced SQL professional who can take customer data sitting on a remote SQL Server and refresh the corresponding tables on our in-house server every day. The transfer must be reliable, consistent, and handled through SQL Server Management Studio (SSMS), as that is already part of our workflow and permissions model. Your job will be to analyse the source schema, map it cleanly to our destination tables, set up the daily pull / push routine, and keep concise logs so I can trace each run at a glance. Data consistency checks, graceful error handling, and verification reports are essential because the customer records drive several downstream apps on our side. The engagement is straightforward: configure the process, prove a few consecutive successful runs, document the step...

I need a concise technical blueprint that shows exactly how to print in Cityworks environment at through SQL Server Management Studio. The goal is to make sure a field on the form "DUP. BAD CHECK “ L-If a Bad Check fee (L-BADCHECK) is attached to a case, it's owed. Status, type, etc. do not matter. Same for L-DUPLCTE. L-DUPBC - this is either or both a bad check fee and a duplicate fee from historic records (Pre-migration) 30 - BC 20 - Dupe 50 - Both (Rare, if it exists) the Cityworks front-end application, then landing it in the back-end SQL database on a batch schedule. You’ll be working with: • Cityworks PLL (latest build) • Microsoft SQL Server 2019 + SSMS What I expect from you: • A clear, step-by-step document that maps Citywor...

I recently moved our 20-year-old automotive forum from vBulletin 4 to XenForo and everything is running smoothly on CloudLinux v9.7.0. The last piece still stuck in the past is our Photopost gallery. All photos, captions and user comments sit in that ageing MySQL database, tied to the old vBulletin user table. I need those images living in a modern, fully supported gallery that: • keeps the same single-sign-on with XenForo users (no extra log-ins) • preserves existing photo comments and album structure • presents the pictures in a clean carousel / slideshow view I’m open to whichever tool makes the most sense—XenForo Media Gallery, an external PHP/SQL package, or another solution—as long as it installs cleanly on CloudLinux and has an active support c...

I need expert guidance to install a database server on a Windows operating system. Key requirements: - Experience with Windows server environments - Advise and whats required to install Sequoia Server/ sofware. - Ability to provide clear, step-by-step installation instructions and best practices

We are looking for a senior full-stack engineer to take ownership of several live products and Smart TV applications. This is a long-term, part-time role focused on maintenance, improvements, and occasional new features. Our Platforms � � � � Apps Samsung TV (Tizen) LG TV (webOS) Android TV Responsibilities Maintain and improve existing websites and admin dashboards Maintain backend services and APIs Bug fixing, performance improvements, and refactoring Maintain and update Samsung & LG TV applications Assist with app store submissions and updates Communicate clearly about progress and risks Tech Stack Frontend: JavaScript, React / Backend: Node.js, REST APIs Databases: SQL / NoSQL Smart TV: Samsung Tizen, LG webOS Android TV (strong plus) Streaming / IPTV experience is a big plus Requ...