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.
11 freelancers are bidding on average $2598 for this job
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.