Sunil S.

• Azure SQL, Azure Data Factory & Databricks working from last 3 years. • Senior Database Developer with expertise in various ETL initiatives. Chief among them, designing and implementing ETL packages using SSIS 2014/2012/2008 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. • 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 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 2014/2012/2008.