- Strong Functional and Technically inclined consultant with experience focused on utilizing Microsoft's Business Intelligence stack in Functional Requirement Elicitation, designing, building and deploying multidimensional SSAS Cubes, SSIS Packages, SSRS Reports and Power BI analytics - Extensively worked on ETL Architecture to extract data from heterogeneous databases & different data source format (flat file, CSV & Excel file, Access database, SQL Database, SSAS cube) - Experience in writing MDX queries while creating and customizing Cubes using SQL Server Analysis Services (SSAS). - Extensively worked on Performance tuning and Optimization of the System. - Experience in creating Drill Down/ Through, Linked, Sub Reports, Hierarchical Reports using SSRS and Adhoc Reports using Report Builder and complex SSIS ETL Packages - Experience in Power BI with thorough knowledge of scripting (DAX), data source integration and advanced GUI development - Experience in design, development and implementation of small/large enterprise-level analytics solutions by leveraging the use of Power BI in the data visualization layer and role level security