Database Warehouse

We are a financial solutions company and have millions of records from various sources.

We require a simple database structure to keep a timely record of all this, allow for further imports and also simple look-up and reporting.

All the data to be imported will be in the same format, same column headers. The first column will be the date that data was received, the file date; the second will be a file label specific to the source and date. Thereafter all columns will be specific to the client such as Name, ID Number, Contact information etc......

After every imported a file, a report needs to be produced, based on the clients ID Number.

This will show, the number of duplicates imported, the file date of all the previous dupes as well as the source and file label.

Any record will never be overwritten, just simply added to with he information for that client based on the most recent file date. It is possible that clients will have multiple contact numbers, particularly cellphone. The primary cellphone number will be again based on the last file date, and each time a new cellphone is added for the client, the previous one, is then the secondary number and so on, keeping up to a maximum of six contact cellular numbers for the client.

We also need campaign fields for sending sms. Each campaign filed will be separate witha date that the client was sent an sms. Typical campaigns would be, but not limited to Debt, Cellular, Loan, Life Cover, Funeral etc.....

The last date the client was sent an sms is campaign specific. If we write a rule where a client is contacted every three months, then this is campaign specific, so theylll be contacted for say debt every three months, but could end up getting four different sms in one month across different campaigns.

We need to be able to extract data to sms based on last sms sent, campaign specific.

Also need a blacklist which is once again campaign specific, which will suppress data from being extracted.

When replies are received, we need to match the cellular number to the last contact information for the client and export information such as name, contact details and lead source.

It is anticipated that the warehouse will hold around forty-fifty million unique records based on ID Number. There will be additional fields up to a maximum of say fifty others.

Kemahiran: Pentadbiran Pangkalan Data, Pengaturcaraan Pangkalan Data, Excel, MySQL, SQL

Lihat lagi: item warehouse database, access warehouse database free, sending flash data php mysql database flash cs3, similarities between data warehouse and database, difference between database and data warehouse pdf, data warehouse example, data warehouse tutorial, types of data warehouse, data warehouse vs database, data warehouse concepts with examples, data warehouse definition, database development, database programming, data warehousing, sending form field information database 60vb, small warehouse access database, warehouse storage access database, access database simple warehouse, access 2007 sample database warehouse inventory, access 2007 database warehouse

Tentang Majikan:
( 0 ulasan ) South Africa

ID Projek: #16464221

25 pekerja bebas membida secara purata R3649 untuk pekerjaan ini


Hi there..... Warm Greetings We came along with your request for Database Warehouse and we reviewed your project description. We'd like to help you with confidence and satisfying results... We have professiona Lagi

R5000 ZAR dalam 5 hari
(279 Ulasan)
R5100 ZAR dalam 7 hari
(181 Ulasan)

Dear, we are Team of French + US. I checked your project description, and I confirm I can develop your program. I will focus on user friendly interface. As you can see I have very good rate, you can be sure I am ser Lagi

R1842 ZAR dalam 10 hari
(66 Ulasan)

Hi, As per given details Its data entry task. It is warehouse database management. I have great experience in all kind of backend support I am good in lead generation, internet research, market research, data entry, Lagi

R2055 ZAR dalam 10 hari
(37 Ulasan)

Hey. Maurice here from Cape Town. I have extensive experience in database operations. I also have 18 years in software development. So contact me and lets discuss a solution Maurice Marinus

R3888 ZAR dalam 10 hari
(26 Ulasan)

Hi, I have gone through your requirements. I am 12+ years experienced Database Programmer at CMMI-5 level company. I am working on : RDBMS: Oracle ,MySQL,MSSQL Server 7.0/2000/2008R2 and Onwards, MySQL. Data Base T Lagi

R4000 ZAR dalam 7 hari
(41 Ulasan)
R5833 ZAR dalam 10 hari
(7 Ulasan)

Hi! I'm an experienced .Net/SQL software developer (8+ years). I'm interested in your project and I would like to know more details. I believe that I have the required skills to help you with this project. Best regar Lagi

R4444 ZAR dalam 4 hari
(7 Ulasan)

Hi , I am interested by your offer. Let me know more details of this work. I will start working immediately :) Br;

R3888 ZAR dalam 10 hari
(16 Ulasan)

Hi, A SQL Server, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS) expert here. I would like to have a detailed document of your requirements s Lagi

R4500 ZAR dalam 21 hari
(2 Ulasan)

A proposal has not yet been provided

R3333 ZAR dalam 20 hari
(7 Ulasan)

Hello There I can create your database in Mysql and create an application in yii2 for search, view and reporting. Looking forward to work with you.

R3888 ZAR dalam 10 hari
(2 Ulasan)

Hi, I'm a software developer working in the industry for almost 5 years now. My overall experience is with working on BI/EDW warehouses. I am specialized in handling big data and working on Hadoop/Big data ecosystems. Lagi

R4444 ZAR dalam 8 hari
(3 Ulasan)

A proposal has not yet been provided

R5222 ZAR dalam 2 hari
(3 Ulasan)

A proposal has not yet been provided

R2222 ZAR dalam 5 hari
(0 Ulasan)
R4722 ZAR dalam 10 hari
(1 Ulasan)

Sir I have 12 year experience in accounts now I wish to work with your company Relevant Skills and Experience Account 12 year with stock maintenance, banking work, foreing exchange active documenting, ect

R3888 ZAR dalam 30 hari
(0 Ulasan)
R3888 ZAR dalam 10 hari
(0 Ulasan)

I have 4+ years of experience in data warehousing. Looking for my first freelance project..

R1944 ZAR dalam 10 hari
(0 Ulasan)
R1750 ZAR dalam 10 hari
(0 Ulasan)