Asp.Net Web Sql Server

JAGAN MOHAN REDDY B

Email-id: *************@*****.***

Ph: +1-945-***-****

PROFESSIONAL SUMMARY:

Over 12+ years of extensive experience with all phases of Software Development Life Cycle (SDLC) in Microsoft .Net Technologies, including Analysis, Design, Development and Testing of Client-Server and Web-based n-tier Architecture for web applications with exposure to diverse business domains and Cloud.

Excellent hands-on experience in development of web-based application with n-tier architecture in Microsoft Visual Studio using C#.Net, VB.Net, .Net Core, Microservices, ASP.Net MVC, ASP.NET Web API, ADO.Net, Dot Net Core Web API, Entity Framework, HTML, JavaScript, jQuery, Angular (6,7,16,17), ReactJS, SQL Server, My SQL, PostgreSQL, Apache Ignite, AZURE Functions, API Management, Key Vaults, Azure SQL Database, Managed Identities.

Hands on experience in Database design and server-side programming in SQL Server using Stored Procedures, Triggers, Views.

Design, develop, configure and implement software applications, packages and components customized to meet specific needs and requirements

Strong hands in developing ASP.NET MVC, ASP.Net Web API, .Net Core Web API, Created Business objects, Data Objects using Repository Pattern and Database Architecture Designs.

Utilized ADO.Net technology extensively for database. connectivity, retrieval and storage of data on SQL Server Created Database tables and implemented Stored Procedures.

Experienced in working on Grid view using ADO.NET and retrieved data from SQL server using quires.

Extensive experience with ASP.NET Web Forms, win forms, Web Services, and State Management, caching features, configuring optimizations, and securing the web application.

Wide experience in designing and implementing applications using ADO.NET objects like Dataset, Data Table and Data Adapter for manipulating, retrieving, storing and displaying data from SQL Server

Extensive experience with ASP.NET MVC4 applications using Database Code First Approach in Entity Framework 4.3/5.0, and UI in Razor View Engine and client-side framework angular, Bootstrap, HTML 5

Extensive experience on SQL, MySQL, PostgreSQL Database table's design as per requirement and perform DML, DDL operations.

Hands on experience on SQL Scheduling jobs for Smart Track.

Adept at developing and maintaining web applications using ASP.NET MVC, ASP.Net Web API, .Net Core Web API.

Have good experience and worked on Ignite Cache, Server-Side caching technologies.

Extensive experience on using JavaScript and jQuery and ReactJS client validations.

Strong hold in developing security login systems and maintaining roles-based authentication and authorizations using JWT token based identity servers.

Experience in interacting with client to review and gather client requirements.

Expertise on Agile Methodology and how it works.

Implemented and maintained the branching and build/release strategies utilizing GIT and developed SQL Scripts, Procedures, Functions and Packages for SQL Reporting and application functionalities.

Hands on experience on read, interpret and/or develop technical specifications, diagrams and database schema.

Developed dynamic and responsive web applications using Angular (versions 6/7/16).

Developed single-page applications (SPAs) using React.js (versions 16/17/18) with a component-based architecture.

Implemented dynamic form handling using Angular Reactive Forms and Template-Driven Forms with validation.

Implemented single-page applications (SPAs) using Angular with component-based architecture.

Built reusable, modular, and optimized React components using functional and class-based components.

Used React Hooks (useState, useEffect, useContext, useReducer, useRef, etc.) for state and side-effect management.

Wide experience on UAT support and bug fixing. Mapping and moving the data from staging grid to production.

Extensive experience in implementing Azure Trigger Functions, Hosting and linking them with API services in Azure API Management, creating sql databases and adding key vaults in Azure.

Azure OAuth2, Managed Identities, Service bus functions, Timer Trigger functions, Azure SQL Database, Key Vaults, Named values.

Worked on developing complete microservices development using AI tools like Chat GPT, Black Box, Visual Studio Co-pilot. Have good experience on giving prompts to AI tool and interpreting the response given by tool.

Worked on Zammad helpdesk and issue tracking system and integrating that to Dot core API’s and Angular.

Designed the application keeping accessibility, usability as a top priority and making the site ADA (Americans with Disabilities Act) compliant.

EDUCATIONAL SUMMARY:

Bachelor of Technology from Jawaharlal Technological University, Hyderabad

Certifications:

Certification Name

Valid Till

AZ-900 Azure Fundamentals

No Expiry Date.

AZ-204 Azure Developer Associate

May 2025.

SKILLS SUMMARY:

Languages

C#.NET, VB.Net, ASP.NET, SQL, PL-SQL.

Server-Side Technologies

