*The consultant should be extremely good at SSAS cube
design/optimization/tuning and also should be able to develop SSIS packages
including delta load..etc. If you have Ex-Microsoft Professional services
guys it would be still good. Appreciate your help.*

*Location : North San Francisco*

*Duration : 4 - 6 months*

*Advanced SSAS (SQL Analysis Services),*

*Advanced MS SQL Server*

*Advanced Data Modeling*

*Intermediate MS Excel,*

*Intermediate SSRS (SQL Reporting Services), Intermediate SSIS*

*9+ Years of experience in Enterprise Data Warehouse Implementation*

*experience and 5+ years of implementing Microsoft Business Intelligence
solutions leveraging SQL Server 2005/2008, SSIS, SSAS. The consultant has to
have strong technical skills in BI Architecture, Data Modeling, ETL design,
Data Quality, SSAS cube design and overall reports deployment strategies.*

*Experience with health care domain is a plus. Has to be a great
communicator and ability to create technical design/architecture
documentation and ability to interact with IT Directors, business VPs.*

*1.Business analysis: This person will meet with  users to understand and
document business requirements. The person must be able to lead the meeting
and direct the conversations towards identifying requirements. The person
must then organize and document the requirements in a format that could be
understood by both business and IT.*

*2.Requirements Gathering: The consultant should be able to trace what was
identified in the requirement back to the source systems. He/she needs to be
able to communicate to IT SMEs and construct the necessary data model and
column mappings from source and destination systems.*

*3.ETL Development: This person then needs to create the SSIS packages
necessary to extract, format and load the data from the various source
systems into the new data model. This person will verify the data accuracy
and compatibility with the source system.*

*4.Cube Development: The consultant should also be able to build the*

*cube(s) using SSAS. The cubes will be tuned to allow users to easily access
the data using front end tools, including Excel.*

*5.Reports Development: Optional this person should have experience of
integrating reports, SSRS & Excel services, into SharePoint.*

*6.Analytics and Dashboards: Optional also is the knowledge and the ability
to work with of 3rd party software that integrates with SSAS and be able to
provide training and mentoring to IT and business users on the use of these

You received this message because you are subscribed to the Google Groups 
To post to this group, send email to reqsresumes@googlegroups.com.
To unsubscribe from this group, send email to 
For more options, visit this group at 

Reply via email to