.Net Developer Sql Server

Rahul G

Phone: 316-***-****

Email: **********@*****.***

PROFESSIONAL SUMMARY:

With around 9 years of experience, I specialized in the design, development, and maintenance of diverse applications, including web, Windows, and Client-Server applications. Proficient in utilizing Microsoft Dot Net Technologies, I have expertise in Microsoft .NET Framework (versions 1.0 through 4.8.1), ASP.NET Core-MVC 6/8/5.0/4.0/3.0, C#, VB.net, ADO.NET, ASP.NET MVC, AngularJS, React, Angular Framework and Web Forms. My skill set extends to Visual Studio (versions 2022 through 2010), and I excel in leveraging Web Services, CSS, HTML, XML, AJAX, JavaScript, jQuery, Angular (versions 1.4 through 13.0), and Bootstrap (versions 3.3 and 4.0). Additionally, I bring experience in working with SQL Server versions 2005 through 2019. My commitment lies in delivering High quality solutions and ensuring the optimal performance of applications across various platforms.

Experience in all stages of the SDLC (Software Development Life Cycle) involving studying of the user requirements, analyzing, designing, implementation, testing, deployment, documentation and maintaining of various stand-alone, intranet, client-server, and web-based projects with exposure to diverse business domains including Banking, Financial and Retailing.

Good working knowledge of industry advanced technologies like ASP.NET MVC Core, ASP.NET MVC, VB.NET, C#.NET, ADO.NET, Entity Framework, AngularJS, Angular Framework and awareness and good understanding of WCF, WPF, and LINQ.

Experience in building Applications using .NET Core 2,3.1, 5, 6, and 8 and developed REST APIs from scratch to externalize the data on SQL Server and Cosmos DB.

Experience of designing and developing software applications with Microsoft Visual studio 2022/2019/2017/2015/2013/2012/2010 and VS Code using C#, ASP.NET and VB.NET.

Experience in using Language-Integrated Query (LINQ) and retrieving data from different data sources (LINQ to Objects, LINQ to XML, and LINQ to SQL).

Implemented responsive and user-friendly design solutions utilizing HTML, CSS3, Bootstrap, jQuery, JavaScript, Angular13/12/11/10/8/7/6/5/4/2/1, React, and Node.js ensuring optimal user interaction across various platforms and devices.

Experience in building Reports using SQL Server Reporting Services (SSRS) and proficient in SSIS.

Experience in unit testing using Microsoft Visual Studio Unit testing framework, NUnit, and xUnit, ensuring comprehensive test coverage and robust code quality assurance.

Proficient in developing end-to-end testing suites using Playwright to simulate user workflows, validate UI elements, and verify application functionality across different browser configurations.

Experienced in leveraging Cosmos DB and GraphQL technologies to optimize data management and enhance API capabilities.

Experience with Data Accessing includes using DataAdapter, DataReader and Dataset in ADO.NET and LINQ (Language Integrated Query) Providers for data manipulation.

Designed and developed several packages to transfer the data between the different environment systems and export the data to other applications using SQL Server Integration services (SSIS).

Strong database design/implementation skills in RDBMS like Oracle Database SQL Server 2022, 2019, 2017, 2016, 2014, 2012, 2008, 2005.

Proficient in SQL Server database design and development, encompassing the creation of constraints, indexes, views, stored procedures, cursors, triggers, and user-defined functions.

Proficient in utilizing the Azure Portal and Azure DevOps across all stages of the development lifecycle to streamline work environment operations.

Utilized Source Control Software such as Git and GitHub, Microsoft Azure and GCP (Google Cloud Platform) Firebase for hosting web applications.

Good Collaborator with excellent communication, analytical, verbal and writing skills along with strong management, organizational and mentoring skills.

Demonstrated capability to lead and oversee entire project life cycles, encompassing initial planning, requirements gathering, development, thorough testing, and successful deployment.

Technical Skills:

Programming Languages

C#.NET, VB.NET, Python, C++, and C Programming.

Technologies

ASP.NET (4.8/4.7/4.5/4/3.5/3.0), ADO.NET, SQL, WinForms,

WebForms, RESTful Services, LINQ, Micro Services, JMeter, Azure-

Events, Web API, WCF, WPF, MVC.NET (5.0/4.0/3.0), .NET Core

(2.1/3.1/5.1/6/8), Kafka, Kubernetes, Playwright, Microservices

Markup Languages

XML, XAML, HTML 5.0/4.0, CSS/CSS3, Bootstrap.

Scripting Languages