C#, VB.Net, ADO.Net, MVC, Dot-Net Core MVC, Web API, Dot-Core Web API, Entity Framework, JWT Token Based system, RCA Archer.

Web Technologies

ASP, HTML, HTML5, Java Script, jQuery, AJAX, CSS, CSS3, React JS, Angular, Bootstrap, TypeScript.

Database

SQL Server 2014/2012/2008/2005, My SQL, PostgreSQL, Apache Ignite Servers.

Protocols

SOAP, FTP, TCP/IP, HTTP

Cloud Technologies

Azure Functions, APIM, Managed Identities, Azure OAuth2, APP Services.

Source Control

VSS, Team Foundation Server (TFS), Git, GitHub

Development Tools

MS Visual Studio.NET 2005/2008/2010/2012/2013/2014, VS Code, SQL Enterprise, Zammad ticketing tool, Post Man, Swagger.

Operating Systems

Windows 10/8/7/Vista/XP, Linux.

Unit Testing Tools

MS Unit, NUnit, XUnit.

AI Tools

Chat GPT 4, Black Box and Visual Studio Co-pilot.

PROFESSIONAL SUMMARY:

Client: Circle K JULY 2022- TILL DATE

Project Name: Brierley Kona (Loyalty Marketing Solutions)

ROLE: SENIOR .NET FULLSTACK DEVELOPER And TECH LEAD

Project Description:

Loyalty OnDemand delivers everything you need to execute your loyalty strategy and measure its success. For over fifteen years we’ve perfected our platform and designed it to be highly configurable, making it unique and robust for every client. It’s capabilities and extensibility are far reaching, always outperforming any competitor. It’s the Platform you can’t outgrow—always delivering seamless growth and proven loyalty results.

Roles and Responsibilities:

Involved in the complete end-end project life cycle right from the initial JAD Sessions until the Warranty phase and Involved in extensive meetings with Business to understand the business requirements and come up with the estimates and timelines.

Created ASP.NET validation controls and JavaScript validations to enforce validations.

Involved in design, develop and deploy application solutions.

Effectively involved in discussions related to loyalty admin product and to applying new features to the system.

Involved in creating multi use API’s so that they can use in different services.

Created Tables and Views on the SQL Server. Written SQL Scripts such as Packages, Stored Procedures, Functions and Triggers to manipulate and retrieve data from Postgres SQL Server databases.

Used Compiled Queries, Multiple Contexts, Explicit Loading, and Save Changes to context after all database operations to improve the performance in Entity F/W.

Created Model objects using Entity Data Model with Entity framework.

Involved vastly in development of promotion and rewards-based loyalty admin system.

Worked on server-side caching system using Apache ignite database.

Involved in development of code first approach of implementation and as part of this worked on migration scripts of updating and inserting tables and data without loss of data.

Developed single-page applications (SPAs) using React.js (versions 16/17/18) with a component-based architecture.

Built reusable, modular, and optimized React components using functional and class-based components.

Used React Hooks (useState, useEffect, useContext, useReducer, useRef, etc.) for state and side-effect management.

Integrated RESTful APIs and Graph QL using Axios, Fetch API.

Implemented client-side routing with React Router (v5/v6) for seamless navigation.

Integrated Material-UI, Tailwind CSS, Bootstrap, and Styled Components for modern UI design.

Became a key developer for discount evaluation and transaction modules where all rules will be applied for giving final discounts with promotions and rewards.

Involved in unit testing and integration testing after completion of module coding Designed cascading style sheets to set style on ASP.NET Forms.

Involved in Knowledge Sharing session to Operations & Maintenance Team.

LINQ was extensively used in view extension to parse out unnecessary information and to make call to SQL database.

Implemented a responsive customer-facing interface using React.js, enabling dynamic menu displays and real-time order tracking.

Created Postgres SQL scripts, store procedures and consoles application to update existing tables data of production servers and maintaining the updated records data, failed records data.

Worked on Azure functions, APIM, Key Vaults, Managed Identities as part of this development.

Designed and implemented risk management workflows in RSA Archer, improving risk identification and tracking by 30%.

ENVIRONMENT: Visual Studio 2019/2022, C#, ASP.NET Web API, Entity Framework, React Js, SQL Server, Dotnet Core, PostgreSQL, Apache Cache, JWT Token Authentication and Authorizations, Azure Functions, APIM, Key Vaults, SQL Database, Azure SQL Database, Managed Identities, GIT, Jira.

Client: State of Arizona (Social Interest Solutions) NOV 2021- JULY 2022

Project Name: Social Interest Solutions

ROLE: SENIOR .NET FULLSTACK DEVELOPER

Project Description:

