Sumit Mishra

Created Restful API. Good knowledge of OOP principles and familiarity with applying programming principles and best practices to write maintainable code. Experience with implementing RESTful Services with ASP.NET Web API. Experience with unit testing and writing testable code. Experience with Microsoft SQL Server. Wrote Complex SQL Queries, Stored Procedures, Triggers, views, & Indexes using DML, DDL, Commands and user defined functions to implement the business logic and Performed normalization & De-normalization. Wrote T-SQL Quereis and procedures to generate DML Scripts that modified database objects dynamically based on inputs. Reviewed, analyzed, and implemented necessary changes in appropriate areas to enhance and improve existing systems. Implemented ETL processes using Power Query to extract, transform, and load data from various sources into Power BI. Designed and developed interactive dashboards and reports using Power BI, enabling the management team to make data-driven decisions. Developed complex DAX calculations and custom measures to derive insights from the data.