Sumit Mishra
@sumitmishra
Software Engineer at ONE Business Consulting Group
New Delhi, India
Sumit Mishra is a Software Engineer with experience in software development and data analysis. He has expertise in building RESTful APIs using ASP.NET Web API and implementing complex SQL queries, stored procedures, and ETL processes. He is proficient in data visualization, having designed interactive dashboards and reports using Power BI and advanced DAX calculations.
Experience
Software engineer
ONE Business Consulting Group
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.
Education
Lal Bahadur Shastri Institute of Management
MCA
Swami Shraddhanand College
Bsc Physical Sciences
Kendriya Vidyalaya No-4
12th Boards
Nav Gian Deep Public School
10th Boards
Licenses & Certifications
Data Visualization and Dashboards with Excel and Cognos
Python for Data Science, AI & Development
Databases and SQL for Data Science with Python