.Net Developer Sql Server

Name: AKHILA ADDULA

Senior Full Stack .NET Developer

Mail: ******.******@*****.***

Phone: +1-616-***-****

Professional Summary:

Over 10 Years of IT experience with Involvement in all phases of Software Development Life Cycle (SDLC) such as planning, analysis, design, implementation, testing and maintenance of Web Based, Client-Server and N-tier Architectures. Proficient in worked with Waterfall and Agile Development Environment, with expertise in SCRUM Programming.

Hands-on experience in software design and development using .NET Frameworks, including ASP.NET, WEB API, Microservices, ADO.NET, SQL Server, Entity Framework, Win Forms, Web Forms, Web Services, LINQ, and IIS.

Spearheaded the development of an interactive, customer-facing application using React JS, which increased app downloads by 65%. Designed and implemented API endpoints using .NET Core for React app.

Used Angular as a framework to create single page Application which can bind data to specific views and synchronize data with server using SaaS, Bootstrap, JSON.

Expertise in using ADO.NET object such as connection Object, Command Object, Data Reader Object, Dataset Object and Data Adapter Object. Implemented web programming with hands on experience on using Custom Controls, Master pages, themes, and Validation controls.

Possess excellent abilities in developing database programs like Store Procedures, Joins, Triggers, Views, Cursors and Working experience of RDBMS like SQL Server (MS SQL)

Strong experience in MS SQL Server working with business intelligence tools in SSAS (SQL Server Analysis Services), SSRS (SQL Server Reporting Services) and SSIS (SQL Server Integration Services).

Strong experience in Azure Development, including Azure web application, API services, Azure SQL Database, and Azure Functions.

Proficient in architecting scalable solutions on Google Cloud Platform (GCP), leveraging services like Compute Engine, Cloud Storage, and Kubernetes Engine for seamless deployment, data management.

Extensively worked on Microservices, AWS working with EC2, RDS, Dynamo DB, S3, Cloud watch and Docker. Responsible for maintaining and expanding AWS (Cloud Services) S3 infrastructure using AWS (SNS, SQS).

Heavily involved in code review, build and deployment with GIT, Jenkins, and Azure

Involved in Debugging and Supporting the application and Performed Unit Testing using N-Unit and MS-Unit, X-Unit and Test tools like POSTMAN, Jasmine, Karma.

Expertise in usage of version controls like GIT, TFS and ticketing tools like JIRA

Demonstrated strong analytical and problem-solving skills, consistently devising innovative solutions to complex challenges in software development and data analysis and collaborative team worker.

Implementing AngularJS Controllers to maintain each view data. Implemented Angular Service calls using Angular Factory. Used Angular JavaScript to develop templates, controllers, and directives for UI development. Expertise in Angular controllers, directives, components, factory and service resources, routings, and events. Used for Dependency Injection to control the permissions.

Possess a robust foundation in computer science fundamentals, showcasing expertise in data structures, algorithms, object-oriented design, and design patterns.

Proficient in orchestrating software development projects through various phases of the SDLC, leveraging Agile methodologies, and utilizing JIRA for efficient project management and issue tracking.

Technical Skills:

.NET Technologies

ASP.NET 1.1/2.0/3.5/4.0/4.5, MVC, WEB API, Microservices, ADO.NET, LINQ, Entity Framework.

Languages

C# .NET, VB.NET, Visual Basic, C, C++, Java, PL/SQL, T-SQL, PowerShell

Web Technologies

HTML5, XML, JSON, SOAP, CSS, Web forms, Web Services, MVC & UML

JS Frameworks

JavaScript, Type Script, Angular JS, Angular 2/4/5/6/7/9/12/13/14,

React JS

Databases

SQL SERVER

Web Servers

IIS (Internet Information Server)5.0/6.0/7.5/8.0/8.5

Testing Tools

XUnit, NUnit, Karma, POSTMAN, Jasmine, Kafka

Reporting Tools

SSIS, SSRS, SQL Server Management Studio (SSMS)

Version Control

Visual SourceSafe, Team Foundation Server and GIT,

Cloud Technologies