JavaScript, VBScript, jQuery, TypeScript, AngularJS, Ajax,

Angular 13.0/12.0/11.0/10.0/8.0/7.0/6.0/5.0/4.0/2.0/1.6/1.5/1.4,

Node. JS, React Framework.

Database

Microsoft SQL Server 2019/2017/2016/2014/2012/2008, MS Access

(2021, 2019, 2016, 2013, 2010), Oracle (9i/10g/11g), My SQL,

Cosmos DB, SQL, PL/SQL.

Cloud Technologies

Azure DevOps, Azure Storage, Azure SQL, Azure App Service, Google

Cloud Platform, Docker.

Development Tools

Visual Studio 2022, 2019/2017/2015/2012/2010, VS Code, Postman,

NUnit, xUnit, Git, GitHub, Team Foundation server.

Client software

Microsoft Active Directory Administrator, Citrix Workspace and

VMware Horizon.

Web Servers

Microsoft Internet Information Server (IIS) 8.0/7.0/6.0.

Operating Systems

Windows 11/10/8/2000/ NT/ XP/ Vista/98/ 95, Windows 2003 Server,

Linux.

Application Tools

MS Office (Excel, Word, Access), MS Project.

EDUCATION:

Master of Science- Wichita State University, Wichita, KS DEC 2017

Major: Computer and Information Sciences CGPA-3.94

Bachelor of Technology- Andhra University, India May 2014

Major: Electronics and Communication Engineering CGPA-7.63

PROFESSIONAL EXPERIENCE:

Client: Morgan Stanley, Alpharetta, GA May 2022 – Till Date

Role: .Net Full Stack Developer

Responsibilities:

Participated in project analysis, design, and development phases and Created External design documents with technical and business functionality.

Collaborated with stakeholders to design and produce reports utilizing SSRS.

Served as a Technical Lead for both Onsite and Offshore teams, fulfilling roles as both Technical Lead and Subject Matter Expert (SME) for tier-1 applications.

Used ASP.NET and C# with .Net core 8 for web application development.

Utilized Angular 14 to modernize legacy ASPX-based applications by migrating them to the MVC (Model-View-Controller) architecture.

Created a new project to have the MVC workflow with ASP.NET and used C# for the back-end logic added with new functionality.

Designed and implemented scalable microservices architecture using .NET Core.

Implemented microservices using serverless computing platforms such as Azure Functions to achieve cost efficiency and scalability.

Developed and deployed containerized .NET applications using Docker, ensuring consistency across multiple environments.

Used Cosmos DB for faster retrieval of cached data with higher Request Units (RU).

Designed web application layout and forms using HTML5, CSS3 and JavaScript.

Working with Type Script and Java Script along with front end technologies like CSS, Bootstrap, Html.

Developed dynamic, responsive web applications using React.js, improving UI performance and user experience.

Transitioning application architecture from AngularJS and Angular 4 to Angular 13.

Developed new features and components using Angular 13, demonstrating proficiency in the latest advancements of the Angular framework.

Working with Node.JS to access the data of ECL Restrictions data and migrated existing screens to React Framework.

Conducted domain-driven design workshops and training sessions for development teams to promote DDD principles and best practices.

Integrated Blazor with ASP.NET Core to leverage its robust server-side infrastructure and middleware pipeline for authentication, authorization, and data access.

Designed and developed Node.JS based JavaScript application that performs a series of mathematical calculations on the numbers obtained from the webservices present the result in a nice user-friendly comparisons trend graph.

Integrated WCF services with various protocols including HTTP, TCP/IP, MSMQ, and named pipes to accommodate diverse communication requirements.

Implemented MVVM (Model-View-View-Model) architectural pattern in WPF applications to achieve separation of concerns, maintainability, and testability.

Led cross-functional teams as a technical lead, guiding and mentoring team members in project execution.

Developed user controls using C# and jQuery, commonly utilized across MSDN and TechNet web pages.

Used ADO.NET for retrieving, querying, storage, and data manipulation for archiving continuous database connectivity.

Writing PL/SQL Statements, Views, User defined functions, complex stored procedures, triggers in Oracle for inserting/updating/deleting the data into relational tables.

Collaborated with other teams to integrate GraphQL with existing RESTful services, ensuring a seamless transition and coexistence of APIs.

Working with Web API to get the different mapping data to application. Adding new GET/POST and PUT methods along with service call on client side.

Worked on .NET 6 by upgrading REST API from .Net Core 2.1 and .Net Core 3.1.

Expert in performing Database monthly and weekly updates based on business requirements by using SSIS packages.

