
Đã đóng
Đã đăng vào
Thanh toán khi bàn giao
I have several disparate sources holding our inventory information and I want it all pulled together into one clean, well-structured Microsoft SQL Server database file. The job is straightforward in principle: extract every piece of inventory data you can reach, reconcile duplicate SKUs or mismatched item descriptions, then load the final result into a single .sql or .bak file that I can restore through SQL Server Management Studio. Please preserve every existing field that carries operational value—quantities on hand, reorder thresholds, location codes, cost figures, and any audit timestamps—and normalise the schema where it clearly improves reporting speed or data integrity. If a field appears under different names in different systems, map it consistently; if you uncover gaps, flag them so I can decide whether to fill or discard. I will consider the task complete when I can: • restore or run the script on my Microsoft SQL Server instance without errors, • query a consolidated Items table and see one row per unique SKU, • join stock levels to their warehouse locations with no orphan records, and • export a sample CSV of current inventory that matches today’s live figures. T-SQL proficiency is essential; SSIS, Azure Data Studio, or any other ETL tooling you prefer is fine as long as the final deliverable is the ready-to-go SQL Server file described above.
Mã dự án: 40219281
37 đề xuất
Dự án từ xa
Hoạt động 19 ngày trước
Thiết lập ngân sách và thời gian
Nhận thanh toán cho công việc
Phác thảo đề xuất của bạn
Miễn phí đăng ký và cháo giá cho công việc
37 freelancer chào giá trung bình $149 USD cho công việc này

Hello I am an expert in sql and create a consolidated sql database for your inventory. I will make sure to consider all the important fields and have a proper database ready which reflects true inventory levels Looking forward to discuss Talha amim
$180 USD trong 7 ngày
8,5
8,5

Hello, Hope you are doing well. I have 12+ years of experience in website application development. I have expertise in ASP.Net, MVC, WebApi, Entity Framework, AWS, Azure, Angular, TypeScript, .NetCore framework, jQuery, Window Application Development and many other Microsoft Technologies. I have worked on many web applications and Windows applications. I have also worked on various domains. Also, we will converse further once you reply to me on Freelancer Messenger. Please send me a message for further conversation. Best Regards,
$250 USD trong 10 ngày
7,0
7,0

As an experienced full-stack developer with over 7 years of experience, specializing in database administration and coding, your inventory data consolidation project is aligned perfectly with my expertise. I am skilled in T-SQL and well-versed in Microsoft SQL Server, which makes me the right fit for this task. With my profound knowledge in not just SQL but also database design principles, I can ensure that your existing field and operational value are successfully preserved. My previous work experiences have taught me how to reconcile duplicate SKUs, standardize disparate fields, normalize schema for improved reporting speed, and maintain data integrity – all key tasks for a project like yours. I am confident I can provide you with a clean, well-structured Microsoft SQL Server database file containing your consolidated inventory information while maintaining every necessary field. In addition to that, I will carry out a thorough testing and checking process to ensure the final script or restored database will run without any errors. Being keen on providing long term solutions for my clients, I guarantee you a complete satisfaction. Let's get started!
$220 USD trong 4 ngày
6,7
6,7

I am expert on inventory system , and probably i can help you very well managed way to consolidate from different source to single SQL server
$140 USD trong 7 ngày
6,4
6,4

Hi, My name is Ali and I can deliver a clean, normalized MS SQL Server database that consolidates your disparate sources into a single source of SQL Server Database. Please share the samples of different sources you have so I can analyze them and clear then as per requirements. My approach involves using T-SQL and SSIS to execute a robust ETL process: mapping inconsistent fields, deduplicating SKUs, and enforcing referential integrity to eliminate orphan records. I will ensure the final .bak or .sql file is fully optimized for performance and produces a "one row per SKU" Items table that reconciles perfectly with your live inventory. Regards, Muhammad Ali Safder
$140 USD trong 7 ngày
5,4
5,4

I can do it. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are anticipating from this platform give me a chance to show you the best i can do at your service.
$140 USD trong 2 ngày
4,5
4,5

Greetings, I see you’re looking to consolidate your inventory data from various sources into a single, structured SQL Server database. My approach would involve extracting all available data, addressing any duplicate SKUs or inconsistencies in descriptions, and ensuring that every important field is preserved. I’d focus on normalizing the schema to enhance reporting speed and data integrity while mapping fields consistently across systems. With my T-SQL proficiency and experience in ETL processes, I can efficiently transform your data into a clean .sql or .bak file ready for seamless integration with your SQL Server. I’ll make sure to flag any data gaps for your review, so you can decide how to proceed. One thing I’d like to clarify is: what are the main sources of your inventory data, and do you expect any specific challenges with them? Best regards,
$100 USD trong 2 ngày
3,6
3,6

