SQL Jobs

Please Sign Up or Login to see details.

I need my Open Journal Systems instance taken from version 3.3 to 3.5.0.3. Alongside the version bump I would like a few fresh interface touches—think new blocks, buttons or info panels that help editors access key tools faster. Existing workflows and plugins can stay as they are as long as the upgrade itself runs smoothly; small visual shifts are welcome if they come with the new elements we add. Here is what I have in mind: • Full files-and-database backup before you touch anything. • Clean upgrade to 3.5.0.3 with all standard post-upgrade checks (DB migrations, plugin compatibility, email templates). • Final verification that submission, review and publishing still work end-to-end. Please bring solid OJS experience, comfort with PHP, SQL and the Smarty/Boot...

I'm seeking an expert to develop SQL document templates specifically for Comarch Optima. The templates will be used to generate essential business documents such as: - Order Confirmations - Invoices - Packing Lists Ideal Skills and Experience: - Proficiency in SQL and Comarch Optima - Experience in creating SQL templates for business document generation - Familiarity with handling financial, inventory, and customer data Please provide examples of similar work done. Looking forward to your bids!

I have a set of records that must be keyed directly into our Microsoft SQL Server database. Everything needs to be done by hand—no automated import tools—so each field is checked for accuracy as it goes in. Here is how the work will flow: • I supply the table schema, any lookup lists, and clear formatting rules. • You receive the source files and a secure connection to the database. • As you enter each record, you verify mandatory fields, follow the naming conventions, and flag anything that does not align with the guidelines. • When the batch is complete, you run a quick count against my control totals so we know everything landed where it should. The goal is simple: a clean, fully populated SQL Server table with zero duplicates and no missing...

