.Net Developer Sql Server

Name: Akhil Reddy

Email: *************@*****.*** PH: 650-***-****

Sr. Full Stack .NET Developer

Professional Summary:

• Over all 9+ years of IT experience in Analysis, Design, Development, Implementation, Testing, maintenance of Client-Server and Backend and Web-Based Applications using N-tier Architectures with Microsoft technologies, following Agile/Scrum development methodologies.

• Designed UML Diagrams, ER Diagrams and Data Flow Diagrams using MS Visio.

• Experience in developing applications under .NET Framework 4.7/4.6.1/4.5 using Full Stack ASP.Net, C#, SQL Server, WCF Services, Web API RESTful Services.

• Extensive Experience in Implementing View, Model, Controller and View model by using ASP.Net MVC Framework 6/7/8.

• Experience in designing User Interface using AJAX, HTML, CSS, XML, JavaScript and other Third-party Controls (Telerik Controls) to enhance the performance, looks and features of the website

• Extensively used Object Oriented Programming Principles (OOPS) principles like Inheritance, Polymorphism and developing applications using design patterns like MVVM, MVC 3/4, Abstract Factory and Singleton.

• Experience implementing Continuous Integration and deployment using various CI Tools like Jenkins.

• Experience on working with Windows Communication Foundation (WCF), Web API 2 in .NET 6/7/8.

• Developed back-end components and Expertise in writing connection logic to connect to third- party Web Services using Node.js.

• Experienced developing REST API's using ASP.NET Web API 2, handling HTTP requests and send HTTP response with serialized JSON data.

• Extensive experience in modern frontend frameworks like Angular (Angular 16+), React.js, and Vue.js, creating custom components, directives, and state management using Redux or NgRx.

• End to end Automation using Powershell for User Account/ Mailboxes/ Distribution Group/ Security Group provisioning and management.

• Extensively worked on WCF and Web Services to provide SOA architecture and Configuration based activation applications on SOAP and REST protocols.

• Excellent experience in creating, consuming and publishing XML Web Services (SOAP, WSDL) using .NET Framework and solid understanding of Service Oriented Architecture (SOA).

• Expertise in creating web based application using technologies like Classic ASP, AJAX Toolkit, JavaScript, XML, HTML 5/4 and DHTML.

• Worked extensively with ADO.NET Entity Framework, ADO.NET objects such as Data Adapter, Dataset, and Data Reader to interact with databases like SQL Server and Oracle providers.

• Proficient in T-SQL Queries, Views, Joins, Functions, SQL Stored Procedures, Database Triggers, Cursors, Performance Tuning and Query Optimization.

• Experience in developing Custom Reports in multiple formats using SQL Server Reporting Services (SSRS) and Crystal Reports.

• Experience in Configuration Management, setting up company Version policies, build schedule using Team Foundation Server, Visual Source Safe, Tortoise SVN and Cruise Control for continuous integration.

• Experience in deploying, configuring and maintaining Web Applications and Services on IIS 7.0/6.0.

• Experienced in Documenting, Preparing Test Plans, developing Test Cases and Testing (Unit, System, Integration, User Acceptance and Regression testing)

• Experienced in using kendo Framework for data analysis reports using Kendo grids, graphs, charts, etc.

TECHNICAL SKILLS :

Programming Languages: C++, C#.NET (7.0/6.0/5.0/4.0), HTML5, CSS3, T-SQL, PL/SQL.

Web Technologies: Full Stack, ASP, ASP.NET Web Forms, ASP.NET MVC 6/7/8, ASP.NET WebAPI2, MVVM, AJAX, Javascript, JQuery, Sharepoint, Silverlight, Sitecore, Web Services, and WCF.

Javascript Libraries/Frameworks: JQuery, AngularJs, Kendo and Node.js.

Responsive Design: Bootstrap.

Xml Technologies: XML, XSLT, XPATH, and XSL.

Message Format: JSON, XML.

