• A solid understanding and great experience in working with different subsets of SQL server such as DML, DDL, TCL and DCL Commands.• Created and worked with various database objects such as complex stored procedures, multivalued user defined functions, temporary tables, CTEs, Derived tables, table types, views, and triggers.• Wrote complex queries using subqueries, cross apply and outer apply.• Implemented error-handling in T-SQL inside transactions using TRY-CATCH blocks.• Managed isolation levels of transactions, by setting transactions Read Committed, Repeatable Read, Serializable and Snapshot Isolation level in order to prevent problems such as Dirty Read, Lost Update, Non-repeatable Read and Phantom rows as to have better concurrency control over the transactions.• Converted data coming into JSON data using openjson function and loaded data into SQL Server Database.• Created complex Power BI reports and dashboards using Power BI Desktop and Power BI service.• Set up row-level security to restrict data access for different users and roles in Power BI reports.• Implemented performance Tuning of Power BI reports using Performance Analyzer and DAX Studio.• Integrated Power BI reports and dashboards into web applications using Power BI Embedded for external user access.

• Created SQL Server jobs and scheduled them to load data periodically using SQL server Agent. • Created reports using Power BI Desktop and deployed to Power BI Service to share with end users via Workspaces and Apps which implemented Row Level Security and User Group management. • Using Power BI, created accounting reports including Year-To-Date, Month to-Date, Period Close reports, Transaction and Snapshot reports for General Ledger, Budget reports, etc. • Created and constructed different SSIS packages. Involved in automating SSIS Packages using SQL Server Agent Job, Windows Scheduler, and third-party tools. Worked on several transformations in Data Flow including Derived Column, Script, Slowly Changing Dimension, Lookup, Data Conversion, Conditional-Split and many more. • Provided performance tuning within SSIS packages and SQL Stored Procs, Views, Inline Queries and Dynamic Queries. • Designed and built Dimensions and Facts, Staged data from various sources for future use in building warehouse Dims and Facts. • Designed reports on account information, research reports using ad-hoc reporting to be used by clients and advisors. • Worked on Power BI in creating dashboards and reports and visualizing data.

• Wrote and Developed complex T-SQL stored procedures/ User Defined functions/expressions, CTEs, indexed views, stage tables to process the data and populate them in the appropriate destination tables;• Utilized T-SQL extensively to support the finance team, including constructing user profiles, relational database models, data dictionaries, and ensuring data integrity.• Extracted, transformed, and loaded data from various databases, such as CRM, ERP, and SharePoint.• Developed complex T-SQL code, including stored procedures, functions, triggers, indexes, and views for application functionality.• Demonstrated strong expertise in databases, SQL, and data warehousing, including performing source-to-target table mappings.• Possessed working knowledge of cloud database technologies, including SQL Server, Hadoop, and MariaDB.• Familiarity with scheduling tools like Control-Center.• Created SSIS packages to extract data from different file formats (.txt, .csv, .xlsx) and load it into SQL Server tables.