• Having 6.5 years of experience in SQL Server Development, Power BI reports and maintenance of database application on SQL Server 2014/08R2 in OLTP. • Good understanding of RDBMS concepts, ACID properties and good in writing complex Queries, Sub queries, Co-related Sub Query, Stored Procedures. • Experience in creating the T-SQL Clustered and Non Clustered Index. • Good Understanding of Creating Composite Primary Keys on Tables For data integrity. • Extensively worked on stored procedures and scalar valued and table-valued functions. • Experience in implementing business logic using DDL, DML, Views, and Functions, Stored procedures, CTE’s and Sub queries. • Written the stored procedures and functions to read the data from XML and stored it into the database tables. • Hands on experience in using CTEs, recursive CTEs, Local temp and Global temp tables. • Strong knowledge in creating stored procedures, Views for performing automation tasks. • Experience in creating Clustered / Non-clustered Indexes to speed up the data retrieval. • Experience in writing queries using Joins, Sub Queries, Functions and CTE. • Involved in designing and development of Objects such as Tables, Views, Stored procedures & functions. • Experience in writing queries using Joins, Sub Queries, Functions and CTE. • Having Knowledge in Performance Tuning of MS SQL Queries. • Extensively worked on stored procedures and functions to read the data from XML and stored it into the database tables. • Improved overall decision-making by designing and developing Power BI reports and providing invaluable insights • Collabrated with cross- functional teams to identify and address bottlenecks in SSIS Solutions. Resulting in increased system efficiency. • Provide technical expertise and support to end-users in troubleshooting and resolving the issues, ensuring minimal disruption to business operations.