.Net Developer Sql Server

Name: Hari Reddy

Role: Senior .Net Developer

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

Mobile: +1 (678) - 908 – 9192

LinkedIn: https://www.linkedin.com/in/haritrinadh1/

Professional Summary:

• Having 10 years of experience as a .NET Developer, specializing in web-based and client-server applications using C#, ASP.NET, ADO.NET, and SQL Server.

• Strong expertise in both front-end and back-end development, with experience in building Single Page Applications (SPAs) using Angular, React.js, and Redux.

• Skilled in developing reusable and responsive UI components, ensuring cross-browser compatibility and smooth user experiences.

• Experience in modernizing legacy systems by upgrading applications to .NET Core and .NET 6, enhancing scalability and maintainability.

• Proficient in integrating complex business logic and working with databases (SQL Server and Oracle) for efficient data management and integration.

• Expertise in utilizing Dapper ORM and Entity Framework for optimized data access and query performance.

• Hands-on experience in developing and consuming web services (SOAP and RESTful), ensuring seamless communication across distributed systems.

• Experienced in designing and deploying applications using microservices architecture, along with cloud technologies like Azure (Azure SQL, Virtual Machines, Auto-Scaling, etc.).

• Extensive experience in implementing secure authentication and authorization mechanisms using OAuth2, JWT, and ASP.NET Identity, ensuring robust user access management for applications.

• Proficient in setting up and automating CI/CD pipelines using tools like Bitbucket, Jenkins, and Azure DevOps to streamline deployments and improve development cycles.

Technical Skills:

Programming Languages

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

.NET Technologies

.NET 7, 6, .NET Framework 4.5, .NET Core, ADO.NET, ASP.NET, MVC 4/5, Web API, Razor C#, AJAX, LINQ, WCF, WPF, Web Services, Entity Frameworks, Web Forms, Windows Forms, Windows Services

Database

SQL Server (2014/2016/2017/2022), Azure SQL, Azure Blob Storage, Cosmos DB, MongoDB, NoSQL

Web Technologies

HTML, HTML5, CSS3, XML, XSLT, JavaScript, AJAX, jQuery, JSON, React JS, React Native, AngularJS 14, Blazor, Angular, Node.js, Bootstrap, TypeScript, Vue.js

Azure Services

Azure DevOps, Logic Apps, Function Apps, Blob Storage, Azure App Services, Service Fabric, Kubernetes, Azure Data Factory, Azure Service Bus, Azure Storage Explorer

Additional Services & Tools

RESTful APIs, SOAP APIs, WCF, Dynamic 365, Kafka, YAML, JWT Token.

IDE / Utilities

Visual Studio .NET 2019/2022, Visual Web Developer Express, Visual Code, Postman, Notepad++, Eclipse, SSMS

Debugging tools

Chrome Developer Tools, IE Developer Tools

Servers

Internet Information Server (IIS 5.0/6.0/7.0/7.5/8.0), Apache Tomcat, HTTP Web Server.

Testing Frameworks

NUnit, XUnit, MS Test, TDD, BDD

Source Control Tools

Team Foundation Server, Subversion, Visual Source Safe, Git, Bit Bucket, Kiln, SVN

Work Experience:

Client: BCBS, Chicago, IL Jun 2023 - Present

Title: Senior Dot Net Developer

Responsibilities:

• Developed dynamic, responsive user interfaces using Angular, HTML5, CSS3, Bootstrap, jQuery, Vue.js, and TypeScript for seamless user experiences in healthcare provider search.

• Implemented real-time search functionality with AJAX, JSON, and WebSockets for dynamic filtering and display of healthcare providers without page reloads.

• Designed and developed rich UI components using Telerik Kendo UI, Blazor, and React for advanced data grids, charts, and calendars, enhancing provider network management.

• Optimized frontend performance by implementing lazy loading, code-splitting, and state management with Angular Services, Redux, and RxJS for smooth user interactions.

• Architected and developed microservices using .NET Core, ASP.NET Core, and Node.js to handle patient searches, provider enrollment, and real-time updates.

