Strong experience with SQL Server 2000/2005/2008/2012/2014/2016, SSAS, SSIS. Deep knowledge of MDX, expert writing queries using MDX & SQL to aid generation of required Business Intelligence reports. Expert building big and complex OLAP cubes at SSAS, size 100+ G, 200+ dimensions, 1000+ measures.Good experience and understanding of database design, data model optimization for BI application. Experience supporting Data warehouses and Data marts at MS SQL Server size 1+ Tb, 400+ million rows fact table.Strong experience in T-SQL, developing ETL strategies based on SSIS, SQL scripts, Stored Procedures, UDF, XML.Experience with CRM and Workflow management tools such as Salesforce, JIRA.