Post Job Free

Resume

Sign in

Asp.Net Sql Server

Location:
Tampa, FL, 33610
Posted:
August 16, 2023

Contact this candidate

Resume:

RajamohanReddy Karnati

Fullstack .Net Developer

Ph No: 813-***-****

Email id: adyzgt@r.postjobfree.com

Professional Summary:

Full stack engineer with 5+ years of IT experience in design, development, implementation, integration, debugging, and testing of various web and mobile applications using Angular 6,9,10, C#.Net, ASP.Net, MVC/Razor, Entity Framework/Core, Web API, ADO.NET, Web forms, Web services, SQL Server, MySQL, and Agile/ SCRUM methodology.

Excellent experience in all stages of the software development life cycle (SDLC), which involves gathering the user requirements, analysis, design, coding, implementation, debugging, testing, and deploying applications across different work environments.

Extensive experience in User Interface (UI) development using Angular 6,9,10, ASP.Net, HTML, XML, JavaScript, jQuery, CSS3, Ajax, and Angular JS.

Strong experience in ASP.Net MVC, Web API, WCF, Entity Framework, IIS, HTML, CSS, JavaScript, jQuery, and Bootstrap.

Worked on Agile, SCRUM development methodology and built the application with Test Driven Development (TDD) and Domain Driven Model (DDD).

Strong knowledge in Object Oriented Programming Design and implementing OOP concepts.

Good experience in developing enterprise-level Web Applications using n-Tier Architecture.

Extensive Knowledge of .NET Design Patterns including Dependency Injection (DI), MVC (Model-View-Control), and CQRS.

Moreover, I would have been responsible for developing grid views, crystal reports, and uploads using the Kendo UI in JavaScript and jQuery.

Extensively worked on developing REST and SOAP-based applications. Authentications like Windows authentication, and forms authentication.

I have 3+ years of experience in Microsoft SQL Server and 2+ years of Strong experience in Oracle writing Stored Procedures, Functions, and Triggers for the implementation of data integrity.

I have Extensive knowledge of writing complex queries using Microsoft SQL Server.

Moreover, I have Extensive experience in the development and optimization of Queries using SQL Query Analyzer, Stored Procedures, and Triggers.

Designed and implemented the Core components for the application, which included a Data Access Layer (DAL), Business Logic layer (BLL), and Presentation Layer (PAL).

Implemented Unit Testing, Integration Testing, and System Testing with N-Unit.

Experience in working in Software Configuration Management using Tortoise SVN and Visual Studio Team Foundation Server (TFS).

Worked in an Agile team environment, using tools like JIRA, Git for project management and version control.

I have been involved in Two-way Integration is done for the data transfer from the CRM project to SAP.

I have been involved in three levels of testing (Agile, Demo, and Live).

Experience in Application Development and Production support environment and cross-platform web-based applications troubleshooting.

Efficient in turning business requirements into technical specifications.

Excellent analytical, problem-solving, communication, Knowledge transfer, and interpersonal skills, with the ability to interact with individuals at all levels.

Highly organized with the ability to manage Live projects support and meet deadlines.

Additionally, using Azure Event Hubs I have been creating an Event Hub namespace, followed by creating an Event Hub and shared access policies.

Implement and manage continuous integration and deployment (CI/CD) pipelines using Azure DevOps to automate build, test, and deployment processes for .NET applications.

.NET library to send and receive events from an Azure Event Hub, and you would need to authenticate the app to Azure using either password less (Azure Active Directory authentication) or connection string.

Adaptable to new software technologies, quick learner, and can work efficiently as an individual.

Great Team Player with strong management, organizational and mentoring skills.

When I work with SSIS (SQL Server Integration Services) and SSRS (SQL Server Reporting Services), I have a range of responsibilities. I have been responsible for designing and implementing Extract, Transform, and Load (ETL) processes using SSIS. Develop SSIS packages to automate data integration workflows. The quality and integrity of data by performing data cleansing and validation tasks within SSIS.

Moreover, I have been involved in developing reports using SSRS. Customize and extend the functionality of SSRS reports by writing custom expressions, adding interactive features, and integrating with other systems. Document my code, configurations, and processes to ensure maintainability and knowledge transfer.

Technical Summary:

Programming Languages

C#, Angular JS, jQuery, JavaScript, HTML, CSS, Angular 6,9,10.

Web Technologies

ASP.NET, MVC, Web API, WCF, HTML, CSS, jQuery, JavaScript, Angular JS, XML, Bootstrap, SOAP.

.NET Technologies

.NET Framework (1.1/2.0, 3.5, 4.0), ASP.NET, ASP.NET MVC, MVC with WEB API, ADO.NET, NET CORE WCF, Entity Framework, LINQ

Design Patterns

MVC, Singleton, Factory, Template, CQRS.

Unit Testing Frameworks

Dynatrace, N-unit.

Dependency Injection Tools

Structure Map, Ninject

Integration Tool

