Job Description :
Bloomfield Hills, MI
Multi-Year Contract

Key Skills: SQL Server, SharePoint and Business Intelligence.

Essential Duties will involve development and maintenance of Sharepoint environment, various SQL based
packaged and custom application and SSRS and excel based reports. Key skills required are expert level
development experience in SQL Server (Including T-SQL, SSRS, SSIS and SSAS), intermediate level knowledge of
Sharepoint development/administration (web parts, site definitions, libraries, PowerShell, etc and BI front end
tools (Performance Point Dashboards, power pivot, tableau, or any other reporting tool Having administration
experience in Active Directory will be a big plus. The ideal candidate should have worked with a combination of
these technologies for 4-6 years.

SQL Server:
Create data transformation packages to load data from various data sources to populate data-
warehouse using integration services (SSIS
Write stored procedures and triggers pull data from SQL Server for reports and other processing.
Develop and Implement SQL Server Reporting Services Reports (SSRS
Develop and maintain cubes, dimensions and measures using Analysis Services (SSAS

Knowledge of Sharepoint PowerShell, Central Administration, Service Applications, and site collection settings.
Design, develop, test, and deploy custom SharePoint web parts, custom features, Workflows.
Ability to create custom SharePoint site definitions (publishing, team sites, collaboration), Lists, Libraries, Content Types.
Experience in configuring all service applications (2013) and configuring Security.
Provide technical leadership and support for SharePoint sites/solutions development, site administration and user access.
Establish SharePoint governance and usage standards.
Give Training to users on processes and systems.

BI Reporting:
Create reporting dashboards in Performance Point, power pivot, or another similar package like Dundas
Dashboards, SAP BusinessObjects Xcelsius etc.
Create KPIs, Scorecards, and Reports for new measures.
Publish BI reports and dashboards through the SharePoint portal.

VBA - Excel/Access: PLUS
VBA and Excel Macro programming to develop applications for data collection and reporting.
Maintain existing VBA/SQL/Excel applications.

Active Directory Maintenance: PLUS
Able to administer user rights and access management.
Maintain Quest/Dell Quick Connect