.Net Developer Sql Server

Sheshwanth Gundeti

**********.***********@*****.***

Full Stack .Net Developer

913-***-****

PROFESSIONAL SUMMARY:

Full Stack .NET Developer with 5+ years of experience in designing, developing, and implementing web applications for healthcare, banking, and finance domains using C#, ASP.NET, Entity Framework, and modern front-end technologies.

Strong experience on MS SQL Server using SQL, MS SQL, SSIS and T-SQL. Have worked on ETL using SSIS and DTS packages.

Experience in creating Views, Partial Views, and Sections etc. In ASP.NET MVC, and Created the Controllers and Controller Actions, Filters, Routing using ASP.NET MVC.

Working with RDBMS includes MS SQL Server … Oracle 8i, 9i, 10g, 11g, 12c and MS-Access.

Responsible for making AJAX Calls for the UI Interactions to the Controller Actions using Angular JS and getting the Data back as JSON and parsing it onto the UI.

Developed complex queries using the SQL API in Cosmos DB to perform data retrieval and manipulation within .NET applications.

Excellent skill in data modelling and implementing tables, views, stored procedures, functions, schemas, and Triggers using T-SQL Queries and PL/SQL.

Good application deployment experience on Windows and on other platforms like UNIX, Solaris.

Expertise on working with RDBMS like DB2 (v 8.1.2) and Oracle (v 8i, 9i, 10g) and knowledge of directory services like LDAP.

Utilized Postman to test and validate RESTful APIs developed in .NET, ensuring they meet functional requirements and perform as expected.

Extensive experience in Web using MVVM, MVC, JSON based development and WEB API 2.0

Working knowledge on Cloud Platforms like AWS, GCP, OpenStack, OpenShift.

Hands - on experience in deploying applications to MS Azure Private Cloud and Good Experience in TFS Branching and Merging.

Implemented and managed indexes in MongoDB to improve query performance in .NET applications.

Demonstrated proficiency in development using Microsoft.NET technologies like ASP.Net, C#, VB.Net, ADO.Net, Web Services, MVC, AJAX, Windows Services, WCF Services, OOPS, XML, XSLT, HTML, SOAP, LINQ Text Editor, MS IIS … DHTML, VBScript, VSS, JavaScript, SQL Server.

Experience in designing web pages using HTML, JavaScript, HTML, CSS and jQuery, Angular JS, AJAX, Bootstrap and JSON, Node JS., UML.

Strong Experience in Web Forms and Win Forms applications with .NET Framework … and Visual Studio.

Strong Microsoft Technologies in the fields of Win - forms, Web-forms, Web Services using ASP.Net … VB.Net, C#, MVC, Entity framework, Angular JS, ADO.NET AJAX, LINQ, WCF, WPF, Silverlight 2.0/3.0 using Microsoft .Net Framework.

Experience in using testing Tools JUnit, Selenium, Cucumber/Gherkin.

Expertise in database modelling and development using SQL, T-SQL and PL/SQL in Oracle and SQL Server environments.

Exposure to Oracle, DB2, and MySQL databases in developing applications using SQL Scripts, Stored Procedures.

Experience using an Integrated Development Environment like Eclipse, RAD 7.5/8.5 for code development.

Good experience on MS Azure Cloud Architecture (MS Azure Pack (Private Cloud), PaaS and IaaS) assessments.

Designed large numbers of WPF Forms and used XAML for the same.

Involved in development of projects using SQL Server Integrated Services (SSIS), SQL Server Reporting Services (SSRS) and Data Transformation Services (DTS)

Good experience with Agile (SCRUM) methodology, Waterfall and Test-driven development.

Exposure in Requirement Analysis, Architecture & Design Documentation, Reviews, System Development, System Testing, System Implementation, User Documentation.

Very Good experience in handling clients & meeting their requirements and willing to adapt to new technologies/work environments, well organized team player with good analytical and leadership skills. In-depth knowledge of PL/SQL with the experience in constructing the triggers, tables, functions, user-defined data type, procedures etc.

Experience in configuration and version management using Sub Version (SVN), Team Foundation Server (TFS), GIT and defect tracking tools like JIRA, Visual Studio Team Services, Database projects.

Performed Unit Testing (using N-Unit), Integration Testing and Performance Testing.

Proficiency in working with databases like Oracle, MySQL, MongoDB, NoSQL.

Extensive experience in developing Web Services applications using REST Client, REST API, SOAP UI, dozer mapper.

Versatile team player with good communication, analytical, presentation and interpersonal skills.

TECHNICAL SKILLS:

