Having Good Analytical Skills with min 4+ years of experience delivering solutions utilizing the entire Microsoft BI stack (SSAS, SSIS, SSRS) - SQL Server 2008R2 / 2012. Strong working knowledge of Microsoft OLAP Cube concepts i.e. OLAP processing, capacity planning, performance tuning and administration, dimensions, hierarchies, aggregations, measures, KPIs, calculations, storage and partitions, etc. Extensive experience in MDX Scripting of multidimensional OLAP Cube data . Write high performance query and provide guidance to the team on writing efficient high performing database queries. Database design using tools such as Erwin. Work with source data team and client to understand data, perform analysis and create requirements. Assist in creating data loading programs using SSIS. Troubleshoot production problems encountered in our production environment. Microsoft BI Certification. BTECH/MCA from Reputed University.
Experience: 8+ Yrs (Since last 4 years only on MSBI)