.Net Developer Sql Server

VAMSI DOSAPATI

United States • ***************@*****.*** • 913-***-****

Full Stack .Net Developer

Professional summary:

Accomplished Full Stack .NET Developer with 5+ years of extensive experience in the software industry, specializing in Microsoft .NET, JavaScript frameworks, and cloud-based solutions. Proven expertise in designing, developing, and maintaining scalable web applications, enterprise software, and cloud-based SaaS solutions using C#, ASP.NET Core, .NET 8, Entity Framework Core, Dapper, Angular, React, Blazor, TypeScript, and SQL Server. Skilled in microservices architecture, RESTful API development, and cloud computing with Azure and AWS, ensuring high availability and optimal performance.

Key skills and expertise:

Proficient in designing and developing frontend and backend web applications using Angular, React, and .NET C#.

Hands-on experience with the latest SQL Server, employing various advanced SQL features.

Experienced in object-relational mapping using ADO.NET, LINQ to SQL, Entity Framework, and Entity Framework Core

Developed data access layers using Entity Framework, Dapper, Automapper, and Unit of Work.

Strong background in gathering and analyzing project requirements.

Actively participates and contributes to Scrum events.

Solid understanding of various design patterns and principles.

Skilled in code review, pair programming, mentoring, and clean coding practices.

Proven track record in Continuous Integration and Continuous Deployment (CI/CD) pipeline practices.

Extensive experience with Microsoft Azure services, including the migration and development of .NET applications to the Azure cloud.

Strong understanding of object-oriented programming (OOP) and design principles.

Experienced in financial software development.

Proficient in T-SQL, SSRS, SSIS, reporting, analytics, RDBMS concepts, and data models.

Good knowledge of basic API authorization and authentication.

Strong analytical and programming skills.

Proven experience in working within timeboxed iterations.

Coordinate with the offshore development team, perform code and design reviews, and participate in daily standup meetings.

Expert in designing Enterprise reports using MS SQL Server Reporting Services (SSRS).

Created new SSIS Packages and fixed failing ones; deployed SSIS Packages to MS SQL Server and created Jobs to run these packages daily.

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

Maintain, modify, and improve existing applications

Technical Skills:

Front-End Technologies

Angular.js, Angular 2x and Higher, Angular 16, TypeScript, JavaScript, jQuery, Ajax, Bootstrap, Angular Material, React, React Native, CSS, Html, React.

Back-End Technologies

C#, ASP.Net Core web API, Asp.Net MVC, .Net Core 3.1, .Net 6, .Net 8, .Net Framework 4.5, Microservices, MVC, Web API, WCF, CQRS, Swagger, SSRS, SharePoint 2010, Powershell, Python.

Databases

Microsoft SQL Server, MySQL, Oracle, T-SQL, SSRS, SSIS, Stored Procedures, Functions, Views, Triggers, Indexing, Performance Tuning, Data Modeling.

Development Tools

Visual Studio 2022, VS Code, Postman, Swagger, GitHub Copilot Testing Tools & Framework: xUnit, NUnit, Mock

Cloud

Azure App Service, Azure Service Bus, Azure Functions, Azure APIM, Logic Apps, Azure Key Vault, Azure API, SQL, Azure Active Directory, Kubernetes, AWS

Version Control

Bitbucket (Git), GitHub, Gitlab, TFS

Agile Tools

JIRA, Azure DevOps, SAFe, GIT

Soft skills

Innovative, Problem-Solving, Mentoring, Agile Collaboration, Clean Coding Practices.

Employment History:

SR .NET Full Stack Developer June 2024 - Present

Nemours Children’s Health, Orlando, Florida

Responsibilities:

Involved in all phases of the Software Development Life Cycle (SDLC), including Analysis, Design, Development, Testing, Deployment, and Production Support, using Agile methodologies.

Developed secure and scalable healthcare applications using C# (7.3), .NET Core, ASP.NET Core, and Angular 16, improving system efficiency and user experience.

Designed and optimized MS SQL Server database schemas and T-SQL scripts to ensure accurate and reliable healthcare data management.

Implemented secure data handling practices in compliance with HIPAA regulations to protect sensitive patient information.

Developed modern web applications using Blazor, improving maintainability and enhancing user interaction.

Led the transition from AngularJS to Angular 16, modernizing the front-end and improving performance.

Integrated Autofac for dependency management, enhancing modularity and scalability of the applications.

Collaborated with integration teams to facilitate data exchange between Salesforce and external healthcare systems using Message Queuing and MuleSoft middleware.

Designed and implemented RESTful APIs returning JSON responses to support seamless client-server communication.

Automated ETL workflows for healthcare data integration using Azure Data Factory, ensuring accuracy and compliance.

Developed Python scripts for data analysis and machine learning models to extract insights from patient records and operational data.

