.Net Developer Sql Server

Vimala Yerraguntla

Sr .Net Developer

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

LinkedIn: https://www.linkedin.com/in/vimala-c-986634288/

Phone: 234-***-****

Professional Summary:

* ***** ** ********** ** IT including analysis, designing, development, testing, bug fixing and implementation in the Software Development Life Cycle (SDLC) of Client-Server and Web-Server for various N - Tier applications using Microsoft Technologies.

Strong experience in Waterfall and Agile Methodologies in Application Development with hands on experience working on Agile Development Team following SCRUM Methodology and paired programming using Test Driven Development (TDD).

Good experience in gathering requirement analysis, architecture, design and development of enterprise N-tier applications, documentation of user requirements, functional, systems Integration and architectural specifications.

Hands on experience in developing applications using MVC 4, ASP.Net, ADO.Net, and C#, HTML, CSS, JavaScript, Bootstrap and SQL Server.

Experience in developing client/server, internet & intranet applications using ASP.NET, C#, Web API, SOA, Web Services, HTML4/5, DHTML XML, ADO.NET, VBScript, JavaScript, SQL Server, AJAX, Angular2, WCF, jQuery and CSS.

Substantial experience in backend programming with solid background in MS SQL Server 2005/2008/2012, Oracle 11g/10g, PL/SQL, T-SQL, SSIS, SSAS, SSRS, PostgreSQL, Unix shell scripting and Linux/Windows.

Experience with Data Accessing including using Data Adapter, Data Reader and Dataset in ADO.NET and Language Integrated Query (LINQ) Providers for data manipulation.

Experience in deploying applications with Cloud Services by creating a simple Cloud Service with Visual Studio, testing it locally, deploying to a live AWS Cloud environment.

Good experience on AWS Services like S3, EC2, IAM, VPC, Redshift, CloudWatch, Load Balancing, Lambda, SNS, SQS, and EFS etc.

Expert in hosting Windows Web APIs, ASP.NET applications in IIS and creating Cloud Instance using AWS for deployment in product environment.

Hands on experience in developing front end applications with Angular, backend applications with C#/.NET, and database interaction with Microservice architecture using .NET.

Experienced in developing WebForms and Web Services in ASP.NET, C#.NET.

Experience in working with ASP.NET MVC and Entity Framework as ORM Mapping tool for Data Access layer.

Used React-Autocomplete for creating google maps location search on the web page added excel-builder to download the tabular data in excel format using react.

Good experience on working with ASP.NET Model-View-Controller (MVC), Language-Integrated Query (LINQ) in Web pages to retrieve and modify data.

Experience in deploying .NET applications through IIS using built-in tools as well as other tools.

Experience in developing Microservices to utilize .NET Core REST Webservices in the client's environment.

Well versed in N-Tier Architecture and Web applications using Windows forms, Web forms and Windows services, SOAP, IIS and XLST.

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

Extensive experience on Queries, Stored Procedures, Functions, Triggers and Views in SQL Server 2005/2008/2008 R2 and Oracle to access database.

Developed and executed LDAP queries to manage and retrieve user and group information for reporting and compliance purposes.

Conducted security assessments of LDAP configurations to ensure adherence to best practices and organizational policies.

Knowledge in using Source Controls like Team Foundation Server (TFS), Subversion (SVN) and Visual Source Safe (VSS).

Experience in Unit Testing, User Acceptance Testing to check whether all the business objective requirements are archived.

Experience in writing test cases with N-Unit and Karma for Unit test and performing end to end test using Protractor.

Technical Skills:

.NET Technologies

.NET Framework, C, ASP.NET, ASP.NET MVC, ADO.NET, LINQ, WPF, WCF, WinForms, WebForms, ADO.NET, Entity Framework

Web Technologies

HTML, HTML5, XHTML, DHTML, CSS, AJAX, XML, XSD, JavaScript, Azure, JQuery, XAML, Web Forms, Razor, Web Services, IIS

Cloud

Azure, AWS

AWS Services

S3, EC2, IAM, VPC, Redshift, CloudWatch, Load Balancing, Lambda, SNS, SQS, and EFS

Databases

PostgreSQL, SQL Server, Oracle 11g, MS Access

Reporting Tools

Crystal Reports, SSRS, SSIS, UML

Other Tools

