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.