Sql Server Stack Developer

Hari Krishna Kosana Senior .Net Full Stack Developer Email: ****.*********@*****.*** Contact: 616-***-****

LinkedIn: linkedin.com/in/hari-krishna-kosana

Professional Summary:

Over a decade of IT experience with involvement in all phases of Software Development Life Cycle (SDLC) such as planning, analysis, design, implementation, testing, and maintenance across various domains like Healthcare, Airlines, and Banking.

Proficient in C# and .NET development, with extensive experience in building robust, scalable, and maintainable applications, leveraging advanced Object-Oriented Programming (OOP) principles and design patterns.

Hands-on experience in .NET Frameworks, including ASP.NET, WEB API, Microservices, ADO.NET, Entity Framework, WinForms, WebForms, Web Services, LINQ, and IIS.

Designed and developed interactive customer-facing applications using Angular and React, implementing JavaScript, HTML, Bootstrap, and CSS for dynamic UI components.

Strong expertise in database development, including Stored Procedures, Joins, Triggers, Views, and Cursors, with working experience in RDBMS like SQL Server (MS SQL).

Expertise in SQL databases (MySQL, PostgreSQL) for structured data management. Skilled in NoSQL solutions like Azure Cosmos DB for globally distributed, multi-model database needs. Experienced with MongoDB for scalable, schema-flexible document storage.

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

Strong experience in Azure Development, including Azure Web Applications, 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 and data management.

Extensive experience in Microservices architecture and AWS Cloud Services, working with EC2, RDS, DynamoDB, S3, CloudWatch, and Docker. Responsible for maintaining and expanding AWS S3 infrastructure, utilizing SNS (Simple Notification Service) and SQS (Simple Queue Service).

Involved in debugging, application support, and performed unit testing using NUnit, MSUnit, XUnit, and testing tools like POSTMAN, Jasmine, and Karma.

Technical Skills:

Category

Skills

.NET Technologies

ASP.NET, .NET Core, MVC, Web API, Microservices, ADO.NET, LINQ, Entity Framework, .NET MAUI

Languages

C#, VB.NET, Python, PowerShell, T-SQL, PL/SQL, Java

Web Technologies

HTML5, CSS3, JavaScript, TypeScript, XML, JSON, SOAP, REST, Angular (2-16), React (16-18), Bootstrap, Kendo UI

Databases

SQL Server, PostgreSQL, MongoDB, Cosmos DB

Cloud Platforms

Microsoft Azure, AWS, GCP

CI/CD Tools

Azure DevOps, AWS Code Pipeline

API Testing Tools

Postman, Swagger, Protractor, NUnit, Selenium, JMeter

Professional Experience:

Mayo Clinic, Minneapolis, Minnesota Jan 2024 - Present

Senior .NET Full Stack Developer

Responsibilities:

Employed Agile SDLC methodologies for adaptive project management, ensuring flexibility and responsiveness to changing requirements.

Designed and developed scalable, resilient microservices architecture using .NET Core and Docker, enabling seamless interoperability and high availability for a healthcare client’s enterprise applications.

Developed dynamic user interfaces with Angular 16, HTML5, CSS3, and Bootstrap, delivering responsive, user-friendly experiences for healthcare professionals.

Enhanced frontend development by creating reusable Angular components, maintaining consistency across modules.

Implemented state management in Angular applications using NgRx, streamlining data flow, improving performance, and ensuring consistency across components, enhancing the user experience for a large-scale healthcare client.

Developed HIPAA-compliant web applications and APIs using .NET Core 8.0 and ASP.NET Core MVC to streamline healthcare workflows.

Built secure RESTful services with C# and ASP.NET Core Web API, ensuring FHIR compliance and seamless healthcare system integration.

Optimized performance and scalability using dependency injection, middleware, and asynchronous programming in .NET Core.

Implemented gRPC services in healthcare applications for high-performance, real-time communication between distributed systems, enabling efficient data exchange and reduced latency.

Optimized data access in healthcare applications using Entity Framework Core 8.0, improving performance and ensuring seamless interaction with patient records.

Optimized database performance using Dapper ORM and Entity Framework Core, enhancing data retrieval speed and reducing query execution time for critical healthcare applications.

Designed and optimized relational databases using SQL Server, implementing indexing, partitioning, and complex queries to improve performance and ensure efficient data management in healthcare applications.

Integrated NoSQL database like MongoDB to handle unstructured healthcare data, enabling scalable storage, real-time analytics, and efficient caching for high-performance applications.

