? Design Data Warehouse and OLAP, using schema Star and Snowflake. Building Essbase Cubes. ? SSAS, (Design Cubes, MDX Queries, Managing and Optimizing Cubes, Partitions and Aggregations) ? Create Name Sets and Calculated Members inside Cubes. ? Multidimensional and Tabular cube design methodology. ? Create Reporting Services with SSAS, Using Excel to display cube data and Analyze data with Power Pivot (DAX). Design MS Excel based Report on SSAS Cubes, Create Offline Cubes. ? Deploying and Processing Cubes, Creating Dimensions, User Interfaces ? Actions, Enable Proactive Cache, Process Cubes through SSIS Packages. ? Monitoring Cubes and Packages of SSIS. ? Design SSIS package of different data sources to maintain Data Mart. ? Populate Dimension and Facts tables using SSIS Package (Incremental an Transactional) ? Experienced in Developing Report in SSRS 2016 sources like SSAS cubes and SQL Server. Parameterized Reports. Design Matrix and Tabular Reports.