Hi there, I understand your project details. I will consolidate all inventory sources into one structured SQL Server database, reconcile duplicate SKUs and mismatched fields, and preserve all operational data with a clean, normalized schema. You will receive a ready-to-run .sql or .bak file that restores without errors, provides one row per unique SKU, maintains proper warehouse relationships, and matches your live inventory figures. I have over five years of professional experience developing full-stack applications using .NET, Angular, and related frameworks. Please send me a message to discuss the project requirements, budget, and timeline. Best regards, Ahsan
$140 USD trong 7 ngày
3,5
3,5

We have reviewed your project details and would love to help you complete this successfully. MD Technosoft is a professional IT services company with extensive experience in delivering high-quality, scalable, and cost-effective solutions. Why Choose Us? ✅ Experienced team of developers and designers ✅ Strong focus on quality, performance, and security ✅ Clear communication & regular progress updates ✅ On-time delivery with full support ✅ 100% client satisfaction is our priority We work with modern technologies and follow best practices to ensure your project meets your exact requirements. Our approach is simple: understand your needs, plan efficiently, execute cleanly, and support you even after delivery. We are confident we can add real value to your project and would be happy to discuss your requirements in detail. Let’s connect and get started.
$140 USD trong 7 ngày
3,4
3,4

Hello, I can consolidate your disparate inventory sources into a clean, reliable Microsoft SQL Server database that restores without errors and reports accurately. I work hands-on with T-SQL–driven ETL, reconciliation, and schema normalization—focused on preserving operational value while improving integrity and query performance. How I’ll handle this Extract all reachable inventory data (via T-SQL, SSIS, or source-specific connectors). Reconcile duplicates and mismatches: canonicalize SKUs, normalize item descriptions, and resolve conflicts with clear rules. Map fields consistently (e.g., quantities, reorder thresholds, locations, costs, audit timestamps); flag gaps or ambiguities for your decision. Normalize where it helps (items, locations, stock, costs, audits) while keeping reporting fast. Load into a single deliverable: a .sql script or .bak ready for SSMS restore. Validate: one row per unique SKU, no orphan location records, and a sample CSV that matches live figures. Why hire me? I don’t just merge data—I make it trustworthy. You’ll get a database you can restore, query, and report on confidently. Deliverables Restore-ready .sql / .bak Consolidated schema + mappings Validation queries & sample CSV Notes on assumptions and flagged gaps I’m comfortable using T-SQL, SSIS, Azure Data Studio, or equivalent—whatever best fits your sources. Ready to start as soon as you share access details.
$240 USD trong 7 ngày
3,1
3,1

Hey , I just finished reading the job description and I see you are looking for someone experienced in .NET, SQL, Data Integration, ETL, Microsoft Access, Database Design, Database Administration and Microsoft SQL Server. This is something I can do. Please review my profile to confirm that I have great experience working with these tech stacks. While I have few questions: 1. These are all the requirements? If not, Please share more detailed requirements. 2. Do you currently have anything done for the job or it has to be done from scratch? 3. What is the timeline to get this done? Why Choose Me? 1. I have done more than 250 major projects. 2. I have not received a single bad feedback since the last 5-6 years. 3. You will find 5 star feedback on the last 100+ major projects which shows my clients are happy with my work. Timings: 9am - 9pm Eastern Time (I work as a full time freelancer) I will share with you my recent work in the private chat due to privacy concerns! Please start the chat to discuss it further. Regards, Syed.
$30 USD trong 5 ngày
2,7
2,7

Hello , I checked your project, and it looks interesting. This is something we already work on, so the requirements are clear from the start. We mainly work on .NET, SQL, Microsoft Access, Database Administration, Microsoft SQL Server, Data Integration, ETL, Database Design We focus on making things simple, reliable, and actually useful in real life not overcomplicated stuff. Let’s connect in chat and see if we’re a good fit for this. Best Regards, Ali nawaz
$129 USD trong 4 ngày
2,4
2,4

Hi, I understand your need for consolidating inventory data into a structured SQL Server database, and I'm confident I can deliver this successfully. With my extensive experience in ETL processes and Microsoft SQL Server, I can efficiently extract data from your disparate sources, normalize the schema, and ensure all relevant fields, like quantities and reorder thresholds, are preserved. I will identify and reconcile duplicate SKUs and flag gaps, giving you clarity on what data is ready for inclusion. The end result will be a single `.sql` or `.bak` file that seamlessly integrates with your SQL Server Management Studio without errors. You can expect a fully organized Items table and precise stock level joins, ensuring no orphan records persist. My goal is to meet your completion criteria while making the process smooth for you. Thanks, Thaveesha
$155 USD trong 3 ngày
1,7
1,7

Hi, I am Debasis, an individual freelancer specializing on Microsoft Data platform (including MSSQL and Azure SQL offerings), would like to work on this assignment. You can trust me to delve into minute details from the various data inventory sources that you currently have. I will formulate a normalized relational schema structure suitable for fast retrieval once it is transferred to SQL platform. Please let me know if you can setup a call to discuss further. Thanks, Debasis.
$150 USD trong 7 ngày
1,5
1,5

Hello, My name is Luciano. I have been a Professional Programmer since 2008. I have many programs and successfully finished in my past employer, I am an expert in the IT Industry, both Hardware and Software Programming. I will give you the quality and satisfaction of my work. I will give you 100% satisfaction. I am really interested and ready to start. Best Regards, Luciano
$90 USD trong 3 ngày
0,5
0,5

