Closed

Report from two SQL databases

A. PROJECT OVERVIEW:

The idea is to create dedicated analytical database which is linked to SFA and OMD mirrow SQL databases. End users will use data link to analytical database to query data through PivotTable data service of MS Excel application. Both bases are in MS Windows and have total size of around 5Gb.

Looking for a professional with following experience:

• Programming and administration for SQL Server 2000

• Programming languages: SQL, T-SQL

• Using Excel PivotTable services

• Working with ms share point databases

B. PROJECT ESTIMATE:

Rough estimate is around 100h man hours in total and 4-8weeks in duration.

Look the attached file to find more detailed estimation.

C. MORE PROJECT DETAILS:

Analysis was done reviewing SFA and OMD databases.

The results of SFA database analysis is saved in UML model and will be provided if there is a fit.

The brief summary of OMD database analysis is the following:

The OMD system has special option which described in its manual which allows performing information transfer in outer SQL Server database. It can be used to setup OMD mirrow SQL database which updated by nightly run of special scripts. This database with existing SFA database can be used for creation Pivot Table reports.

There is good description of OMD tables in help on database structure at host where installed OMD server.

Skills: Data Processing

See more: working from, find programming services, use data structure programming, tables data structure, report programming, programming databases, programming sql, programming from, programming data structure, professional summary, looking good excel professional, linked services, fit model, find professional service, estimation excel, databases programming, database programming sql, database programming services, pivot table report, sql experience, on sql, excel professional services, database administration services, two hours, summary table

About the Employer:
( 0 reviews ) San Diego, United States

Project ID: #195512

11 freelancers are bidding on average $2598 for this job

dataconsultants

Please check PMB for details, Thank You

$3000 USD in 30 days
(44 Reviews)
5.0
sawantgovind

Dear Sir, Please chect PM Regards

$2000 USD in 30 days
(0 Reviews)
0.0
elastain

First bid......i have to keep myself on the top for the rest to come.

$2750 USD in 22 days
(0 Reviews)
0.0
waitingadi

I am a sql server database professional with 5 years of work experience. I even have US masters concentrating on query performance. I also have excellent communication skills and if selected will try my level best to d More

$2300 USD in 25 days
(0 Reviews)
0.0
pobeda

I am a data analyst and ms sql server programmer. My experience with ms sql 2000 is about 4 years. Reporting and analysis are tasks well-known to me. Thank you.

$1800 USD in 40 days
(0 Reviews)
0.0
KTCJPR

We have expertise in database, database application, database migration and reporting.

$1800 USD in 30 days
(0 Reviews)
0.0
reliable13

We can do this job with Quality .

$4600 USD in 23 days
(0 Reviews)
0.0
profinnovators

We strongly believe that we wil be able to deliver the result as per your requirements

$4500 USD in 30 days
(0 Reviews)
0.0
galileng

www.galileng.com

$2500 USD in 20 days
(0 Reviews)
0.0
Georgest

2 similar projects are succeed for the last 2 year

$1700 USD in 21 days
(0 Reviews)
0.0
Desperado2006

Hello! I am a professional Developer also working for largest IT-outsourcing company in Ukraine, have good skills in MSSQL, Mysql , Data Analysis and T-SQL. Managed to do a personell efficiency analysing DB with buildi More

$1630 USD in 25 days
(0 Reviews)
0.0