I need a compact system that links physical NFC tags to a simple informational landing page and funnels every tap into meaningful analytics. Landing page The page is single-screen, mobile-first, and purely informational—no registration forms or quizzes. When someone taps a tag, they arrive here instantly, so load speed and clear branding matter. NFC tag logic Please generate each tag’s ID as a unique sequential number and encode it in the URL you burn onto the tag. That ID must persist through any redirect so we can track the specific tag that was tapped. Data to capture For every interaction, log the timestamp, the location of the tap, and any user details you can legally gather on first contact. Store these records in a database you set up (SQL or NoSQL—your ca...

I currently run a Windows-based restaurant and bar billing application that handles everyday operations but is showing its age. I need it rebuilt from scratch, preserving every mission-critical function while giving me full ownership of the new source code and database. Core scope My existing system already includes restaurant billing, bar billing, inventory control, KOT printing, and state-wise excise reporting. I also rely on integrated user management, daily sales reports, a searchable customer database, and detailed excise summaries. All of these must carry over exactly as they work today. Deliverables • A Windows desktop application (preferably .NET or similar) that mirrors the current workflow for restaurant and bar billing, inventory, and KOT. • State-wise excise rep...

I need a SQL familiar with CityWorks Activate Report platform

ob Title: Data Scientist Role Overview: We are seeking a Data Scientist to help us transform our CRM, Gradlynk, into a more intelligent, AI-driven platform. The role will focus on leveraging data to enhance student engagement, improve learning outcomes, and optimize operational efficiency across our edtech ecosystem. Key Responsibilities: -Collect, clean, and analyze data from Gradlynk and other sources to generate actionable insights. -Develop predictive models and machine learning algorithms to personalize student experiences and forecast performance trends. -Collaborate with IT, Product, and Operations teams to integrate AI-driven features into Gradlynk. -Translate complex data findings into clear recommendations for educators, administrators, and business stakeholders. -Monitor an...

I need a clean, reliable bridge that moves data from Tally into my PostgreSQL database through Tally Definition Language. The goal is seamless, automated integration—no manual exports, no Excel hops—so that every voucher, ledger, and stock movement recorded in Tally lands in dedicated tables inside Postgres in near-real time. Here’s what matters to me: • TDL code that hooks into the relevant Tally events and packages the data for transfer. • A lightweight service or script on the Postgres side that receives the payload and inserts or updates the right tables. • Clear mapping documentation so I can see which Tally fields end up in which database columns. • Basic error handling and a simple log so I know when something fails. I already have the...

I have an extensive set of financial records attached to an 86-million-dollar portfolio and need them transformed into clear, defensible investment insights. The core purpose is to evaluate current and prospective opportunities, not merely spot trends or forecast performance. Expect to dig into raw transactional data, balance sheets, and market feeds, then surface the strengths, weaknesses, and hidden potential of each holding. You are free to work in Python (Pandas, NumPy, SciPy), R, SQL, Excel Power Query, or any other toolkit you trust, so long as the outcome is reproducible. I will provide the data in CSV and relational-database dumps; secure transfer protocols are already in place. Deliverables • Cleaned and well-documented dataset (with transformation scripts) • Analy...

I need to bring several Visual FoxPro databases up to modern standards while also building a fresh one from scratch. On the legacy side, the structure needs a careful redesign so tables, indexes, and relations make sense for today’s workflows. As part of that redesign, stale and duplicate records have to be cleansed, and performance tuned so queries return instantly rather than in minutes. Once the data is sound, I want clear, professional-looking reports and analytics dashboards that management can run with a single click. The new database should follow the same architecture and optimisation principles so it integrates cleanly with our existing codebase. Everything must stay native to Visual FoxPro; however, if a lightweight helper tool (e.g., SQL Server Express or Power BI for t...

I have a batch of numerical records that capture daily financial transactions. I need each entry checked for accuracy, consistency, and basic logic errors before the data moves into our reporting system. The work is strictly on transactions—no invoices or budget reports are involved. You will review the figures against a reference sheet I’ll supply, spot any mismatched totals, duplicate IDs, or impossible values (such as negative credits), and then return a clean file plus a brief discrepancy log. Excel or Google Sheets will be fine for the task; if you prefer to script quick checks in Python or SQL that’s welcome as long as the final deliverables remain in spreadsheet form. Deliverables • Corrected transaction spreadsheet • Separate log outlining every c...

I’ve just cleared the Philippine Nursing Licensure Exam (Nov 2025) and now oversee quality assurance for a small but busy clinical unit. To tighten patient-safety practices, I want a streamlined way to capture, track, and analyse infection-control breaches as they happen. Here’s what I need from you: • Build a simple, reliable reporting workflow (Google Forms, Microsoft Forms, or a light web app—whichever you know best) that staff can complete in under two minutes. • Create a central log—Excel, Google Sheets or an SQL-lite table—where every submission lands automatically and is time-stamped, categorised and searchable. • Add basic dashboards so I can spot trends at a glance: breach type, location, time of day and staff role. • Dra...

I’ve just cleared the Philippine Nursing Licensure Exam (Nov 2025) and now oversee quality assurance for a small but busy clinical unit. To tighten patient-safety practices, I want a streamlined way to capture, track, and analyse infection-control breaches as they happen. Here’s what I need from you: • Build a simple, reliable reporting workflow (Google Forms, Microsoft Forms, or a light web app—whichever you know best) that staff can complete in under two minutes. • Create a central log—Excel, Google Sheets or an SQL-lite table—where every submission lands automatically and is time-stamped, categorised and searchable. • Add basic dashboards so I can spot trends at a glance: breach type, location, time of day and staff role. • Dra...

ob Title: Data Scientist Role Overview: We are seeking a Data Scientist to help us transform our CRM, Gradlynk, into a more intelligent, AI-driven platform. The role will focus on leveraging data to enhance student engagement, improve learning outcomes, and optimize operational efficiency across our edtech ecosystem. Key Responsibilities: -Collect, clean, and analyze data from Gradlynk and other sources to generate actionable insights. -Develop predictive models and machine learning algorithms to personalize student experiences and forecast performance trends. -Collaborate with IT, Product, and Operations teams to integrate AI-driven features into Gradlynk. -Translate complex data findings into clear recommendations for educators, administrators, and business stakeholders. -Monitor an...

I’m building an internal security tool and need a solid PostgreSQL foundation that starts as a single, multi-tenant database yet can be cleanly split into separate databases—and separate servers—later on. The first release will concentrate on storing architectural components (a very well defined structure) alongside threat-intelligence data (mapped to the components metadata), so the schema must keep cross-tenant isolation strict while still allowing swift relational join matching across those two domains. What I need from you • A full relational schema (ERD and DDL) optimised for multi-tenant operation—think shared-table with isolated tenant-id or schema-per-tenant, whichever you can justify—and documented so the eventual extraction path is clear. &...

Product: ManageEngine Application Manager License Required: No Professional Services Required: Yes SCOPE OF WORK This Scope of Work includes below set of activities: Install Application Manager Configure mail server settings Configure general and security settings Configure users (up to 10) Configure user roles (up to 10) Add monitor credentials (up to 10) Discover Monitors (up to 50 - Applications, DB, Web Services, Servers etc.) Configure APM Insight - .Net monitors/instances (up to 5 monitors) Configure Monitor groups/Business groups (up to 5) Configure actions (up to 5 - Email, SMS (if applicable), Helpdesk (if applicable)) Configure Threshold profiles (up to 9) Configure windows services monitors and group (up to 11) (services from MES, LIMS and PI Historian) Configure SQL query moni...

Hello I have so little time to go very quickly I am looking for a reliable programmer. I want IPTV streaming control , admin panel , reseller Panel Best would be in PHP / MYSQL / NGINX / HMTL / CSS code. Create certain packages where I can iptv divided into packets Live View on the homepage And it must be running nginx *************** Specifications: *************** All with VLC and FFSERVER Video / Audio Format ********************* + MPEG2/MPEG-AVC/H264 + AAC/MP3 Containers ********** + MP4, Transport Stream, MOV, 3GP, 3G2 Streaming Protocol ****************** + HTTP + RTSP + RMTP + UDP Multicast + Re-Stream Protocol + HTTP MPEG2/H264 TS + HTTP ASF (H264) + UDP/RTP MPEG2/H264 TS Live Encoding Protocol ****************...

This homework requires a working Python program that respects every constraint my instructor set. Only the libraries covered in class may be imported—specifically NumPy, Pandas, and Matplotlib. A few lightweight SQL queries are acceptable, but no external packages beyond that list can appear in the final code. The assignment brief and its “AI usage” rules will be shared right after we start; the code must follow them to the letter. I need mid-level, object-oriented design, clear function separation, and comments in English so the grader can follow the logic. Deliverables • A single, well-commented .py file (or notebook, if advised in the brief) using only NumPy, Pandas, Matplotlib, and basic SQL. • A short README explaining how to run the script and where ...

I need a robust web server configured specifically for storing and managing transaction records. The entire environment must meet recognized industry standards such as PCI DSS, so every layer—from operating system hardening to database encryption and network configuration—has to align with those controls. Here is what success looks like to me: • Provision a scalable server (cloud or on-prem, your recommendation) built for high-volume transaction data. • Implement advanced encryption at rest and in transit, with key management that satisfies PCI DSS. • Configure access controls, logging, and monitoring so audit trails are complete and tamper-proof. • Provide clear documentation of the architecture, compliance checkpoints, and any scripts or automation ...

I need a full-stack website that lets visitors request our “Cloud” home service and gives me a robust admin panel to run everything behind the scenes. The site has to be deployed on Microsoft Azure, so please structure the code and infrastructure (App Service, SQL/NoSQL, storage, CI/CD if you prefer) accordingly. Front-end • Modern, responsive landing page that explains the service and captures leads or direct bookings. • Clean contact/booking form with validation and confirmation emails. Admin panel requirements • User management (create, edit, suspend customers and staff). • Service booking management with status updates, filters, and search. • Analytics & reporting—at minimum daily/weekly booking counts and user stats, shown i...

I need a senior Delphi mind to craft a clear-cut strategy for moving an existing application from the Borland Database Engine to FireDAC with SQL Server as the back end. The objective is full modernization: cleaner code, easier maintenance, and freedom from legacy BDE constraints. I will spin up a dedicated testing environment first, so your plan must assume zero changes touch production until every issue is ironed out. Please lean on practical experience—show me similar projects you have already steered; past work is my main filter when choosing who to collaborate with. Deliverables • A written migration roadmap outlining phases, timelines, and required tooling • A checklist for preparing the test instance (drivers, FireDAC components, SQL Server settings, connec...

## Project Overview Seeking an experienced data engineer to integrate our complete Google marketing stack into Google BigQuery as a centralized data warehouse, with an AI-powered natural language query interface on top. ## Scope of Work **Phase 1: Data Integration to BigQuery** Connect and automate data pipelines from: - Google Analytics 4 (GA4) - Google Ads - Google Search Console - Google Tag Manager - Google Merchant Center Requirements: - Set up automated, near real-time data transfers - Design efficient BigQuery schema with proper data modeling - Implement ETL/ELT processes with data quality checks - Create unified views combining data across platforms - Import historical data - Document all data flows and transformation logic **Phase 2: AI Integration Layer** Implement AI-power...

Job Title: Oracle WAX & WAM Consultant – Job Support Engagement Type: Part-Time Job Support Support Duration: 2 Hours per Day Monthly Budget: ₹22,000 – ₹24,000 Mode: Remote Experience Required: 7+ Years Role Overview We are seeking an experienced Oracle WAX (Work & Asset eXchange) and Oracle WAM (Work and Asset Management) Consultant to provide daily job support for an ongoing Utilities project. The consultant will assist with configuration, issue resolution, integrations, and functional/technical guidance. This is a remote, part-time engagement requiring 2 hours of support per day. Key Responsibilities Provide daily remote support (2 hours) for Oracle WAX & WAM modules. Assist in configuration and functional setup of WAM. Support asset lifecycle and work or...

I need a cloud database setup using either AWS, GCP, or Azure. The database should support both SQL and NoSQL. Requirements: - Experience with at least one major cloud provider (AWS, GCP, or Azure) - Proficiency in both SQL and NoSQL databases - Ability to design and implement secure, scalable, and efficient cloud databases - Knowledge of best practices for cloud database management and maintenance Ideal Skills: - Cloud architecture design - Database administration - Security compliance in cloud environments - Performance tuning and optimization Please provide examples of similar work done.

I need a turnkey solution that watches a dedicated folder on our local server, reads every stock-dispatch PDF dropped there, and pulls out the roll-level details we receive from multiple vendors—Micron, Size, Roll Number, Gross Weight, Net Weight, Invoice Number, Vendor Name and Dispatch Date. Once captured, that data must flow straight into a master inventory database, stay synchronised, and drive all downstream reports. Key functions I expect: • Continuous PDF scraping from the local path I specify, with no manual trigger required. • Central master inventory that grows with each import; I’m open to whichever SQL back-end you feel best suits the job as long as it is industry-standard and easy for us to maintain. • Live stock dashboards that let me view ba...

If you are expert in building Oracle AI agents and if you have the fusion experience then only bid this project. payment will be released only if the project satisfied or else no payment. it needs to be remote work you just need to guide me i will do in my system. I have a Fusion Application instance and want to layer Oracle AI Agent Studio on top of it so that key customer-facing actions happen automatically. The flow is straightforward: • The agent picks up promise dates and status changes from Fusion. • It updates the relevant “Notes” field in real time. • If a promise is missed, the agent triggers an email to the customer (and a copy to our team). Few of theAPI keys are already available; I simply need you to wire them into Oracle AI Agent Studio, c...

Hi! I am looking to upgrade my current sales dashboard. I am looking for a Data Specialist who I can learn from and who can propose the best solution for my needs. Data will come from CSV files. I need a place where I can import that data to. I would like the dashboard to be as detailed as possible showing multiple KPIs, graphs, and correlations between the various data. Once setup, I would like it to be fairly simple to import new data, and modify the dashboard as needed over time. I would like this setup to be fully offline and local. My current thoughts are Metabase + SQLite. However I am open to other solutions and recommendations. I will be able to provide an example of the CSV during discussion to see how and what we can achieve with the data. I am looking for an individual who...

I have an existing UNX universe already in daily use by the Sales team and I need an experienced SAP IDT developer who is equally comfortable with SAP S/4 HANA reporting to extend it and refresh our Web Intelligence sales dashboards. Scope of work • Universe updates: the job is strictly about modifying the current universe, not creating a new one. You will add the objects the analysts keep asking for—new dimensions, measures and hierarchies—so they can slice revenue, margin and forecast data the way they need. • S/4 HANA alignment: everything you add must pull from the correct CDS views or calculation views in S/4, with naming and aggregation rules that match the existing data model. • Report enhancement: once the universe is updated, I want at least three...

I’d like a data-savvy partner who can dive into our raw inventory history and surface clear, actionable trends. The sole objective is to analyze historical data—specifically inventory data—so our team can understand how stock levels have moved over time and where the pressure points sit. Here’s what I have: several years of SKU-level records housed in a SQL database, plus a few CSV extracts. I need you to pull and clean the data, run robust trend analysis in Python (Pandas, NumPy, preferably some Matplotlib or Seaborn visuals), and package the insights so they are easy for our planners to act on. Time-series forecasting or demand planning frameworks aren’t required right now, but please structure the code so we could layer those in later if needed. Deliverab...

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

I have a Hadoop cluster holding several large data sets, and I need a seasoned PySpark developer who also writes rock-solid SQL. The immediate aim is to connect to the cluster (YARN/HDFS with Hive metastore), develop or refine PySpark jobs, optimise the accompanying SQL, and make sure everything runs smoothly end-to-end. You’ll receive access to a staging namespace plus a sample of the data. Once the logic checks out we’ll promote the code to the full environment. Deliverables • A clean, well-commented PySpark notebook or .py job that executes successfully on the cluster • The corresponding SQL script or view definitions ready for Hive or spark-sql • A concise README detailing execution steps, parameters, and expected outputs Acceptance criteria &bul...

I have a fully-functional ERP written in core PHP with a MySQL backend. The next milestone is an Inventory Management module dedicated exclusively to stock tracking. No supplier or order features are needed at this stage. What I need built • Database changes to record products, stock movements (in, out, adjustments) and current on-hand quantities. • Clean, responsive PHP screens that blend with the existing UI for item setup, stock transactions and a real-time stock level dashboard. • Basic search, filter and export to CSV so staff can pull quick counts. • Low-stock thresholds with email alerts (SMTP already configured in the system). • Clear install/merge instructions and brief user documentation. Acceptance The module must install without breaking e...

I currently manage a website built for display management. It runs on a Linux server with an SQL database. Over time, the system has slowed down and is struggling to handle the increasing volume of data efficiently. The goal is to redesign the website using modern technologies and update the overall architecture to improve performance and scalability. All page designs have already been completed in Figma. The platform synchronizes its main database with local databases on connected desktop workstations, and the new version must remain fully compatible with the existing desktop software to ensure seamless synchronization. There are three user roles: Super Admin, Admin, and User, each with specific permissions to manage or view different levels of content. In addition, the UI needs to be...

This project will create an end-to-end, AI-powered email delivery system for a U.S. client. All work must be carried out on-site or remotely from New York State; residency is a strict requirement because of data-handling policies. Scope of work The core task is to design, train, and deploy a regression-based machine-learning model that predicts optimal email-send parameters from rich transactional data. I will supply secure access to the historical transaction logs; you will architect the data pipeline, engineer the relevant features, and iterate on model performance until it is production-ready. Once validated, the model should be wrapped in an API and integrated into our existing email infrastructure so it can trigger personalized sends automatically. Key responsibilities • Da...

I need a web-based application that lets me run every aspect of a high-school wrestling tournament from one screen. The core must cover participant registration, automated bracketing and seeding, match scheduling, real-time score tracking, live team scoring, and on-demand printing of brackets, bout sheets, and final results. Here’s how I picture the flow: • Coaches register athletes online, selecting weight classes and entering roster data. • The system seeds each bracket automatically yet allows manual tweaks when necessary. • Matches are scheduled across multiple mats and rounds, with clear matside displays. • Scores are entered live; individual results immediately roll into cumulative team standings. • At any point, I can print clean, ready-to-po...

I’m setting up a central repository where each of my subscribed clients—schools, companies, public bodies and similar organisations—can log in over the internet to view, upload and download their own estate-related and compliance documents such as surveys, inspection reports and certificates. Editing in the browser isn’t required; the goal is a “read, upload, download” portal that keeps every file in its original form. Here’s what I need built: • A relational database (SQL or comparable) that stores the file-metadata and user accounts. • A clean web interface that works on desktop and mobile, served from my own on-prem server. • Username-and-password authentication with session timeout and password-reset functions. • Rol...

I’m standing up a series of production data pipelines and need an IT professional who can move comfortably between Python scripting, SQL optimisation, PySpark transformations and Airflow orchestration. The immediate focus is end-to-end pipeline build-out: designing clean ingestion logic, transforming data in Spark, writing efficient queries and scheduling everything through well-structured Airflow DAGs. If you can demonstrate hands-on experience across all four technologies - Python, SQL, PySpark and Airflow—and enjoy owning a pipeline from raw source to curated output, I’d like to work together. Deliverables I’m expecting: • A working set of PySpark jobs that handle ingestion, transformation and output staging • Airflow DAGs that schedule, monit...

Employment Type & Work Location: - Full-time position - Onsite work required - Candidates must be willing to work onsite in Thailand and/or Indonesia (depending on project assignment) Required Skills: - Strong proficiency in Python - Solid knowledge of SQL - Experience with Git version control system - Good English reading and writing skills Preferred Skills: - Experience with ERP systems and/or eCommerce platforms - Business knowledge such as Accounting or Supply Chain - Experience with Docker Additional Advantages: - Hands-on experience with ERP systems (development and/or functional usage) - Knowledge of JavaScript, HTML, CSS - Demonstrable work on GitHub repositories - Public GitHub repository with proven experience will be a strong advantage

I need a seasoned Tally user to build a complete book of accounts focused on inventory management and to configure the system so I can pull accurate financial reports any time I need them. The company file has to be set up from scratch in Tally (ERP 9 or Prime), with every stock item, godown, and unit of measure properly mapped to the chart of accounts. What has to happen: • Create the inventory-centric ledger structure, enter opening balances, and enable stock tracking features. • Configure voucher types, taxation ledgers, and cost centres so that monthly profit-and-loss, balance-sheet, and stock-summary reports generate correctly without extra adjustments. • Provide a brief hand-over guide and one remote walkthrough so I know exactly how to enter day-to-day inventor...

To better understand our brand and how we support online players, we invite you to visit our website by searching “La Planque Du Joueur” on Google. Taking the time to explore our platform is a strong sign of motivation and curiosity, which we highly value. La Planque Du Joueur is an independent website specializing in online gaming websites comparisons. As part of our growth, we are looking for a Data Analyst passionate about data and digital performance, capable of transforming numbers into strategic recommendations to improve business results and user experience. Key Responsibilities : - Collect, clean, and analyze data from website traffic and marketing campaigns - Build dashboards and reports to monitor KPIs (traffic, engagement, conversion, revenue) - Identify trends, pa...

We are building a network of experienced Oracle ERP functional and technical consultants for upcoming UK and international transformation programmes. Engagements will include both Oracle E-Business Suite (EBS) and Oracle Fusion Cloud environments. Key focus areas: • Oracle Financials • Supply Chain Management • Human Capital Management • Enterprise Asset Management • Technical integrations (OAF, SOA, middleware, custom extensions) We are particularly interested in: • Senior Functional Consultants • Technical Consultants / Developers • ERP Architects • Integration Specialists • Database & Middleware experts Consultants should be comfortable working independently, contributing to design workshops, producing configuration or technical ...

Responsive Web application + Mobile App Technology: .NET core, SQL, Angular Feature 1. Vehicle Master Management Add and manage vehicle details including registration, insurance, permits, fitness, PUC, and ownership information. 2. Driver Management Maintain driver profiles, license details, expiry tracking, and vehicle assignment. 3. Trip Tracking Log trip start and end with odometer capture and maintain route/date-wise trip history. 4. Fuel Management Record fuel entries with bill upload, auto-calculate mileage, and monitor fuel efficiency. 5. Maintenance Management Schedule preventive maintenance, record service history, and track maintenance costs. 6. Compliance & Expiry Alerts Automated alerts for insurance, permit, PUC, fitness, and license expiry. 7. Gate Entry &...

I have a backlog of financial figures that must be transferred accurately into working spreadsheets and then reflected in our existing SQL database. The spreadsheets will be the primary source, so precision in every cell—dates, currency formats, formulas, and cross-sheet references—is essential before the data is pushed to the database. You will receive scanned source documents, the current Excel template, and credentials to a staging schema in our SQL environment. Once each spreadsheet is complete and vetted for errors, the corresponding tables in SQL need to be updated so that our reporting dashboards stay in sync. Deliverables • Completed Excel workbook with all financial data correctly entered and formatted • SQL script (or direct upload) that mirrors the sp...

I need a techno-functional specialist who knows SAP HANA inside-out to set up an automated pipeline that pulls data from three live modules—Financial (FI), Production Planning (PP) and Plant Maintenance (PM)—and ships it to a remote server on a fixed schedule. Here is what I am after: • Build or configure the job inside HANA Server (HANA DB with query language access, or any proven method you recommend... No additional connector licenses will be bought) so that it extracts the required tables and views, converts the output to clean JSON and pushes it to the destination path via SFTP or a comparable secure protocol. • The transfer must run on a schedule that I can adjust easily (hourly, daily thrice weekly, etc.) without redeploying code. Preferably leave the cr...

We are looking for an experienced developer to support and enhance an existing enterprise application built using Visual Basic (VB / VB.NET) with a SQL database backend. The application is currently in active use, and we require a developer who can quickly understand the existing codebase, implement enhancements, optimize database performance, and resolve issues as they arise. This is not a greenfield project — the focus will be on improvement, stabilization, and incremental feature development. Scope of Work Includes: Understanding and working with an existing VB / VB.NET codebase Enhancing modules and implementing new business requirements Writing and optimizing complex SQL queries, stored procedures, views, and functions Debugging and resolving application and database-relat...

I need an API layer that lets HikCentral Pro push employee attendance records directly into my SQL database. HikCentral will be the data source; the SQL instance will act as the system of record. At the moment I’m not completely sure of the payload format—HikCentral’s documentation mentions something that looks like “POSTSQL”, so I’ll need guidance on the exact structure (it could end up as JSON once we see the sample webhook). Core requirements • Accept incoming attendance records from HikCentral over HTTPS. • Route those records into a chosen table within my SQL environment (SQL Server is currently installed, but I can adjust if you suggest a better flavour). • Support three actions through separate, secure endpoints or a single e...

(Solo perfiles con experiencia demostrable en diseño de esquemas PostgreSQL en producción. No busco desarrollo web, sino arquitectura y consistencia relacional.) Tengo una base de datos PostgreSQL alojada en Supabase que recoge partidos, goles, tarjetas, convocatorias, sustituciones y más. Ya está conectada a Power BI y funciona, pero quiero garantizar su integridad antes de seguir creciendo. Lo que necesito • Revisar el esquema actual y unificar los tipos de clave (codigo_equipo, codigo_jugador, codigo_acta). • Definir y aplicar PK, UK, FK e índices que mejoren consistencia y tiempos de consulta. • Detectar registros duplicados y proponer claves naturales para cada tipo de evento. • Renombrar o re-codificar columnas problem&aa...

Necesito diseñar e implementar una base de datos que centralice la información de producción, clientes e inventario de mi negocio. Todavía no he decidido si conviene un modelo relacional (SQL) o no relacional (NoSQL), así que valoro tu recomendación según escalabilidad, costo y facilidad de mantenimiento. Alcance que tengo en mente: • Modelado del esquema para datos de producción, clientes e inventarios, asegurando integridad y relaciones claras. • Funciones básicas de consulta y reporte: totales de producción por periodo, niveles de stock en tiempo real y resumen de clientes activos. • Documentación breve que detalle la estructura, credenciales genéricas, instrucciones de respaldo y c&oa...

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