Swetha Mk Email & Phone Number

Having over 8 years experience as a Business Intelligence Developer with a primary focus on Power BI and Microsoft SQL Server 2019/2016/2014/2012/R2. SQL proficiency and understanding of RDBMS principles, especially Microsoft SQL Server. Expertise in Data Modeling using SQL Server, including Star & Snowflake Schemas, Fact and Dimension Tables, and Physical and Logical Data Modeling. An excellent understanding of the project management methodologies of Waterfall and Agile. Installation and configuration experience with SQL Server 2019/2016/2014/2012/2008. Experience designing, developing, and maintaining Power BI reports and dashboards that provide actionable insights to business users. Experience on publishing Power BI reports of dashboards in Power BI server and Scheduling the dataset to refresh for upcoming data in power BI server. Reporting and dashboarding experience using Power BI. Experience with MS SQL Server BI tools (SSDT) including SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Services ( SSAS). A working knowledge of performance tuning, client/server connectivity, query optimization, and DBCC commands for checking database consistency. Expertise in developing complex Stored Procedures, Triggers, Tables, Views, and User Defined Functions in T-SQL. Working experience analyzing query plans, managing indexes and locks, troubleshooting deadlocks. An expert in SQL Server Integration Services and Packages (Developing, Deploying, Scheduling, Troubleshooting, Monitoring) for data transfers and ETL purposes. Expertise in Complex Stored Procedures, Views, Import/Export, and System Views and Functions. Data extraction and migration experience using import/export Wizard, SSIS, BCP and Bulk Insert utilities to migrate data from Excel, Access, and Oracle to MS SQL Server. Extensive experience writing, debugging, fine-tuning, and optimizing complex Stored Procedures, Cursors, and Triggers in SQL Server by analyzing the Query Execution Plan. A significant amount of experience in logging, error handling, and custom logging for SSIS packages, using event handlers and custom logging. In-depth knowledge of row transformations, partial blocks, and blocks. Expertise in designing and implementing enterprise reports (SSRS/Business Objects) utilizing data derived from ETL loads, SSAS Cubes, and multiple heterogenous data sources.

• 

  Visvesvaraya Technological University

  Computer Science