Sql add decimal query oracle jobs

...you open it you’ll see the full layout I have in mind—sales metrics, cohort analysis, retention curves, all mapped to specific chart types. Here’s what I need from you after reviewing the file: • Write the SQL that structures the data exactly as outlined, ready for visualisation. • Build the interactive dashboard in the BI tool you feel most comfortable with (Tableau, Power BI, or a Python framework). • Make sure the three questions inside the brief are answered clearly through the visuals and any supporting calculations. • Hand over the final dashboard file and the annotated SQL so I can refresh it with new data at any time. If the spec makes immediate sense and you can already picture the charts and logic, send me a quick DM...

...Formula errors scattered across several interconnected sheets (the standard #VALUE!, #REF!, or similar messages pop up in different places). • Data validation that no longer stops incorrect data entries, allowing wrong codes and inconsistent formats to slip in. You are free to use whichever method you trust—formula auditing tools, error-checking rules, VBA snippets for quicker tracing, Power Query for reshaping data—so long as the end result is a clean, reliable workbook. Deliverables • Revised workbook with all formulas producing correct results • Re-implemented data validation rules that prevent incorrect entries • A short change log highlighting what was fixed and why Once those items are in place, I’ll run a quick test with my ...

...management, form filing, and all types of new incorporations. Who the leads must fit • Client profile: small businesses and startups headquartered anywhere in India • Intent: demonstrably interested in the above services (e.g., asking questions online, searching specific terms, downloading related checklists) • Data fields required: contact name, direct phone, email, city/state, and the exact query or keyword that captured their interest Preferred acquisition channel Search Engine Optimization is my primary focus. You should already have proven tactics for ranking service pages, publishing keyword-rich content, and capturing high-intent visitors via landing pages or forms. If you can amplify results with supporting methods (content clusters, local SEO, lo...

OCI L3 / Technical Lead Client: Indian/Bank Location: Mumbai (On-site) Model: 24x We want a professional who has worked Oracle Cloud Infrastructure on immediate basis as we have a project to offer on urgent basis Key Responsibilities: - Act as the final escalation point (L3) for critical OCI incidents and complex issues. - Design HA/DR architectures, landing zones, IAM strategies, and network frameworks. - Lead security, compliance, and cloud governance initiatives. - Drive performance tuning, observability, and cost optimization (FinOps). - Lead cloud migration and modernization programs. - Mentor L1/L2 engineers and collaborate with cross-functional teams. Qualifications: 5 years in cloud/infrastructure engineering, with at least 4 years of hands-on experience w...

...visitors and route qualified leads into HubSpot - Build the bridge between anonymous traffic and known contacts **AI-Native Reporting & Workflow** - We run lean and move fast because we use AI tools — particularly Claude — as a daily extension of our team. You'll be expected to do the same. - You should be fluent in using Claude with HubSpot's MCP (Model Context Protocol) connector to pull reports, query contact and deal data, and surface insights in minutes instead of building a report from scratch each time - You'll use Claude to draft workflow logic, debug tracking issues, summarize campaign performance, and accelerate the operational work — not to replace your judgment, but to multiply your output - If you've never used Claude with M...

...mentions: * pricing assumptions * adoption pathways * investment scenarios * market demand So your model may include: Revenue Forecast Example: Revenue = Price times Demand Growth Forecast Future Value = Present Value times (1+r)^n NPV / Investment Analysis NPV = sum frac{CF_t}{(1+r)^t} Adoption Curve Could include: * Linear growth * Logistic adoption * CAGR-based scaling ⸻ 4. Add Scenario & Sensitivity Analysis This is one of the most important parts. Build: * Base case * Optimistic case * Conservative case Use: * Excel Data Tables * Scenario Manager * Dynamic dropdown selectors Example: Variable Base High Low Carbon Price 50 80 30 Adoption Rate 10% 18% 5% Then connect all outputs dynamically. ⸻ 5. Automate with VBA / Macros Use VBA onl...

...mentions: * pricing assumptions * adoption pathways * investment scenarios * market demand So your model may include: Revenue Forecast Example: Revenue = Price times Demand Growth Forecast Future Value = Present Value times (1+r)^n NPV / Investment Analysis NPV = sum frac{CF_t}{(1+r)^t} Adoption Curve Could include: * Linear growth * Logistic adoption * CAGR-based scaling ⸻ 4. Add Scenario & Sensitivity Analysis This is one of the most important parts. Build: * Base case * Optimistic case * Conservative case Use: * Excel Data Tables * Scenario Manager * Dynamic dropdown selectors Example: Variable Base High Low Carbon Price 50 80 30 Adoption Rate 10% 18% 5% Then connect all outputs dynamically. ⸻ 5. Automate with VBA / Macros Use VBA onl...

I'm seeking an experienced Node.js backend developer for my multi-vendor Flutter project. Key Requirements: - Core Functionality: Product listing and management - Existing SQL-based database for product management Ideal Skills & Experience: - Strong expertise in Node.js - Experience with SQL databases - Background in building backend for multi-vendor applications - Familiarity with Flutter is a plus - Ability to create scalable and efficient APIs Please provide relevant experience in your bids.

...values, eliminated duplicates, and standardized data formats for downstream consumption. Scalable ETL Processing (PySpark): * Leveraged PySpark to process and transform large-scale datasets efficiently, optimizing partition strategies to reduce execution time. Executed complex business logic, aggregations, and data joins across massive distributed data frames. Hybrid Data Storage (PL/SQL & MongoDB): Relational (PL/SQL): Designed relational schemas, wrote optimized stored procedures, triggers, and complex analytical queries to manage structured transactional data. NoSQL (MongoDB): Handled semi-structured and unstructured data elements, managing high-throughput document storage with optimized indexing for fast retrieval. Business Intelligence & Insights (Power BI): *...

...mentions: * pricing assumptions * adoption pathways * investment scenarios * market demand So your model may include: Revenue Forecast Example: Revenue = Price times Demand Growth Forecast Future Value = Present Value times (1+r)^n NPV / Investment Analysis NPV = sum frac{CF_t}{(1+r)^t} Adoption Curve Could include: * Linear growth * Logistic adoption * CAGR-based scaling ⸻ 4. Add Scenario & Sensitivity Analysis This is one of the most important parts. Build: * Base case * Optimistic case * Conservative case Use: * Excel Data Tables * Scenario Manager * Dynamic dropdown selectors Example: Variable Base High Low Carbon Price 50 80 30 Adoption Rate 10% 18% 5% Then connect all outputs dynamically. ⸻ 5. Automate with VBA / Macros Use VBA onl...

...Compliance / Industry Knowledge Developer should understand or research: Australian fuel industry SIRA methodology EPA compliance requirements Underground Petroleum Storage Systems (UPSS) Fuel inventory reconciliation Preferred Experience Experience building: Fuel management software Environmental compliance systems Data analytics dashboards SaaS platforms Experience with: React / Node.js / Python SQL databases Dashboard UI/UX API integrations Deliverables Full software platform Source code ownership Admin dashboard Reporting module Deployment assistance Ongoing support option To Apply Please Provide Examples of similar software/projects Proposed tech stack Estimated timeframe Estimated budget Team size Important Only apply if you have experience building business software, an...

...an upcoming paper. You’ll receive the cleaned, anonymised transcripts as Word files. I’d like you to: • Import and organise the sources in NVivo. • Develop an initial codebook (inductive or deductive—whichever best fits the material) and refine it as you progress. • Apply systematic coding throughout all 25 interviews, ensuring consistency across cases. • Generate clear visualisations or query outputs (e.g., word trees, matrix coding) that illuminate behavioural themes. • Provide a concise analytic memo summarising each major theme, illustrative quotes, and your interpretation of how these patterns interact. Deliverables 1. The complete NVivo project file with all nodes, classifications, and queries intact. 2. A short (&as...

...shortages instantly. No additional metrics are necessary for now; the focus is purely on accurate, real-time stock visibility. Deliverables: • One Excel workbook containing the finalized pivot table, formatted for quick reading • Clear, step-by-step notes (inside the file or in a short README) explaining how to refresh the data and expand or collapse product categories If you prefer Power Query, slicers, or any other native Excel tools to streamline the process, feel free to integrate them as long as the final result remains user-friendly....

...immediately after migration. Scope of Work: • Analyze the existing ASP.NET Framework 4.8 solution • Migrate the application to ASP.NET Core (Razor Views or Razor Pages as appropriate) • Rebuild controllers, routing, and UI structure • Update configuration files (appsettings, dependencies, etc.) • Replace or upgrade outdated third-party packages • Ensure database compatibility and data integrity (SQL Server) • Maintain all existing business logic and features • Improve performance and security where possible • Ensure full build, run, and publish readiness • Provide clean and structured codebase following best practices The goal is a production-ready solution that can be cloned, built, and deployed without errors. Timeline: Estim...

Project Title: Build TallyPrime Integration Bridge Application with SQL Server ERP Project Description: We are looking for an experienced developer to build a bi-directional bridge application between our SQL Server-based ERP software and TallyPrime. The application should enable seamless two-way data synchronization between our ERP database and Tally. Requirements: 1. ERP to Tally Sync The application should push data from our SQL Server ERP to Tally, including: Sales vouchers Purchase vouchers Credit notes / Debit notes Ledger creation Item master synchronization Customer/vendor master data 2. Tally to ERP Sync The application should fetch data from Tally into our software, including: Bank receipt entries Payment vouchers Journal entries Ledger updates Voucher update...

I need a clean Postfix installation configured to handle both outgoing and incoming mail. All account, alias, and domain information must live in PostgreSQL, so the build has to include the proper SQL maps and permissions from the start. My goals are straightforward: – Mail flows reliably in both directions. – TLS is enforced for all SMTP traffic. – Users authenticate against the PostgreSQL-backed tables. – Standard anti-spam and DKIM/SPF records are in place so messages land in the inbox, not junk. You are free to choose the Linux distribution you’re most comfortable with, but please document every package, file path, and command so I can replicate the setup later if needed. Once the server passes basic send/receive, DKIM/SPF, and relay-restriction t...

...requirements and translate them into technical solutions Enable and support advanced analytics or AI use cases (forecasting, predictive insights, etc.) Document processes, data models, and workflows Required Skills Strong experience with: Power BI (Data modelling, DAX, visualization) Power Automate (workflow automation, system integrations) Solid understanding of data warehousing concepts Experience with SQL and data transformation tools Ability to handle end-to-end data projects independently Strong analytical and problem-solving skills Preferred Qualifications Experience with Microsoft Dynamics 365 Business Central Exposure to: Azure Data Services (Data Factory, Synapse, etc.) AI/ML integration or advanced analytics layer Familiarity with APIs and system integrations Experien...

I need an all-in-one AI Agent that becomes the intelligent front line for my brand. Its primary function is exactly that—an AI Agent—capable of shifting seamlessly between customer support, sales and marketing conversations without feeling like three sep...• Training scripts / datasets aligned with my brand voice • Integration code and webhook/ API documentation • Admin dashboard or reports covering inquiry types, lead scores and user-data insights • A short video walkthrough plus written hand-off instructions so my team can adjust intents or flows without coding Acceptance criteria: live end-to-end demo showing the agent solving a support query, capturing a lead, and writing data back to the CRM; average response time under three seconds; anal...

...mentions: * pricing assumptions * adoption pathways * investment scenarios * market demand So your model may include: Revenue Forecast Example: Revenue = Price times Demand Growth Forecast Future Value = Present Value times (1+r)^n NPV / Investment Analysis NPV = sum frac{CF_t}{(1+r)^t} Adoption Curve Could include: * Linear growth * Logistic adoption * CAGR-based scaling ⸻ 4. Add Scenario & Sensitivity Analysis This is one of the most important parts. Build: * Base case * Optimistic case * Conservative case Use: * Excel Data Tables * Scenario Manager * Dynamic dropdown selectors Example: Variable Base High Low Carbon Price 50 80 30 Adoption Rate 10% 18% 5% Then connect all outputs dynamically. ⸻ 5. Automate with VBA / Macros Use VBA onl...

...AI-controlled traffic that obeys signals, yields and reacts believably to the player. • Introduce interactive NPCs specifically themed as other delivery drivers. These NPCs must follow their own delivery routes, compete for pickups, and trigger contextual dialogues or mini-events when players cross paths. • Provide hooks (JavaScript events or REST/WebSocket calls) so my existing gameplay code can query traffic density, spawn or despawn NPC drivers, and read basic state like location or speed. • Supply cleanly organised project files, commented source, and a short setup document so future updates—warehouses, seasonal events, city expansion—slot in smoothly. Acceptance criteria 1. Initial city scene loads in under 6 seconds on a typical 4G connec...

I want to launch a dedicated website that proclaims the message of Jesus Christ to all mankind, and I need it online as quickly as possible. The site has to let me publish frequent text reflections, high-quality images, and inspiring...and an SSL certificate should be in place from day one. Deliverables I’ll review for sign-off • Fully responsive website, live on my chosen domain • CMS credentials with clear instructions for posting text, images, and videos • Image sitemap submitted and indexed in Google Search Console • At least one sample post showing correctly optimised images that appear when I do a Google Images query for the file name If you have a proven track record in fast website roll-outs and SEO that gets images indexed quickly, I&rsqu...

I run an established RP digital-signage and appointment-booking platform and now want to bolt on an AI agent. The agent must combine predictive analysis with voice recognition so users can simply speak to: • schedule appointments • retrieve real-time information • receive basic customer support Your task is to create thorough, developer-ready documentation that shows exactly how to weave this agent into the current stack. I’m looking for a pragmatic, no-fluff guide that covers architecture, data flow, API touchpoints, error handling, and security considerations so my in-house team can implement the integration without guesswork. Acceptance criteria 1. High-level architecture diagram illustrating where the AI layer sits alongside our signage and booking modul...

I have been running my team’s data from a single Excel workbook for seasons now—minutes playe...new player is added, they should slot straight into the tables without manual tinkering. Once the data flows automatically, I’d like dynamic charts that reshape themselves on-the-fly. For example, selecting a player from a drop-down should redraw a trend line of their minutes per game; choosing a competition should flip the dashboard to that league’s standings. Slicers, pivot charts, or Power Query—whatever does the job cleanly inside Excel is fine. Because this is time-sensitive, I’m hoping to move quickly. If you can show past work where you’ve automated sports (or similarly stat-heavy) spreadsheets and built interactive dashboards in Exce...

...and any future rule we add—then flag risks before they become violations. Core functions I must see from day one: • Real-time alerts: instant email/SMS or in-app notifications the moment a threshold is breached or a document nears expiry. • Compliance reporting: on-demand and scheduled PDF/Excel outputs that summarise status by property, rule category, and time period. Charts and colour-coded heat maps are welcome if they stay clear and printable. • Document management: secure upload, OCR tagging, expiry reminders, and easy retrieval for audits (drag-and-drop interface preferred). Tech stack is your choice as long as it is mainstream, maintainable, and browser-based—think React, Vue, or Angular on the front end; Node, Django, or Laravel on the ...

...75-query taxonomy All six API keys, provisioned and shared via 1Password Sample completed scans for reference Direct Slack access to the project lead Timeline and process 10 business days from kickoff to delivery Fixed price, paid in three milestones (30% / 40% / 30%) $500 bonus if delivered on or before business day 8 Daily commits to the repo required Weekly Friday sync at 10am ET Mutual NDA signed before access to query taxonomy Required skills 5+ years Python with strong asyncio experience Hands-on experience with at least 3 of: OpenAI API, Anthropic API, Perplexity Sonar API, Google Gemini API, xAI Grok API, SerpAPI openpyxl for Excel manipulation Streamlit for UI Google Cloud OAuth for Drive integration Slack API for notifications Strong Git/GitHub workflow Out ...

I have a beautiful, high-resolution family shot that’s missing one important person—my husband. I’d like a skilled Photoshop pro to blend him in naturally so the final image feels as if he were there all along. The original group photo is sharp and well-lit, and the picture I have of him is a candid, so careful color-matching, lighting adjustment, and shadow work will be key to making the merge believable. Because this is meant as a family keepsake, subtlety matters more than flashy effects; skin tones, perspective, and texture all need to align perfectly. Please deliver: • A flattened, print-ready JPEG (minimum the same resolution as the source image) • A layered PSD so I can make minor tweaks in the future if needed If you’ve handled similar com...

I want a clean, Excel-based MIS solution that turns raw inventory data into actionable insight. The report must surface: • Product movement (inbound, outbound, returns, ageing trends) • Supplier details (lead times, performance, cost variances) Everything should refresh with a single click, so feel free to rely on pivot tables, Power Query, dynamic arrays, or lightweight VBA if it streamlines the process. Formatting has to be clear enough for non-technical managers to read at a glance, yet detailed enough for the warehouse team to drill down when they need specifics. Your proposal should focus on your experience building similar inventory dashboards in Excel—screenshots or brief descriptions of past work are welcome. Once I share the raw data structure, I’...

I have a collection of PDFs with tables that need to end up in a clean, well-structured Excel workbo...• Accurate extraction of every table, regardless of layout changes. • A single Excel (.xlsx) file with each source PDF represented on a separate sheet, preserving numeric formats and basic styling where possible. • A quick note on any tables that cannot be captured automatically so I can review them manually. I’m open to whatever stack you prefer—Python (pandas, tabula-py, camelot), Power Query, or even a smart VBA solution—as long as the final workbook is reliable and reproducible. When you respond, please include a sample or brief clip from past work that shows you have already tackled inconsistent PDF tables. That reference will help me mov...

...months. We need to act fast. • Language: I do not speak local European languages. The preparation must focus strictly on international companies or tech hubs operating entirely in English. • Experience Level: I have very little professional job experience, but I am targeting entry-level Data Analyst roles. What I need from you: • Framework for Technical Interviews: Help me structure my answers for SQL, Excel, and data visualization (Tableau/Power BI) questions, even with limited experience. • Behavioral & Case Prep: Teach me how to handle business case studies and behavioral questions using the STAR method, tailored to European corporate culture. • Portfolio Review: Quickly review how I present my projects/skills to ensure they stand out to recruiter...

...corners, passes, red cards, and the rest—carries equal weight, so I expect full coverage with high accuracy. Key parsing rules to bake in: home figures must fill the “home_” columns, away figures the “away_” columns; if a stat is missing it should leave a blank cell (but set red-card counts to 0); and composite values like “86% (448/520)” should be broken out into successful, attempted, and a decimal rate (0.86). Because Flashscore is rendered client-side, headless browsing is required—I’m fine with Selenium, Playwright, or any equivalent that you prefer, as long as it is robust. Please make the code clean, reproducible, and well commented. It must run on recent versions of Python and pandas and cope with both desktop and mo...

...training • FI & CO focus: General Ledger Accounting (FI-GL), Cost Center Accounting (CO-OM-CCA) and Internal Orders (CO-OM-OPA). Please walk me through the key tables, field meanings, and the joins typically used for each area. • SQL in Databricks: I can read and write basic queries, but I want to become confident writing production-grade statements, optimising them for performance, and—importantly—prompting Gen AI tools to generate correct SQL from everyday FI/CO terminology. • Dashboard build: show me, step by step, how to turn those queries into a Databricks SQL dashboard designed for financial analysis and reporting. I would like practical examples such as a P&L view, cost-centre variance, and internal-order tracking. De...

Hi, I am a Data Analyst / BI professional with experience in SQL, Power BI, ETL, dashboards, and analytics. I am planning to explore international career opportunities, especially in countries like Australia, Europe, or the Middle East from India I am looking for an experienced career counsellor or recruiter who can guide me with: * International job market for Data Analyst / BI roles * Resume and LinkedIn optimization for overseas jobs * How recruitment works abroad * Countries with better opportunities and visa options * Work visa / sponsorship process * Job application strategy and interview preparation * Networking and recruiter outreach guidance I am mainly looking for consultation and practical guidance from someone who has experience helping IT professionals secure jobs a...

...works this way: using AI to write, scaffold, and review code as a matter of course, not as a novelty. If that's not how you work, this isn't the right contract. The work: Connect mock UIs to live API calls across multiple user dashboards Integrate Clerk authentication with correct role-based access (5+ distinct user personas) Work within an established 16 / TypeScript monorepo (Turborepo) Query and shape data from MongoDB Maintain existing component library (shadcn/ui, Radix UI) You must have: 3+ years writing strict TypeScript, naturally, not reluctantly App Router fluency: RSC, Server Actions, middleware MongoDB: schema design, aggregation pipelines, indexing Auth: JWT, session management, claims-based access control Genuine hands-on AI development experience, Cl...

Role Summary We are seeking a Principal AI Engineer with deep expertise in Generative AI, and Agentic AI systems to lead the design and delivery of scalable, production-grade AI systems. This role require...Gemini, Azure OpenAI). Cloud AI Platforms: Experience with AI/ML services on any major cloud platform (Vertex AI, SageMaker, Azure ML). Preferred Skills Cloud-Native Systems: Experience building scalable systems using Docker, serverless, and managed cloud services. API & Backend Engineering: Experience in API design, development, and lifecycle management. Data & Persistence: Working knowledge of SQL (e.g., PostgreSQL) and NoSQL (e.g., DynamoDB) databases. Technical Leadership: Experience mentoring engineers, reviewing complex designs, and operating in agile, fast-chan...

I have a few Excel workbooks that tracks touch-football match results and player statistics. Before I start deeper analysis, this file needs a thorough review. I have done most of the data cleaning and processing with scripts, but I need help to cross-check the processed data against the source files and fix obvious or hidden errors....franchise (ie. sports teams) files that serve as the source of person stats, which will need to be referenced occasionally for certain errors - Total data to be reviewed spans 5 tournaments Deliverables - Validated Excel files ready for analysis - Flagged rows that were unable to be resolved - A short change log that summarises the key corrections and the rules you applied Feel free to leverage Power Query, formulas, VBA, or AI tools if that speeds ...

...What I need back: • Clean, well-commented VBA modules that automate the full sequence • Error handling so the macro fails gracefully and tells the user what went wrong • A quick read-me inside the code or a short PDF explaining how to trigger and edit the macro I work exclusively in Microsoft 365, so please test on the same version to avoid library conflicts. If you like to leverage Power Query or other native Excel tools as part of the VBA flow, just flag it first—flexibility is fine as long as the final trigger remains VBA-based. Timing is flexible over the next week, but let me know earliest availability and a realistic turnaround once you’ve seen the workbook. If you’ve got examples of prior Excel automation, a quick screenshot or descri...

...app developmentNative and cross-platform solutionsSecond platform app developmentUI/UX designConsulting and prototypingAutomated QA and testingPower managementNotification and geofencingEmbedded Android customizationsMaintenancePost-warranty supportWe use the latest technologies to produce fully-fledged, stable, and scalable mobile applications, including Kotlin, Java, React Native, Flutter, .NET, SQL Server, Azure DevOps, and provide the first week of onboarding at no cost and all our packages can be customized to meet your specific us today to learn more about how we can help you build a cutting-edge, customized solution for your business....

...unrealised profit or loss for every position. Here is what I need built: • A macro, add-in or small script that I can trigger on demand (one click or a shortcut key). • On execution it should fetch the latest CMP for every symbol in the sheet from a reliable source that covers Indian equities. I am open to your guidance on whether that is a free financial API, a paid endpoint, or a lightweight scrape of NSE/BSE data—whichever is stable and within fair usage limits. • Once prices are pulled, the tool writes them into the designated column, updates the P/L calculation for each row (₹ value and percentage), and optionally flags any position whose CMP is at or below the stop-loss. You are free to use VBA, Power Query, Python, or another method tha...

...mentions: * pricing assumptions * adoption pathways * investment scenarios * market demand So your model may include: Revenue Forecast Example: Revenue = Price times Demand Growth Forecast Future Value = Present Value times (1+r)^n NPV / Investment Analysis NPV = sum frac{CF_t}{(1+r)^t} Adoption Curve Could include: * Linear growth * Logistic adoption * CAGR-based scaling ⸻ 4. Add Scenario & Sensitivity Analysis This is one of the most important parts. Build: * Base case * Optimistic case * Conservative case Use: * Excel Data Tables * Scenario Manager * Dynamic dropdown selectors Example: Variable Base High Low Carbon Price 50 80 30 Adoption Rate 10% 18% 5% Then connect all outputs dynamically. ⸻ 5. Automate with VBA / Macros Use VBA onl...

...database export, or a Google Sheets link—so you can work in your tool of choice (Python, R, Excel Power Query, SPSS, etc.). What I need from you: • Clean and structure the data so it is analysis-ready. • Perform a thorough statistical review—frequencies, cross-tabs, correlations, or other techniques you feel reveal the most useful story. • Visualize key findings in easy-to-share charts or dashboards. • Summarize results in plain language, highlighting patterns, surprises, and any recommendations you can confidently draw from the numbers. If you see value in deeper methods such as sentiment scoring or predictive modelling, feel free to suggest them; I am open to approaches that add clarity and depth. Please let me know: – Your ...

...edge materials, textures/graphic overlays, and schedule assignments directly into the Cabinet Vision SQL database. The app should allow the user to enter a material name, board thickness, custom thickness, texture/swatch image, edge thickness, and select which Cabinet Vision schedules the material should be applied to, such as assembly schedules, door schedules, drawer box schedules, and rollout schedules. Once entered, the user clicks a Deploy button and the app writes the required data into SQL. The app must also track all materials it has deployed and include a cleanup function that can safely remove those materials, edge materials, textures, and schedule entries from SQL. Strong SQL Server and Windows desktop application experience is required. Cabinet...

...client-facing tools. What I’m after • Clean, well-documented code that slots straight into an existing Git repository • Short feedback loops—push small updates, open pull requests, and respond to review comments quickly • Clear communication on progress or roadblocks via Slack or similar Typical tech stack you’ll touch JavaScript (React or Vue), Python (Flask or Django), a sprinkling of SQL, and basic DevOps in GitHub Actions or similar. If you’re stronger in adjacent languages or frameworks, mention them; I’m flexible as long as you can prove efficiency. Deliverables & acceptance 1. A functioning feature or bug-fix branch merged each week 2. Related unit tests passing in CI 3. A brief Markdown note that explains what chan...

I use Chatwoot to route my WhatsApp messages and I want to layer an AI assistant on top, orchestrated in n8n. The goal is simple: every inbound WhatsApp query about our products should be answered instantly, guided through pricing, and steered all the way to a closed sale without human help unless the bot flags an edge-case. The flow I picture works like this 1. n8n listens to the WhatsApp webhook coming from Chatwoot. 2. A dedicated autonomous node fires a custom prompt to the LLM (OpenAI or similar) so the reply is fully tailored, not a canned template. 3. The agent checks Google Sheets for live inventory, pricing and discount rules, writes back any new leads, and updates order status. 4. When the prospect isn’t ready to buy immediately, the bot schedules a follow-u...

...inside the existing Wix project—not a site overhaul. Here’s what should happen: a visitor applies to become a seller, their application lands in my admin dashboard, and I decide manually whether to approve or reject them. Once approved, the seller gets access to list cards, upload images, set prices, manage stock, and view their own sales analytics. Shoppers can filter Vault listings separately, add items to the same cart as my store if possible, then check out through the standard Wix Stores flow. The idea is similar to eBay, but built within my own Wix website. My main site will still sell my own inventory, but the Vault Marketplace page will be a separate area where approved seller members can list and manage their own sports cards and TCG cards. Key elements I ...

...responsive data dashboard deployed 24/7 on a Linux Hetzner VPS (Germany). Speed and long-term stability are our absolute business priorities. ### PROJECT COMPONENTS & ROADMAP: 1. Real-Time Data Engine & Architecture: * Target endpoints: Three major German web platforms. * The system must fetch lightweight JSON data embedded in page responses using asynchronous Python architecture (asyncio) to query all filters and platforms in parallel. * Anti-Bot Engineering: Use specialized HTTP clients (like curl_cffi) to emulate proper TLS profiles and rotate residential proxy connections to bypass platform protections. 2. Telephony Backend & Carrier Integration: * Configure Asterisk to bundle 3 independent German SIP Trunks (Deutsche Telekom, Vodafone, o2 Telefónica). *...

I’m building a community-focused website that will serve two purposes: a rich business directory and a steady revenue channel through on-site advertising. The entire solut...revenue versus featured-listing upsells – Expansion path for sponsored content and local coupons Acceptance criteria 1. Fully responsive pages validated in the latest Chrome, Firefox and Safari. 2. Search and filter return results under 500 ms on a 5k-item dataset. 3. AI expiry logic successfully disables test ads on schedule during demo. 4. Delivered assets: source code, database schema (SQL or JSON), setup guide and business model document. If questions arise about edge cases—such as map integration or payment gateways—flag them early so we can decide whether they belong in ...

I need help adding a set of new firewall rules that govern both inbound and outbound traffic. All of the rules will target TCP only; no UDP changes are required this time. The job will involve: • Reviewing the current rule-base so the new entries slot in cleanly without breaking existing flows. • Drafting and implementing the additional TCP rules I provide (or advising on best-practice wording if any gaps appear). • Verifying that legitimate traffic continues to pass while unauthorized or unwanted connections are blocked. • Supplying a brief change log that notes each rule inserted, its purpose, and the result of basic tests. Success is measured by the updated policy loading without syntax errors, services remaining reachable where intended, and test scans con...

I have an advanced PHP/MySQL inventory application that already offers search and filtering, and I now need a clean way to move data in and out of it through CSV files. Export – When I click an “Export” button, the system should run the same SQL query that currently feeds the inventory results grid and stream the result as a downloadable CSV. Column order, names, and character encoding must remain identical to what users see on-screen so they can open it immediately in Excel or Google Sheets without reformatting. Import – Users will upload a CSV created from that export (or formatted the same way). Your code must parse the file and insert or update records across the relevant tables—items, locations, and stock levels—according to our ...

...a RESTful (or GraphQL, if you prefer) back-end, and a SQL database. From polished UI screens to secure deployment, everything should feel fast, intuitive, and rock-solid across mobile and desktop. Core scope • Front-end: React.js with a clean component architecture, responsive layouts, and smooth state management. • Authentication: classic email-and-password flow only; social logins or 2-factor can stay on the roadmap for later. Security best practices (hashed credentials, rate-limiting, etc.) are non-negotiable. • API layer: integrate LinkedIn’s social API so users can pull profile data and share content. Future hooks for payment gateways or third-party data services should be left extensible. • Database: design optimized SQL schemas, wr...

...automatically sign/broadcast USDT TRC20 payouts to sellers minus a 0.5% fee. Watcher Service: Create a background service via TronGrid API to poll the escrow wallet every 30 seconds and match incoming payments to pending trades. Admin Dashboard: Add live escrow tracking, an append-only event log, and manual override buttons (release/refund) to our Express web dashboard. Tech 18+ & node-telegram-bot-api PostgreSQL 14+ (writing clean migrations) tronweb & TronGrid REST API RequirementsStrong experience with Node.js backend systems and raw SQL queries. Proven experience tracking/interacting with the TRON network or similar EVM chains. Security-first mindset regarding private key management and state machine idempotency. Please reply with your experience ...