.Net Developer Sql Server
Resume:
SIVA PRAKASH KATRAGADDA
Full stack .NET Developer
Email:*****************@*****.***
Cell #: +1-609-***-****
EDUCATION:
Degree
(AA/AS, BA/BS, MA/MS/MBA, PhD, JD)
Area of Study
School/College/University
Location
MCA
Computer Applications
Krishna University
INDIA
BSC computers
Computer Science
Acharya Nagarjuna University
INDIA
PROFESIONAL SUMMARY
Committed IT professional with 10 years of relevant experience in the Design, Development & Implementation of Web Based Applications using Microsoft Technologies with sound analytical and programming skills out of 10 years of IT industry.
Extensive working experience in Microsoft Technologies such as C#.NET, ASP.NET, MVC, Web API, ADO.NET, Entity Framework, HTML, CSS, JavaScript, Angular, jQuery, AJAX, LINQ, WCF.
Experience in creating Restful Services using ASP.NET Web API and C#.
Having good experience on MS SQL Server and Azure cosmos DB.
Working Knowledge of Angular14.
Knowledge on React Js.
Working Knowledge on TFS CICD.
Good perception of Object-Oriented Programming Concepts.
Has experience of AGILE (SCRUM) practices for Software Development.
Strong analytical problem determination/solving skills.
Welcome new challenges, quickly learning new skills and procedures with excellent adaptability.
PROFESSIONAL EXPERIENCE
Application Developer Feb2024 – Present
American Express - AMEX
Description: Design and Developed web pages for the application as the requirement, Developed Windows applications and configured in Schedulers, Published APIs and Implemented DB objects. Worked on annual/monthly maintenance jobs.
Responsibilities:
Analyze, develop, test, modify, implement and maintain enterprise applications using Angular, Visual Studio, .net core 6.0, C#, REST API, SQL Server.
Creating, modifying, optimizing, and monitoring database objects in SQL Server.
Developing and Consuming Web API.
Developed and optimized various database objects including Tables, Views, Stored Procedures, Jobs in MS SQL Server
Manage team in terms of communicating the requirements.
Implemented security in Web Applications and the Service layers.
Troubleshooting and technical support to the programmers as well as end users
Actively participate in design of the application and tech solutions and implemented various Design Patterns
Created Database objects including Tables, Views, Triggers, Stored Procedures, functions, and Jobs.
Environment: .net Core, Restful API, MVC, C#, SQL Server.
Application Developer Apr 2023 – Jan 2024
United Parcel Service - UPS
Description: Developed UI web pages for the application as the client requirement and wireframes. Responsible for all client-side UI validations, and implementing business logic based on User Selection. Used directives and modules to create reusable components to use across the application. Developing the APIs for backend.
Responsibilities:
Analyze, develop, test, modify, implement and maintain enterprise applications using Angular, Visual Studio, .net core 5.0, C#, REST API, SQL Server.
Creating, modifying, optimizing, and monitoring database objects in SQL Server.
Developing and Consuming Web API.
Developed Azure functions, Azure durable functions, and consumed and develop various Azure Services
Developed and optimized various database objects including Tables, Views, Stored Procedures, Jobs in MS SQL Server
Analyze and design databases within an application area.
Manage team in terms of communicating the requirements.
Implemented security in Web Applications and the Service layers.
Used Enterprise Library, Entity Framework with both, Code First / Data Base First in various Applications.
Troubleshooting and technical support to the programmers as well as end users
Rollout the application to Production
Actively participate in design of the application and tech solutions and implemented various Design Patterns
Used SCRUM / AGILE methodology for rapid delivering and have used Azure DevOps.
Used Fortify for code scan and resolved all the reported issues.
Resolved all the issues raised by the Penetration Testing team.
Created unit, integration, and regression tests in test driven development environment.
Created Database objects including Tables, Views, Triggers, Stored Procedures, functions, and Jobs.
Environment: .net Core, Restful API, MVC, C#, Angular13 & 14, SQL Server, Azure.
Lead Sep 2022 – Feb 2023
Loquat
Description: A Simple and Secure Way for Financial Platform to Offer a Full Digital Banking Experience to Small Businesses!
.
Responsibilities:
Analyze, develop, test, modify, implement and maintain enterprise applications, Visual Studio, .net core 5.0, C#, REST API, SQL Server.
Creating, modifying, optimizing, and monitoring database objects in SQL Server.
Developing and Consuming Web API.
Developed Azure functions, Azure durable functions, and consumed and develop various Azure Services
Developed and optimized various database objects including Tables, Views, Stored Procedures, Jobs in MS SQL Server
Analyze and design databases within an application area.
Manage team in terms of communicating the requirements.
Implemented security in Web Applications and the Service layers.
Used Enterprise Library, Entity Framework with both, Code First / Data Base First in various Applications.
Troubleshooting and technical support to the programmers as well as end users
Rollout the application to Production
Actively participate in design of the application and tech solutions and implemented various Design Patterns
Used SCRUM / AGILE methodology for rapid delivering and have used Azure DevOps.
Used Fortify for code scan and resolved all the reported issues.
Resolved all the issues raised by the Penetration Testing team.
Created unit, integration, and regression tests in test driven development environment.
Created Database objects including Tables, Views, Triggers, Stored Procedures, functions, and Jobs.
Environment: .net Core, Restful API, C#, SQL Server, Azure.
Lead Jan 2022 – Aug 2022
NEPTUNE
Description: NEPTUNE 360 is an application that that provides water meters statistics like water usage, condition of the meter, any leakage etc. information. This application is being used by the end users and Neptune team. End users can login and generate reports for different types of readings, export the reports in pdf and excel formats, they can see any alert notifications related to their endpoints etc. They can generate custom reports as well in the customer enquiry screen.
Responsibilities:
Worked closely with various team to find the gap in the system and gathering the requirements.
Create the Functional and Design document and design the applications to reduce the timeline of resolving issues in the existing applications.
Developed the application and various database objects including Tables, Views, Stored Procedure, Jobs
Worked on S3 and lamda function on AWS environment.
Rollout the application to Production
Environment: C#, MVC, Web API, .net Core, Angular6, My SQL, AWS, Red Shift.
Sr Software Engineer Jun 2019 – Dec 2021
GEP
Description: GEP SMART is a unified procurement software platform built for procurement professionals. GEP SMART unifies upstream sourcing and downstream procurement operations into one state-of-the-art cloud platform with a powerful, complete set of capabilities for direct as well as indirect spend management.
Worked on a Product developed by GEP Solutions that provides a procurement platform for buyers and suppliers. I have been working on Login, MFA and generic components for the product which can be integrated with any module of the procurement like P2P, Sourcing, Contracts, Projects.
Responsibilities:
Worked closely with the customers in gathering the requirements.
Worked on MVC, Web API, C#.Net, Angular.
Value added the requirement with additional features to serve the business needs and usability to the end users.
Design application and tech solutions and implemented various Design Patterns
Analyze the requirement and feasibility of the same and decide the technologies and framework to be used.
Using Microsoft Visio to build a complete architecture flow diagram.
Design the Framework, application, and the database objects in a flexible model open for further enhancements.
Created Database objects including Tables, Views, Triggers, Stored Procedures, functions, and Jobs.
Create the Functional and Design document.
Developed the application and various database objects including Tables, Views, Stored Procedure, Jobs
Implemented the validations using the Validation Controls and data access using ADO.Net.
Implemented Security to the application and the modules available in the application.
Integrate various layers including Web Service, Active Directory, Framework and Database.
Configured the service and the consumer using the config file.
Troubleshooting and technical support to the programmers as well as end users
Rollout the application to Production
Develop define technical requirements, technical standards, and policy creation.
Environment: .net Core, C#, MVC, Web API, Angular5, jQuery, SQL Server, Azure.
Sr Software Engineer Sep 2017 - May 2019
American College of Radiology - ACR
Description: The ACR Radiology Case Management System (RCMS) is a web-based Application which is streamlined to fit the needs of radiology. It allows users and enterprises to collect, store, develop, assess and distribute knowledge in ways that uniquely facilitate next generation radiology learning. Cortex is a upgrade project of RCMS is to upgrade the application to new technologies to improve user experience and performance.
Responsibilities:
Worked closely with the customers in gathering the requirements.
Value added the requirement with additional features to serve the business needs.
Involved in usability to the end users.
Using Microsoft Visio to build a complete architecture flow diagram.
Create the Functional and Design document.
Manage team in terms of communicating the requirements.
Developed the application and various database objects including Tables, Views, Stored Procedure
Configured the application using XML file and Database.
Implemented Security to the application and the modules available in the application.
Integrate various layers including Web Service Framework and Database.
Troubleshooting and technical support to the programmers as well as end users
Environment: .net, C#, MVC, Web API, .net Core, Angular6, jQuery, Java Script, SQL Server, My Sql.
Software Developer Jun 2014 - Aug 2017
Choice Solution Ltd.
Description: This product was designed for the US Education System to give the best results to the various state departments in the USA. By using this product end User can upload data files and create customized reports and, he can manipulate the uploaded data.
Responsibilities:
Value added the requirement with additional features to serve the business needs.
Involved in usability to the end users.
Using Microsoft Visio to build a complete architecture flow diagram.
Create the Functional and Design document.
Manage team in terms of communicating the requirements.
Developed the application and various database objects including Tables, Views, Stored Procedure
Configured the application using XML file and Database.
Implemented Security to the application and the modules available in the application.
Integrate various layers including Web Service Framework and Database.
Troubleshooting and technical support to the programmers as well as end users
Environment: .net, C#, ASP.net, MVC, Web API, SQL Server, SSIS, SSRS, Google Charts, D3js.
TECHNICAL SKILLS:
Microsoft Technologies: C#, ASP.NET, ASP.NET MVC, WCF, Web Services, Windows Services,
Web API, Entity Framework, SQL Server, WPF, .Net Core, Asp.Net core
Scripting Languages: Angular, HTML, JavaScript, jQuery, Ajax
IDE/Source Control: Visual Studio, Visual Studio Code, TFS, GIT, Azure DevOps repositories
Designing: UML, Design Pattern, Visio
Business Intelligence: SSRS, SSIS
Process and Methodologies: SCRUM, Azure DevOps
Open Source: Entity Framework core, JWT, D3Charts
Databases: SQL Server, My SQL
Contact this candidate