Strong experience in developing complex Stored Procedures, Functions, Triggers, Views, Cursors, Joins and Sub queries with T-SQLExperience in creating Jobs, Alerts, SQL Mail Agent and Scheduled SSIS Packages. Experienced in designing and developing large number of enterprise reports (SSRS/Business Objects) using the data from ETL loads, SSAS Cubes and various heterogeneous data sourcesHighly proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Tables, User Defined Functions, Views, Indexes, User profiles query writing and SQL joins.Developed Cubes using SQL Analysis Services (SSAS) and Experience in Developing and Extending OLAP Cubes, Dimensions and data source viewsInvolved in writing MDX Scripts for the SSAS Cubes, developed reports using MDX and SQL. Knowledge in developing cubes using Partitions, KPI's, and Perspectives, storage, aggregations etc. and created various user roles (SSAS).Experienced in using Data Analysis Expressions (DAX) to creating custom calculations in Power Pivot for Microsoft Excel workbooks and Analysis Services tabular model projects. Involved in the Design Complex Reports like Drill Through, Tabular, Drill Down, Matrix and Sub Reports in SSRS