Post Man, Soap UI, REST.

Database Development

SQL server 2008R2/ 2012/2014, MySQL, Oracle 11g

Software Methodologies

SDLC, Agile, waterfall

Source Repositories

Git Hub, TFS, Tortoise SVN, Visual Source Safe, and Jira

RAD/IDE

Visual Studio 2017/2015/2013/2012/2010

Modeling and Design Tools

Microsoft Visio 2003, UML (Unified Modeling Language)

Operating Systems

Windows Server 2003, XP, Windows, LINUX, UNIX

EDUCATION Details:

Masters

Computer science at Saint Leo University Florida United States of America.

2021 - 2023

Bachelor’s

Bachelor of Technology from JNTUH, Hyderabad in 2015.

2011 - 2015

Professional Experience:

Client: Agility E Services, Hyderabad, India September 2019 – August 2021

Role: .Net Developer

Responsibilities:

I played a crucial role in the implementation of the Rate Cloud module which allowed NPC to store, maintain, and analyze rates related to Agility E-services such as origin/destination charges, international freight movement rates, sell tariff, and other rates as applicable.

I ensured that Rate Cloud integrated seamlessly with different aspects of the project such as Contract Management, Gateway Management, Stakeholder Management, Quotation, Job Processing, Job Accounting, Tender Management, and Analytics, to facilitate the smooth functioning of these modules.

Involved in different phases of the Software Development Life Cycle (SDLC) including Requirement Analysis, Designing, Programming, Testing, and Documentation.

Created Web API as a back end and performed database operations (CRUD) through Entity Framework and DAL (Data Access Layer).

Developed smart search functionality in the application.

I have been involved in Built UI, more user interactive and user-friendly web pages, reusable classes, and functions using Angular, TypeScript, HTML5, CSS3, JavaScript, jQuery, and C#.NET.

Extensively used Kendo controls, Custom controls to develop crystal reports.

Designed and implemented the Core components for the application, which included a Data Access Layer (DAL), Business Logic layer (BLL), and Presentation Layer (PAL).

Designed and developed various pages using C# ASP.NET, MVC/Razor, HTML, CSS, JavaScript, and jQuery.

Implemented server-side caching using Redis cache.

Suggested the latest upgrades and technologies for NoSQL databases.

Evaluated system performance and validated NoSQL solutions.

Upgraded single-page application Angular 9 to 10.

Developed and assisted in the migration of web applications to Angular Applications. I took responsibility for the Architecture of the stand-alone module for the complete migration of the module.

Developed various services in Angular that consume the rest of services from the backend written in DOT NET. Also Utilized reusable components and guards to better accommodate the complete web application.

Leveraged Angular resources for all data access, encapsulating URLs, and standardizing data access interfaces. Created custom directives for re-usable components (multi-filed form elements, background file uploads, etc.)

Leveraged Angular for developing applications using Http Client Module for REST calls and used jQuery to process XML then providing them to components that are in need.

Implemented Angular Service calls using Angular Factory.

Customized Data Tables and High charts into Angular Directives.

Implemented search filter using Angular filter and create custom filters for specific use.

Used JIRA for getting the development details and tracking purposes and to report the hours and issues that are related to the project.

Migrated backend application from .NET Framework to .NET Core.

My duties included database design, creating stored procedures, triggers, and views using Oracle Database.

Additionally, I oversaw the development of grid views, crystal reports, and uploads using the Kendo UI in JavaScript and jQuery.

Used SOAP Web Services for transferring/retrieving data between different internal providers.

Involved in requesting Logging and Exception Handling in WEB APIs using Action filters, exception filters, custom error codes, and filters.

Involved in the design of UML diagrams like Class Diagrams, Sequence Diagrams, and Activity Diagrams from the Use Cases.

And moreover, I have created DOT NET CORE 2.0 Application for getting rates from the Oracle database by using Postman.

Design and architect scalable and secure cloud solutions on Azure, including creating high-level and low-level design documentation, defining Azure resource architectures, and recommending best practices for .NET application development on Azure.

Provision and manage infrastructure resources on Azure, including virtual machines, virtual networks, and load balancers, to support the deployment and operation of .NET applications on Azure.

I have been involved in monitoring and optimizing the performance and cost efficiency of .NET applications on Azure by leveraging Azure Monitor, Azure Advisor, and other monitoring and optimization tools provided by Azure.

For this project I have implemented security by using authentication tokens and validation certification (It consists of a user Id, password, and Organization access code).

Environment: Angular 9, 10, ASP.NET Web API, .Net Core 2.0, C#.NET, HTML5, MVC/Razor, CSS3, Kendo UI, JavaScript, jQuery, LINQ, Visual Studio 2017, SQL Server 2014,2016,2019, Oracle, and Azure DevOps.

Client: Grapple info solution, Hyderabad, India August 2017– September 2019

Role: .Net Developer

Responsibilities:

Involved in different phases of the Software Development Life Cycle (SDLC) including Requirement Analysis, Designing, Programming, Testing, and Documentation.

This is a CRM project which is a tool that’s designed to offer customers a unique and seamless experience, as well as build better relationships by providing a complete picture of all customer interactions, keeping track of sales, organizing, and prioritizing the opportunities, and facilitating collaboration between various teams.

Handled all aspects of the web application including maintaining, testing, debugging, and deploying.

Designed and developed various pages using Angular 6, C#, MVC/Razor, HTML, CSS, TypeScript, and JavaScript.

Created the Web API controllers in ASP. NET MVC to build, and maintain Restful APIs, also consumed API's client side using Angular 6 data binding.

Implemented Language Integrated Query (LINQ) for retrieving the data effectively and in a timely manner.

It consists of different sub-modules like Customers, Employees, Vouchers, DC, Invoices, Payments, Receipts, Estimates, Variants, etc., which are used to maintain the data of their day-to-day business practice.

Involved in the design and development of the project, I would have had several responsibilities.

Development of Orders, Estimates, Opportunities, Templates, and Payroll in the CRM Project.

In database design and development to create complex database queries, constraints, indexes, views, stored procedures, and other database objects.

Additionally, I would have implemented two-way integrations in a container, which typically requires a strong understanding of APIs and data management.

Moreover, I would have been responsible for developing grid views, crystal reports, and uploads using the Kendo UI in JavaScript and jQuery.

The main aim of this project Configure all business terms and conditions along with customers' credit health to speed up the order processing in the supply chain. Digital channels your network with complete control over data about the orders and customers' credit health limits to enable a seamless credit system for repeat customers with good credit health.

I must be proficient in CRM configuration, customization, integration, and migration, as well as plugin and workflow development, and report generation.

Responsible for maintaining customer databases, providing technical support to end-users, and troubleshooting any issues that arise in the CRM system.

Implemented JSON parsing for data handling on different scenarios.

Integrated the GSTR-1 filing with the CRM project where all invoices’ data can be pushed to GST.

portal, GSTR-2A Reconciliation.

Two-way Integration is done for the data transfer from the CRM project to SAP.

Developed Line charts, Bar Charts, Pie charts, and Scatter plots using Kendo UI.

Data extraction from various sources, data transformation, and loading it into the target database or data warehouse by using ETL Process (SSIS and SSRS).

I have been involved in creating control flow tasks, data flow tasks, and event handlers to handle errors, logging, and auditing.

Customize and extend the functionality of SSRS reports by writing custom expressions, adding interactive features, and integrating with other systems. Collaborated with peer teams to find better and more efficient ways of implementing the functionality.

Participated in envisioning discussions and provided inputs from a development perspective for shaping up overall product strategy.

Environment: C#, ASP.Net, ADO.Net, IIS 6.0, Visual Studio 2012, Angular 6.

Client: Grapple info solution, Hyderabad, India June 2016 – August 2017

Role: .Net Developer

Project Title: Bizgaze V.0

Project Description: Bizgaze V.0 is a web-based payroll and HRMS solution specifically designed for small businesses. It has an intuitive interface with streamlined features so small business owners can focus on critical aspects of running an organization. Users simply run payroll quickly from any device. ADP’s automatic tax features help owners keep on top of federal and state regulations so they’re in compliance.

Responsibilities:

• Developed and implemented web page interfaces. Created ASP.NET MVC pages using we.NET for middle-tier processing of client requests with Entity Framework interfaces for database and implemented stored procedures.

Followed Agile Methodology for development in most of the individual projects and actively participated in the daily meetings to produce quality deliverables within time.

Worked with Subject Matter Experts to identify and understand the features and helped them in breaking down into small user stories.

Developed Single Page Applications using Angular, HTML5, CSS3, Bootstrap 3 and Ajax for handling asynchronous requests.

RUN is a web-based payroll and HRMS solution specifically designed for small businesses for internal employees. It has an intuitive interface. with streamlined features, so small business owners can focus on critical aspects of running an organization. Users simply run payroll quickly from any device. ADP’s automatic tax features help owners keep on top of federal and state regulations so they’re in compliance.

Used ADO.NET and data objects such as Data Adapter, Data Reader, Dataset, and data table for consistent access to SQL data sources.

Developed the custom error pages and Error Handling. Migrated the functionality from existing asp pages to new aspx pages and added new functionality to reflect the Business Users’ requirements.

Analyzing and achieving client requirements by participating in client calls.

Involved in sprint planning and group discussions to lay the future for product development.

Involved in the design and development of payroll and pay data entry.

Involved in resolving production issues.

Used to create stored procedures, triggers, and views using SQL in SQL SERVER.

Developing REST API and writing code bundles and wrappers.

Developing widgets, Grid views using dojo UI in JavaScript and jQuery.

Environment: C#, ASP.NET MVC, SQL Server, HTML, JavaScript, jQuery, Angular.



Contact this candidate