Programming Languages

C#, Java, VB.NET, VB, PL/SQL

Web Technologies

ASP.NET, ASP.NET MVC, ASP.NET API, ASP.NET CORE, HTML, CSS,

JavaScript, jQuery, Angular, ReactJs, Bootstrap, JSON, AJAX, Mango db

IDE Tools

Visual Studio 2020-2022, SQL Server Management Studio (SSMS), SQL Server Business Intelligence Development Studio (BIDS), Eclipse

Databases

SQL Server 2014-2015,2018, Oracle 12c, Access, MySQL

Reporting Tools

SQL Server Reporting Services (SSRS), Crystal Reports

Modeling Tools

UML, Microsoft Visio 2013-2007

Version Control Tools

Subversion (SVN), Team Foundation Server, GITHUB

Middleware

WCF, ADO.NET, Web Services (RESTful, SOAP, XSLT, Web-API)

ETL Tools

SQL Server Integration Services (SSIS), Ascential Datastage

EDUCATION:

Masters from UNIVERSITY OF CENTRAL MISSOURI

PROFESSIONAL EXPERIENCE:

Client: Starr Insurance New York, NY March 2023 to Presen t Full Stack .Net Developer

Responsibilities:

Created and used User Controls in developing the front-end application and multi-thread windows applications using VB.Net.

Automated the build process for .NET applications using Jenkins, configuring jobs to compile code, run unit tests, and produce build artifacts.

Used Postman's powerful debugging tools to identify and resolve issues in API requests and responses, improving the reliability and functionality of .NET applications.

Created packages to write procedures in Oracle to load Global Dir Params and update audit transactions.

Converted the web sites to web applications to make Azure compatible.

Involved in deploying desktop applications, web applications, websites and console applications to the Confidential Azure Cloud.

Utilized Rider's advanced code editing features, including code completion, navigation, and refactoring tools, to streamline the development process and improve code quality

Developed stored procedures, triggers, cursors using Oracle for authorization and card details database.

Utilized various JavaScript and jQuery libraries, AJAX for form validation and other interactive features.

Developed Web forms using ASP.Net server controls and validated input using Java Script.

Created and maintained database objects like complex Stored Procedures, Tables, Views, and User Defined Functions in SQL Server 2012.

Extensive use of Web Services, Web API, Query String to expose the reports to facilitate the information sharing

Involved in deploying the application on IIS Server.

Extensive use of Web Services, Web API, XML to expose the reports to facilitate the information sharing

Worked on SOAP and RESTFUL Services using WEB API which return JSON data.

Designed brand-new windows-based application from scratch to meet business requirement in short span of time.

