Deepak M.

• Having 7+ years of development experience on Database Design and Development in MS SQL SERVER, SSRS and Power BI. • 1+ Years of experience in Azure Cloud, Azure Data Factory, Azure Data Lake Storage. • Expertise in gathering business requirements, identifying source, target and applying transformation logic as per the functional requirements. • Expertise in implementing Azure Data factory, pipeline components such as linked services, Datasets and Activities. • Good exposure on Power BI desktop and Power BI Service. • Expertise in handling data in different storage ADLS and Blob storage. • Having experience in connecting to different sources like Azure SQL database, data lake storage and blob storage from ADF. • Expertise in developing different type of report in Power BI, SSRS and Report builder. • Extensively used tools like SQL Profiler, Index Tuning Wizard, and Database Engine tuning wizard, Windows Performance Monitor for monitoring and tuning MS SQL Server performance. • Also worked on database creation, modeling, and log file parsing, Database server information, compress and copying daily log files. • System study, analysis, design, development, testing and implementation with expertise in online transaction processing and multi-user systems involving large and distributed databases. • Thorough knowledge of Normalization, data transfer, documentation, preventive maintenance, database security design and setup, client connectivity, developers support, automation, store procedures, load balancing etc. • Worked on development/staging/production environments.