I am the Azure Data Engineer,ETLdeveloper, SQL Developer. My professional experience includes extensive hands on expertise on Microsoft technologies.I understand how to build project that directly meet user requirements end to end, user friendly and affordable. I also understand the importance of building strong projects that stand up to the high performance and high volume environment.
13+ years of professional experience in IT, as SQL Server 2016/2012/2008/2005/2000 Database Developer with SQL server and SQL Azure.
•Extensive experience in Azure Databrick notebooks, Azure Data Factory and Azure DevOps.
•Extensive experience in Pyspark, Python, SQL, ETL process, SSIS, SSRS, C#.Net, VB6.0, Oops concepts and Windows Application.
•Extensive experience in development of Reconciliation applications - Recon Frontier 3.0, Recon Frontier 7.2, Recon Trade & Intellimatch.
•Good understanding of Data Warehousing OLAP, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables using SQL server Analysis Services (SSAS).
•Expert in designing and implementing Database using various RDMS like SQL SERVER, Oracle, MS Access.
•Expertise in implementing business logic using Triggers, Views, Stored Procedures and User defined functions.
•Expertise in writing T-SQL Queries using Joins, Sub queries, CTE, Window function.
•In-depth knowledge in Tuning SQL Queries and improving query performance.
•Experienced with SSIS performance tuning on Control flow, Data flow, Error handling, and Event handler, re-running of failed SSIS packages,
•Experienced on Managing SSIS packages with SQL server management studio, create SQL server agent jobs, configure jobs, configure data sources, and schedule packages through SQL server agent jobs.
•Hands on experienced in Deploying, Build, and SSIS Packages/Project, Securing SSIS packages, Managing and Browsing SSIS packages.
•Experience in creating Jobs, Alerts, SQL Mail Agent, and Scheduling DTS and SSIS Packages.
•Experienced in creating various types of reports such as drill down & drill through reports, Matrix reports, Sub reports and Charts using SQL Server Reporting Services (SSRS) on Relational databases.
•Assisted production support team in resolving performance issues, defects, and database availability issues
•Created and Managed SQL Server Logins and Users as per the requirement with specific roles and permissions on production servers.
•Performed DBA activities like creating Logins, Users, groups, Roles, Jobs, Alerts, Mails confirmation upon tasks.
•Has done DBCC checks to ensure the physical consistency of the database and objects.
•Checking Space monitoring, Index Defrag, rebuild index, and reorganize Index, Update Statistics.
•Planning and implementation of database backup/restore Strategies.
•Experience in working with shared code repository GIT, TFS and SVN.
•Good experience in the development, implementation, testing of application software.