.Net Developer Sql Server

Senior .Net Developer

Name: Alekhya Dasari

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

Contact: +1-657-***-****

LinkedIn: https://www.linkedin.com/in/alekhya-dasari-7aa9bb1a5

Summary

Having 11+ years of IT experience working in all phases of Software Development Life Cycle (SDLC) such as Requirement gathering, Analysis, Design, Development, Testing and Deploying of applications including Agile and Waterfall methodology.

Hands-on experience in domains like Finance and Healthcare.

Have a solid background in Object-Oriented Programming/Analysis/Design and Development.

Experience working with front and back-end languages & technologies including the latest .NET 8 framework.

Skilled in architectural patterns, including Microservices, MVC, N-Tier, and Onion, for scalable and maintainable solutions.

Developed Single Page Applications using JavaScript framework angular, jQuery, Blazor and Bootstrap CSS.

Extensive Experience of LINQ and ORM technologies like Entity Framework, ADO.NET, Database First, Code First and performance tuning in Entity Framework.

Experienced in integrating Entity Framework with .Net Core Web API with UI technologies Angular and React JS.

Expert in developing web applications, services in Microsoft Visual Studio .Net IDE using Classic ASP.NET, ASP.NET MVC, ASP.NET Core, C#, VB.NET, ADO.NET, Entity Framework, LINQ, MVC, WCF and SQL Server.

Worked on different object-oriented programming techniques, Microsoft design patterns like Microsoft View Controller, Service Oriented Architecture (SOA), WCF and Data Transfer Objects (DTO).

Substantial experience in various .NET applications using Angular, Node Js, React JS, VB.net, Asp.net, Telerik Controls, Silverlight, AJAX, XML, Typescript and Java Script.

Familiar with Node.js for backend development, and adept in both RESTful and SOAP web services.

Developed RESTful services/ HTTP services using ASP.NET Web API Framework.

Knowledgeable in implementing security standards like OAuth2, SSL, and JWT for robust authentication and authorization.

Experienced in managing both SQL databases (SQL Server, PostgreSQL) and NoSQL databases (MongoDB), alongside PL/SQL stored procedures, functions, and triggers.

Proficient in Analysis, Design and implementation of databases using SQL server databases, Oracle, MS-Access and writing stored procedures, having firm understanding of relational database system with strong T-SQL experience.

Efficiently used Data Readers and Datasets in ADO.NET to retrieve, display edit and update the database.

Worked on creating reports using SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS). Have created various SQL server jobs using SQL Server Agent that process various T-SQL statements.

Developed Power BI reports for executive-level decision-making, including financial forecasts, fraud detection, claims processing, patient care analysis, and operational reporting.

Hands-on experience with message queues such as MSMQ and RabbitMQ.

Implemented .NET security features such as Authentication & Authorization, Windows-based Authentication, Forms-based Authentication, Authorizing Users and Roles.

Extensive Knowledge on Microsoft .NET Design Patterns including Dependency Injection (DI), Inversion of Control (IOC), Singleton, MVVM and MVC.

Proficient with front-end testing tools like Karma, Jasmine as well as web services automation with Cucumber and Citrus.

Knowledgeable in testing tools including Postman, SOAP UI, and Swagger UI.

Skilled in Azure DevOps for CI/CD pipelines, alongside cloud platforms like AWS and Azure from a developer’s perspective.

Experience in building infrastructure on AWS Cloud using CloudFormation, EC2, Virtual Private Cloud (VPC), Elastic Load Balancing, Auto Scaling, Route 53 DNS, RDS, S3, Docker and other Services.

Hands on experience Azure Data Factory, Databricks, Azure Monitoring, Key Vault, Azure Data Lake and Data storage.

Good experience on DevOps essential tools like Docker, Kubernetes, GIT, Jenkins.

Good exposure in using Source controls like Team Foundation Server (TFS) and GIT.

Ability to handle multiple tasks and work independently as well as in a team.

IT Skills:

Languages

C#, C, Python, T-SQL, PL/SQL, VB.NET, CRUD queries

.NET Technologies

.Net core, .Net Framework, ADO.NET, ASP.NET, MVC 4/5, Web API, Razor C#, AJAX, LINQ, WCF, WPF, Web Services, Blazor, Entity Frameworks, Web forms, Windows Services

Database

SQL Server, Mongo DB, AZURE SQL, Azure, Blob Storage, Cosmos DB

Web Technologies

HTML5, CSS3, XML, XSLT, JavaScript, AJAX, jQuery, JSON, React.js, Vue.js React Native, Angular, Node.js, GitHub, Azure, jQuery, Bootstrap, TypeScript.