Experience in generating SSRS and crystal reports using SQL server.

Used Kafka and Azure Events to send the data to downstream users based on the approval time stamp.

Used Selenium Web Driver for performing functional testing on the API and on .NET Application.

Used Kubernetes for the containers and deployment. Working presently on moving app services to docker containers.

Experienced in using the Azure Portal and Azure DevOps for the various stages of work environment.

Worked with Azure Data Factory for the SQL and DB2 Maintenance.

Involved in creating the new app services on Azure Subscriptions and helped in managing them.

Environment: C#, Vb.Net, ASP.Net, AngularJS, Angular 1,4,8,9,10,13, Node.JS .Net framework 4.5 and 4.6, LINQ, XML, SQL Server 2016, MVC, WCF Services, Microservices, Web API, jQuery, Visual Studio 2019, Azure Portal, Azure DevOps, Azure Data Factory, Rest API, WPF, Visual Studio Code, Blazor, SSIS, Micro Services, .NET Core 2.1,3.1 and 5.1, GraphQL, JIRA, Kafka, Docker, Kubernetes.

Client: PayPal, San Jose, CA September 2020 – April 2022 Role: Software Developer.

Responsibilities:

Involved in the complete Software Development Life Cycle including Analysis, Design, Implementation, Testing and Maintenance.

Served as a Technical Lead for both Onsite and Offshore teams, fulfilling roles as both Technical Lead and Subject Matter Expert (SME) for tier-1 applications.

Designed the ASP.NET application Authentication using .NET Framework, Model View Controller (MVC) and IIS 7.5 security model.

Used Microsoft Team Foundation Server (TFS) for source access management.

Used ASP.NET MVC Page Controller pattern to add functionality to individual pages such that to accept input from the page request, invoke the requested actions.

Created Docker images and orchestrated services for improved scalability and resource management.

Responsible for Designing and Developing the Reusable UI Components Like MVC Master Pages Layouts and Nested Layouts, View Start and MVC User Controls Partial Views.

Created various Angular Services and injected them into Angular Controllers (using Dependency Injection) to enable AJAX calls and created Custom angular directives to create own HTML tags and induce functional behavior to those tags.

Utilized Domain-Driven Design (DDD) patterns and practices to model microservices around business domains for better alignment with business requirements.

Developed interactive and SPA (Single Page Application) web applications using Blazor, an innovative framework for building web UIs with C# and .NET.

Implemented AJAX functionality using AngularJS to load contents individually in different partial views to minimize loading time and for better user experience.

Enhanced user experience by designing new web features using MVC Framework like Angular.JS and Node.JS.

Used Entity Framework Code First Approach to interact with Database and implemented the Mappings, Model Changes, CRUD (Create, Retrieve, Update, Delete) operations and dealt with performance issues.

Developed ASP.NET MVC 5 applications using Code First Approach in Entity Framework and UI in Razor View Engine.

Transformed design mock-ups into Cross-browser compatible HTML5/CSS3 layouts and implemented dynamic elements and reusable libraries with JavaScript, jQuery, and Angular JS.

Used JSON to transmit data between Server and Web Application an alternative to XML Serialization.

Consumed Restful Web Services with Angular JS updating the Model and Views of the application.

Used ASP.NET MVC Page Controller pattern to add functionality to individual pages such that to accept input from the page request, invoke the requested actions.

Implemented reusable components with React component-based architecture, streamlining development and ensuring consistency across large-scale .NET applications.

Performing complex data transformations and calculations using SSIS expressions, Script Task, and custom .NET assemblies.

Implemented WEB API Services for CRUD operations with HTTP verbs GET, POST, PUT and DELETE.

Used HTTP Response Exception to manage the exceptions in Web API and customized the Exceptions using Exception Filters and registered them at the Action Level.

Used Cascading Style Sheets (CSS) to import several styles in Html for the views (Presentation layer).

Worked on all the required Stored Procedures, User Defined Functions, Triggers, and Views using T-SQL as per business logic.

Extensively used LINQ to SQL, LINQ to Entities to manipulate the data in database.

Implemented Unit Testing using N-unit and involved in Integration Testing and Regression Testing.

Used various report items like tables, sub report and charts to develop the reports in SSRS (SQL Server Reporting Service).

Implemented Reports using SQL Server Reporting Services, Crystal Reports by using stored procedures implemented in the SQL Server 2012/2008.

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

Worked in AGILE and SCRUM environment regularly attending the Status Meetings and updating status to Scrum Master.

Worked on Azure pipelines for the various auto maintenance jobs scheduling.