Utilized Azure App Services for deployment and monitoring, ensuring high reliability and availability.

Enhanced team collaboration using Azure DevOps, streamlining development workflows and project management.

Developed automated test scripts to validate data integration processes, reducing manual testing efforts and improving efficiency.

Assisted in migrating legacy .NET Framework applications to .NET Core, improving performance and scalability.

Automated deployment pipelines using Infrastructure as Code (IaC) and Jenkins Pipeline as Code (JPaC).

Mapped JSON responses to C# models for structured data handling in .NET Core applications.

Implemented authentication mechanisms such as OAuth 2.0 and JWT, ensuring secure access to healthcare applications.

Used Git for source control, maintaining versioning and code integrity

.NET Full Stack Developer Jan 2024 – May 2024

Wells Fargo, San Francisco, CA

Responsibilities:

Involved in Software Development Life Cycle like Requirement Analysis, Design, Implementation and Testing.

Followed Agile methodology with daily scrum meetings and providing user story updates Worked with JIRA as an ALM tool for the central view for user stories and the bug tracking.

Rendered XML document to an HTML using XSL and XSLT Transformations Designed and developed application using

MVC5, Kendo, UI, and C #.

Worked in a team to produce a Service Oriented Architecture (SOA) in developing a product.

Participated in developing Single page application using ASP.NET 4.7 through Visual Studio 2019 for developing the project.

Developed ASP.NET Web API Controllers that involved in implementation of service layer components and data object layer components using ASP.NET MVC Web Application.

Used Angular HTTP Client to Interact with Servers/backend and modularized the Application with Ng Module.

Designed and developed new features for the application using C# within.NET framework.

Successfully developed web applications using C#.NET, MVC, Web API through IDE visual Studio 2019 and SQL Server Management Studio for retrieving backend data.

Created the backend database tables, views, functions and store procedures based on the application requirements.

Working on Azure for highly available customer facing B2B and B2C applications.

Involved in development of data access, business and application layer using LINQ, C#.NET and Asp.NET. Designed, developed and enhanced the application in.NET Core 3.0

Utilized Angular 13 inbuilt directives for implementation also implemented costumed directives for the ones that are not

available.

Designing the UI using HTML5, CSS3, Bootstrap 4.0 and Angular 9 and jQuery for client-side validations in few controllers.

Experience with process modelling using UML, Flow charts, and Use cases by using tools like MS Visio.

Creation of new complex SQL Stored Procedures, understanding of existing stored procedures and database model. Use the

Oracle 19C to create procedures, views, and SQL functions.

Enhanced application performance by Angular 13 Component based development in view of future Angular framework transitions.

Implemented MVC 5.0 (Model View Controller) pattern to have a clean separation of concerns and for easy testing of code using C#.

Designed and developed various abstract classes, interfaces, classes to construct the business logic using C#.NET.

Full Stack .Net Developer Sep 2021 - July 2022Think Bridge, India

Responsibilities:

Led client projects from initial requirements gathering through analysis, design, development, testing, and deployment, ensuring tailored solutions aligned with business objectives and industry best practices.

Engineered end-to-end applications using the latest .NET technologies, building scalable backend services and dynamic front-end applications with Angular 14.

Utilized Blazor Server and Web Assembly (WASM) to develop rich interactive web applications, selecting the optimal model based on project demands.

Conducted in-depth code reviews, offering constructive feedback and mentoring junior developers to enhance team efficiency and code quality.

Designed and developed highly responsive UI components using HTML5, CSS3, Bootstrap, and Angular Material, ensuring cross-platform and cross-browser compatibility.

Implemented modern .NET Core solutions to build cross-platform applications that run efficiently on Windows, Linux, and macOS.

Integrated Sync fusion UI libraries to enhance Blazor applications with advanced controls and improved interactivity.

Designed API-driven integration solutions to enable seamless communication between systems using modern middleware technologies.

Employed Newtonsoft.Json for parsing, serializing, and deserializing structured data within API responses.

Developed secure, high-performance REST APIs that facilitate efficient data exchange while adhering to industry standards and compliance guidelines.

Applied Python and Semantic Kernel to implement machine learning solutions, enabling predictive analytics for enhanced decision-making and automation.

Created ETL pipelines using Azure Data Factory, ensuring smooth ingestion and transformation of high-volume datasets into SQL Server.

Spearheaded the transition of legacy applications to cloud-based infrastructures, improving performance, scalability, and maintainability.

Validated and processed complex electronic lab reporting (ELR) data in HL7 format, ensuring seamless integration and transformation.

Leveraged AWS Lambda and Azure Functions to implement serverless computing, streamlining data processing and system interactions.

Deployed applications and managed cloud infrastructure using Azure and AWS for high availability and scalability.

