Sql Server .Net Core

Nishant Gupta

Full Stack Developer

Troy, Michigan • +1-248-***-**** • ************@*****.*** • linkedin.com/in/nishant-gupta-23534a155/

PROFESSIONAL SUMMARY

oHighly-skilled Full Stack development professional with more than 15 years in software design, development and maintenance using .NET Technologies.

oExtensive Experience in various front-end/back-end web technologies using ASP.Net, C#, MVC, HTML5, CSS, JavaScript, Entity Framework, WebAPI, XML, JSON, Angular

oProficient in using Entity Framework using LINQ and ADO.Net for data manipulation (CRUD) going against multiple data sources

oStrong expertise and development of database objects like tables, views, stored procedures using SQL Server/Oracle. Extensive working knowledge in creating indexes, triggers, constraints, sql jobs, performance tuning e.t.c.

oWorking knowledge of Azure Devops (CI/CD) and Azure cloud (Azure databases/services)

oKnowledge of NoSQL databases.

oLeveraged Agile methodologies to support the SDLC process.

oContinuously exploring new tools and methodologies to enhance development processes and improve application performance.

SKILLS

Web Technologies: .NET framework (4.6, 4.5, 4.0, 3.5), ASP.Net, .Net Core (6.0, 3.0), MVC, Web API, LINQ, Web Services, XML, JSON, Angular, WPF, Windows Forms, Bootstrap, CSS3, Restful Services, AJAX, Azure

Languages: C#, HTML 4/5, VB.Net

Scripting Languages: JavaScript, jQuery, PowerShell

Database: SQL Server (2016, 2012), Oracle 10g, NoSQL (MongoDB)

IDE: VS Studio (2022, 2019, 2015), VS Code, SQL Server Management Studio

Source Control: Team Foundation Server (TFS), Git, VSS

Reporting: Crystal Reports, SSRS, SSIS

RELEVANT WORK EXPERIENCE

Blue Cross Blue Shield of Michigan Detroit, MI March 2007 – August 2024

Advanced Software Engineer

As part of the auditing department, I developed and maintained applications to manage claims and recover payments from providers. My development efforts contributed to recovering over $10 million annually. Additionally, I streamlined business processes, resulting in significant efficiency and productivity gains

oDeveloped and maintained an ASP.NET application that allows users to manage 100,000+ claims from multiple providers. Built using .Net Core, MVC, SQL Server 2016 and Visual Studio 2022

oCreated an ASP.NET WebAPI back-end service for an Angular front-end application using Visual Studio 2019, .Net Core, SQL Server 2016

oDesigned and created an ASP.NET application to process claims for payment, utilizing .Net core, MVC, and SQL Server 2016

oMigrated a WPF application to ASP.NET platform, enabling audit document management, reporting for vendors & internal department. Implemented with .Net Core, MVC, SQL Server 2016 and Visual Studio 2019

oDeveloped a web application using jquery plugin (jtable.org), WebAPI back-end service and SQL Server 2016

Technologies used: MVC, authentication, role-based authorization, Entity Framework, Dependency Injection, ADO.Net, View Components (Custom Grids), LINQ, CSS3, HTML5, Jquery, Angular, JSON, XML

FMF Capital Southfield, MI Jan, 2005 – March, 2007

Solutions Engineer

As part of a subprime mortgage company, I developed and maintained applications supporting the entire loan lifecycle from origination to servicing

oDeveloped and maintained a Windows application for managing mortgage applications from loan origination to servicing. Built using VB.Net, SQL Server 2005 and Visual Studio 2003.

oCreated a Windows Service to interface multiple systems and handle daily data migrations. Implemented using VB.Net and SQL Server 2005, and Visual Studio 2003

oCreated an intranet website for users to add, modify or view business user Information, using ASP.Net and SQL Server 2005 and Visual Studio 2003

oProvided application support and performed changes for MS Access 2002 application developed with front-end MS Access and back-end SQL Server 2005.

Technologies used: VB.Net, ASP.Net, ADO.Net, MS Access, CSS, HTML, SOAP, XML

EDUCATION

Masters of Science, University of Michigan, Dearborn MI Sept 2000 – June 2002

Major: Computer and Information Science

Bachelors of Science, Wayne State University, Detroit, MI Sept 1995 – Dec 1998

Major: Computer Science

Contact this candidate