Windows App Technologies: Win Forms, WPF.

IDE Tools: Visual Studio 2022/2019/2017, SQL Server Management Studio.

.Net Frameworks: .Net Framework 4.7/4.6.1/4.5/4.0/3.5/3.0

Databases: MS SQL SERVER 2016/2014/2010/2008, MSAccess 2010/2007, Oracle 10g/9i, and MongoDB.

Reporting Tools: SQL Server Reporting Services (SSRS 2014/2008/2005), Crystal Reports (2010/9/8.5/8).

ETL Tools: SQL Server Integration Services (SSIS 2008/2005).

Modeling Tools: UML, MS Visio 2010/2007.

Version Control Tools: SVN, Team Foundation Server (TFS 2015), GIT, and FileNet.

Middleware: Web Services, WCF, ADO.NET, ADO.NET Entity Framework.

Continuous Integration: Cruise Control.

Servers: Windows Server 2008/2003/NT, Microsoft IIS (7.0/6.0/5.0)

Work Experience

Client: CME Group, Chicago, IL July 2023 – Till Date

Role: Sr. Full Stack .NET Developer

Responsibilities:

• Involved in full Software Development Life Cycle using Agile Scrum methodology, including sprint planning, daily stand-ups, reviews, and retrospectives.

• Designed and developed scalable web applications using ASP.NET Web API (.NET 6/7/8) and Angular 17, utilizing RESTful services and component-based architecture.

• Built responsive, single-page applications with TypeScript, HTML5, CSS3, Bootstrap 5, and Node.js 21 for frontend scripting and package management.

• Deployed containerized applications using Azure Kubernetes Service and managed Helm-based release cycles to streamline deployments.

• Implemented backend services using Azure Functions for event-driven processing and Logic Apps for system integrations.

• Managed CI/CD pipelines using Azure DevOps and GitHub Actions, automating builds, tests, and deployments across dev, QA, and production environments.

• Provisioned and managed infrastructure using Terraform and ARM templates, ensuring consistent and repeatable environments in Azure.

• Integrated Azure Cosmos DB and Azure SQL Database for data storage, using partitioning and indexing for performance optimization.

• Created and consumed secure APIs using OAuth 2.0 and Azure AD with role-based access control.

• Monitored applications using Azure Monitor, Application Insights, and Log Analytics, improving observability and reducing incident resolution time.

• Designed and implemented complex T-SQL queries, Stored Procedures, Views, and Functions for business-critical operations in SQL Server 2022.

• Developed and scheduled SSIS packages for ETL processes integrating data between Oracle Server and SQL Server.

• Conducted unit testing using NUnit, and supported system and integration testing activities across environments.

• Led code reviews, managed version control using Git, and provided production support with a strong focus on performance tuning and debugging.

• Collaborated with cross-functional teams to document technical specifications, user stories, and architectural diagrams.

Client: Providence Health & Services, Renton, WA Jan 2022 – June 2023

Role Sr. Full Stack .NET Developer

Responsibilities:

• Engineered enterprise-grade microservices using ASP.NET Core 5.0 and RESTful APIs, deployed on Azure Kubernetes Service (AKS) with Helm and Docker, resulting in highly available and fault-tolerant systems.

• Designed and orchestrated full-scale cloud infrastructure using Terraform for Azure, automating provisioning of AKS, App Services, Azure SQL, and Cosmos DB—cutting environment setup time by 80%.

• Built serverless pipelines using Azure Functions and Logic Apps for event-driven data processing and automated healthcare workflows, reducing manual operations by 60%.

• Developed secure, compliant APIs with OAuth 2.0, Azure AD authentication, and RBAC to meet HIPAA and enterprise security standards.

• Architected and delivered CI/CD pipelines using Azure DevOps, integrating unit tests, SonarQube scans, and multi-stage YAML-based deployment strategies to reduce release cycle time by 40%.

