Sunil S.

• Azure SQL, Power BI, Azure Data Factory & Databricks working from last 4 years. • Highlight proficiency in Power BI Desktop, Service, DAX, M, and Data Modeling. • Converted SSRS Report to Power BI. • Extensive experience in T-SQL writing complex Queries, Stored Procedures, Functions, Triggers and Views. • Experience in Performance monitoring, SQL Profiler, Tuning, Query Optimization. • Experience in Replication Models (Snapshot/Transactional). • Employed SQL Server database to create and maintain Data Marts. • Experience in logical and physical database design, data structures, and data modelling. • Experience defining Data Warehouse (star and snow flake schema), fact table, cubes, dimensions, measures using SQL Server Analysis Services. • Experience in designing and implementing ETL packages using SSIS 2017/2016/2014 for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text file, Teradata) using multiple transformations available in SSIS toolbox such as Data Conversion, Conditional Split, Bulk Insert, Merge, Lookup and Union all. • Experience developing SSAS Cubes, Aggregation, KPIs, Measures, Partitioning Cube, Data Mining Models, and deploying and Processing SSAS objects. • Expert in designing Enterprise reports using SQL Server Reporting Services. Generated Drill down reports, Parameterized reports, Linked reports, Sub reports, Matrix reports and Cascaded reports in SSRS 2017/2016/2014.