• Developed RESTful APIs in C#, Entity Framework, with ASP.NET Core for seamless communication between frontend and backend services, handling patient and provider queries.

• Implemented event-driven architecture with Kafka, Azure Service Bus for asynchronous messaging, ensuring real-time synchronization across microservices.

• Integrated legacy services like WCF, Web API, SOAP to maintain interoperability between new microservices and older system components, ensuring data consistency.

• Designed and optimized database schemas in SQL Server 2022/2019, MongoDB, and Cosmos DB to manage large-scale datasets for patient records, provider details, and insurance plans.

• Developed T-SQL queries, stored procedures, PL/SQL, and functions for filtering provider data, retrieving patient preferences, and generating reports.

• Built ETL processes using SSIS, Azure Data Factory to extract, transform, and load provider and patient data from external sources into SQL Server, ensuring real-time data synchronization.

• Implemented indexing, partitioning, and query performance tuning with LINQ to optimize data retrieval and reduce response times.

• Implemented secure authentication and authorization using OAuth2, JWT tokens, and Azure AD ensuring that only authorized users can access sensitive healthcare data.

• Enforced HTTPS and SSL/TLS encryption with YAML configurations to secure communication between frontend, backend services, and third-party providers.

• Deployed applications on Microsoft Azure using Azure App Services, Azure Functions, for hosting Angular and .NET Core microservices, ensuring high availability and scalability.

• Created and managed Azure Kubernetes Services (AKS) for orchestrating and scaling containerized microservices and implemented CI/CD pipelines with Azure DevOps, Git, and TFS to automate build, testing, and deployment processes.

Environment: .NET Core, ASP.NET Core, Angular, Microservices, Kafka, MS Azure, Agile (Scrum), SQL Server 2022, SQL Server 2019, T-SQL, MongoDB, ETL, SSIS, SSRS, HTML5, CSS3, Bootstrap, jQuery, Vue.js, Telerik (Kendo) UI, AJAX, JSON, TypeScript, .NET Framework 4.0, C#, VB.NET, Entity Framework, WCF, WPF, Blazor, WinForms, Visual Studio, Postman, NUnit, XUnit, JWT Token, MOQ, Azure DevOps, JIRA

Client: Fannie Mae, Washington, D.C Sep 2021 – Jun 2023

Title: Dot Net Developer

Responsibilities:

• Developed dynamic, single-page registration and profile creation forms using Angular 12/13, Vue.js, TypeScript, with real-time data binding through Angular Reactive Forms for an interactive experience.

• Ensured responsive design with HTML5, CSS3, SCSS, and Bootstrap, Blazor, providing a smooth and consistent UI across mobile, tablet, and desktop devices.

• Utilized AJAX, jQuery, and HTTP Client for asynchronous form submissions, ensuring smooth user interactions without page reloads.

• Integrated a modern UI with real-time validation using Dynamic 365 for a seamless and intuitive user experience during registration and profile updates.

• Built backend logic for user registration and profile creation using ASP.NET Core Web API, ASP.NET MVC 5, WCF, handling HTTP requests for user operations.

• Developed RESTful APIs, SOAP services for registration, profile updates, and authentication, following best practices in API development.

• Used Kafka, Azure Service Bus, for event-driven architecture, handling user registration events and notifications, ensuring a scalable and decoupled system.

• Integrated secure user authentication and authorization using ASP.NET Identity, JWT, and YAML configurations, enabling secure access to user accounts and profile data.

• Designed and optimized database schema in SQL Server, SQL Azure, and MongoDB to support user registration, profile creation, and related metadata.

• Developed T-SQL queries, PL/SQL, and stored procedures for handling user registration data, including insertion, updates, and retrieval of profiles.

• Implemented data validation in SQL to ensure the uniqueness of fields like email and username using LINQ, preventing duplicate registrations.

• Used Entity Framework, ADO.NET with SQL Server for ORM-based data management and implemented database migration strategies for seamless updates.