Microsoft Azure, AWS, GCP

CI/CD

Azure DevOps, Jenkins, Azure Kubernetes

Key Skills:

Language

Proficient

Exp in Years

Asp.Net MVC

Expert

5

Asp.Net

High

5

Web API

Expert

6

C#

Expert

10

MS SQL

Expert

9

React

Expert

6

Angular

Expert

6

Project Experience:

Mayo Clinic - Rochester, Minnesota Jul 2021 to Till Date

Role: Senior Full stack .Net Developer

Project Title: Flight Reservation System

Project Description: Web application that allows users to search for flights, view schedules, and make reservations. It can also handle payment processing, seat selection, and email confirmations.

Responsibilities:

Implemented performance optimizations leveraging new features in .NET core 6.0, resulting in a 30% reduction in application response time.

Complex suite of mission-critical online applications was created in React JS high levels of customer satisfaction were achieved by meeting their evolving wants.

Created the application in ASP.NET MVC environment as requested and implemented services to consume the RESTful Web API using C# ASP.NET Web API.

Modernized codebase from outdated .Net Framework to .Net Core for web application, improving performance by 60%.

Developed secure RESTful API services using .NET Core leading to seamless and faster data transfer.

Developed a RESTful Web API to separate data handling from the front end which was able to handle Get, Post, Put and Delete requests with HTTP and return JSON results.

Produced multiple visual elements of web applications by translating UI/UX design wireframes into code, producing high quality markup using HTML5 and CSS3.

Used OAUTH 2.0 authentication framework to provide security to Restful web services by generating access token to access protected resources.

Orchestrated the overhaul of our user authentication protocols, escalating user security and reducing breach incidents by 70%

Designed, built and tested completely rebuilt infrastructure to move delta application from static hosting in Rackspace to containerized infrastructure-as-code maintained in Azure utilizing automation tools and terraform.

Enhanced the efficiency of Azure DevOps, streamlining our CI/CD pipeline and resulting in a notable 35% reduction in software delivery time.

Implemented cluster services using Azure Kubernetes and Docker to manage local deployments in Kubernetes.

Implemented cluster services using Docker and Azure Kubernetes services (AKS) to manage local deployments in Kubernetes by building a self-hosted Kubernetes cluster using Jenkins CI/CD pipeline.

Worked on Log4J to validate functionalities logging errors, messages, and performance logs and Mockito framework JUnit for unit testing.

Streamlined the software release process using GIT for version control, reducing project oversights by 45% and provided technical leadership to a team of five developers, fostering an environment that encouraged performance improvement.

Used Microsoft Azure for building, deploying, and managing applications and services through a global network of Microsoft-managed and Microsoft partner hosted datacenters.

Environment: ASP.NET, C#, MVC5, WEB API, Visual studio 2019, IIS, HTML5, CSS3,React, Kubernetes, LINQ, NUnit, Xunit, Agile Methodology, Git,JIRA, Log4J, Azure DevOps,,REST, OAUTH, Azure Cloud,,SQL.

Delta Air Lines - Atlanta, Georgia Oct 2018 -Jun 2021

Role: Senior .Net Developer

Project Title: Electronic Medical Records System

Project Description: This project involved the development of a system that allows medical practitioners to record and monitor their patient's medical history, diagnosis, treatments, medications, progress, visits.

Responsibilities:

Involved in all stages of SDLC including designing, coding, testing, and implementing the application following Scrum (Agile) methodology.

Assisted and managed in all sorts of Agile ceremonies (user story grooming, sprint planning, sprint retrospective, daily Standups, Release Planning).

Experience in designing and developing Microservices for the business components using .NET framework 4.5.

To improve performance and enable process simplification worked on re writing old windows-based applications to a web-based application in newer technologies such as ASP.NET CORE, SQL Server.

Used TypeScript and Angular to update a portion of a web page thus reducing bandwidth usage and load time and add modal dialog in web pages to get user input and requests.

Designed and implemented an innovative user interface using Angular that increased user engagement by 30%.

Used Microsoft Entity Framework code. First Approach for the Data Access Layer for the ASP.NET MVC. Created REST Web API web services to post and consume data between SQL database using C# MVC 5 application.

