Freight Invoice SQL Pipeline Rebuild

@amusto

Hi, this is my proposal to migrate your freight-invoice workflow into a fully SQL Server–driven pipeline. Deliverables/Milestones: • Raw/staging/final table schema with audit fields • Dynamic CSV import handling variable carrier layouts • T-SQL stored procedures replicating all documented business rules (validated against your 12-month golden dataset) • Authenticated ASP.NET Core REST API (JWT) with sub-second response times • One-pass deployment script for any Windows/SQL Server environment Timeline: 8 weeks from receipt of CSVs, rule handbook, and golden dataset. I need to know exactly the rules and the db schema to calculate the effort need to complete each milestone. I bring 15+ years on .NET/SQL Server, PMP certification, and direct experience managing multi-country ERP deployments on SQL Server. Happy to schedule a call to align on details. Best regards, Armando Musto

@irsolutions

With over 10 years of experience in web and mobile development, specializing in SQL Server and T-SQL, I understand the challenges you face in rebuilding your freight invoice pipeline. Your project requires a seamless transition from a desktop utility to a SQL Server-driven pipeline with precise data mapping and processing. In the realm of fintech and data management, I have successfully implemented similar solutions for clients, ensuring accurate calculations and efficient API integration. My expertise in SQL schema design, stored procedures, and API development align perfectly with your project requirements. By leveraging my experience and knowledge, I am confident in delivering a robust import routine, comprehensive stored procedures, and a secure REST endpoint for your freight invoice workflow. Together, we can achieve your goal of reproducing accurate results and achieving sub-second response times. If you are ready to take the next step in rebuilding your invoice pipeline, I am eager to discuss timelines and milestones with you. Let's collaborate to bring your vision to life seamlessly.

@leadconcept

Greetings, Are you hosting this on-prem only, or should our team design it to be cloud portable as well? Our understanding is that you need a SQL Server driven freight invoice pipeline where carrier CSV files land in staging tables, T-SQL stored procedures apply documented rate card logic, results match your 12 month golden dataset exactly, and an authenticated REST API exposes processed invoices and audit fields. The stack must include flexible CSV ingestion, raw, staging, and final schemas, regression aligned stored procedures, and a one pass deployment script for Windows Server. Our team has deep experience with SQL Server, complex T-SQL rule engines, high performance indexing, and lightweight REST APIs with sub second response times. We focus on deterministic outputs, regression validation, and clean deployment automation. Timezone alignment within 3 to 4 hours of AUST works for us. FYI, the current bid amount is a placeholder for proposal submission. Looking forward to connecting via chat. Regards, Yasir LEADconcept PS: Let me know, if you want to see our team past work to determine our skills/expertise or past customer's references.

@tangramua

Dear ,   We carefully studied the description of your project and we can confirm that we understand your needs and are also interested in your project. Our team has the necessary resources to start your project as soon as possible and complete it in a very short time.   We are 25 years in this business and our technical specialists have strong experience in .NET, Data Processing, SQL, C# Programming, Microsoft SQL Server, Data Integration, Database Design, API Development and other technologies relevant to your project.   Please, review our profile https://www.freelancer.com/u/tangramua where you can find detailed information about our company, our portfolio, and the client's recent reviews.   Please contact us via Freelancer Chat to discuss your project in details.    Best regards, Sales department Tangram Canada Inc.     

@Guptapuru304

Hello, We've thoroughly reviewed your project details for rebuilding a freight-invoice workflow into an SQL Server–driven pipeline. We understand the critical need for seamless data integration, precise rule encapsulation through T-SQL, and a robust API for timely data migration. We've previously transitioned complex workflows similar to yours, leveraging our expertise in SQL Server and T-SQL to deliver data pipelines that ensure accuracy and efficiency. Our experience with API development will ensure your application receives the necessary data promptly. With over 8 years of experience in developing intelligent systems and automation workflows, we are well-equipped to handle this project. Our expertise in developing APIs and managing complex data integrations aligns perfectly with your requirements. We've worked extensively with SQL Server, ensuring impeccable data processing and API response times. Our portfolio showcases projects where we've built scalable, maintainable solutions that exceed client expectations. We are confident in delivering a pipeline that mirrors your historical data outputs precisely. Please message us with more details, and we'll provide a detailed tailored proposal within 24 hours. We are excited to align our expertise with your project's needs. Best regards, Puru Gupta