• Implemented SSL/TLS encryption, XML security standards to secure communication between the frontend and backend, protecting sensitive data like passwords and personal information.

• Applied password hashing techniques (PBKDF2 and bcrypt) to securely store user passwords in the database, with Azure Key Vault integration.

• Enabled email verification functionality to ensure valid user registrations and reduce fraud and used OAuth 2.0, Azure AD for secure user access management.

• Deployed the Angular frontend and ASP.NET Core Web API backend to Microsoft Azure App Services, Azure Functions, ensuring high availability and scalability, with CI/CD pipelines via Azure DevOps, TFS, and GitHub Actions for automated deployment.

Environment: .NET Core, ASP.NET MVC 5, Web API, Angular 12/13, Vue.js, Entity Framework, ADO.NET, SQL Server, SQL Azure, C#, Kafka, Azure Service Bus, HTML5, CSS3/SCSS, Bootstrap, JSON, TypeScript, SSIS, SSRS, MongoDB, Microsoft Azure, Azure DevOps, REST APIs, JWT Token, YAML, Node.js, Microservices, React, React Native, WCF, WPF, LINQ, T-SQL, PL/SQL, XML, SOAP, Postman, NUnit, XUnit, Jira, Agile Methodology

Client: State of Ohio, Columbus, Ohio Apr 2020 – Aug 2021

Title: Dot Net Developer

Responsibilities:

• Developed a responsive user interface using Angular 4.0 with Bootstrap to display real-time traffic data, incident alerts, and optimized routes.

• Implemented interactive dashboards for traffic authorities with HTML5 and JavaScript, enabling real-time monitoring of traffic conditions, incidents, and road closures.

• Integrated Google Maps API to visualize traffic congestion, incidents, and suggest alternate routes to users.

• Developed mobile applications using Ionic and Cordova, enabling users to receive real-time notifications and traffic updates on-the-go.

• Used TypeScript to enhance code maintainability and structure, ensuring performance optimization and error handling in the frontend.

• Optimized front-end performance for real-time data rendering using RxJS and NgRx for effective state management during high data flow.

• Designed and implemented backend services using .NET Core with Microservices, managing traffic monitoring, incident detection, and alerting modules.

• Developed RESTful APIs for real-time incident data communication between frontend, external sensors, and backend systems using JSON and SOAP.

• Implemented real-time data streaming using Kafka, enabling communication between traffic sensors, cameras, and backend systems for continuous monitoring.

• Integrated legacy systems with WCF and SOAP to connect with state databases and weather services, improving data accuracy for incidents and traffic updates.

• Used ADO.NET and LINQ for efficient data retrieval and manipulation to generate traffic analytics and incident reports.

• Processed traffic data using XML, integrating information from various devices and external systems into the backend.

• Designed and optimized SQL Server database to store traffic data, incident logs, and sensor data, with efficient querying for real-time reporting.

• Developed stored procedures and views in SQL Server to aggregate and generate incident reports, providing insights into traffic patterns and road conditions.

• Used SSIS (SQL Server Integration Services) to automate ETL processes for integrating traffic data from multiple sources.

• Leveraged SSRS (SQL Server Reporting Services) for generating real-time reports and dashboards, offering insights into traffic congestion and incident frequency.

• Utilized ADO.NET and LINQ for querying and manipulating SQL Server data, ensuring smooth data flow during incident updates.

• Implemented OAuth 2.0 and JWT for secure authentication and authorization to access traffic management systems and incident data.

• Used SSL encryption and HTTPS to secure communication between frontend, backend, and external systems, ensuring safe data transmission.

• Secured API endpoints with role-based access control (RBAC), restricting access to sensitive traffic data and system settings.

• Integrated FHIR and HL7 standards to exchange healthcare-related incident data securely with external healthcare systems.

• Monitored and logged security events using Azure Monitor and custom logging systems, enabling proactive threat detection and audit trails.

• Ensured security best practices for SQL Injection and Cross-Site Scripting (XSS) vulnerabilities by implementing input validation and secure coding practices.