Cloud Technologies

Azure (Azure app services, Azure Blob Storage, AKS, AKV), AWS (S3, EC2, Lambda).

IDE / Utilities

Visual Studio .NET, Visual Web Developer Express, Visual Code, Postman, Notepad++

Reporting tools

Power BI, SSIS, SSRS.

Servers

Internet Information Server, Apache Tomcat, HTTP Web Server.

Testing Frameworks

N-unit, X-Unit, MS test.

Source Control Tools

Team Foundation Server, Git, Bit Bucket, SVN.

Work Experience:

Client: Molina Healthcare Inc – Long Beach, CA Mar 2023 – till date

Title: Senior .Net Developer

Responsibilities:

Collaborated with cross-functional teams of business analysts, UI/UX designers, QA engineers, and cloud architects using Agile (Scrum) methodology.

Participated in daily stand-ups, sprint planning, and retrospectives, ensuring timely delivery of project milestones.

Built RESTful APIs using ASP.NET Core Web API to facilitate data interactions for medical consultations, patient records, and appointment management.

Implemented Microservices architecture using C# to ensure modular, scalable services, enhancing the maintainability of the system.

Integrated Entity Framework Core for ORM, ensuring efficient data storage and access for patient records, consultations, and medical histories.

Developed JWT-based authentication and role-based authorization for securing access to sensitive healthcare data and ensuring compliance with HIPAA regulations using C#.

Designed and developed self-contained microservices in C# responsible for different modules, such as patient management and billing, enabling scalability and flexibility.

Applied API Gateway design patterns for routing requests to microservices and implemented Service Discovery to enable dynamic load balancing.

Built responsive, user-friendly UI using Angular, TypeScript, HTML5, and CSS3, with Bootstrap for layout and grid management, ensuring a seamless user experience across devices.

Enhanced the user interface with Angular Material components, such as date pickers, data tables, cards, and modals, to provide a modern, responsive design consistent with healthcare industry standards.

Used JavaScript for custom client-side logic and to handle asynchronous operations like data fetching, real-time updates, and UI interactions.

Utilized SignalR for secure, real-time communication between healthcare providers and patients, enhancing user engagement during virtual consultations.

Designed stored procedures and optimized T-SQL queries for data processing, providing secure and efficient data access for high-traffic telehealth sessions.

Designed and implemented a message queue-based architecture using RabbitMQ enabling asynchronous, decoupled communication between services in a microservices environment.

Developed SQL Server Integration Services (SSIS) packages for data migration and ETL (Extract, Transform, Load) tasks from legacy systems to the new database.

Created parameterized and drill-down reports using SQL Server Reporting Services (SSRS) to deliver in-depth analytics on virtual consultation metrics, patient usage statistics, and healthcare provider performance.

Developed interactive Power BI dashboards to track key healthcare metrics like patient outcomes, care utilization, and cost-efficiency, enabling leadership to make data-driven decisions

Creating Docker containers and Docker consoles for managing the application life cycle.

Managed Kubernetes deployments, objects for high availability and scalability using horizontal pod scaler.

Deployed the entire application on Azure App Services, ensuring high availability, scalability, and reliable performance.

Managed Azure Key Vault for secure storage of sensitive information like API keys, database credentials, and encryption secrets.

Designed and deployed data integration workflows using Azure Data Factory to automate data movement from various healthcare systems into a unified data repository, enhancing data accessibility for analytics and reporting.

Implemented Azure Cosmos DB for handling patient records, medical histories, and transactional data with high availability and compliance.

Utilized xUnit as a primary testing framework for .NET, implementing unit tests for individual components, business logic, and data validation, ensuring modularity and reliability.

Designed and implemented CI/CD pipelines using Azure DevOps, automating the deployment process and ensuring consistent build and release cycles.

Managed source code using Git and GitHub, following feature branching and pull requests for version control and collaboration.

Environment: Agile (Scrum), RESTful APIs, ASP.NET Core, C#, Microservices, Entity Framework Core, Azure SQL,, API Gateway, Angular, TypeScript, HTML5, CSS3, Bootstrap, JavaScript, SQL Server, Cosmos DB, RabbitMQ, Azure Service Bus, SQL Server Integration Services (SSIS), ETL, SQL Server Reporting Services (SSRS), Azure App Services, Azure DevOps, Azure Monitoring, EHR, FHIR-based APIs, EPIC API, ASP.NET Core Identity, Git, GitHub.

Client: Capital One - McLean, Virginia May 2021 – Feb 2023

Title: Senior .Net Developer

Responsibilities:

Applied Agile SDLC methodologies to effectively manage project timelines and deliverables, facilitating continuous feedback and iterative improvements throughout the development lifecycle.