Social Interest Solutions is a national nonprofit dedicated to improving access to quality health and social services through policy and technology solutions. We work with federal, state, and local agencies, service providers, community-based organizations, and researchers to better connect millions of low-income Americans to health care, nutrition, and other programs.

Roles and Responsibilities:

Designed the application keeping accessibility, usability as a top priority and making the site ADA (Americans with Disabilities Act) compliant.

Involved in all phases of development as this is the new project and need to develop from beginning. Worked right from the API architecture designing, database, tables design and planning deployments across multiple environments.

Implemented API’s with clean architecture and using Dotnet core, MySql, SMTP services for notification, RabbitMQ for queuing processes, JWT based token authentication.

Used several browser plug-ins and JAWS software to check the application for any accessibility issues.

Created windows services to collect and transfer information and transfer the verification documents faxed/uploaded by the users.

Develop the application by following WAI-ARIA (Web Accessibility Initiative – Accessible Rich Internet Applications) to make the web pages more Accessible.

Involved in collecting the Functional requirements from the business partner and preparation of functional specifications and developing the site using Microsoft technologies.

Designed and developed a multi-tenant SaaS platform for restaurants to manage online orders, reservations, and inventory seamlessly.

Developed dynamic and responsive web applications using Angular.

Implemented single-page applications (SPAs) using Angular with component-based architecture.

Created reusable components, directives, and pipes to optimize code reusability.

Optimized performance by using lazy loading, Ahead-of-Time (AOT) compilation, and OnPush change detection strategy. Improved page load speed by implementing code splitting and asynchronous module loading.

Integrated RESTful APIs using HttpClientModule, handling authentication, authorization, and data binding.

Optimized database schema in MySQL, supporting fast queries for high-volume data like sales and customer feedback.

Developed and automated unit and integration test cases using XUnit, improving code coverage to 95% and reducing critical bugs by 30%.

ENVIRONMENT: Visual Studio 2019/2022, Clean Architecture, ASP.Net Core Web API, C#, Entity Framework, Angular(16,17), TypeScript, MySQL Server, Dotnet Core, SMTP Email Services, RabbitMQ for queue processes, JWT Token Authentication and Authorizations, Azure Functions, APIM, Zammad Ticketing system, GIT, Jira.

Client: Altruista Health Pvt Ltd, Medicaid, Medicare MAY 2020- NOV 2021

Project Name: Guiding Care (Care Management System)

ROLE: SENIOR .NET FULLSTACK DEVELOPER

Project Description:

Care management refers to a comprehensive suite of services and activities that help patients with chronic or complex conditions manage their health. Care management’s overarching goal is to improve patient health. To get there, the model also aims to improve care coordination, reduce hospital visits and boost patient engagement. Care management software can significantly support healthcare providers meet those goals.

Roles and Responsibilities:

Designed and developed Web Pages using ASP.NET MVC, C#.NET, HTML, JavaScript, AJAX, jQuery CSS, and server controls.

Involved in editing, validating and reporting of patient claims data using SQL Scripts.

Involved in developing web forms in ASP.NET using C# and in the creation of stored procedures in MS SQL Server 2008 and worked extensively for developing and consuming Web Services and n-tier web applications using ASP.NET MVC, C# and ADO.NET

Implemented software components in a more customized and dynamic way to meet specific needs of requirements.

Involved in retrieving data using ADO.Net with ASP.Net MVC, worked with the database using ADO.

Developed secure login interfaces with ASP.NET Server controls and used various server controls like Multi View and Grid View with extensive data binding to display, page and sort multiple records.

Review and modify programs to ensure technical accuracy, security, reliability.

Extensively worked with Partial Pages, Layouts, Sections to design the CSHTML pages with Razor Engine to get consistent look and feel.

Integrated the third-party APIs into the current system and added client and server side validations for corresponding validations required for business logic in Web Forms and developed user interfaces using ASP.NET MVC.

Implemented a tool as a part of client upgradation which takes all forms in lower version and convert them to pdf and save in the upgraded version.

ENVIRONMENT: Visual Studio 2019, ASP.Net MVC, C#, ADO.NET, ASP.NET Web API, Entity Framework, SQL Server, jQuery, GIT, Jira.

Client: Trojan JAN 2020- MAY 2020

Project Name: Caspar Cloud (Trojan Caspar2)

ROLE: SENIOR .NET FULLSTACK DEVELOPER

Project Description:

Caspar, from Trojan Consultants, is a comprehensive case management solution for professional deputies and their teams, appointed to manage the property and financial affairs of their clients under the Court of Protection. It introduces new rigour, transparency and process efficiency, while freeing up fee-earners to act in the best interests of clients and maximise their chargeable time.

