[url removed, login to view] Hand-Coded ETL

Closed

[url removed, login to view] 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 [url removed, login to view] 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.

Skills: .NET, Azure, jQuery / Prototype, SQL, Visual Basic

See more: structure stores, prototype upload, prototype create form, new product prototype, implementation of data structures, implementation of data structure, different data structures, data structures through c, data structures implementation in c, basic data structures in c, about data structures in c, about data structures, etl sql, azure login, net migration, net c# azure, hand, etl, database population, azure migration, azure database, asp jquery sql, data structures mini project, net sign

About the Employer:
( 2 reviews ) Atlanta, Chile

Project ID: #5415294

29 freelancers are bidding on average $1895 for this job

itgurussoftware

Hello, We would like to confirm our interest in this opportunity. We have developed several end-to-end web apps for our clients in US and Europe, and can share references with our proposal. We're placing our bid More

$2680 USD in 25 days
(78 Reviews)
8.0
promactinfo

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 More

$2886 USD in 45 days
(80 Reviews)
7.9
qualifiedcoders

Hi We have read your requirements but would like to discuss further as we have 8 ASP.NET Experts in our company and have developed over 200 big size Desktop,web & mobile applications in the last 5 years. Please More

$1546 USD in 13 days
(29 Reviews)
7.6
ambar

We understand that, we will create an application where the main function will be store users upload documents (txt, csv and xlsx) with a pre-defined structure into a SQL Azure server.User can upload their maintained s More

$1030 USD in 30 days
(46 Reviews)
7.3
sandeep25101982

Hello Friend, I am Experienced developer in .Net,ASP,CRM,Windows server,Exchange, eCommerce,Desktop,Web and Mobile Applications. Below is recent Development work: 1. http://databua.no [eCommerce] 2. https:/ More

$1473 USD in 20 days
(39 Reviews)
6.6
DebasisB

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

$1184 USD in 20 days
(59 Reviews)
6.4
sinharavi

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, C More

$1473 USD in 21 days
(23 Reviews)
5.6
LearningNew

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 More

$750 USD in 10 days
(22 Reviews)
5.4
feninsoftech

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 More

$1666 USD in 30 days
(18 Reviews)
5.4
talkwaqar

I am experienced .net developer for 8+ years. I have hands on experience in working on Azure I just completed one big project after 6 month migration from ASP.net app to Windows Azure Platform and we used following tec More

$1666 USD in 20 days
(20 Reviews)
5.2
wanggil

Hi, I have read your requirement carefully. I am an iPhone | Android software expert with rich experience. I have done many successful iPhone | android apps and games: single, multi-player, cocos2d, unity3d. A More

$1717 USD in 12 days
(1 Review)
5.1
L8G8S

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 format More

$1666 USD in 15 days
(11 Reviews)
5.0
deepindersingh

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 det More

$1111 USD in 30 days
(6 Reviews)
5.0
tudiptechnology

Thanks for sharing your requirement with us. We are a software development company with immense experience in .NET, ASP, C#, MySQL, JavaScript, JQuery, CSS and HTML. What we offer and bring to the table: - Project M More

$2105 USD in 30 days
(3 Reviews)
5.0
Cygnusinfomedia

Hello, Greetings for the day !! We have gone through your project details. We have understood the total requirement of your project and also need to discuss some of the queries that we have. We have also discuss More

$1500 USD in 30 days
(7 Reviews)
4.9
Peterpay

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.

$1500 USD in 5 days
(16 Reviews)
4.8
programer218

Hello! I am a asp.net developer. Please look my reviews. If you hire me, I will do my best. Thank you.

$1184 USD in 20 days
(7 Reviews)
4.7
murtaza1981

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 More

$1350 USD in 25 days
(12 Reviews)
4.6
bdprofessional1

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 yea More

$1472 USD in 28 days
(3 Reviews)
4.6
esadeghi59

have over 10 years experience in .NET & ready to start working. My services are fast & reliable and you can trust me to do your project.

$1250 USD in 20 days
(18 Reviews)
4.5