Built Web based and service-oriented platforms using Microsoft .NET technologies (C#, ASP.Net, MVC, Web API, and Entity Framework).

With the concept of ReactJs Worked on usage metrics and also end to end events tracing for analysis purpose.

Developed UI interfaces with MVC 5 Razor Views (CSHTML), CSS JavaScript, Knockout JS and jQuery.

Implemented CRUD functionality with Entity framework in ASP.NET MVC and implemented sorting, filtering and paging with Entity framework in MVC.

Experience on latest Evolutions of JavaScript, Docker, Web pack, OpenStack, AWS, Elastic Search, Radis, MongoDB, GitHub Enterprise, Splunk.

Implemented Application logging, email for error handling and notifications.

Prepared unit test cases and performed N-Unit testing prior to system implementation. Used Hibernate - Object Relational Mapping Tool for the backend data persistence

Applied Test-Driven Development (TDD) principles using xUnit, writing tests before implementation to drive design and ensure thorough test coverage.

Integrated code coverage tools with xUnit to measure and improve test coverage, identifying untested parts of the codebase and reducing potential bugs.

Created logical and physical data models putting to practice, concepts of normalization and RDBMS.

Used Rational Application Developer which is based on Eclipse, to develop and debug application code.

Modified the Spring Controllers and Services classes to support the introduction of Spring framework.

Developed and Enhanced Master Pages, User Controls, Custom Controls, User Interface by using HTML 5, CSS 3, Bootstrap and Kendo UI Controls.

Used Dependency Injection Pattern to reduce the dependency coupling between classes and in Front end using AngularJS.

Implemented Swagger Codegen to generate client SDKs and server stubs, accelerating development and ensuring alignment with API specifications.

Used NUnit's rich set of assertion methods (Assert) to validate expected outcomes and behaviors in unit tests, ensuring code correctness.

Designed and implemented continuous integration and continuous deployment (CI/CD) pipelines using Jenkins to automate the build, test, and deployment processes, ensuring quick and reliable delivery of .NET applications.

Implemented robust CI/CD pipelines in Azure DevOps for .NET applications, reducing deployment time by 40% and improving release reliability.

Configured and managed release pipelines in Azure DevOps to streamline application deployments across multiple environments (development, staging, production).

Used ADO.Net extensively for database interactions using Data Reader, Data Adapter, Data view and Datasets.

Responsible for fine tuning the Stored procedures and SQL Queries that have been found expensive in the load testing conducted for the releases.

Managed project dependencies using NuGet, ensuring consistent and reliable package management across multiple .NET projects.

Configured and managed custom indexing policies in Cosmos DB to optimize query performance for .NET applications.

Designed and optimized MongoDB schemas and collections for efficient data storage and retrieval

Environment: VS.NET 2013, .Net 4.5, Asp.Net MVC 5, VB.Net, HTML5, CSS3, jQuery, Angular JS, Knockout JS, Kendo UI, Ajax, Restful web services, Web Forms, Bootstrap, IIS 7.0, TFS, SQL Server 2012, Asp.Net Web API and LINQ, ReactJs, VUE.JS.

Client: CGI (Remote) Oct 2019 to April 2022 Full stack AngularJS and .Net Developer

Responsibilities:

Involved in design and developing case management system web screens using ASP.Net MVC 4.0 Framework and had knowledge on Web API (Restful).

Used Inject to implement Dependency Injection (DI) when developing Components for MVC Architecture.

Developed the Controller with using LINQ to Entity to query Stored Procedures or Entities to render JSON data, VIEW to Front-end.

Used VUE.JS for HTML-based template syntax that allows to declaratively bind the rendered DOM to the underlying Vue instance’s data

Built the Responsive UI screen using HTML 5, CSS 3 and twitter Bootstrap.

Developed Web screens using Responsive Web Design methodology. Utilized MVVM design pattern with front end framework jQuery, AngularJS and LESS CSS pre-processor to replace old system's JavaScript code.

Extensively used JavaScript, jQuery and AJAX for implement client-side data verification, data transfer and load, sending XML with asynchronous/synchronous request to build the data communication between client side and server side.

Applied security best practices and compliance standards within Azure DevOps pipelines, including integrating static code analysis and vulnerability scanning tools

Utilized ADO.NET objects like Data Set, Data Adapter, and Data Reader to retrieve data from databases. Work with ASP.Net Grid Views, Repeaters, and Data Lists for displaying in front-end.

Extensively developed with using various C#.NET Web Forms, Server Controls and User Controls. Developed the Presentation Layer with writing HTML, CSS.

Developed applications in AngularJS and Bootstrap and deployed into development, Test and production environment successfully.

Worked on the MVC architecture of AngularJS in developing the apps, controllers and directives which are totally customized to meet the needs of the application.

Performed Unit Testing and maintaining the system by tracing, debugging, exception handling, and logging.

Utilized Swash buckle to integrate Swagger with ASP.NET Core applications, enabling automatic generation of interactive API documentation and exploration.

Worked with writing technical document, unit testing document.

Worked with Using TFS for source control and project related document sharing.

Building/Maintaining Docker container clusters managed by Kubernetes Linux, Bash, GIT, Docker, on GCP

Analyzed the application performance in Azure environment using Dyna Trace.

Integrated Blazor applications with ASP.NET Core Web APIs for efficient data operations and real-time functionalities using SignalR.

Utilized the Azure Cosmos DB SDK for .NET to connect, query, and manage Cosmos DB resources within .NET applications.

Implemented deployment automation of Azure deployments utilizing PowerShell

Worked on making AJAX calls to connect the database using restful web-services and also worked on integrating the middleware to the front end.

Used Jenkins to orchestrate the provisioning and configuration of infrastructure using tools like Terraform or ARM templates.

Deployed and managed MongoDB instances on cloud platforms (e.g., Azure Cosmos DB, MongoDB Atlas) within .NET applications.

Worked on non-linear video editing and authoring with After Effects for company's project.

Designed and implemented reusable Blazor components for streamlined development and consistent user experience.

Worked with media queries and mobile UI development to customize the View.

Environment: ASP.Net 4.0, Visual Studio2012/2010, C#, ADO.NET, ASP.NET MVC4.0, NINJECT, Web Services (SOAP), WCF, LINQ, Entity Framework, AJAX, HTML5, CSS, JavaScript, Angular. jQuery, Bootstrap, SQL Server 2008r2, SSRS, IIS7.0/5.0, TFS

Contact this candidate