Post Job Free

Resume

Sign in

Software Engineer Sql Server

Location:
Overland Park, KS
Posted:
September 21, 2023

Contact this candidate

Resume:

Nikhil Kandalkar

***** ******* **, *** *** adzu1m@r.postjobfree.com

Overland Park, Kansas, USA- 66223

913-***-****

LinkedIn Profile: https://www.linkedin.com/in/nikhil-kandalkar-299bb95a

Professional Summary

Motivated technical lead with over 10 years of experience in designing, developing, and managing projects using Microsoft Technologies including ASP.Net Core, ASP .Net MVC, Angular 2+, C#, Web API, SQL Server, JavaScript and jQuery.

Proficient in Software product development with deployment and build automation, Release strategy and planning, source code repository and environment management.

Experienced in Agile Methodology, GitHub (GIT) and Azure CI/CD with a track record of delivering projects on time and within the estimated timeline.

Additional skills include SSO implementation with ADFS and OKTA with two-factor authentication for security implementation.

Strong Knowledge and good experience in .Net Core 3.1/6, MVC framework, Angular, Web Api, C#, AJAX, ADO.NET, Entity Framework, JavaScript, jQuery, CSS, HTML

Developed web application using ASP.NET MVC (Razor view engine, View, partial view, models, and layout view) and ASP.NET Web API.

Good experience in developing UI Framework for Single Page Web Application (SPA) using AngularJS, Bootstrap, Angular 8, JavaScript, jQuery, HTML5, CSS

Hands on experience in handling databases like SQL SERVER, writing SQL scripts, stored procedures, Views, Functions as per the business needs.

Proven track record of delivering high-quality software solutions that meet business objectives. Seeking opportunities to leverage my extensive skills and experience in a challenging role.

Professional Experience

CitiusTech Inc. – Technical Lead Feb 2022 – PRESENT Overland Park, KANSAS

Led the development of mission-critical web applications using .NET Core Web API, SQL, and Angular 13

Detailed analysis of the as-is and new functionality, discussion, and clarification of the requirements with the product management team.

Keeping project roadmap on track and ensuring they are completed on time and according to specifications.

Work with clients to understand new requirements, analyze them to fit into existing application workflow, and define technical solutions and timelines.

Work closely with project managers and account managers to ensure that client expectations are met and that the team adheres to project schedules.

Implement modularized reusable components to use across the client applications.

Utilized Entity Framework to create database models and implemented business logic using LINQ queries.

Worked on creating a CI/CD pipeline.

Deployed applications to the server using Azure DevOps.

Production support and attending the Code Red call.

Implement an automated unit testing framework for application end-to-end testing.

Worked on creating Azure resource using Terraform script and deploying it using TFE.

Onsite Coordination between client and Offshore team.

Extensively involved in Agile methodology like attending daily Scrums, planning, defect and backlog, Review meetings and other meetings for efficient sprint.

Project:

1)Customer Portal: Aging and Disabilities (A&D) provides services to persons who may need various kinds of assistance on a day-to-day basis. This project is for creating the organization and users, providing the licensing features such as purchasing the licenses, assigning the applications against purchased licenses, providing the SSO functionality, and reporting of license history.

Environment: C#, Angular 13, .NET Core 6, Web API, SQL, ADFS/OKTA for SSO, Azure

CitiusTech Healthcare Technology PVT LTD – Senior Software Engineer Dec 2018 – Jan 2022 Mumbai, INDIA

Developed and maintained technical solutions to complex business problems using web applications using ASP.NET Core, Angular, and SQL Server.

Designed and Developed UI Framework for Single Page Web Application(SPA) using Angular, Bootstrap, JavaScript, jQuery, HTML5,CSS

Built Web pages that are more user-interactive using JQuery plugins for Drag and Drop, Auto Complete, JSON, Angular JS, JavaScript and Bootstrap.

Focused on database design, collation of requirements, designing, coding, review, and testing of applications.

Involved in project management activities like reporting, estimations, and work allocation apart from coordinating with Managers pertaining to requirements.

Experience in Code Review and code performance improvements.

Developed and maintained SQL Server databases, tables, and stored procedures.

Projects:

2)Aging and Disabilities: This project is for aged and/or disabled persons who may need various kinds of services on a day-to-day basis. The application will allow providers to enroll such people as consumers. Consumers will opt for various services available such as meals, healthcare, home care, etc. The application also handles claims, billing, and payments.

Environment: C#, ASP.NET Core, Angular5, Web API, SQL Server 2016, jQuery.

CMS Computers Ltd – Software Engineer NOV 2015 – JAN 2018 Mumbai, INDIA

Identify, prioritize, and execute tasks in the software development life cycle.

Undertaking scheduling and analyzing the requirements for further proceedings. Ensure software is up to date with the latest technologies.

Created Database structures, tables, Views, Stored procedures, triggers, Pivot tables and performed CRUD operations in SQL Server 2016.

Logged Exceptions, Errors, Information, and Warnings in the application for any issues using Log4net.

Created Client-side validations both field level and form level by using JavaScript, jQuery and angular functions.

Developed and maintained ASP.NET MVC project.

Used the ADO.NET SQL client Objects like SQL-Connection, SQL-Command, SQL-Data Reader and SQL Data Adapter and Dataset object in the Data Access Layer to fetch the data from the SQL Server.

Implemented data annotation and unobtrusive jQuery validation.

Used SVN Tortoise for all the source code maintenance among the whole team.

Projects:

1)Redemption Process – Back Office2: Back Office2: Back Office is a loan maintenance Web Application Of Jerrold Holdings Group. It handles customer data and transactions for loan clients. The requirement of a client was to provide support to the existing web application. The existing Back Office has a manual loan redemption process for the final settlement of the loan account. The requirement is to migrate all manual processes and calculations into a front-end application. Environment: C#, MVC5, Web API, Entity Framework, SQL Server 2012, LINQ, jQuery.

Technical Skills

Cloud

: Azure

Languages & Scripting

: C#, JavaScript, jQuery

Libraries & Frameworks

: Entity Framework, LINQ

Web Technologies

: Asp.net Core, Asp.net MVC, Web-API, Angular

Database

: MS SQL Server 2012, 2016

Development Tools

: Visual Studio Code, MS Visual Studio 2017/2019/2022.

Others

: OKTA, ADFS, New Relic, Agile methodology, TFS, GIT, Confluence, Snyk

Education

B.E. in Computer Science, Mumbai University, India, 2012

H.S.C (Specialization in Science), Maharashtra board, India, 2008

Work Experience

1] Organization name [Current]: CitiusTech Healthcare Technology Pvt. Ltd.

Designation: Technical Lead – 1, Delivery Lead (Onside), Technical Lead (Onside)

Duration: January 2018 to Present

2] Organization name [Previous]: CMS Computers Ltd.

Designation: Sr. Software Engineer

Duration: November 2015 to January 2018

3] Organization name [Previous]: Mastek Ltd.

Designation: Software Engineer

Duration: Dec 2014 – June 2015

4] Organization name [Previous]: V2 Tech Ventures Pvt Ltd.

Designation: Software Engineer

Duration: Nov 2012 - Dec 2014



Contact this candidate