Working with and assisting the client’s team, who is in Beverage Industry to help them in building Dashboards and Reports as well as automating the existing project architecture and streamlining it.The team is part of the People Business Services who are currently trying to track the data excellence in their HR suite and other HR related KPI’s in a single scorecard across all zones.

Leveraged different tools from Microsoft’s BI stack such as Power BI, SSMS, SSAS, SSRS, etc to assist in designing and developing Dashboards and Reports.Took part in Requirement gathering, Development, User Acceptance Testing(UAT) and Product Walkthroughs.Restricted the data access for users dynamically using Row Level Security(RLS) and/or Object Level Security(OLS).Migrated the data sources of existing reports and connected them to SSAS Tabular Cubes to increase their performance… Show more Leveraged different tools from Microsoft’s BI stack such as Power BI, SSMS, SSAS, SSRS, etc to assist in designing and developing Dashboards and Reports.Took part in Requirement gathering, Development, User Acceptance Testing(UAT) and Product Walkthroughs.Restricted the data access for users dynamically using Row Level Security(RLS) and/or Object Level Security(OLS).Migrated the data sources of existing reports and connected them to SSAS Tabular Cubes to increase their performance and reduced the size constraints.Data Modeling using best practices like Star Schema in Power BI or SSAS according to the project architecture for sustainable dashboards. Show less