Developed optimized T-SQL stored procedures, views, and triggers to enhance data integrity, streamline healthcare data processing, and improve database performance.

Implemented authentication and authorization mechanisms using ASP.NET Identity, OAuth 2.0, and OpenID Connect, securing sensitive healthcare data and ensuring role-based access.

Developed Python scripts to automate healthcare data processing, ETL workflows, and system monitoring, improving efficiency and reducing manual effort.

Implemented Azure Health Data Services (AHDS) to support scalable and secure healthcare data management, integrating FHIR APIs for seamless patient data exchange and compliance with industry regulations.

Developed and optimized FHIR-based APIs to standardize HL7 data exchange, ensuring interoperability between healthcare applications and enabling efficient data transformation and retrieval.

Utilized Azure Service Bus for reliable messaging and event-driven architecture in healthcare applications, improving scalability and asynchronous processing.

Implemented Azure API Management to securely expose and manage healthcare APIs, ensuring seamless integration between systems and optimizing performance.

Deployed and optimized healthcare applications using Azure App Services and Azure Functions, enabling scalable, serverless execution for real-time processing and automation.

Automated CI/CD pipelines using Azure DevOps, streamlining the deployment and testing of microservices and APIs.

Secured application secrets and configurations using Azure Key Vault, ensuring compliance with security best practices.

Developed containerized services using Docker and deployed them to Azure Kubernetes Services (AKS) for scalable operations.

Designed Power BI dashboards to visualize healthcare metrics and provide actionable insights.

Developed WPF applications for administrative tools and UI, delivering rich desktop experience for healthcare professionals.

Conducted integration testing using xUnit, NUnit, and Selenium to maintain high-quality software standards.

Conducted API testing with Postman and documented APIs with Swagger for seamless developer collaboration.

Utilized Git, GitHub, and Azure Repos for version control and collaborative development, integrating Azure Application Insights to monitor and optimize healthcare application performance.

Environment: Angular 16, .NET Core 8.0, C#, Entity Framework Core 8.0, and SQL/NoSQL databases, RESTful APIs, HIPPA, HL7, FHIR, Azure DevOps, Docker, and test automation with Selenium and NUnit.

Delta Airlines, Atlanta, GA Aug 2021 – Dec 2023

Senior .NET developer

Responsibilities:

Developed a scalable airline application using Agile SDLC, implementing Microservices Architecture with .NET Core and Azure, enhancing performance, scalability, and system resilience.

Built responsive user interfaces using Angular 12, Bootstrap, and TypeScript, enhancing user experience across devices.

Developed reusable and modular Angular components using Angular CLI, enabling structured and maintainable UI architecture while improving development speed and code reusability.

Configured and optimized Nginx as a reverse proxy and load balancer for .NET Core and Angular applications, enhancing performance, security, and scalability of web services.

Developed core functionalities in C# and .NET Core 6.0 for implementing flight search, booking, and user authentication within the application.

Designed and developed RESTful .NET Web APIs using ASP.NET Core, enabling secure and efficient flight booking, payment processing, and real-time status updates.

Implemented scalable backend architecture with ASP.NET and .NET Web APIs, integrating with SQL Server and Azure Services to enhance data management, performance, and reliability in airline operations.

Implemented Apache Kafka for real-time data streaming and event-driven communication in the airline application, enabling seamless processing of flight updates, booking events, and payment transactions, ensuring high availability and scalability.

Implemented authentication and authorization mechanisms with JWT Tokens and OAuth 2.0 for secure API access.

Integrated external payment APIs such as Stripe and PayPal using Python Frameworks like Flask and Django for secure and seamless online transactions.

Adopted GraphQL for efficient and flexible data querying and SignalR for real-time communication and updates within the application.

Enhanced system performance with Redis, caching frequently accessed data and optimizing database connections.

Developed and maintained complex SQL Server databases, optimizing queries and designing indexes for faster processing.

Implemented SQL Server for secure management of structured data and utilized Entity Framework Core for efficient Object-Relational Mapping (ORM) in the application.

Implemented Dapper ORM for high-performance data access, optimizing query execution and reducing latency in flight booking and real-time status update services.

Implemented SQL Server Integration Services (SSIS) for data migration and synchronization, alongside SQL Server Reporting Services (SSRS) for operational and analytical reporting in the application.

Monitored application performance and health using Azure Monitor and Application Insights.

Configured cloud services using Azure App Services, implementing Azure Functions and Azure Blob Storage for scalability.

Integrated Azure Key Vault for secure management of application secrets and Azure Function Apps for serverless execution of event-driven tasks like flight notifications and payment processing, enhancing security, scalability, and efficiency in the airline application.

