Sandeep S

Years of exp 7.5 Technologies Worked SQL development , SSIS,SSRS,ADF,ADLS Companies PEPSICO,AMNET DIGITAL, PROKARMA, VALUE LABS , CAPGEMINI Other Activities Bring Talent to Org, Client Interaction and Design Databases Having a 7 Years of work experience on different Microsoft Azure data services like Azure Blob Storage, Azure Data Lake Storage Gen1/Gen2, Azure SQL Database, Azure SQL Data warehouse, Azure Cosmos DB ,Azure Data Factory, Azure Data Bricks Experience in SQL server and Microsoft Business Intelligence Tools (SSIS, SSRS) Worked with SQL Server 2008/2008R2/2012, SSIS and SSRS and ADF Having 3+ Years of experience in development of Client applications using Microsoft Technologies: SQL Server 2008/2008R2/2012, T-SQL programming, SSIS and SSRS. Expert in creating and debugging indexes, Views, complex Stored Procedures, user defined functions, cursors and Triggers to facilitate efficient data manipulation and data consistency. Sound knowledge & Expertise in Database development including data designing, developing Stored Procedures/functions etc. In depth experience optimizing the query by looking at the code and having experience on optimization and monitoring tools experience like SQL profiler, Query plan, estimated and execution plan, index adviser in SQL server. Hands of experience in Extract Transform Load (ETL) development using SQL Server, Integration Services (SSIS). Excellent knowledge on Full Loading and Incremental Loading with SSIS Worked on many Transformations such as Lookups, Conditional Split, Merge, Multicast, Derived Column, OLEDB Command, Row Count etc. Excellent knowledge of using variables and expressions in packages Good knowledge on Data Transformations. Expertise in generating reports using SSRS. Worked on SSRS to provide user access and assign roles. Willingness to have responsibility to lead a team and for successful deliver on it. Strongly initiative, creative and able to learn new technologies and systems. Set up health checks for systems & applications in monitoring tools like Nagios, SolarWinds etc. Creating the pipeline in ADF for loading data into the cloud. Different types of load strategies implemented using script and configuration files. And loading data into various tables through incremental, CDC and SCD approaches. Involved in analyzing data and designing the pipelines using the Azure data factory components. Involved in migrating the database from On-premises SQL server to Azure SQL and SQL Server Hosted inside Virtual Machine. Having work experience on lift and shift migration SSIS to azure. Participated in on-site interaction calls for requirement gathering. Cooperating and communicating with other team members for efficient management work and analyzing the business requirements