Led cross-functional teams as a technical lead, guiding and mentoring team members in project execution.

Actively participated in Design reviews for creating new functionalities for Anthem clients.

Involved in developing technical design specification documents.

Environment: Visual Studio 2016/2013, SQL SERVER 2014, IIS7.5/7.0, .NET Framework 4.5.1, C#.NET 4.0, ASP.NET, MVC 5.0, LINQ, TFS, jQuery, Web Services, Entity Framework 4.5, JavaScript, Ajax, CSS3, Node.JS, Angular JS 1.4, Web API, HTML5, RESTful Services, WPF, Docker, Kubernetes, GCP (Google Clod Platform), Azure pipelines, SOAP, Blazor, SSIS, T-SQL (Transact- SQL), AGILE Methodology.

Client: eBay, San Jose, CA January 2018 – August 2020

Role: .Net Full Stack Developer

Responsibilities:

Taken part in Design, Development and Testing of the venture utilizing Agile SCRUM strategy going to everyday Standup meetings.

Functioned as a trusted advisor and subject matter expert (SME) for Tier 1 Applications.

Using Windows server as the information get to layer to interface with database and keep up the network among inner records.

Used ASP.Net MVC Razor Views to empower quick coding work process and rapidly incorporate server code into HTML markup with least of keystrokes.

Skilled in Designing SSIS Packages to move information between servers, load information into database, and file information record from various DBMS utilizing SQL venture director/SSMS on SQL server.

Created Controllers and Views in ASP.NET MVC 5.0 applications utilizing Razor View Engine.

Responsible recorded as a hard copy Stored Procedures and Functions for recovering and enduring information in the database.

Working on CMS WordPress incorporating MVC pages utilizing iframes.

Designed, created WCF Services utilizing C#.Net and hosted on IIS.

Developed custom controls, user controls in WPF to encapsulate UI logic and promote code reusability across applications.

Analyzed, Strategized & Implemented Azure migration of Application & Databases to cloud.

Worked in a group to create a Service Oriented Architecture (SOA) in building up an item.

Participated in creating Single page application utilizing ASP.net through Visual studio 2019 for building up the undertaking.

Designing the UI utilizing HTML5, CSS 3, Bootstrap, JavaScript, and jQuery for customer side approvals in barely any controllers.

Enhanced application performance by Angular 8 Component based development in view of future Angular framework transitions.

Utilized various Angular 8 custom directives to create reusable components and templates that could be efficiently employed across multiple sections of the application. Ensured comprehensive code maintenance by managing the entire codebase using the TFS repository.

Creating Table, Stored Procedures and Functions in SQL Using SSMS.

Utilized GraphQL to optimize data fetching from both SQL Server and Cosmos DB, resulting in improved performance and responsiveness.

Used ADO.NET and LINQ to get to SQL database through C# database layer.

Implemented Data Access Layer using Entity Framework to get and update data.

Used JavaScript to perform approvals and catch the occasions on customer's program.

Creation of new complex SQL Stored strategies, comprehension of existing put away methods and database model. Utilize the Oracle 19C to make techniques, perspectives, and SQL capacities.

Used Entity system for the database availability and utilized LINQ to keep up the CRUD activities.

Developed ASP.NET Web API Controllers that are associated with usage of administration layer segments and information object layer parts utilizing ASP.NET MVC Web Application.

Implemented RESTful APIs using ASP.NET Core Web API for communication between microservices and client applications.

Experienced in using the Azure Portal and Azure DevOps for the various stages of work environment.

Have created and used WinForms to create functionality in networking module.

Engaged in hands-on development of web services, including both REST and SOAP-based, with a focus on web service security. Contributed to the development of APIs and specifically worked on creating reusable components.

Worked on the issues and very much kept up the correspondence with different servers.

Using the JIRA board for dealing with the client stories and the reports on them.

Environment: HTML5, CSS3, JavaScript, C#, JSON, AngularJS, Angular 6/7/8, Visual Studio 2017, 2019, JavaScript, Bootstrap, SQL server, SSIS, GraphQL, Azure Portal, Azure DevOps, Cosmos DB, Oracle, MySQL, VB.NET, ASP.NET MVC, ASP.NET Core, WCF, WPF, ADO.NET, jQuery, WordPress, REST Api.

Client: Cognizant, India October 2015 – July 2016

Role: Associate

Responsibilities:

Collaborated on the integration of .NET components for seamless functionality.

Conducting regression test on each release and coordination with development team on defects.

Participate in User acceptance testing and deliver customer expectations during production release.