Visual Studio, Visual Studio Code, MS SQL Server

Version Control Tools

VSS, Git, TFS, SVN

Design Patterns

MVC, MVVM

Operating System

Microsoft Windows XP Pro, 2000, 2003, NT, XP, Vista, 7

Professional Experience:

Client: Centene Corporation, Columbus, OH Jan 2023 - Current

Role: C#.Net Developer

Responsibilities:

Designed and created application using ASP.NET 5.0/4.5 using C# as major developing language.

Used JavaScript, jQuery and Ajax to develop user interactive web applications.

Implemented MVC, controllers, directives, services, factories, single page applications, filters and third-party angular module integrations.

Created and deployed XML Web Services (WCF) using ASP.NET and C#, used them to generate the proxy class files based on the web services and consumed in web application.

Created WPF controls and to create communication framework using WCF.

Extensively used AJAX and JSON/XML data to get server-side data and display it to users.

Created and altered various stored procedures, joins, functions and views as per requirements.

Used Entity Framework Code First approach for the Data Access Layer for the ASP.NET MVC 5.0 application.

Used Model-View-Control (MVC) architecture with Razor Engine in web applications to view the HTML.

Worked extensively on performance improvement in UI as well as stored procedures.

Created front-end applications for customer search using Angular and APIs with .NET Core

Managed and administered AWS Services CLI, EC2, VPC, S3, ELB Glacier, Route 53, CloudTrail, IAM, and Trusted Advisor services.

Integrated RESTful APIs and third-party services, utilizing Flutter’s networking capabilities to streamline data management and improve app functionality.

Used generics, Lambda expressions, extension methods, LINQ to SQL and LINQ to Objects.

Experience with large scale, production critical SQL coding in PostgreSQL including setting up scripting.

Designed, developed, and optimized SSIS packages for complex ETL workflows, ensuring seamless data extraction, transformation, and loading from diverse sources into unified data warehouses.

Proficient developing applications using MVC, Blazor server- side and web API Entity Framework.

Setup development environment using latest Blazor.net with ASP.net core.

Worked in using React JS components, forms, events, keys, router, animation and flux concepts.

Maintained and expanded AWS (Cloud Services) S3 infrastructure using AWS (SNS, SQS).

Initiated alerts in CloudWatch for tracking the server's performance, CPU utilization, disc utilization, and other metrics to take suggested measures for improved performance.

Used ASP.NET Web API for RESTful Web API service.

Used JQuery and Cascading Style Sheets for formatting front end. Worked on the UI layer using HTML, CSS, and JavaScript to give a good look and feel for the site.

Worked with IIS 10 and .NET Assemblies during application deployment.

Implemented Service oriented architecture using SOAP Webservices.

Deployed application to all lower environments including UI changes and generated/executed script to move database changes.

Migrated an Application developed in Angular 14.0 to Angular 15.0 recently.

Implemented Azure Devops services for project management tasks, source code repository, continuous integration and deployment.

Implemented new projects builds framework using Jenkins and Maven as build framework tools.

Used TFS extensively to keep track of story and hours worked in a task.

Used ALM to keep track of bugs and fixes.

Used Microsoft sign tool to sign the applications developed using a digital certificate.

Followed Agile methodology by having daily status calls with project managers, business analysts and tech leads.

Environment: .Net 6, ASP.NET MVC 5, C#, VB.Net, ADO.NET, AWS Cloud, Razor Engine, PostgreSQL, Microsoft Visual Studio 2019, TFS, SSIS, MVC, Blazor, Entity Framework, PowerShell Scripting, SQL Server 2012/2018, WCF, HTML, CSS, XML, JQuery, IIS 10

Client: Cox Communications, Akron, OH May 2022 – Nov 2022

Role: .Net Developer

Responsibilities:

Gathered client requirements and converted them into the technical specifications and developed Web Forms using C#.NET.

Developed Web applications using ASP.NET MVC, C#.NET, VB.NET, LINQ, Entity Framework and WCF.