Automated CI/CD pipelines using Azure DevOps, integrating unit and API tests for streamlined deployments.

Conducted frontend testing using Jasmine and Karma for Angular components, backend testing with xUnit for .NET Core services, and API testing using Postman and Swagger, ensuring application reliability, performance, and seamless integration.

Utilized Git branching strategies for version control and collaborative development across distributed teams.

Environment: Bootstrap, SQL Server, MongoDB, SSIS, SSRS, Python, Stripe, PayPal, OAuth2.0, REST APIs, HTTPS, SSL, TLS, Azure (Key Vault, Function Apps, DevOps), Docker, Kubernetes, Apache Kafka.

State of PA, Pennsylvania Mar 2019 – July 2021

. Dot Net Developer

Responsibilities:

Spearheaded backend service development using Microservices Architecture within an Agile SDLC environment, incorporating Sprint Planning, Daily Stand-ups, and Retrospectives for seamless collaboration.

Designed and implemented dynamic frontend interfaces leveraging React 16, Redux, Zustand, HTML5, CSS3, and Bootstrap, ensuring a responsive and user-friendly experience.

Developed and maintained stateful applications using React Hooks and Redux, optimizing application performance and maintainability.

Engineered reusable React components and leveraged Axios for seamless API communication, enhancing frontend efficiency and maintainability.

Led the migration of legacy VB.NET applications to .NET Core, modernizing system architecture for improved scalability and maintainability.

Built scalable enterprise web applications using C#, .NET Core, and MVC, improving system performance and code modularity.

Designed and implemented secure .NET Core Web API and REST-based services, ensuring reliable and secure data exchange between distributed systems.

Standardized data exchange using XML, ensuring interoperability and structured communication across services.

Integrated OAuth 2.0 and JWT authentication, strengthening security measures for user access control and authorization workflows.

Developed SSIS ETL workflows to aggregate and transform data from multiple sources for reporting and analytics.

Conducted automated end-to-end testing using Selenium, ensuring functional accuracy and UI consistency.

Designed and optimized SQL Server databases, writing efficient stored procedures, triggers, and indexes for enhanced query performance.

Developed and optimized PL/SQL scripts for high-performance transaction management and enterprise data processing.

Designed and deployed SSRS reports, providing actionable insights and analytics for state-wide applications.

Utilized Entity Framework to enhance data access efficiency, improving overall database operations and application performance.

Implemented AWS CloudWatch monitoring to track system health, optimize performance, and improve troubleshooting efficiency.

Optimized serverless applications using AWS Lambda, ensuring cost-effective and scalable execution of event-driven processes.

Managed secure application secrets and configurations using AWS Secrets Manager, enhancing system security and compliance.

Automated CI/CD pipelines using AWS CodePipeline, incorporating unit and integration tests for deployment reliability.

Implemented AWS S3 for secure and scalable storage of unstructured data, optimizing file access and management.

Integrated AWS Step Functions to orchestrate workflow automation, streamlining business processes.

Deployed AWS CodeBuild and CodeDeploy for efficient build automation and release management, improving development velocity.

Conducted performance optimization for AWS-hosted applications using AWS ALB (Application Load Balancer) and AWS API Gateway, improving traffic management and security.

Performed React testing using Jest and React Testing Library, ensuring component reliability and consistent UI behavior.

Conducted backend testing using xUnit and NUnit, validating API reliability, database integrity, and system functionality.

Executed API testing using Postman and documented API contracts using Swagger, improving API usability and clarity.

Managed Git-based version control, configuring Git workflows, incorporating feature branching, pull requests, and code reviews to ensure streamlined development and collaboration.

Environment: C#, .NET Core, SQL Server, PL/SQL, SSRS, ADO.NET, XML, Cosmos DB, AWS CloudWatch, AWS Lambda, AWS Secrets Manager, AWS CodePipeline, AWS S3, AWS Step Functions, AWS ALB, AWS API Gateway, AWS CodeBuild, AWS CodeDeploy, Git, GitHub.

Wells Fargo, San Francisco, CA Nov 2017– Feb 2019

.Net Developer

Responsibilities:

Developed dynamic user interfaces for online banking platforms using Angular 5, implementing real-time data binding, secure authentication flows, and robust client-side validation for enhanced security and usability.

Built responsive and interactive UI components using HTML5, CSS3, JavaScript, jQuery, and AJAX, ensuring a seamless and engaging customer experience.