Re-architected applications to improve performance, maintainability, and scalability, ensuring they met evolving business needs.

Optimized system performance by identifying bottlenecks and implementing strategic improvements to boost efficiency.

Integrated OpenAI’s GPT for automation and predictive analytics, enhancing business processes through AI-driven solutions.

Designed and maintained CI/CD pipelines using Azure DevOps, GitHub Actions, and Jenkins, utilizing YAML for automation and seamless deployments.

Built and deployed serverless applications on AWS Lambda and Azure Functions, efficiently handling scheduled and event-driven tasks.

Implemented automated data transformation workflows using DML operations, ensuring secure and optimized data processing.

Developed automation scripts and background tasks using PowerShell and Azure Automation, increasing operational reliability.

Designed and maintained ETL processes with Azure Data Factory and SSIS, ensuring secure and structured SFTP data transfers with error handling.

Managed and deployed applications in AWS Cloud and Azure Cloud, utilizing Docker for containerization and Kubernetes for orchestration.

Created data visualization and reporting dashboards using Power BI and SQL Server Reporting Services (SSRS), providing actionable insights for business decisions.

Full Stack .Net Developer Jan 2019 - Sep 2021

Deltek, India

Operated within an Agile development environment, accelerating application delivery while maintaining high-quality standards.

Participated in Sprint Planning, Daily Stand-ups, Design Discussions, Sprint Demos, and Retrospectives, ensuring smooth execution throughout the development lifecycle.

Engineered user-friendly, responsive web applications leveraging .NET Framework, AJAX, CSS, Bootstrap, HTML, jQuery, and JavaScript to enhance UI/UX.

Designed and implemented backend logic using Spring MVC, Spring Boot, and Spring Security, ensuring secure and scalable applications.

Leveraged Spring IoC (Inversion of Control) to inject dependencies efficiently, promoting modular and maintainable code.

Developed Razor Pages in an ASP.NET MVC-based web application, using C# for backend logic and SQL Server for data storage.

Created feature-rich Angular applications, optimizing performance with lazy loading and modular feature integration.

Maintained XML-based configuration files, standardizing settings and simplifying deployment processes.

Strengthened security by implementing authentication mechanisms and industry-standard best practices to safeguard REST APIs.

Designed and optimized SQL Server database objects, including Stored Procedures, Triggers, Tables, Views, and Joins for seamless data management.

Managed containerized applications with Azure Kubernetes Service (AKS), improving orchestration and scalability of microservices.

Developed WinForms-based desktop applications in C# for intuitive data visualization and robust reporting.

Leveraged Azure API Management to oversee the full API lifecycle, enhancing security, monitoring, and scalability.

Wrote optimized T-SQL queries and stored procedures to synchronize data across multiple systems efficiently.

Implemented Data Grids, Data Sets, Data Views, and Data Adapters to retrieve and manipulate backend data seamlessly.

Developed RESTful API services in .NET for user authentication and file transfer, ensuring secure data exchanges.

Created MySQL stored procedures and triggers, optimizing traffic flow between servers and clients.

Designed and executed unit tests to validate code quality, ensuring compliance with client coding standards.

Automated report generation, established trend alerts, and built monitoring dashboards to track system health and performance.

Delivered projects using Scrum-based Agile methodology, from initial requirement gathering to final deployment.

Utilized C#, XML, and Data Grids to dynamically fetch and display database information in UI components.

Applied HTML, AJAX, and CSS to update web content dynamically, streamlining front-end responsiveness.

Developed MVC3-based applications using ASPX View Engine, adhering to .NET framework design principles.

Engineered custom user controls in ASP.NET and AJAX, facilitating data input and display for web applications.

Built WinForms-based financial tools for automated transaction processing and data entry operations.

Spearheaded analysis, design, and development of new public site features, utilizing ASP.NET, JavaScript, XSL, XML, SQL, and C#.

Leveraged AngularJS to develop modular, reusable components, improving efficiency in data binding and routing.

Designed database constraints and triggers to uphold data integrity and prevent anomalies.

Integrated jQuery AJAX with server-side APIs, enabling real-time data updates without requiring full-page refreshes.

Built and optimized complex SQL Server objects, including stored procedures, functions, views, triggers, cursors, indexes, and packages.

Designed comprehensive test cases, scripts, and testing scenarios for unit testing and integration testing, ensuring application reliability.

Education

Masters in Computer Science Aug 2022 - May 2024

University of Central Missouri, Warrensburg, MO, USA

Relevant Coursework: Cloud Computing, AWS, .NET Advanced, Web Application Development, Machine Learning, Artificial Intelligence

Bachelors in Computer science and Engineering.

Lendi Institute of Engineering and Technology, Vizianagaram, India.

Contact this candidate