Hi [ClientFirstName], I’m experienced with Microsoft SQL Server, ETL, and data consolidation, and I will design a robust, normalized schema that preserves all operational fields (on-hand quantities, reorder thresholds, location codes, cost, and audit timestamps) while reconciling duplicates and mismatches across sources. I’ll extract from each source, map variably named fields to a single canonical schema, flag gaps for your decision on fill/discard, and load the final result into a clean SQL file (ready for MS SQL Server restore) with a single consolidated Items table and proper foreign-keyed relationships to stock levels and locations. The deliverable will support a repeatable restore process, referential integrity (no orphaned records), and an exportable sample CSV reflecting today’s live figures. Frame a unique question about the project to engage the client, tone should be Adaptive English. Best regards,
$180 USD trong 5 ngày
0,0
0,0

Hello, thanks for posting this project. Your requirements for consolidating and normalizing inventory data into a unified, production-ready Microsoft SQL Server format are clear and align closely with my expertise. I have deep experience extracting, transforming, and reconciling disparate datasets, and I always ensure that operationally significant fields remain fully preserved and consistently mapped across the new schema. My approach emphasizes clean normalization for optimal performance, thorough deduplication, and strict data integrity—ensuring all joins and exports function as specified. I’m highly proficient with T-SQL and have extensive hands-on experience delivering robust ETL solutions for similar consolidation projects using a variety of tools, including SSIS and Azure Data Studio. Could you clarify how many unique source systems or file formats are involved, and what sample data you can provide for initial assessment? Looking forward to hearing from you. Warm regards, Vitalii.
$140 USD trong 1 ngày
0,0
0,0

Hi, I’m a SQL Server–focused data engineer with strong T-SQL and ETL experience, and I can consolidate your inventory data from multiple sources into a clean, well-structured Microsoft SQL Server database. I’ll extract the data, reconcile duplicate SKUs and mismatched descriptions, standardize field mappings, and normalize the schema where it improves integrity and reporting performance—while preserving all operational fields like quantities, reorder levels, locations, costs, and timestamps. Any data gaps or inconsistencies will be clearly flagged for your review before final loading. You’ll receive a ready-to-restore .sql or .bak file that runs cleanly in SSMS, with a consolidated Items table (one row per SKU), properly linked stock and location data, and a sample CSV export that matches your live inventory. I focus on accurate reconciliation, clean schema design, and smooth handover so the database is immediately usable. Available to start right away. Best regards, Anand Shah
$130 USD trong 7 ngày
0,0
0,0

Hi, I’ve carefully reviewed your project to consolidate diverse inventory data sources into a unified, well-structured Microsoft SQL Server database file. With extensive experience in T-SQL, ETL processes, and database design, I am confident I can extract, reconcile, and normalize your inventory data to create a seamless single database. I will ensure every operational field is preserved, map inconsistent fields consistently, and flag any gaps for your input. The deliverable will be a clean .sql or .bak file ready to restore and query immediately in SQL Server Management Studio, meeting all your requirements including unique SKUs, accurate warehouse joins, and generating live-accurate CSV exports. I propose to start with a detailed review of your data sources and draft schema within 3 days, ensuring alignment before final delivery. Let me know how many data sources you have and any specific challenges you foresee. How many separate inventory data sources are involved, and are there any with particularly complex or inconsistent schemas? Best regards,
$155 USD trong 25 ngày
0,0
0,0

Hi sir, I have 13+ years of expertise creating Desktop and Web application in various Microsoft Technologies. I have gone through your requirement for "ASP.NET resources in India". I have expertise in creating web applications in ASP.NET MVC and ASP.NET Core along with following technologies. Technology Experience Web Development Technologies: ASP.NET MVC, ASP.NET Core, ASP.NET Web Form, Bootstrap, JQuery, ASP.NET Web API , HTML5/XHTML, XML, CSS3, Java Script, Angular js . Software Technologies: C#, WPF, WCF, Crystal Reports, Ajax’s, silver Light, Entity framework, Windows Services, Web Services ,Windows Form, Dapper Database: SQL Server You can also see our portfolio to know about my expertise in Software Development. Look forward to further discussion and working in your project. Thanks, Lav Kush Kumar (07827184078)
$240 USD trong 10 ngày
0,0
0,0

Bandung, Indonesia
Thành viên từ thg 9 2, 2025
tối thiểu 50 USD$/ giờ
₹75000-150000 INR
$750-1500 USD
£18-36 GBP/ giờ
₹750-1250 INR/ giờ
₹100-400 INR/ giờ
₹12500-37500 INR
$250-750 USD
$2-8 USD/ giờ
$2-8 USD/ giờ
$10-30 USD
₹12500-37500 INR
$250-750 USD
$3000-5000 USD
$30-250 USD
$10-30 USD
₹12500-37500 INR
₹1500-12500 INR
$750-1500 USD
$30-250 USD