Find Jobs
Hire Freelancers

ASP.NET Hand-Coded ETL

$750-1500 USD

Closed
Posted about 10 years ago

$750-1500 USD

Paid on delivery
ASP.NET Hand-Coded ETL The project consists on the implementation of a .NET solution in which users upload documents (txt, csv and xlsx) with a pre-defined structure. Uploaded data must be loaded through a mini hand coded ETL process to populate a fact table hosted in SQL Azure. There are 15 different files with closely similar structures containing data of products being sold in different stores. Files are uploaded by the users generally on a weekly basis. Each file has many columns but only 5 columns contains valuable data that must be loaded DIRECTLY into an SQL Azure Table, which is a fact table used for reporting. Files must be securely stored and deleted after migration is completed. A cross check of missing products must be created for data loaded into the DB. If a new product code is found on the uploaded file, this row of new information must be added into the product table. A form is required to complete information about the missing product. JQuery must be used to create an autocomplete so population of the information is eased using data located in the product table from the SQL Azure Database. This ASP.NET solution needs to be developed in Visual Basic. Users must be able to Sign-up/Login through a secure protocol. This project has a big growth potential for future developments.
Project ID: 5415294

About the project

26 proposals
Remote project
Active 10 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
26 freelancers are bidding on average $1,538 USD for this job
User Avatar
Hello, I have reviewed your project requirement and found it to be one of the challenging project we would like to work on.I would like to connect with you over private message or other medium to discuss about the project in more detail. To give you a quick background Promact InfoTech Pvt Ltd (ISO 9001:2008) is a 100% EOU-complete High-Tech IT solutions company, delivering comprehensive solutions to various businesses across a wide range of platforms and technologies. We are website and Software Development Company providing professional website design, website development, web-based applications (specialized in E-learning module creation), Software Development, DB management application, e-commerce and ERP systems. Promact InfoTech has over 10 years of experience in custom software development services for customers worldwide, including Global 1000 which includes Fortune 500 companies. Look forward to hear from you soon, Thanks and regards, Promact Infotech Pvt Ltd
$2,886 USD in 45 days
5.0 (56 reviews)
7.8
7.8
User Avatar
I have few confusions: Can you please explain this? Uploaded data must be loaded through a mini hand coded ETL process to populate a fact table hosted in SQL Azure. Is it extraction of data from the documents and some conversion verification is done and finally loaded in database ?
$750 USD in 10 days
4.9 (67 reviews)
6.7
6.7
User Avatar
Hi, This can be achieved by designing an ASP.NET website where can upload files after log-in. When file uploaded successfully, a SSIS package will be triggered to upload files data in SQL database. I have 9 years experience in C#, ASP.NET/ MVC with Jquery/Ajax and for services using WCF/Rest WCF/Rest Web API and SQL Server for back-end. I have delivered highly successful projects in ASP.NET, C# Win-Forms,VB.NET with complex logic in SQL Server Stored Procedures. Thanks, Ajay
$1,666 USD in 30 days
4.9 (57 reviews)
6.7
6.7
User Avatar
Hello Sir, I have 7+ years of web development experience in ASP.NET MVC, ASP.NET Web forms(C#), Classic ASP, SQL Server, HTML. CSS, jQuery javascript and XML. I have handled similar projects. For more details on my portfolio, please review the url: freelancer.com/u/deepindersingh.html Thank You
$1,111 USD in 30 days
5.0 (38 reviews)
6.3
6.3
User Avatar
Hi nachoreca, You project sounds really interesting and I think I could help you to develop this mini ETL application. I have already done this kind of projects, and I have few questions with regards to file formats, security and application hosting. If my proposal sounds interesting to you, I would like to discuss further about your project to see if I could be of any help :) Regards, G.
$1,666 USD in 15 days
5.0 (20 reviews)
5.9
5.9
User Avatar
Hello, I've reviewed the requirement and interested to work on it. I have expertise in enterprise data processing and I'm sure I can provide you the best service you are looking for. Thanks, Debasis
$1,184 USD in 20 days
4.8 (62 reviews)
6.3
6.3
User Avatar
A proposal has not yet been provided
$1,184 USD in 30 days
4.9 (30 reviews)
5.1
5.1
User Avatar
Hi, I have developed project like that. Contact me and we will discuss further. Wait for your response. Best Regards Ghazi Oualha
$1,052 USD in 20 days
5.0 (16 reviews)
5.2
5.2
User Avatar
Hi, I read your requirements, i am ready to the work. I am having 6+ year of experience in ASP.NET, MVC, C#.NET, VB.NET, MS SQL Server 2008 R2/2005, Microsoft Azure, WCF Service, WCF REST Service, Javascript, JQuery, CSS. Please let me know your concern. Thanks Raviranjan
$1,473 USD in 21 days
4.5 (18 reviews)
5.7
5.7
User Avatar
por favor extender todos los formatos posibles de entrada y las condicionales de conversion y completado asi como algun mockup o sketch de la pantalla de manipulacion.
$1,500 USD in 5 days
5.0 (16 reviews)
4.8
4.8
User Avatar
Hello, We are an Ahmedabad (India) based software and mobility solutions provider company having the team of dynamic & highly technical developers. We are having developer having experience in the range of 2-12 years on .Net, C#, JQuery, MVC, DevExpress, Bootstrap, Silverlight, DotNetNuke, Telerik, Linq, WPF, WCF, MySQL, SSRS, SSIS, SaaS, HTML5, CSS3, Windows Phone, Android, iPhone, IOS, Phonegap, Corodova, etc. We reviewed your requirement detail and Interested to work on the same. We are having core expertise of working on exactly similar projects. You can check our portfolio, past and current projects so that you can get better confidence on our skills and expertise. We can assign the dedicated resources to work on your projects. Our rich knowledge, domain experience will help to finish the work on time, with good quality and under budget. We are interested to start working immediately on your project. Kindly provide your Skype ID so that we can discuss further also I can show you the demo of our projects through screen sharing session. Looking forward to get quick and positive response. Best Regards, BD Professional
$1,472 USD in 28 days
5.0 (3 reviews)
4.7
4.7
User Avatar
Hi, An ASP.NET,c#,vb ,SqlServer,JQuery,Javascript expert here. Please feel free to discuss the project with me so that i can wrap it up in a timely manner as per your requirements. I would like to highlight following qualities of me why you would love to work with me. 1) Has an eye for detail and places heavy emphasis on end user experience. Bringing more value to the table is the utmost priority of my career goal. I believe in continuous progress and rapid upkeep with latest technology is the key to thrive. 2) My focus is on doing high quality work. I am finding an individual approach to each new job and do it professionally, quickly, qualitatively, paying attention to even the smallest details. 3) The most important thing for me is a quick and quality work. 4) I specialize in making things intuitive, engaging and enjoyable. 5) Programming is not only my job but it is also one of my hobbies. Coding is fun for me and my goal is to always exceed the expectations. I try to compete on quality not quantity or price with the other programmers. 6) You will get perfect end result of work on time and you will be satisfied with the end product. I would like to have a detailed document of your requirements so that we can discuss the each and every point in details. Thanks, Murtaza
$1,350 USD in 25 days
5.0 (11 reviews)
4.5
4.5
User Avatar
A proposal has not yet been provided
$1,250 USD in 20 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, I have gone through the project requirements and interested in working with you. I am very much excited to know more about your project and would like to showcase our work done during a discussion. I can provide you with exact cost and timeline after a detailed understanding of your project. Therefore, please revert me here for further communication. Also, we can work as per your preferred timings and time zone. Look forward to talking to you. Best Regards, Rutu Taranekar Staffing Manager
$1,368 USD in 30 days
0.0 (0 reviews)
3.6
3.6

About the client

Flag of CHILE
Atlanta, Chile
5.0
2
Payment method verified
Member since Apr 9, 2013

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.