Implemented the application using Onion Architecture, promoting separation of concerns and enhancing the maintainability and testability of the codebase.

Developed robust backend services using ASP.NET Core Web API, ensuring high performance and security for the digital account opening processes.

Designed and implemented RESTful web services for seamless integration between frontend and backend, ensuring efficient data exchange and functionality.

Leveraged Entity Framework Core as the ORM framework to simplify database operations and manage SQL Server for data persistence and retrieval.

Developed the frontend using Angular, combined with HTML, CSS, and Bootstrap to create a responsive and user-friendly interface.

Integrated Blazor components within the Angular application for .NET-specific functionalities, enabling reuse of .NET libraries and services directly in the frontend.

Utilized JSON as the data format for API communication, ensuring lightweight data exchange between client and server.

Implemented stored procedures, functions, and triggers in SQL Server to encapsulate business logic and optimize database performance.

Deployed the application using Azure Cloud, specifically utilizing API Gateway for managing and routing API calls efficiently.

Implemented secure user authentication and authorization mechanisms using OAuth2, ensuring compliance with financial security standards.

Integrated Apache Kafka for real-time data streaming and event-driven architecture, facilitating asynchronous communication between microservices and enhancing system responsiveness and scalability.

Integrated GraphQL with the existing ASP.NET Core back end, enabling seamless data fetching and mutation while maintaining the security and efficiency standards required for financial services.

Conducted unit testing using xUnit to ensure the reliability and correctness of the backend services.

Utilized Karma and Jasmine for frontend testing of the Angular components, ensuring a robust user interface and seamless user experience.

Employed tools such as Swagger UI for API testing and documentation, enhancing collaboration and understanding among development teams.

Designed and managed API Gateway in Azure API Management to handle API traffic securely and efficiently, enabling seamless integration with external banking systems and partner services.

Utilized Azure Functions for serverless processing of tasks such as customer notifications, document verification, and account setup, optimizing cost and performance with scalable background processing.

Implemented Azure Key Vault to securely store sensitive data, including API keys, database connection strings, and encryption secrets, maintaining compliance with financial security standards.

Implemented CI/CD pipelines using Azure DevOps, automating the build, testing, and deployment processes, which improved deployment frequency and reduced time to market.

Integrated SonarQube for code quality analysis and continuous inspection, enhancing code reliability and maintainability.

Managed source code and version control using Git, following best practices for branching, merging, and pull requests to maintain a clean and organized codebase.

Leveraged Visual Studio and SQL Server Management Studio for development and database management, ensuring an efficient development environment.

Utilized Log4Net for application logging, facilitating monitoring and troubleshooting of production issues.

Participated in project management using JIRA, effectively tracking progress, managing tasks, and collaborating with cross-functional teams.

Environment: Agile SDLC methodologies, Onion Architecture, ASP.NET Core Web API, RESTful web services, Entity Framework Core, SQL Server, JSON, Azure Cloud, Azure API Gateway, OAuth2, Angular, Blazor, HTML, CSS, Bootstrap, Apache Kafka, xUnit, Karma, Jasmine, Postman, Swagger UI, GraphQL,Azure API Management, Azure Functions, Azure Key Vault, Azure DevOps CI/CD, Git, Visual Studio, SQL Server Management Studio, Log4Net, JIRA

Client: State of CA - SFO, CA Oct 2019 – Apr 2021

Title: Senior .Net Developer

Responsibilities:

Worked on Agile Methodology to achieve smooth collaboration between self-organizing, cross functional teams.

Architected and implemented Microservices Architecture for scalable and modular application design, allowing independent deployment, maintenance, and optimization of critical features in the Emergency Response platform.

Developed backend microservices using ASP.NET Core and RESTful APIs to handle business logic and ensure high performance and security for data processing and response coordination.

Developer software code using C# programming language to meet the design specifications and user requirements as well as delivered high-quality applications within specified deadlines.

Utilized Dapper as the ORM framework for seamless data access and manipulation.

Integrated MongoDB to handle unstructured data, providing flexible schema design and enabling efficient storage and retrieval of large volumes of diverse data types in the application.

Employed XML as the primary data format for API communication, ensuring lightweight and efficient data interchange between client and server.

Used Repository and Factory design pattern to develop reusable domain.

Integrated Apache Kafka as a message queue to facilitate real-time data streaming and asynchronous communication between microservices, enhancing system responsiveness and scalability.

Designed and developed UI using jQuery and Razor view.

Built a responsive frontend using React JS, alongside HTML, CSS, and JavaScript, to create an intuitive user interface for real-time monitoring and resource management.