@MashoodurRehman1

I am a skilled data engineer with extensive experience in SQL Server and T-SQL, well-equipped to rebuild your freight invoice workflow. My expertise includes designing and executing complex ETL pipelines and integrating APIs for data access. I have successfully migrated several similar workflows to SQL Server environments, ensuring accuracy and efficiency. I understand the requirements of ingesting CSV files into staging tables, executing T-SQL stored procedures to match line items to rate-card logic, and delivering results through an API. I've previously implemented robust import routines that handle varying CSV layouts, and designed stored procedures to encapsulate complex business logic, ensuring outputs match historical benchmarks. I can develop a REST endpoint to provide processed invoices and audit data with high performance and reliability. I am interested in discussing this project further to understand your timeline and specific milestones. Could we set up a time to talk in detail and ensure alignment? I look forward to contributing to your project's success.

@reedsystems

Hi, I'm excited to propose a solution for moving your freight-invoice workflow into a fully SQL Server-driven pipeline. With over a decade of experience in the field, I can ensure that we will implement a robust and efficient system. The proposed flow involves ingesting CSV files from carriers into staging tables, using T-SQL stored procedures to match each line with rate-card logic for calculating freight charges, and surfacing the results through an API. The schema for raw, staging, and final tables will be meticulously designed to ensure smooth data processing. A robust import routine will handle varying CSV layouts without manual adjustments, ensuring seamless integration. For the API, I'll develop a lightweight framework-based endpoint that authenticated users can use to access processed invoices along with key audit fields, guaranteeing sub-second response times for your front-end needs. A repeatable deployment script will be provided so that the entire stack can be rebuilt on another Windows server in one pass. Let's discuss timelines and milestones to align our efforts effectively. Looking forward to collaborating with you.

@ZohaibRoy

⭐⭐⭐⭐⭐ Build a SQL Server Pipeline for Freight-Invoice Workflow ❇️ Hi My Friend, I hope you're doing well. I've reviewed your project needs and see you're looking to move your freight-invoice workflow to a SQL Server pipeline. Look no further; Zohaib is here to help! My team has completed over 50 similar projects for SQL Server implementations. I will create a robust pipeline that meets your requirements, ensuring accurate results and efficient processing. ➡️ Why Me? I can easily handle your SQL Server pipeline project as I have 5 years of experience in database management, T-SQL procedures, and API development. My expertise includes data ingestion, schema design, and building REST endpoints. Additionally, I have a strong grip on SQL Server optimization, ensuring quick response times. ➡️ Let's have a quick chat to discuss your project details. I would love to show you samples of my previous work and how I can add value to your project. Looking forward to chatting with you! ➡️ Skills & Experience: ✅ SQL Server ✅ T-SQL Procedures ✅ Database Design ✅ API Development ✅ Data Ingestion ✅ CSV Handling ✅ Schema Creation ✅ Performance Optimization ✅ RESTful Services ✅ Deployment Scripts ✅ Data Mapping ✅ Invoice Processing Waiting for your response! Best Regards, Zohaib

@softwarelinkerrs

When it comes to migrating your Freight Invoice workflow onto a SQL Server pipeline, my team at SoftwareLinkers has got what it takes. With my deep understanding of T-SQL and Microsoft SQL Server, I can ensure an efficient and robust import routine that doesn't require any manual tweaks for varying CSV layouts. Our code will match your existing business rules and replicate the 12-month reference set exactly. Moreover, I'm well-versed in RESTful API development and can build you an authenticated endpoint using a lightweight framework that meets your need of integrating with your client applications. Our APIs have been widely tested and are known for their speed and scalability. The best part of partnering with us is that we don't just write code; we analyze your business goals, design future-ready systems, and provide long-term support even after deployment. We ensure high client retention, on-time delivery, and clear communication throughout the process. Given your focus on reproducing results accurately along with sub-second response times, I believe my skills in full-stack development and infrastructure management align perfectly with your project requirements. Give us the chance to turn your vision into reality