Used .NET Framework 4.5 N-tier architecture and Object-Oriented Programming (OOP) concepts (C#) for Application Development.

Worked on React JS Virtual Dom and React views and rendering using components which contains additional components called custom HTML Tags.

Performed Visual Studio load testing for AWS migration. Built and deployed the code to AWS servers using Jenkins.

Experience supporting database application development including developing, deploying, maintaining, and documenting Oracle and/or PostgreSQL databases and stored procedures throughout the software development lifecycle.

Integrated MS/MQ messaging protocols into microservices architecture, ensuring seamless inter-service communication.

Accessed and performed the data analysis on RDS data service (Oracle).

Developed the front-end applications using HTML5, DHTML, CSS3, JavaScript, AJAX, XML, jQuery, JSON and AngularJS.

Angular 15.0 is written in TypeScript, a superset of JavaScript that adds static typing and other features to the language.

Implemented CI/CD pipelines to deploy Docker containers to Kubernetes clusters, reducing deployment time and increasing efficiency.

Implementing various screens for the front end using React.js and used various predefined components

Designed, developed and Deployed Azure Functions to achieve server less computing.

Used ASP.NET Web API as the platform for building Restful applications on the .NET Framework.

Used Web API controllers which support GET, POST, PUT, and DELETE.

Worked on ASP.NET WebAPI framework for building HTTP services that can be accessed from various clients, such as browsers and mobile devices.

Designed the web UI using Razor View Engine, HTML, XSL/XSLT, JavaScript, CSS, JQuery, AngularJS, Bootstrap, Web Forms and AJAX controls.

Involved in calling Stored Procedures and Functions from Entity Framework using C#.NET, VB.NET and Visual Studio 2019.

Developed PowerShell Desired State solution to ensure server compliance in AWS.

Wrote .Net Core/NodeJS for Amazon Lambda to manage some of the AWS services.

Designed and built AWS fail-overs, fault tolerance website with auto-scaling and load testing with multiple EC2 instances.

Developed service class in Windows Communication Foundation (WCF) service to retrieve the Customer payment details for processing payments.

Developed Restful service using Web API for communicating with the in-rule service.

Published Web services using C#.NET to interact with the other applications and exposed them using SOAP and HTTP.

Worked on existing complex SQL Codes to fix the errors and change the procedures to match the requirements for various business reasons.

Implemented scalable data integration solutions, leveraging SQL and ETL tools to process large datasets, improved pipeline efficiency, and support business intelligence reporting needs.

Worked on API’s to create multiple microservices using Rest and GraphQL as the middle ware for react projects to connect to service end points.

Implemented PL/SQL queries, triggers, Packages and Stored Procedures as per the design and development vb6related requirements of the project.

Developed XML Web Services and WCF services common for various applications using .NET Framework.

Created SSRS Data Model projects using Microsoft Visual Studio 2019 and using Report Builder for report server to facilitate Ad-hoc reporting by the business users.

Deployed the site into Production and Pre-Prod, QA Servers and Azure Cloud Environment

Involved in configuring and managing source using GIT.

Used WPF, Win Forms with C#, developed windows application parallel to project.

Environment: .NET, ASP.NET MVC, Razor, C#.NET, VB.NET, Azure, AWS Cloud, Visual Studio 2019, Win Forms, C#, Entity Framework, WCF, HTML, CSS, JavaScript, JQuery, Ajax, LINQ, T-SQL, PostgreSQL, Shell Scripting, Restful, MongoDB, TFS, Git, Jira, Agile

Client: S&P Global, Hyderabad India Feb 2019 – Jun 2021

Role: .Net Developer

Responsibilities:

Worked on modern software development models and theories, such as the object-oriented programming (OOP) model, event-driven programming.

Gathered client requirements and converted them into the technical specifications and developed Web Forms using C#.NET. Designed and created various User Controls, Custom Controls.

Created Console and Windows executable applications that monitor and validate various kinds of logs for weekly, monthly and annual report.

Involved in analyzing requirements for application. Extensively involved in reporting table structures and web forms based front end.

Used React JS for templating for faster compilation and developing reusable components.

Developed client-side JavaScript framework using Knockout.js employing ASP.NET MVC and Web API.

Used ASP.NET MVC, CSS, JavaScript, AngularJS, and C# to create Razor views with strongly typed view models and HTML Helpers, as well as partial views.

Developed PowerShell Desired State solution to ensure server compliance in AWS.

Wrote .Net Core/NodeJS for Amazon Lambda to manage some of the AWS services.

Designed and built AWS fail-overs, fault tolerance website with auto-scaling and load testing with multiple EC2 instances.

Applied SOLID principles to refactor a legacy .NET system, resulting in a 15% improvement in performance and a 10% reduction in bugs.

Consumed web services in applications to display data from database and make change to data in database.

Worked on application design pattern Abstract Factory, MVC, MVP, WCF, N-Tier, Domain Driven Design, Inversion of Control, Object per Query and etc.

Worked on RESTful service framework, C#, SQL, HTML, XML/XSLT, CSS, Enterprise service framework.

Used NodeJS, AngularJS, Backbone.js and Require.js MVC Frameworks in the development of web applications.

Worked on performance monitoring tools like AWS Cloud Watch and Stack driver.

Implemented WCF services and better logging exception management support to help in the premature detection of new problems.

Used Web Services, SOAP, XML and XSL to expose the reports to facilitate information sharing.

Implemented MVC framework to reduce the complexity and to get full control over the behavior of the application.

Worked with various AngularJS Expressions, Directives, Filters and Controllers.

Involved in writing complex Database Queries, Adored procedures, Trigger, View, Functions using SQL, MS SQL Server 20012.

Worked on the UI layer using HTML, CSS, and JavaScript to give a good look and feel for the site.

Environment: ASP.NET, VB.NET, C#, ADO.NET, AWS (EC2, Lambda, CloudWatch), SQL Server 2012, HTML, CSS, XML, XSLT, JavaScript, Oracle SQL Developer, Microsoft Visual Studio, IIS, SOAP, Restful, MVC, JQuery, Ajax, Web Forms, PowerShell

Client: NextGen Healthcare, Hyderabad, India Sep 2017 – Feb 2019

Role: .Net Developer

Responsibilities:

Worked on Agile Methodology (Scrum) to meet timelines with quality deliverables

Developed new product features for the high-profile single page application applying knowledge of ASP.NET MVC, JavaScript resulting in consistent deployment of major products updates.

Used .NET MVC, n-tier architecture and Object-Oriented Methodologies for application development.

Gathered requirements based on the documentation provided for the application and generated functional specifications and technical specifications.

Designed and implemented Business Layer using ASP.NET.

Designed and implemented User Interface Layer using ASP.NET MVC architecture.

Developed the front-end screens in ASP.NET and C# .NET using Visual Studio. Created different business classes and interfaces using and .NET Core and .Net Framework 4.6 with OOPS Methodology.

Implemented dependency injection and inversion of control to improve testability and maintainability of a .NET application.

Refactored the desktop application applying knowledge of .NET Core, ASP.NET Core and WPF and added additional features improving performance and usability by 20%.

Participated in code reviews and ensured adherence to OOPs best practices and .NET coding standards.

Created and developed independent WCF services and defined service contracts for specific functionality in search module. Created SQL command on Data layer to access data from Database and to insert data in database

Designed and implemented Data access layer using ADO.NET to connect and retrieve or manipulate database information.

Implemented MVC 4.0 to reduce the complexity and to get full control over the behavior of the application.

Used ASP.NET AJAX and updated web pages to implement the AJAX functionality to enhance the application.

Involved in customizing the Web Forms Data grid for GUI.

Designed and developed the components for implementing business logic in middle tier of the development architecture that interact with SQL Server database using managed provider with ADO.NET.

Worked on Server-side validations using C# and ASP.Net validation controls and client-side validations using JavaScript.

Worked with IIS 7 and .NET Assemblies during application deployment.

Created and hosted Restful Services, Web services and Web API also used different bindings to make it available to different types of clients.

Implemented Dependency Injection on Web API controller with Entity Framework for handling restful requests and responses using C#.NET.

Implemented PL/SQL queries, triggers, Packages and Stored Procedures as per the design and development related requirements of the project.

Used Jira to keep track of various stages of the bugs and incidents.

Environment: .NET Framework 4.6, ASP.NET MVC, ASP.NET Core, ASP.NET Web API, ADO.NET, .NET Core, C#, WCF, WPF, Entity Framework, LINQ, IIS 7, MS Visio, SQL, PostgreSQL, JavaScript, JQuery, HTML5, CSS3, Visual Studio 2016, TFS, Jira, Agile

Education:

Bachelors in Computer Science from Acharya Nagarjuna University, India-2016

Masters in Computer Science from Kent State University, USA - 2022

Contact this candidate