Somasundar Sambathini Email & Phone Number

16+ Yrs of Experience in Azure data implementations (ADF, Data Bricks, HDInsights, Polybase, Spark, Python etc), Datawarehousing, Business Intelligence technologies(SSIS, SSAS, SSRS, Sharepoint, Power BI) and SQL Server Programming. IT Professional offering a distinguished career of over 13+ Years with insightful exposure across designing and implementing Business Intelligence, Data Warehouse(MSBI). Excel BI (Power Pivot,PowerView, Power Query and Power Map), Office 365 Power BI.Proficient in Designing Business Intelligence Architecture using Sql Server 2014/2017, SSIS, SSRS, SSAS( Multidimensional Model and Tabular Model),DQS, Performance point server 2007/Performance Point services 2010, MOSS 2007/MSS-2010 ,Power Pivot,Power View, Office-2010/2013,Crystal Report and .Net and Excel Macro programming.Good understanding about Industrial solution verticals like banking, manufacturing, trading and retail.Strong MDX/DAX Script skills to design any type of complex MDX/DAX for busines user and Business needs.Specialties: Good hands on experience in SSAS included Unified dimensional model, Data storage, Dimensions usages, Creation of KPIs, Cube partition and good hands on experience to write MDX query/ DAX expressions. Strong Exprience in SharePoint 2010/1013, Excel Services, PowerPivot for SharePoint, PowerView Reporting using Tabular Model as well as PowerPivot. Strong and In-depth knowledge and experience on SQL server 2008r2/2012/2014/2017 on premise/azure Database(s) . Strong understanding about Database infrastructure. In-depth knowledge and hand-on experience on Database Objects like Indexes, Column store Index, stored procedure, functions, Trigger, strong query design and optimization technique

Listed skills include Ssrs, Ssis, .Net, Data Warehousing, and 1 others.

• 

  Mca

  Information Technology