Developed the windows and web versions of the project using ASP.NET, VB.NET, SQL server, Oracle, HTML, CSS, and jQuery.

Involving in complete software development lifecycle requirement gathering, software designing, and development and testing.

Migration from VB6 to C# windows application from scratch.

Have created Windows form (WinForms) application to create state level access database from Nation level access database.

Decent work experience in developing User Interface (UI) Rich web applications, and Web Service Applications covering front-end/UI using the web technologies like HTML5, CSS3, XHTML, JavaScript, J-Query, AngularJS, and other frameworks in JavaScript library.

Designed and developed a web application by using AngularJS as front-end and using Web API to receive and pass data to backend. Maintains and development of existing legacy applications using VB6.

Experience in writing Components, Pipes and Services to separate concerns and manage different situations by using AngularJS.

Developed visual components through WPF using XAML and Expression Blend.

Skilled in using AngularJS Material and Bootstrap 3.2 to do view design and template functions such as pagination and models.

Used JavaScript framework like Node.JS and Angular JS in the development of web applications.

Designed and implemented Data access layers using LINQ for XML Data.

Understand the project requirements and scope of the project and prepare execution strategy. Worked on web framework services are RESTful services, built using Express which is a light and flexible web application framework.

Experience in database design using PL/SQL to write Stored Procedures, Functions, Triggers, and strong experience in writing complex queries, using Oracle, DB2, SQL Server and MySQL.

Managed source code repositories and version control using Team Foundation Server (TFS), ensuring a streamlined and organized development process.

Implement CI/CD based application development methodology using tools like Jenkins/TFS/power shell.

Worked on Azure pipelines for the various auto maintenance jobs scheduling.

Proficient in creating server-side components, designing, and implementing business tier objects, unit testing, debugging and deployment.

Valuable experience in AGILE, Waterfall, delivery process of software using Automation and Manual Testing.

Environment: C#, HTML5, CSS3, JavaScript, JSON, AngularJS, Visual Studio 2015, Bootstrap, Node.js, SQL, Oracle, SQL Developer, MySQL, VB.NET, TFS, WCF, WPF, ADO.NET, jQuery, Azure Pipelines.

Client: Nisum Technologies, India July 2014 – October 2015

Role: .Net Developer

Responsibilities:

Analyzed, Designed and Developed new features as per business user’s requirements.

Utilized Agile methodology using internal process SCRUM for the application development.

Interacted with business users to gather business specs and prepared design docs (use cases, sequence diagrams) using UML.

Designed and implemented the application using AngularJS, HTML5, CSS3, Angular UI, Bootstrap, AJAX, Web API, C#, and Entity Framework, ASP.Net MVC.

Involved in Transformation of Data into SQL Server database by development of views, staging tables and load data into tables using Stored Procedures.

Involved in understanding and analyzing the client’s business requirements for the system. Involved in Design and Developing components of this application using ASP.NET, C# .NET, VB. NET, JavaScript, COM/COM+, CML, XSLT.

Used WPF to communicate between DAL and other business components.

Architect and implement high volume, high traffic transactional application using conventional design practices (SOA, design by contract, MVC)

Implemented business, database access layer classes in C# using UML class diagrams and sequence diagrams.

Written SQL Queries, Stored Procedures, Triggers, Backup and Restore Database, defining roles, creating database users, Assigning Roles to users using SQL Server 2000.

Responsible to deliver the give modules without slipping the deadlines and without exceeding the estimated effort.

Application design is based on n-tier Architecture.

Extensively involved in developing components for Business and Data tier using C#, ADO.Net, LINQ.

Involved in Performance testing for different bandwidths by using the bandwidth controller.

Involved in preparation of cascade style sheet (CSS) files.

Involved in Code review phase.

Developed secured web services using .Net, C#, XML/SOAP.

Written code to access secure web service using .Net, Web form using C# and ASP.Net, WSDL, Proxy Class, XML/SOAP.

Extensively involved in Stored Procedures Optimization.

Implemented Restful Services over HTTP with GET, POST, PUT and DELETE.

Coding business layer and data access layer or entity framework configuration for the different modules of the project.

Wrote Stored Procedures, Views involving complex joins and add them to Entity Framework.

Environment: .Net Framework 4.5, C#, Entity Framework, Bootstrap, ASP.Net MVC, Visual Studio 2013, SQL Server 2012, HTML, JavaScript, CSS3, Jenkins, Telerik Controls, VB.NET, WCF, WPF, ADO.NET, jQuery, NUnit, IIS 6.0.

Contact this candidate