Developed RESTful Web API endpoints using ASP.NET Web API framework to facilitate seamless communication between client applications and server-side logic.

Buit responsive websites using sematic HTML, CSS, Angular, JSON

Created and deployed .NET-based websites and web applications into AWS Services. Using PowerShell, RESTful, and APIs, monitored the website resources.

In responsible for expanding and maintaining AWS S3 infrastructure (SNS, SQS).

Automating JS applications by using Protractor, Jasmine framework and Developed Test Scripts to implement Test Cases, Test Scenarios and features for Behaviour Driven Development using Cucumber.

Involved in creating a Web API with Entity Framework and Used Postman to test Web API functionality.

Extensively used Node.js tools like Gulp, Grunt, Web pack to Develop internal CLI applications using Commander Module for application build.

Consumed SOAP APIs from enterprise customer system and RESTful APIs provided by other applications in the portfolio, also created W&C RESTful APIs.

Effectively worked on JIRA for ticketing and as well as defect tracking system and configure various workflows, customizations and plug-ins for JIF bug/issue tracker, integrated Jenkins with JIRA, GitHub, Maven.

Environment: ASP.Net Core, C#, MVC, Angular, WEB API, MS SQL, Visual Studio, IIS, HTML5, CSS3, Postman, AWS, GIT, Agile Methodology, JIRA, Entity Framework, JSON, REST, NodeJS.

First Republic Bank - San Francisco, California JAN 2016- Oct 2018

Role: .Net Developer

Project Title: Health Secure Portal Enhancement for First Republic Bank

Project Description: The Health Care Technology Group (HCG) supports the recordkeeping and administration of Health Benefits (Medical, Dental and Vision plans) as well as the Health Savings and Reimbursement Account plans on behalf of First Republic’s corporate clients, their employees and

retirees.

Responsibilities:

Designed and developed web technologies like C#, ASP.net, Angular, TypeScript, CSS3 and HTML5 in designing and developing the web project.

Planning Agile and Scrum implementations within the organization

Worked with advanced concepts of ASP.NET Web API, LINQ and responsible for designing the ASP.NET application authentication using .NET Framework 4.5 IIS security model.

Extensively used CSS (Cascading Style Sheets) to apply different styles to the layouts for varying screen sizes and pixels.

Extensively used Angular JS UI for ng grid and UI components and responsible for making API Calls for the UI Interactions to the Controller Actions using Query and getting the data back as JSON and parsing it onto the UI.

Developed using REST based APIs services to integrate with Mule ESB based on use case and had implemented the custom transformations.

Experience using Configuration management tools like Team Foundation Server

Created custom SharePoint web parts using visual studio with Microsoft.

Implemented TDD, Unit Testing, Integration Testing and System Testing

Migrated SQL Server databases to Azure SQL Database at the end of project, optimizing the costs by 30%

Environment: ASP.NET, Web API, LINQ, C#.NET, SQL Server, HTML5, CSS3, JavaScript, Angular, IIS, Git

Bank of India - India Jun 2013 -Dec 2015

Role: .Net Developer

Responsibilities:

Expertise and implemented rich user interface using Asp.Net, jQuery, CSS, and HTML

Developed various abstract classes, interfaces, and classes to construct the business logic within the Model using ASP .NET.

Spearheaded the implementation of large and highly complex applications.

Used ADO.NET and strongly typed datasets to insert, update, delete, and retrieve data from a SQL Server database.

Wrote SQL Statements, Stored Procedures, Triggers, Functions, and Sequences to access data from database.

Used SSRS for reporting in SQL and SSIS for transferring data between applications.

Troubleshooted SSMS setting up/connection issues for other team members.

Employed Team Foundation Server (TFS) for version control and in documentation and creating Help files.

Environment: Visual Studio, ADO.NET, ASP.Net, jQuery, TFS, IIS, JavaScript, SSRS, SSIS, Html, CSS, Waterfall.

Bachelor of Technology in computer science:

Jawaharlal Nehru Technological University Hyderabad

Contact this candidate