• Created reusable UI components using Angular 10+, optimized with lazy loading, NG modules, and advanced RxJS patterns, boosting frontend performance and maintainability.

• Integrated Azure Monitor, Application Insights, and Log Analytics to build proactive monitoring dashboards and set up alerting pipelines, increasing observability and reducing MTTR by 50%.

• Leveraged Cosmos DB and Azure SQL with optimized indexing, partitioning, and data access layers for scalable and high-performance data operations.

• Developed and managed FHIR-compliant dashboards for real-time healthcare analytics using Angular and ASP.NET APIs, enabling 20% improvement in clinical decision-making.

• Automated ETL workflows using SSIS, moving large datasets across Oracle, flat files, and SQL Server, with complete logging and error-handling mechanisms.

• Mentored junior developers on advanced concepts like async pipelines, CQRS patterns, containerization, and DevSecOps practices in a cloud-native .NET ecosystem.

• Conducted code reviews, defined architecture standards, and introduced modular design principles to enhance reusability, testability, and scalability across microservices.

Client : Midwest Airlines, Indianapolis, IN Sept 2020 – Dec 2021

Sr. Fullstack Dot Net Developer

Responsibilities:

• Developed web pages to create messages, to set up messages rules and to set up content using ASP.NET core 3.1, AJAX, and C #, JavaScript and XML.

• Involved in all phases of SDLC from software requirements gathering, design, implementation, testing, support, and product maintenance.

• Developed Client/Server Applications on n-tier architecture and MVC (Model View Controller) design pattern.

• Developed business objects viz., Business Entities, façade layer objects and data access objects using OOD /OOP concepts for the N-tier web application.

• UI development utilizing WPF 4.7.2, implementing MVVM. Creating and troubleshooting Views (XAML), View Models and Domain Object Models.

• Individually authored, installed, deployed, and managed reports utilizing SQL Server 2013 Reporting Services (SSRS).

• Used C# WIN FORMS to create a dynamic reporting tool that queried a complex SQL backend.

• Converted .NET application to Microsoft AZURE Cloud Service Project as part of cloud deployment.

• Migrated SQL Server 2017 database to Windows AZURE SQL Database and updating the Connection Strings based on this.

• Development of mobile application using Xamarian.

• System exposes all the data/content through an MVC REST API and Windows Communication Foundation (WCF).

• Created client-side framework to load and reuse JavaScript files and html templates asynchronously using require.js and Asynchronous Module Definition (AMD).

• Involved in Test Design, Development, and Implementation of test procedures in Selenium Performed unit testing and integrated testing for fixing the bugs, writing test cases, test plans and generating test scripts.

• Customized User Controls, web controls using Kendo UI and improved the performance of the application by configuring the caching, Bowser Storage, Managing Cookies.

• Managed Process, Operator, Materials Enforcement modules in MES Systems and integrated with other systems like ERP & PLM's. modules under Paperless Manufacturing, Product/WIP Traceability, Genealogy, & Audit Trail, Process, Operator, Equipment, & Materials Enforcement, Data Collection & Process Limits.

• Used Telerik Controls like dating control, autoing complete text boxes, file upload controls, Radgrids for rich user experience.

• Designed the front-end user interface by using ASP.NET, NO SQL, MVC, Node JS, HTML, Angular JS and Ajax controls.

• Used Express Framework to set up middleware to respond to the HTTP requests with the help of Node JS.

• Re factored and enhanced an existing application to follow strict MVVM/MVC patterns for improved source code maintenance, code reduction, ease of upgrade, scalability, ease of developer spins up, enhanced performance using Angular JS.

• Designed the web UI using ASP.NET MVC 4.7, HTML, DHTML, XSL/XSLT, Angular JS, Bootstrap, JavaScript, CSS3, Web Forms and AJAX and JQuery controls.

• Involved in coding, testing and implementation of the project using C#, ASP.NET, SQL Server, SQL Server Integration Services.

• Worked on User Interface System using HTML5, CSS3, JavaScript, AJAX, JSON, JQuery, Angular JS, Bootstrap.