Developed robust and scalable backend services using C#, implementing Object-Oriented Programming (OOP) principles, Asynchronous Programming (async/await), and LINQ to enhance performance and maintainability in banking applications.

Designed and developed secure and scalable banking applications using .NET and MVC, prioritizing maintainability and high-performance standards.

Developed and secured SOAP APIs using .NET Core Web API and SOAP Services, ensuring seamless and encrypted communication between banking systems.

Optimized database operations using ADO.NET, enhancing data access performance across SQL Server and Cosmos DB, ensuring efficient structured and unstructured data management.

Managed SQL Server relational data and implemented NoSQL solutions with Cosmos DB, optimizing financial transaction storage, schema-flexible data models, and high-availability performance.

Designed ETL workflows using SSIS, enabling secure migration and transformation of banking data from legacy systems to cloud-based architectures.

Designed and managed scalable data models in Cosmos DB, executing efficient migrations while leveraging schema-flexible JSON document storage for transactional banking data.

Developed serverless banking solutions using Azure Functions, optimizing real-time event-driven processing for financial transactions, fraud detection, and automated alerts.

Secured Azure Functions using Azure Key Vault, enforcing Role-Based Access Control (RBAC) and Managed Identities to protect sensitive banking credentials and transactions.

Configured Azure Blob Storage for secure document storage, enabling encrypted access to financial statements and customer documents.

Implemented front-end testing using Jest and React Testing Library, ensuring UI stability, proper component rendering, and accessibility compliance.

Optimized backend testing using xUnit and NUnit, ensuring secure API endpoints, reliable transaction processing, and robust system performance.

Conducted API testing using Postman and Swagger, verifying authentication mechanisms, secure data transmission, and seamless integration with third-party banking services.

Strengthened version control by implementing Git best practices, leading team training on branching strategies, pull request reviews, and conflict resolution, ensuring seamless development collaboration.

Environment: .NET Core, C#, MVC, SQL Server, Cosmos DB, Angular, HTML5, CSS3, JavaScript, jQuery, Ajax, ADO.NET, Azure Functions, Azure Key Vault, Azure Blob Storage, SSIS, OAuth 2.0, JWT, Jest, xUnit, NUnit, Postman, Swagger, Git, HIPAA, GDPR Compliance.

Vodafone, Mumbai, India Oct 2015 – Aug 2017

.Net Developer

Responsibilities:

Implemented Agile methodology with MVC Architecture, ensuring iterative development, seamless collaboration, and efficient management of telecom business logic.

Built dynamic and responsive user interfaces using Angular, HTML, CSS, JavaScript, jQuery, and Kendo UI, ensuring an intuitive and seamless customer experience for telecom service management.

Designed and developed telecom web applications using C#, .NET, and MVC, ensuring high scalability, availability, and performance.

Developed RESTful Web Services for telecom APIs, facilitating secure and efficient communication between billing, provisioning, and CRM systems.

Utilized ADO.NET and SQL Server for efficient database operations, optimizing Stored Procedures, Triggers, and Indexes for real-time call data processing and telecom billing.

Managed Azure SQL Database for high-volume telecom data processing, ensuring low-latency, high-availability database transactions.

Deployed Azure Functions for event-driven automation, handling real-time call monitoring, fraud detection, and automated service provisioning.

Integrated Azure Service Bus for asynchronous messaging, enabling smooth communication between billing, CRM, and network provisioning systems.

Secured telecom applications using Azure Key Vault, managing API keys, encryption keys, and credentials securely.

Implemented Azure Blob Storage for storing large volumes of call recordings, invoices, and network logs securely.

Optimized backend services with Microservices Architecture, improving the scalability of telecom billing and subscription management systems.

Developed CI/CD pipelines using Azure DevOps, ensuring fast, automated deployments of telecom applications while maintaining high service reliability.

Conducted API testing using Postman and Swagger, ensuring seamless third-party integrations with payment gateways, telecom networks, and CRM solutions.

Performed backend testing using xUnit and NUnit, validating telecom billing calculations, API responses, and database consistency.

Implemented Git workflows using Azure DevOps, streamlining telecom development cycles with feature branching, pull requests, and version control best practices.

Environment: C#, .NET, MVC, HTML, CSS, JavaScript, jQuery, Kendo UI, SQL Server, ADO.NET, REST APIs, Azure SQL Database, Azure Blob Storage, Azure Service Bus, Azure Functions, Azure Key Vault, Azure DevOps, Postman, Swagger, Git.

Education Details: Bachelor of Technology in Computer Science – JNTU Kakinada

Contact this candidate