Sql Server Software Developer
Resume:
Krupesh Shah
Software Developer
*************@*****.***
www.linkedin.com/in/krupesh-shah7dev
Summary:
●Almost 5 years of experience in end-to-end development of software applications from requirement analysis, designing, coding, testing, debugging, documentation, implementation using Microsoft.Net Technologies, and maintaining of web and Windows applications.
●Expertise in developing web-based and Windows based applications using ASP.Net, C#, SQL Server, and AngularJS.
●Extensive working experience with different methodologies like Agile Scrum, Test-driven development TDD, Domain-Driven, and Waterfall methodologies.
●Good experience with N-Tier architecture and Repository pattern.
●Extensive experience in Software Applications Development using Microsoft Technology namely ASP.Net, C#, Web API, WCF Service, Entity Framework, and databases such as MS SQL Server, Azure SQL Database, Win Forms and Parent Form.
●Good Hands-on Experience in front-end UI Development tools like HTML, CSS, JavaScript and jQuery, Angular, ReactJS, and Ajax.
●Experience in working with Angular 2/4/6 modules, services, templates, directives, services, and dependency injection to create web applications.
●Worked with HTML5, CSS, and JavaScript libraries such as JQuery, Angular JS, Bootstrap, JavaScript, and JSON.
●Implemented .NET Security features such as Authentication Authorization using Form-based and Window-based Authentication, Authorizing Users, Roles and User Account Impersonation.
●experience in working with IOT Devices using TCP/IP connection.
●Strong knowledge of Object Oriented Programming Systems (OOPS).
●Experience in building single page Applications (SPA) using HTML5, CSS3, LINQ, Bootstrap, JS, MVC 5.0, ASP.NET, and Entity Framework.
●experienced in writing the SQL Server Stored Procedures, Functions, Triggers, and Database tasks like backup and restore.
●experience in working with ASP.NET Windows Form, Web Form, CSS, JavaScript, and JQuery. Validation Controls and Secured Web Applications using Authentication Tokens.
●Experience in working with different version control tools like TFS and GIT.
●Strong analytical skills with proficiency in debugging and problem-solving.
Education:
●Masters in data science (Saint Peter’s University, NJ, USA)
●Bachelors in computer engineering (Gujarat Technological University, India)
TECHNICAL SKILLS:
●Languages: C#, SQL, JavaScript, HTML, CSS, jQuery, Python
●Databased: SQL Server 2012/2014/2015, Azure SQL Server
●Frameworks/Technologies: ASP.NET, ASP.NET Core, Entity Framework Core, Dapper ORM, .NET Core Web API, WCF Service, Windows Form, Windows Service, SQL Server, Repository Pattern, Factory Pattern, Unit Testing (C#), Azure, Azure DevOps, Debugging, PostgreSQL(basic).
●Methodology: Agile Scrum, Waterfall
●Tools: Visual Studio 2012,2015, 2017, 2019, SQL Server, VS Code, JIRA, Docker, Azure DevOps, GIT & TFS, Visio
●service Layer: Web Service(SOAP, REST), WCF, WEB API
EXPERIENCE:
Schrodinger NYC-NY (Aug, 2023 – Till Date)
Software Developer
Description:
I work as a Full Stack Developer at Schrodinger in New York City, where I oversee the complete development of features and user stories. Using tools like Azure SQL Database and EF Core Code-First with Repository Pattern, I construct RESTful API CRUD activities in my job. I manage the development of the AngularJS front end, SQL server database, and ASP.Net Core applications. my duties include working with QA teams to conduct testing and verification, adhering to Agile processes, and delivering web apps across various server environments.
Responsibility:
Implemented RESTful API CRUD actions like GET, POST, PUT, DELETE, and PATCH using EF Core Code- First with Repository Pattern, Microservices, and Azure SQL Database.
Owning full stack development responsibility for end-to-end development of the features/user stories with ASP.Net core MVC application tier, SQL server DB, and AngularJS front end.
Worked on JWT token-based authentication to provide security to the Web API and provide authorization to different users.
Developed a web application using RESTful Web API, Entity Framework, and Repository Pattern.
Involved with the lead in implementing CI/CD pipelines for .NET applications using Azure DevOps.
Managed all development tasks and source code modifications via TFS and GIT version control tool to coordinate team development.
Followed Agile methodology which involves daily Scrum Meetings and Sprint Meetings to meet deadlines, and discuss roadblocks and expectations.
Developed web forms in ASP.NET and WinForms applications in Which Presentation layer was designed in Windows form and business layer in .Net Core Application.
Used ADO.NET to connect Web forms to data sources such as MS SQL Server and XML files for manipulating data in database.
Responsible for designing database tables, writing complex stored procedures, and LINQ queries.
Developed searched components using Entity Framework to retrieve the search results from backend database Asynchronous calls with AJAX features with partial page updates.
Implemented NUnit Testing, and Integration Testing.
Responsible for deploying the web application/database entities across all environments.
Performed NUnit testing for the system, automated, and end-end testing, and prepared requirement documents for testing.
Environment: Asp.net Core, Web API, Swagger, Visual Studio 2022, LINQ, Entity Framework, SQL Server, GitHub, Azure.
Exelegent – Freehold NJ
Software Developer ( Sept 2022 To Feb 2023)
Description:
Exelegent, based in Freehold, NJ, is a dynamic software development company focused on designing and implementing innovative software and web applications. With a dedicated team of professionals, Exelegent specializes in planning, designing, and integrating new applications, utilizing cutting-edge technologies and best practices. From building REST APIs to developing desktop applications and implementing microservice architectures, Exelegent delivers high-quality solutions tailored to meet the diverse needs of its clients.
Responsible:
●Responsible for planning and designing new software and web applications. Analyse, test, and integrate the new applications.
●Responsible for designing, building, documenting, and consuming REST APIs using the Swagger OpenApi Specification tool.
●Implemented Desktop Application and created Setup Project .
●Involved in database development like creating stored procedure, functions, view.
●User Object-oriented design software development technique.
●Responsible for Writing stored procedures and LINQ queries.
●Worked on Generating report using HTML, CSS, and JavaScript.
●Involved with team to implement microservice architecture.
●Have maintained the Web application in TFS. Main features like Branching, Merging, Checkout and check-in were used.
●Coordinated and supported the team in the runtime environment to debug the production issues.
Environment: .Net Core API, Swagger, HTML5, CSS, JavaScript, Angular, LINQ, Visual Studio 2019, Agile, SQL Server, TFS, GitHub.
PlentyCart – South Plainfield - NJ (May,2022 – Sep 2022)
Software Developer
Description:
I worked as a software developer for PlentyCart, a South Plainfield, New Jersey-based software development company, from May 2022 to September 2022. I worked with project managers and team leads to gather requirements, design databases, and implement business logic as part of a variety of projects that I contributed to while I was there. I worked on Microservice Architecture using.NET Core REST API, utilizing Entity Framework and SQL Server database technologies. Additionally, I contributed to the implementation of multilingual validation messages, Swagger documentation, and validation controls to improve the usability and functionality of online applications.
Responsibility:
●Worked with project manager and team leads for the requirements gathering, Database design and business logic implementation for projects.
●Involved in Agile/Scrum Environment to develop the application by meeting the timelines.
●Worked on Microservice Architecture using .NET Core REST API.
●Worked on .NET Core API, Entity Framework and SQL Server Database.
●Established Data Models and Object Relational Mapping (ORM) using a combination of Language Integrated Query (LINQ), ADO.Net, Auto Mapper, and Entity Framework.
●Analyzed business, functional and technical requirements to make sure the project met expectations.
●Implemented Swagger/Swagger UI for the endpoint Documentation.
●User Object oriented design software development technique.
●Used LINQ entity framework for retrieving data from the SQL database.
●Created tables and indexes and wrote store procedures, and functions in SQL server.
●Implemented WCF services and hosted WCF services on IIS.
●Worked on Setup multilingual Validation messages for the Web Application.
●Worked on creating web services using ASP.NET Web API and C#
●Responsible for designing the web pages Using web forms, jQuery, User Controls, Form validation control and CSS.
●Involved with Team lead to implement CI/CD pipelines for .NET applications using Azure DevOps.
●Utilized Git for the version control and source code maintenance.
●Performed Unit, integration testing.
Environment: .NET Framework, C#, ASP.NET Web API, MVC, Visual Studio, SQL Server, IIS, WCF, JavaScript, LINQ, SQL, Angular 6, HTML5, CSS, GIT, Swagger/Swagger UI.
Samyak Infotech PVT. LTD., India
Software Developer (June 2018 - August 2021)
Description:
I worked as a software developer at Samyak Info Tech Pvt. LTD. Developed and maintained a variety of software solutions encompassing ASP.Net Core Web API, AngularJS, Angular, and Windows Form applications. Collaborated on IoT device communication via TCP/IP, conducted rigorous testing, and provided client support. Proficient in SQL Server database management, Agile methodology, and version control with Git. Experienced in handling logistics domain projects and adept at team management. Skilled in utilizing a diverse tech stack including C#, JavaScript, HTML, and CSS within Visual Studio environment.
Responsibility:
●Worked on ASP.Net Core Web API, Web API, WCF Service, Entity Framework, Dapper, AngularJS, Angular, Windows Form, SQL Server, Windows service, and web applications.
●Collaborated on communication with IoT devices via TCP/IP.
●Conducted unit testing, and integrated testing, and provided client communication and support.
●Responsible for developing desktop and Web applications and software.
●Used Asp.net Core API to develop N-layer Architecture.
●Responsible for the Creating SQL Queries,, Tables, and Database.
●Contracted API Architecture and desktop application architecture.
●Implemented Windows form application, and Web application with MVC architecture from Scratch.
●Used JavaScript, C#, HTML, and CSS as a front-end for Developing web Applications.
●Used TCP IP, and UDP connection for connecting software with Hardware for the AI applications.
●Working on SQL Server Management Studio.
●Used Git and Docker for the Continuous Integration and deployment process.
●Involved in Agile methodology for SDLC and web applications.
●Used Dapper for the Setup testing environment.
●Worked on Entity Framework Core, SQL server, Repository Pattern, and Unit Testing for Web application.
●Worked with Team lead for the setup of the project, Scrum board, and Estimation of the Task.
●Worked on Unit testing and integrated testing.
●Worked with Git with version controlling deployment.
●Attended client calls for the project requirements and Modifications.
●Developed Web Portals for the IOT Devices.
●CRUD operation of the database server was tested using the Postman services to ensure the get, put, and post functionalities are working fine.
●Used Factory pattern for the setup of different external Email and text APIs.
Environment: .NET Framework, Visual Studio, C#, ASP.NET Web API, Visual Studio, SQL Server, IIS, WCF, JavaScript, LINQ, SQL, Angular 6, HTML5, CSS, GIT, SQL Server Management Studio(SSMS), JIRA.
Silverwings:
Software Developer(intern), India (Jan 2018- June 2018)
Description:
Worked as an intern software developer at Silverwings during my January–June 2018 in India. I actively participated in database administration, front-end analysis, coding, debugging, and other software development processes in this capacity. With the use of technologies like JavaScript, HTML, CSS, ASP.NET, and Windows Form, I was instrumental in the creation of desktop and web apps.
Responsibility:
●Analysed the requirements and Modifications on the Front end side.
●Analysed the software structure.
●Involved in Coding the modules in asp.net.
●Worked on HTML, CSS, and JavaScript to develop and validate web forms.
●Written JavaScript code for performance validation.
●Worked on Windows form for the developing Desktop applications.
●Worked on debugging and bug fixing.
●Created design documents and database schemas
●Participated in the complete life cycle of the development Analysis, designing, Implementation, testing, and deployment phases.
●Written Stored Procedure in SQL server.
Environment: Visual Studio 2015, SQL, SQL Server Management Studio, HTML, CSS, JavaScript, Windows Form.
Contact this candidate