• Deployed backend services on Microsoft Azure, utilizing Azure App Services and Azure Kubernetes Service (AKS) for scalability and high availability.

• Containerized backend services using Docker, ensuring consistent environments across development, staging, and production environments.

• Automated CI/CD pipelines using Azure DevOps, enabling continuous integration, deployment, and version control across multiple environments.

• Deployed frontend web application on IIS 7.5, ensuring reliable access to the traffic management dashboard for users and traffic authorities.

• Managed cloud infrastructure with Azure Resource Manager (ARM) templates, provisioning resources like databases and web services automatically.

• Implemented auto-scaling with Azure Monitor to handle traffic fluctuations and provide optimal performance during peak times.

Environment: NET, WinForms, Net, C#.NET, Net CORE with Microservice SQL Server, SQL, SSIS, SSRS, ADO.NET, LINQ, WCF, XML, HTML5, JavaScript, SOAP, FHIR, HL7Typescript, Kafka, Cordova, Ionic and angular 4.0 with Bootstrap, IIS 7.5, Visual Studio 2019/2022, Azure DevOps as repository, Microsoft Teams

Client Kroger, Blue Ash, OH Jan 2018 – Apr 2020

Title: .Net Developer

Responsibilities:

• Developed a Hybrid mobile application from scratch using latest web technologies like Ionic, Cordova, and Angular JS, HTML5, CSS3, enhancing cross-platform compatibility and user experience.

• Optimized jQuery code and leveraged best practices to enhance the performance and responsiveness of web applications.

• Designed and implemented enhanced user interfaces using HTML5, CSS3, jQuery, and Angular JS to enable the input of additional personal information for insurance plan generation.

• Integrated jQuery functionalities with ASP.NET server controls such as Grid View, Data List, or Repeater, enhancing user experience and providing dynamic interactions.

• Designed databases in SQL Server and created stored procedures, functions, views to optimize front-end SQL queries and enforce entity relationships.

• Developed components for Business Logic and Data tier using C#, ASP.NET MVC, and ADO.NET, ensuring robust and scalable applications.

• Implemented CRUD functionality with Entity Framework in ASP.NET MVC, improving data management and application efficiency.

• Leveraged Delegates and Events to establish communication between WinForms, enhancing application responsiveness and user interaction.

• Implemented AJAX controls for partial page updates, decreasing response time and improving user experience.

• Integrated jQuery functionalities with ASP.NET server controls such as Grid View, Data List, or Repeater, enhancing user experience and providing dynamic interactions.

• Utilized .NET security features such as Form-Based Authentication and Role-Based Authorization to ensure secure access to applications and data.

• Employed Agile Methodology to achieve smooth collaboration between self-organizing, cross-functional teams, ensuring efficient project delivery.

• Participated in daily Scrum and weekly meetings with project managers and architects to meet expectations and deadlines effectively.

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

Client: Client: ICrea Infotech, Hyderabad, India Jan 2014 – Oct 2017

Title: Software Engineer

Responsibilities:

• Enhanced application user interface using HTML5, CSS3, jQuery, and Angular JS, improving user experience.

• Developed UI to input additional personal information for insurance plan generation.

• Modified database columns using Entity Framework and optimized database design in SQL Server with stored procedures and views.

• Implemented REST APIs using WEB API 2 and developed business logic components with C#, ASP.NET MVC, and ADO.NET.

• Utilized Entity Framework for CRUD functionality in ASP.NET MVC, improving data management.

• Integrated jQuery functionalities with ASP.NET server controls and used TFS for source version control.

• Implemented .NET security features such as Form-Based Authentication, Role-Based Authorization, and JWT Security for Web APIs.

• Migrated MVVM Architecture to MVC Architecture with containerization, improving modularity and deployment.

• Employed Agile Methodology for smooth collaboration and efficient project delivery.

• Conducted unit testing with N-Unit and Just-Mock and involved in the full SDLC with Agile Methodology.

Environment: ASP.NET, C#, Visual Studio, MVC, HTML5, CSS3, JSON, C#.Net, SQL Serve

Contact this candidate