@chraheelbhatti

As a well-versed Data Scientist with over 8 years of experience encompassing exact fields of SQL, Machine Learning, and Database Design, I can certainly deliver the sky-high standards of structure and performance that your project demands. I've been a part of multiple challenging projects ranging from automated workflows to rate-card-based billing systems that align closely with your requirements. My strong background ensures I can handle varying CSV layouts without any manual handicaps. Drawing from my broader expertise in Python, MATLAB, R Programming, and additional technical competencies in CI/CD, Kubernetes, GitLab, etc., I am supremely capable of offering you an end-to-end solution that goes beyond invoice processing including the deployment of this entire SQL Server–driven pipeline on another Windows server in one uncomplicated passage. Not to mention my commitment to continuous improvement which makes me a fantastic partner for the long haul - especially given my proficiency in regression testing. We can further guarantee the quality control by incorporating my know-how in building architecture and AutoCAD so our pipeline matches not just on "numbers" but also on all levels. Partner with me, to derive consistently accurate results alongside efficient sub-second responses for your front end applications.

@ail5a9f298b597ed

I am excited about the opportunity to help you rebuild your freight invoice SQL pipeline. With extensive experience in SQL Server, T-SQL, and API development, I can efficiently transform your existing workflow into a robust and scalable solution. My background in data processing and automation ensures that I understand the importance of accuracy and performance, allowing me to deliver the required schema, import logic, stored procedures, and API endpoints that will meet your specification and replicate your “golden” output precisely. I am dedicated to communication and collaboration throughout the project to guarantee alignment with your goals.

@sasaprogramer21

This aligns very well with my background in SQL Server–centric systems and finance-driven data pipelines. I’ve built similar ingestion-to-calculation workflows where the database is the single source of truth and all business logic is encapsulated in versioned T-SQL stored procedures to guarantee deterministic outputs. My approach would be to design a clean three-layer schema (raw, staging, processed) with strict validation and audit fields at each step. The CSV import routine would use a configurable mapping layer so column variations can be handled without code rewrites. All freight rating logic would be modularized into clearly structured stored procedures with regression tests against your 12-month “golden” dataset to ensure byte-for-byte consistency. The API layer would be lightweight (ASP.NET Core or minimal API in .NET), authenticated via token-based auth, and focused purely on orchestration and retrieval—keeping all computational logic inside SQL Server for performance and transparency. Deployment would be fully scripted (schema, procs, indexes, API publish profile) so the environment can be rebuilt in one pass. I’m comfortable working close to AEST hours and can align within a 3–4 hour overlap window. With your documentation and reference outputs, we can structure milestones around ingestion, rule validation, API exposure, and performance hardening. Timeline: 3-4 weeks

@Hemantt841

You’re looking to replace a Windows-only freight-invoice utility with a fully SQL Server–based pipeline that ingests carrier CSVs, applies detailed rate-card logic in stored procedures, and exposes results through a responsive API. Your emphasis on matching a year’s validated invoice outputs and supporting varied CSV layouts shows a clear focus on accuracy and flexibility. With over 15 years of experience and more than 200 completed projects, I specialize in database design and API integration, including Microsoft SQL Server and C# development. I’m well-versed in creating robust data pipelines and authenticated REST endpoints that serve dynamic front ends with minimal latency. For your project, I’ll design normalized schemas for raw, staging, and final tables, develop flexible import routines to handle varying CSV formats, and implement T-SQL stored procedures that replicate your documented business rules precisely. The API will be built with a lightweight .NET framework to ensure sub-second response times, and I’ll provide a repeatable deployment script for seamless server setup. A realistic timeline for this scope is about two weeks to cover development, testing against your golden dataset, and deployment. Let’s discuss your priorities and timelines in more detail to get this moving.