• Used Angular JS for Client-Side scripting along with JavaScript and JQuery.

• Developed 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.

• Developed classes using C#.NET to improve performance and Consumed WCF services using REST / WSDL.

• Involved in the changes to existing MVC pages for login and Change password pages and, also added authorization and authentication of the pages using Membership database.

• Implemented Angular JS Controllers to maintain each view data, Used an Angular JS Factory to Interact with a RESTful Service.

• Development and Deployment using Power Shell Scripts using Azure. Developed Power Shell Scripts for Automated Deployment of Developed Packages using Service Fabric.

• Used TFS to automatically build the projects and source code management.

• Experience with built-in services and knowledge of custom services and scoping in Angular JS.

• Consumed Web API from ASP.NET MVC application using Http client, Implemented Web Services Using ASP.NET for consumption by the client application.

• Involved in designing, Coding and documentation of application flows and worked on presentation layer for developing GUI and developed using WPF.

• Performed querying to database using LINQ to SQL and querying to XML files using LINQ to XML.

Client: Atyati Technologies PVT LTD, Bangalore, India Jan 2018 – Dec 2019

Role: Dot Net Developer

Responsibilities:

• Migrated Windows application to Web Application using Visual Studio 2017 (.NET Framework 4.7.2) and SQL Server 2017.

• Worked on Views to enhance and update the page as per the user request by using jQuery3.3 and JavaScript, HTML and CSS.

• Developed and designed Single Page Application using Angular 6/7.

• Developed Web Applications were involving Web API Backend and Front end Angular 6/7 and implemented swagger (for the API testing interface).

• Used WPF as it supports UI, document, Hardware acceleration, Interactive data visualization and superior readability.

• Designing the database structure for the application in Dynamo DB, a NoSQL Db from AWS.

• Work with .Net Core 2.2 Web API and to develop Back End Technologies.

• Done some enhancements to the code to display some extra fields in the windows application.

• Developed Custom Controls and User Controls using ASP.Net and C#.

• Used JSON to transmit data between Server and Web Application, an alternative to XML Serialization and performed CRUD operations with WCF Restful services.

• Worked on Kendo UI Controls to support HTML5 Controls in all the browsers.

• Implemented CRUD functionality with Entity framework 6 in ASP.NET MVC 5 and applied sorting, filtering, and paging with Entity framework in MVC.

• Wrote complex stored procedures and SQL queries using SQL Server for extracting, inserting, and manipulating the data and display on Grid view controls and dropdown list boxes and User controls.

• Implemented robust MS SQL backup and recovery strategies to safeguard critical data. This ensured minimal data loss and downtime during unexpected failures.

• Leveraged NoSQL databases to support real-time data analytics and business intelligence, enabling data-driven decision-making and providing insights for strategic planning.

• Core programming using Angular 6/7, REST/WEBAPI, C#, AWS. .Net Core etc.

• Created and scheduled SQL jobs to run SSIS packages daily.

• Developed SQL stored procedures using T-SQL for data manipulation and querying data from database.

• Used VSS for version control and to maintain consistency with the remote team members.

• Performed detailed test designs using software test engineering principles in the context of test automation platforms and integration across distributed systems.

• Prepared support documentation for all the activities undertaken at regular intervals for the Project management review and update.

Client: Menlo Technologies Hyderabad, India June 2015 – Dec 2017

Role: Software Developer

Responsibilities:

• 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.

• 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 2015.

• Created different business classes and interfaces using .NET Core and .Net Framework 4.0 with OOP Methodology.

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

• Created and developed independent WCF services and defined service contracts for specific functionality in search module.

• Used Bit bucket for source code repository, version control, bug tracking & fixing and configuration management.

• 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 to reduce the complexity and to get full control over the behaviour of the application.

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

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

• Created and updated Entity Relationship Diagram using Microsoft Visio.

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

Contact this candidate