Sharepoint and SQLServer 2008 BIDC DW development

Web, Mobile & Software Dev Web Development Posted 2 years ago

Hourly Job

Part Time
1 to 3 months

Details

Job Description
Overview
Seeking experience in SSAS on SQL Server 2008 R2, including converting a OLTP  data model to a data cube for SharePoint Business Intelligence using Excel Services, PerformancePoint Analytic Reports, PerformancePoint Scorecards, PerformancePoint Dashboards.
Base data is from a traditional warehousing environment representing: Ordering, Shipping, Usage, and Inventory Levels

PROJECT
•Create instances of  OLAP SSAS Data Cubes from  OLTP tables in a SQLServer2008R2 .  OLTP scripts will be provided.   Will be required to supply scripts for database  including SSIS and SSAS projects into a test environment.
• Create  import package using SQLServer Integration Services or SSRS to load data from Excel/CSV file into database.  
• Create  five  SQLServer drill down reports using SQLServer Business Development Studio and Reporting Services with Asp.Net
• Convert existing Excel 2010  dynamic charts file with data supplied from a MS Access  data connection to use SQLServer data connection.
• Generate five  interactive dashboards  from within Sharepoint 2010  using PerformancePoint Analytic Reports, Performance Point Scorecards, PerformancePoint dashboards, SQLServer Reporting Services and VS.
• Provide this application to the Project Manager with instructions and guidance to help install in Office365 SharePoint environment.


TIMEFRAME
Start Date: Immediately

Stage 1: Create tables (tables and fields will be supplied) to SQLServer OLTP database and populate values (will be supplied from Excel) .  Create BASE  ELT SSIS scripts to load into   SSAS data cube with sufficient indexes for adequate performance.  Supply guidance on the STAR schemas to build the fact and dimension tables for 3 data cubes.
Stage 2:  Convert Graphs in Excel 2012 to Sharepoint BI web parts using SSAS, SSRS, Performance Point Analytic Reports and  Business Intelligence tools .
Stage 3:  Provide assistance and scripts to load instance onto Office 365  sharepoint instance


END DATE: March 7, 2013

Responsibilities will involve:
- Reviewing draft cube design against output specification (web pivot grids / charts)
- Proposing and implementing changes to cube design and/or SQL source
- Constructing custom measures with MDX
- Implementing solution for business users to update / process cube

Possibility of follow-up development after this initial phase.

In your response, please provide:
- evidence of similar work done in the past, particularly any MDX examples.
- possible times for interviews (8am-9pm GMT)
- availability over next 2-3 weeks

Skills Required:
microsoft-sql-serverolapssis
Preferred Qualifications:
Feedback Score:
At least 4.00
Test Passed:
MS SQL Server 2005 Test
English Level:
Fluent in English with  good verbal and written skills

---
Skills: test, import, ssrs, design, english

Skills Required:

Client Activity on this Job

Last Viewed: 2 years ago

Applicants: 38

Hired: 3


About the Client

(4.92) 9 reviews

United States
Gahanna 06:27 AM

15 Jobs Posted
67% Hire Rate, 1 Open Job

$2,590 Total Spent
15 Hires, 2 Active

$15.46/hr Avg Hourly Rate Paid
148 Hours

Member Since Apr 4, 2012