Leveraged AWS Cloud Services for efficient deployment, management, and scaling of applications, ensuring high availability, reliability, and compliance with government standards.

Used AWS CodePipeline for continuous integration and deployment (CI/CD), automating build, test, and deployment workflows to improve release speed and maintain code quality.

Utilized Amazon S3 for secure and durable storage of critical data and documents, incorporating lifecycle policies for efficient data management and cost control.

Utilized API testing tools like Postman for testing and documenting APIs, enhancing collaboration among development teams.

Conducted thorough testing using xUnit for backend services to ensure functionality and reliability, contributing to a robust application.

Utilized Visual Studio, Visual Studio Code for development, debugging, and database management, ensuring an efficient development workflow.

Implemented application logging with Log4Net, enabling effective monitoring and troubleshooting of application performance and issues.

Managed source code and version control using TFS, maintaining a clean and organized codebase through effective branching and merging strategies.

Documented entire project from machine setup and coding standards to test environments and system architecture.

Environment: Agile Methodology, Microservices Architecture, ASP.NET Core, RESTful APIs, Entity Framework, Dapper, PostgreSQL, JSON, XML, Apache Kafka, Repository, Factory, Angular, React.js, Razor, jQuery, HTML, CSS, JavaScript, Blazor, Razor, xUnit, AWS, Amazon S3, MongoDB, Visual Studio, Visual Studio Code, SQL Server Management Studio, Log4Net, Postman, Git, TFS.

Client: Ford - Dearborn, Michigan Jan 2017 – Sep 2019

Title: .Net Developer

Responsibilities:

Worked on Agile methodology and involved in meetings/discussions with the team on a regular basis as part of the requirements gathering.

Designed and implemented applications using MVC architecture, promoting a clear separation of concerns between the Model, View, and Controller layers, which enhanced maintainability, testability, and scalability of the web application.

Implemented CRUD functionality with Entity framework in ASP.NET MVC, enhancing data management and accessibility for users.

Created and used User controls in developing the front-end application and multi-thread windows applications using VB.Net.

Performance Optimization: Optimizing jQuery code and leveraging best practices to enhance the performance and responsiveness of web applications.

Implemented client-side Interface using React JS. Build stable React components and stand-alone functions to be added to any future pages. Used React-Router to turn application into Single Page Application.

Extensive usage of Delegates and Events to establish communication between the WinForms.

Wrote standard complex T-SQL Queries to perform data validation and graph validation to make sure test results matched back to expected results based on business requirements.

Implemented AJAX controls for partial page updates and to decrease the response time on the pages.

Worked on .NET security features such as Form-Based Authentication and Role-Based Authorization.

Implemented JWT Security to provide authentication and authorization to secure the Web API.

Designed database in SQL Server and created stored procedures, functions, views to reduce the complication of front-end SQL queries and triggers to enforce entity relationships.

Extensively involved in developing components for Business Logic and Data tier using C#, ASP.NET MVC, and ADO.NET.

Integration with ASP.NET Controls: Integrating jQuery functionalities with ASP.NET server controls, such as Grid View, Data List, or Repeater, to enhance the user experience and provide dynamic interactions.

Environment: NET, WinForms, C#.NET, Net. SQL Server, SQL, ADO.NET, LINQ, WCF, XML, HTML5, JavaScript, SOAP, Ionic and React JS, Bootstrap, Blazor, IIS, Visual Studio, JWT, T-SQL, Azure DevOps as repository, Microsoft Teams

Client: Evoke Technologies - Hyderabad, India Feb 2013 – Oct 2016

Title: Software Engineer

Responsibilities:

Involved in the complete Software Development Life Cycle (SDLC) including Analysis, Design, Implementation, Testing and Maintenance with Agile Methodology.

Involved in Migrating the MVVM Architecture design to MVC Architecture by implementing the containerizing.

Provided Windows based and Form Based Security for Login and Authentication.

Implemented various User Controls and Custom Controls in front-end forms.

ADO.NET was used to access data from SQL Server.

Wrote SQL queries with Joins on multiple tables, Stored Procedures, Functions, Triggers, Backup and Restore Database, define roles. Create database Involved in designing database, SQL queries optimization and performance.

Involved in enhancing the application user interface, modifying the database columns using the entity framework.

Used TFS (Team Foundation Server) for source Version Control.

Involved in unit testing with N-Unit, preparing System Test Cases, Documentation, Debugging, and bug fixing.

Environment: ASP.NET, C#, Visual Studio, MVC, HTML5, CSS3, C#.Net, VB.NET, SQL Server

Education Details

B.Tech in CS – Vignan University, 2013

Contact this candidate