Microsoft Business Intelligence and Data warehousing Specialist
12 + years of experience on Data warehouse and Business Intelligence with MS SQL server development across Investment Banking, Private Banking, US Mortgage, Telecom and Automobile Industry domains.
Expert in creating Power pivots, Power views and SSRS reports using tabular model (DAX), Cubes (MDX) and SQL queries.
Experience in implementing user based subject selection (Role based security) in Power Views, Power Pivots and SSRS using DAX, MDX and SQL queries
Expert in creating indexes, Views, complex Stored Procedures, user defined functions, cursors, derived tables, common table expressions (CTEs) and Triggers to facilitate efficient data manipulation and ...