Sqlроботи

Обязательные знания: Python, SQLAclhemy, PostgresSQL, Aiogram, FastApi, HTML, CSS Особенно важны: Aiogram, FastApi, Python, SQL Краткий список работ: 1. Добавление проверки/валидации сдачи отчетов 2. Интеграция Telegram бота с фуд-треккером FatSecret 3. Проверка на оплату 4. Изменение общего визуала сайта и информации, которая отображается 5. Добавить дату добавления админа 6. Трекинг действий куратора 7. Добавить закреп юзера за определенным куратором Подробнее при личном контакте

Доброго дня! Шукаю фрілансера, хто міг би допомогти час від часу писати коди SQL запитів для SAP B1.

...Супроводження процесу впровадження. Вимоги: • Досвід роботи – від 2-х років. • C++11, STL, GCC/CLang, GDB/LLDB, GNU Make, CMake, Bash. • Знання STL — контейнерів та алгоритмів. • Знання файлового вводу/виводу у стандарті POSIX. • Знання POSIX Threads —нитки, м’ютекси, умовні змінні. • Вміння користуватися системою контроля версій Git. • Вміння користуватися командним рядком Linux. • Реляциійні БД, SQL. • Основи функціонування комп’ютерних мереж, протоколи TCP и HTTP. Знання HTTP/1.1. Знанння архитектури REST. • Багатопоточність. Буде плюсом: • C++14, 17, 20. • Qt. • Boost. • Засоби статичного і и динамічного анализа коду (cppcheck, clang-tidy, clazy, valgrind, gprof, &helli...

... Шукає Unity розробника для створення багатокористувацької браузерної 3D гри, Unity за допомогою WebGL. Обов'язкові навички: Вміння працювати в Unity і знання мови C#. Плюсом буде додаткові знання: JS, HTML 5. І back end розробника для написання серверної частини на ASP.NET Core. Обов'язкові навички: ASP.NET Core Entity framework core SQL С кидайте свої резьуме на: business@ або проджект менеджеру проекту: viktorstor@ KICKOOS GAMES - це молода outsourc GameDev компанія, що з недавна почала розробляти і внутрішні проекти. Друзі компанія зараз розширюється і влітку планує відкрити офіс в Україні, тому долучайтеся до нашої спільноти у телеграмі, де публікуются відкриті вакансії на різні позиції.

Потрібно зробити легкі лабораторні роботи, терміново! Файли прикріпив, за потребою скину методичку.

Я маю довгострокову роботу, яка пов'язана з нашим попереднім проектом 'Change Framework CMS from Shopify to Prestashop - PHP, HTML, CMS, SQL'

Project Title Full-Stack Developer/Agency for On-Demand Home Service Marketplace (iOS, Android & Web) Project Overview I am launching a new on-demand service platform that connects customers with skilled profession...navigation (Google Maps) to client locations. * Earnings dashboard and payout tracking. 3. Admin Panel (Web): * Comprehensive management of users, providers, and services. * Revenue analytics and reporting. * Automated invoicing and dispute management. Technical Requirements Preferred Stack: Flutter or React Native (Cross-platform) for mobile; Node.js or Python for the backend. Database: Scalable SQL or NoSQL (PostgreSQL/MongoDB). Security: SSL encryption, secure API endpoints, and data privacy compliance. Deliverables: Clean, commented source code and 100%...

Business Requirements Document (BRD): SQL Server Stored Procedure Performance Optimization Document ID: BRD-DB-OPT-2026-001 Date: January 16, 2026 Prepared For: Database Administrator (DBA) / Performance Engineering Team System: Microsoft SQL Server 2022 Enterprise Edition Database Size: ~25 GB ________________________________________ 1. Executive Summary This document outlines the business and technical requirements for optimizing five critical stored procedures in a 25 GB SQL Server 2022 database. These procedures currently consume only 1–7% of available system resources (CPU, memory, I/O) and exhibit runtimes ranging from several minutes to several hours. The goal is to maximize utilization of available system resources to minimize execution time while preserv...

I need help resolving a network-related error when connecting a .NET WinForms application to a SQL database hosted on a local server using mixed mode authentication. Key Requirements: - Diagnose and fix the network-related error - Ensure stable SQL connection for the application Ideal Skills: - Strong expertise in .NET WinForms and SQL Server - Experience with mixed mode authentication - Familiarity with network configuration and troubleshooting Looking for a solution within 30-60 minutes.

...store the results in a SQL database. The scrapers are already built and live; what I need now is reliable, ongoing management and quick-turn updates whenever a source site changes its layout or blocking rules. The work centres on data-scraping updates, so you should feel comfortable tracing XPath/CSS changes, adjusting anti-bot measures, and ensuring the cron-driven jobs keep delivering fresh data. When an update is pushed, the pipeline must still land clean, well-typed rows in the existing database schema without breaking downstream queries. Typical tasks • Diagnose and fix failed scrape runs • Modify or extend selectors when sites update HTML or add new price fields • Optimise or re-write scraps in Python (requests, BeautifulSoup, Selenium or similar) &...

...Connect ou équivalent. – Tableau de bord permettant le suivi des projets, factures, évaluations et statistiques. – Interface moderne et épurée ; je m’inspire des lignes claires de Figma, Notion, Airbnb. Mobile-first dans l’ergonomie, même si seul le web est requis. Stack suggérée (à discuter) React / ou Vue.js côté front, Node.js + Express ou NestJS, ou encore Laravel côté back, base SQL ou NoSQL selon vos bonnes pratiques, intégration Stripe, déploiement sur AWS, GCP ou Vercel / Render. Livrables attendus 1. Cahier des charges technique bref validé ensemble. 2. Maquettes haute fidélité (Figma) conformes au style moderne & &e...

...and export reports without wading through a bloated feature set. I’m fine with any modern tech stack you’re comfortable with—Laravel, Node, Django, or even a clean SPA front-end tied to a lightweight REST API—as long as you keep the code readable and easy to extend. A minimalist UI that works on desktop browsers is enough for now. Deliverables • Full source code with clear folder structure • SQL (or migration) scripts to spin up the database • A brief README that explains local setup, an admin login, and how to add employees and run payroll Acceptance criteria • I can create, update, and archive employee records. • Payroll runs accurately from configurable salary fields and produces a PDF payslip. • Monthly an...

...network layer itself—routing, VLANs, traffic analysis, and proactive monitoring. At the same time, I develop in several languages, with ASP.NET being the platform I’m concentrating on right now. If you’re comfortable reviewing C# code, building small modules, or advising on best practices inside Visual Studio, that will make collaboration much smoother. Typical environment • Windows Server, SQL Server, and Hyper-V • Mix of Cisco and MikroTik devices • Visual Studio, Git, and IIS for deployments Deliverables I expect • A clear action plan for stabilizing and optimizing the network • Hands-on configuration or remote guidance to implement that plan • Occasional code reviews or lightweight feature work in ASP.NET (as task...

...looking for a Technical Project Manager + Developer (or a small, tight-knit agency) to build our new volunteer management web platform. We have an existing WordPress website that serves as our public-facing marketing and intake site, and an existing SQL database on our VPS that contains all our current volunteer, homeowner, and request data. We are building a custom mobile-responsive web application to handle the complex logistics of volunteering. Note on Infrastructure: We are NOT using Supabase. Our backend already exists—we have a production SQL database with live data. The new platform will connect to this existing database via a Node.js/Express API layer on our VPS. If you see Supabase mentioned in older planning documents, please disregard. We need someone comf...

...You’ll team up with me (the engineering manager) to design brand-new reports and tighten the data plumbing behind them. Here’s the landscape • Data source: Electronic Health Records flowing from our SQL-backed warehouse. • Targets: Resource management and clinical operations KPIs that our nursing leads review daily. • Core ask: create fresh, insight-rich visuals while improving the SQL queries and data model that feed them. Deliverables - At least three new Power BI dashboards, each centred on an agreed resource or clinical metric, ready for stakeholder sign-off. - Optimised SQL scripts and refreshed integration steps, documented and checked into our Git repo. - A short hand-over guide so internal analysts can extend your wor...

...feedback score and prompt payment. ************************************************************************************************** Project description : I want a PHP Application written. The application should allow me to call a URL Details are in the attached Powerpoint and PDF file (open either one) We will provide the winning bidder with webspace for hosting the code files, and My SQL space for the databases Please proceed with reading further, only if you are willing to work hard and devote time to complete the task correctly, and have 2 hours free right now. What we are looking for - Your ideal skills and experience: - Strong experience in PHP coding and building customer-facing applications - Excellent attention to detail - Ability to work efficiently and meet ...

...provision and configure a fresh Azure SQL Database for my current website code. Right now the site runs on a regular SQL Server instance; I’m unsure whether the existing data must be moved or recreated, so I’ll look to you for guidance on the most reliable path forward. The database’s role is straightforward—solid, fast data storage and retrieval for a live production app. You’ll handle the full setup inside the Azure portal, set the correct performance tier, secure it with firewall rules and proper authentication, generate the connection string, and make sure the site connects without hiccups. If we do identify an existing database worth migrating, you’ll take charge of exporting, importing, and validating the data. Deliverables will ...

Metto a tua disposizione i file grezzi con vendite, spese, clienti e traffico social; sono dati eterogenei e in parte dis...normalizzazione dei dataset esistenti, mantenendo coerenza tra fonti online e offline. • Integrazione dei dati cliente per generare una vista unificata. • Individuazione di pattern d’acquisto ricorrenti, fasce orarie e canali preferiti. • Report visivo (dashboard o slide) con insight chiave, metriche e trend. • Raccomandazioni operative basate sui risultati. Puoi utilizzare Excel, Google Sheets, SQL, Python (pandas) o strumenti BI come Power BI/Tableau: scelgo la soluzione che ti è più comoda purché il risultato sia chiaro e verificabile. Consegna attesa: file puliti, script o macro usati, report finale...

I need a seasoned accountant who has already completed at least one full-scale au...methodology Acceptance criteria • Every transaction on every statement is matched or clearly explained • All variance explanations are backed by documentary proof • Final report is formatted so that legal counsel can file it without additional editing Please cite at least one previous Chase audit you have completed and the tools you used—e.g., QuickBooks, Sage, IDEA, ACL, or a custom SQL workflow. Familiarity with Chase’s download quirks, statement structures, and cutoff times is essential. Make your that you audit will be successful against the bank defenses in front of a judge in court. No need to appear in court if your audit is comprehensive and meets the a...

Requirement: Pre-Built Indian Payroll & Compliance HRMS (React + .NET Core Only) We are looking for a ready-made / pre-built HRMS application with Indian Payroll and Statutory Compliance, developed strictly in React (frontend) and .NET Core (backend). Mandatory Technical Stack Frontend: React.js Backend: .NET Core (API-based architecture) Database: SQL Server / PostgreSQL Deployment: Cloud-ready (Azure / AWS preferred) Mandatory Pre-Built Functional Modules The application must already be developed and running. We are NOT looking for fresh development or starting from scratch. 1. Payroll (India Specific – Pre-Built) Salary structure configuration Monthly payroll processing Payslip generation PF (EPFO) calculation ESI calculation Professional Tax TDS calcul...

I need an SSIS project to run a complex SQL query across multiple SQL servers, all within the same network. The goal is to aggregate results from these servers. Key Requirements: - Develop an SSIS package to execute the SQL query. - Ensure efficient aggregation of results. - Provide error handling and logging mechanisms. Ideal Skills: - Proficiency in SQL Server and SSIS. - Experience with complex SQL queries. - Strong understanding of data aggregation techniques.

I want to sharpen my SQL abilities with a structured, hands-on approach inside Google BigQuery. My current priority is data querying and retrieval, specifically: • Basic SELECT statements • Join operations • Aggregate functions with GROUP BY I’d like a mentor who can demonstrate each concept directly in BigQuery, assign short practice tasks, and review my work so I see where to improve. Explanations should stay clear and practical, gradually adding optimisation tips and BigQuery-specific features once the core techniques sink in. By the end of our time together I should be able to write clean SELECTs, build reliable joins, summarise data confidently, and understand how query plans reveal efficiency issues. A small set of completed exercises stored in a ...

I already have a stable Android code-base written in mixed Java / Kotlin that targets an offline-first workflow (SQLite locally, SQL Server remotely) and exchanges data through FTP-triggered PHP/HTTP scripts. The project sits on a legacy Gradle 4 stack, and I use a separate C# utility to pre-seed the local database before each release. What I need now is a senior-level pair of hands to take full ownership of the end-to-end APK generation cycle. All SDKs, NDKs, keystores, and signing configs are present on my machine; the environment is ready—you simply step in, run the build, and hand back repeatable output. Scope of work • Pull the existing repository, resolve any Gradle-4 quirks, and confirm the build variants compile cleanly. • Produce a signed, installable ...

I need an engaging Power BI dashboard focused exclusively on sales analysis, with a single, crystal-clear objective: show our sales growth over time at a glance. All raw data will come to you as CSV files—I’m not connecting to a SQL database or an online CRM for this project—so please be comfortable working with flat-file sources and building robust, refreshable data models around them. The finished dashboard should allow me to: • upload or replace new CSV exports without breaking visuals, • track month-over-month and year-over-year growth, and • slice results by any standard dimensions already present in the files (product, region, rep, etc.). Deliverables 1. A fully interactive .pbix file with clean, well-labeled visuals and measures. 2...

I HAVE A WEB APPLICATION MADE IN REACT JS , NODE JS AND POSTGREY SQL . I WANT IT THOUROUGHLY TESTED BY AN EXPERT .

...case Establish conventions: folder structure, partitioning strategy, naming, table registration, and schemas Ingestion (Raw/Landing) Build repeatable ingestion patterns into S3 Set up Glue Data Catalog assets and crawlers as appropriate Ensure ingestion is auditable (run logs, basic data quality checks, and schema change approach) Transformations Implement transformations (Glue / Spark / SQL) into curated tables Produce analytics-ready datasets with agreed-upon business logic Optimize for performance: partitions, file sizing, and query cost control Orchestration / Reliability Implement a reliable scheduling/orchestration approach (recommend best fit: Glue workflows, Step Functions, MWAA/Airflow, etc.) Add a monitoring/alerting strategy appropriate for a small team (Cl...

Будь ласка, зареєструйтесь або увійдіть в систему для перегляду деталей.

...user interface. The Power BI dashboards will consume data from an external Azure SQL Database, not from the Odoo database. The solution must provide a seamless and secure embedded analytics experience inside Odoo while maintaining clean separation between operational data and reporting data. High-quality documentation and long-term maintainability are essential for this project. Scope of Work Design and develop a custom module for Odoo Enterprise (self-hosted). Embed Power BI dashboards within Odoo views (menu items and dashboard pages). Implement secure Power BI embedding using supported authentication methods (e.g. service principal or delegated access). Configure the Power BI dataset to use Azure SQL as the external data source. Manage tokens, secrets, and confi...

My website needs a thorough security health-check. I want an ethical hacker to attempt real-world attacks, document every weakness, and explain how to close the gaps. Standard black-box and grey-box techniques are welcome, and I expect coverage of common web threats—SQL Injection, XSS, broken authentication, misconfigured headers, insecure direct object references, and anything else you uncover. Please probe the live production instance (no staging mirror is available), but keep service disruption to an absolute minimum and notify me immediately if you hit a critical point where downtime is possible. Burp Suite, OWASP ZAP, SQLMap, Nikto, Nmap, or your preferred toolset are all fine as long as your methodology aligns with OWASP Top 10 and produces reproducible results. Delive...

I'm seeking an AI and automation expert to integrate our Primavera ERP system with SQL for the purpose of automating financial reporting. The key goal is to streamline and automate the generation of the following financial reports: - Balance sheets - Profit and loss statements - Cash flow statements - Budget reports Ideal candidates should have: - Proven experience with Primavera ERP and SQL - Strong background in financial reporting automation - Familiarity with AI tools and automation processes - Excellent problem-solving skills and attention to detail Please provide relevant work experience and examples.

...without further edits. On the SQL side, the schema is sketched but not finalized. I still need the tables normalised, primary and foreign keys confirmed, and any lookup tables added where they make sense. After that, I’ll need production-ready scripts that cover: • well-structured SELECT statements for the main dashboard views • INSERT, UPDATE and DELETE queries to handle routine maintenance Please deliver: 1. The cleaned, fully-formatted Excel file with all requested charts in place. 2. A .sql file (or equivalent) containing the final schema plus the tested queries. 3. A brief read-me so I know how to run everything end-to-end. If you’re comfortable jumping between Microsoft Excel and a standard relational engine (MySQL, PostgreSQL o...

I need a clean, reliable dataset covering sea-freight export shipments connected to Europe. The file ...connected to Europe. The file should let me drill down by shipper, consignee, departure and arrival ports, HS code (or at least a descriptive commodity field), weight/volume, value and sailing date. A recent two-year window is ideal, but if you can provide a longer back-history please flag that in your bid. Preferred format is CSV or Excel so I can load it straight into Power BI for analysis, but SQL dumps or well-structured APIs are fine too as long as you document the schema. Before delivery, please share a short sample so I can verify field layout and data freshness. Final acceptance happens once I can reproduce the sample queries on the full dataset without missing or corrup...

I’m putting together a full-stack solution in .NET Core 8.0 (Razor Pages) backed by SQL Server that will let me run every key pharmacy workflow from one browser tab. The build must open with a secure, role-based login and carry me straight into a lightning-fast POS screen. Transactions have to feel instant, accept barcode lookups later on, and finish with a clean PDF or thermal invoice in a click. Behind the counter, I want real-time visibility of every box on the shelf. Stock levels should refresh the moment a sale is posted, warn when minimum quantity is reached, and highlight anything creeping toward its expiry date. When items actually cross that line, automatic write-offs—or at least prominent alerts—are essential. Reporting comes next: daily sales summari...

1. change Admin login email id 2. OTP enter screen can show only numeric keypad. 3. Driver can see their earning reports. 4. when passanger book ride then he can show drivers coming movement on map 5. Refer and earn need to share on whatsup 6. driver get weekly reward bonus they can withdraw. 7. Driver get whats up notification for updates. 8. Driver can login using registered mobil... can update it later 10. admin can update reward and bonus amount 11. admin can check and verify driver documents then approve for using app 12. admin can set commision structure differernt for bike,cab etc. 13. admin dashboard need to update properly data display in real time 14. admin can see and check driver documents and allow access as a driver 15. Change Postgres to Microsoft SQL

...BI specialist to turn raw customer data into clear, interactive reports that I can explore without leaving the Power BI environment. The job centers on custom reporting, so the emphasis is on shaping the data model, writing efficient DAX, and presenting insights in a way that lets me drill into any customer-related metric in seconds. My source files arrive as CSV exports and occasionally direct SQL pulls. You’ll determine whether a simple star schema or further normalization is best, build it in Power Query, then craft the DAX measures that power the visuals. Accuracy and refresh speed are critical; visuals only matter once the numbers are right. Deliverables • A fully documented .pbix file ready for publishing, containing the refined data model, all DAX measures, an...

...BI specialist to turn raw customer data into clear, interactive reports that I can explore without leaving the Power BI environment. The job centers on custom reporting, so the emphasis is on shaping the data model, writing efficient DAX, and presenting insights in a way that lets me drill into any customer-related metric in seconds. My source files arrive as CSV exports and occasionally direct SQL pulls. You’ll determine whether a simple star schema or further normalization is best, build it in Power Query, then craft the DAX measures that power the visuals. Accuracy and refresh speed are critical; visuals only matter once the numbers are right. Deliverables • A fully documented .pbix file ready for publishing, containing the refined data model, all DAX measures, an...

Required Skills - Strong hands-on coding experience (professional or research-based) in one or more of the following: Python JavaScript / Node.js TypeScript - Experience with additional languages is a plus, including: Go, Java, C++, C#, Rust, SQL, R, Dart, or similar - Solid experience with Linux environments, Bash scripting, and automation - Strong knowledge of Docker, reproducible environments, and development containers - Advanced Git skills, including: Branching strategies Diffs and patches Conflict resolution

...applications to modern .NET Core/ .NET 8+ environments, optimizing for cloud readiness. Frontend Development: Architect and develop responsive, component-based UIs using React 18/19 and modern state management (Redux Toolkit, Zustand). API Design: Build and maintain scalable RESTful APIs and microservices using C# and ASP.NET Core. Database Management: Perform data modeling and performance tuning for SQL Server and Entity Framework Core. Code Quality: Conduct deep-dive code reviews, implement unit testing (xUnit/NUnit), and ensure high standards of maintainability. Collaboration: Work directly with the project owner to translate business requirements into technical execution plans....

I already own the full source code for a Satta Matka Android application, its Laravel-based admin panel and the accompanying REST API. What I need now is someone who can take all of that and make it run flawlessly on my own VPS. You will receive: • the Android Studio project (Java/Kotlin) • admin panel files • SQL dump and environment variables • brief setup notes from the previous developer Your job is to: 1. Spin everything up on my VPS (Ubuntu 22.04 with root access; I can switch distro if you prefer). 2. Configure the web server stack (Nginx or Apache, PHP-FPM, MySQL/PostgreSQL as required by the code). 3. Secure the installation with HTTPS (Let’s Encrypt is fine), a properly-hardened firewall, basic intrusion-prevention rules and upda...

...Experience and Skills sections re-worked so recruiters immediately see me as a strong analytical hire. Here’s what you’ll be working with • Hands-on background in Hadoop administration, PySpark development, Databricks workflows and day-to-day data analysis. • A solid foundation in SQL and reporting tools, though these strengths are not highlighted well in the document. What I’m after • Rewrite both sections to spotlight analytical impact, business-friendly storytelling and in-demand keywords (think SQL, dashboards, data visualization, statistical insight, KPI tracking, etc.). • Re-order bullet points around results, not tasks, and translate engineering jargon into analyst language. • Optimise for common ATS scans while...

...joins coming from our relational sources (mostly SQL Server and a few MySQL tables) so customer-segmentation views report accurately. Once the joins are solid, I want the key dashboards redesigned for clarity and consistency - think clear cohort break-downs, fast filtering and performance that holds up as the data grows. After the rebuild, I’ll rely on you to bring our team members up to speed so they can own day-to-day Tableau management. A short, hands-on training program with step-by-step documentation will be essential. Specific milestones we’ll work through: • Review existing workbooks, map current joins to business rules, and deliver a gap report • Re-engineer data sources and relationships in Tableau (and, where needed, back in SQL...

... Backend • Symfony + Doctrine ORM expose a JSON-based REST API. • Endpoints must return instant, prefix matches while a user is typing either a code, an industry name or any text found in the descriptions. Frontend • Another Symfony app (no direct DB access) calls the API only. • A single screen with a search box and auto-complete dropdown is enough for the demo. Deliverables 1. SQL dump (or migrations) that creates and populates the normalised schema. 2. Source code for both Symfony projects, clearly separated. 3. README with setup instructions and examples of API calls. If you already know the quirks of NAICS, NACE and ISIC and have paired Symfony with Doctrine before, this should feel straightforward. If you have never worked with NA...

Do not apply for this project if: a) you are not experi...reachable (video conference) during the working time Job description ------------------------- Full-Stack Development: Designing, developing front-end (UI) components. DevExpress UI Implementation: Using DevExpress controls (for Blazor, ASP.NET Core) to create complex UIs like data grids and charts. C#/.NET Expertise: Developing server-side logic, services Database Interaction: Working with SQL databases (SQL Server 2025) for data management. API Integration: Connecting front-end components with back-end services via REST. For software houses: a) we do not give access to our live data b) we do not export our database schema c) we do not export our source code (debug and runtime environments only available on our loca...

...Azure SQL Database and I need its contents restored onto my own SQL Server 2019 instance so I can run day-to-day transactional queries locally. The job covers the full extraction from Azure, transfer, and successful restore or import into my on-prem/VM SQL Server 2019 environment. Focus • Use whichever method you find most reliable—native backup, BACPAC/DACPAC, Azure Data Factory, SSMS Import/Export—so long as every row and relationship arrives intact. • The restored copy must open in Management Studio 18+ with all tables, primary/foreign keys, and constraints ready for immediate SELECT/INSERT/UPDATE activity. • I do not need special Azure-side configurations preserved; the priority is simply accessing the transactional data without...

Write a working example of a login/logout and user management functionality using Python, FastApi, and Postgres/SQL Alchemy that can seamlessly integrate into an existing web application. Including a login landing page. Must use the Fastapi-users library. All accounts should be created and managed by an admin. No user registration or password reset functionalities will be needed. More details: What type of authentication do you need for your system? Basic Auth Should users be able to sign up with their email and password? No What is the primary method users will use to log in? Single Sign-On (SSO)

...into our SQL Server tables. A new provider has come on-board and they expose their transaction feed only as a downloadable CSV, so I need one more API written that behaves just like the others. The job is straightforward: fetch the CSV transaction data, map its columns to the existing table structure, and insert each record without any extra transformation—same values in, same values out. The authentication method is a simple token in the request header; I will supply test credentials and the schema of the target tables. You are free to use your preferred stack (our other services are a mix of .NET and Python), but the finished service must: • Retrieve the CSV on a scheduled or on-demand call • Parse the file reliably, handling edge-cases such as commas in te...

I need our existing database portal to gain a simple “Export” button that lets me pull user data straight into both CSV and Excel formats. The export should all fields on the internal portal. The database is with SQL.. Once generated, the files must download instantly to the browser—no email sends or cloud hand-offs. Key deliverables • Add front-end control to trigger the export • Server-side code that queries the user table, extracts those three columns, and streams the result as CSV and .xlsx • Basic success / error messaging and a quick read-me so my in-house dev can maintain it I’ll provide portal access and a staging database as soon as we start, and I’m happy to clarify table names or column mappings. Looking forward to a cl...

MuleSoft Integration Developer (VS Code) – SAP RFC/BAPI + SQL Server (Secure Credentials) Hola, Estoy buscando un freelance con experiencia en MuleSoft para desarrollar una integración tipo API-led connectivity (Process API + System APIs) que ejecute un RFC/BAPI sincrónico en SAP y luego inserte / ejecute procedimiento en SQL Server. Requisitos clave Desarrollo en Mule 4 Trabajo 100% en Visual Studio Code (NO Anypoint Studio) Uso de DataWeave para transformaciones Experiencia real integrando SAP RFC/BAPI Experiencia integrando SQL Server (insert / stored procedure) Buen manejo de errores + logging + trazabilidad Scope / Flow (End-to-End) Process API is triggered Transform Message (prepare payload for RFC Call – BAPI) Process API ca...

J’ai une série ...d’amélioration. Je souhaite recevoir : • un onglet ou fichier propre avec les données vérifiées et mises en forme, • un tableau de bord (Google Sheets ou Data Studio) présentant les indicateurs clés, • un court rapport (PDF ou Docs) synthétisant vos observations et recommandations. L’accès se fera via un lien Google Sheets partagé ; vous pouvez, si besoin, exporter sous Excel ou traiter en Python/SQL tant que le livrable final reste lisible dans Google Sheets. Les chiffres doivent être présentés de façon compréhensible pour un débutant en analyse, avec visuels simples (graphiques de ventes, courbes de tendance). Merc...

I’m ready to overhaul the way our team looks at data and need a developer who can take ownership of the full MS SQL-to-Power BI pipeline. The end goal is clear: deliver rock–solid data analytics that put timely, actionable Sales insights in front of our stakeholders. You’ll start by refining and expanding our MS SQL Server environment—creating or tuning tables, views, stored procedures, and functions so queries run quickly even on very large fact tables. From there, design a star or snowflake model that makes sense for reporting, then build the ETL logic to keep it populated and up to date. Our source of truth is MS SQL Server, and the semantic layer will live in Power BI; if you’re comfortable incorporating other sources such as flat fil...