Roles and Responsibilities:

•This is the first project which I handled alone i.e. from taking requirements from client to till publishing my code to environment in Azure Devops which includes host function creating, configuring and publishing, Services creating and run pipeline, API Management and Database creating and publishing in azure devops.

•Gathering client requirements and analyse with existing functionality whether it supports for existing system design.

•Applied Dependency Injection (DI) for better modularity and maintainability.

•Utilized Content Projection (ng-content) and View Child/View Children for advanced component interactions.

•Secured applications using CORS handling, CSRF protection, and Content Security Policy (CSP).

•Provide suggestions for better approaches to fulfil requirements with better quality of standards.

ENVIRONMENT: Visual Studio 2019, .Net Core, Microservices, C#, Angular, TypeScript, Azure Dev-ops, SQL server, GIT, Jira, Azure Functions, Azure APIM, Key Vaults, Named Values, Azure SQL Server.

Client: Launch ship Technologies Pvt Ltd DEC 2018- JAN 2020

Project Name: School Management Project

ROLE: .NET FULLSTACK DEVELOPER

Project Description:

Academy Front is a complete school management designed to automate a school’s diverse operations from classes, exams to school event calendar.

This school software has a powerful online community to bring parents, teachers and students on a common interactive platform. It’s a paperless office automation solution for modern schools. The School Management system provides the facility to carry out all day to day activities of the school, making them fast, easy, efficient and accurate.

Roles and Responsibilities:

•Fully involved in coding of the application, performed unit test. Implemented template generating, printing and saving as pdf.

•Implementing Authentication, Authorization and RBAC access using JWT token based system.

•Implemented Communication Module like sending email on complete of any action in Academy front.

•Involved in unit testing and integration testing after completion of module coding Designed cascading style sheets to set style on Forms.

•LINQ was extensively used in view extension to parse out unnecessary information and to make call to SQL database.

•Involved in migration of data loading process to automated PL-SQL jobs which reduced the manual efforts and manual errors considerably.

•Used various Transformations such as XML Transformation, Look up, SQL, Joiner, Filter and other Passive transformations.

•Integrated RESTful APIs using HttpClientModule, handling authentication, authorization, and data binding.

•Implemented JWT-based authentication and authorization using Angular guards and interceptors.

•Configured and maintained Angular CLI for project setup and efficient development.

•Integrated Angular Material CSS for modern UI design.

•Managed application state using RxJS (Observables, Subjects, Behaviour Subjects) and NgRx for efficient state handling.

•Implemented pagination to display large data in front end using angular.

•Implemented software components in a more customized and dynamic way to meet specific needs of requirements.

•Actively involved in peer review during the various phases of the project.

ENVIRONMENT: Visual Studio 2019, VS Code, .Net Core, Microservices, C#, Web API, Angular (6,7), Type Script, MySQL, GIT, Jira.

Client: DCR Workforce, Coupa JULY 2013- July 2015(Intern) Aug 2015- DEC 2018(Full time)

Project Name: SmartTrack (Vendor Management System)

ROLE: .NET FULLSTACK DEVELOPER

Project Description:

A Vendor Management System (VMS) is basically a software tool used by business to manage companies that supply labour to them. However, that doesn't even begin to do this valuable system justice. A VMS is that "thing" you didn't know you really need... just like other software programs you perhaps were oblivious to but now you just can't live without it.

Roles and Responsibilities

•Involved in SOW (Statement of Work) module. Develop end to end application components involving business layer, persistence layer, and database and web services layer. • Develop and execute MS Test unit test cases

•Worked as an intern before

•Involved Creating SQL stored procedure, tables, triggers to meet functional requirement needs.

•Involved in developing ASP.NET MVC, Created Business objects and Data Objects using Repository Pattern.

•Involved in Creating WEB API for Data Binding.

•Involved in Coding jQuery based on Business requirements.

•Utilized ADO.Net technology extensively for database. connectivity, retrieval and storage of data on SQL Server Created Database tables and implemented Stored Procedures.

•UAT support and bug fixing. Mapping and moving the data from staging grid to production.

•Implemented Communication Module like sending email on complete of any action in Academy front.

•Fully involved in module analysis, analyse specifications, user interaction, designing, coding of the application, performing unit testing.

•Handling Onshore Calls effectively for the respective module.

•Implement role-based applications for users.

•Collaborate with other software developers to create optimum solutions which is useful for product.

ENVIRONMENT: ASP.Net MVC, C#, ADO.NET, ASP.NET Web API, Entity Framework, SQL

Server, jQuery, TFS, HTML, JavaScript, Razor Pages.

Contact this candidate