.Net Developer Sql Server

Raviteja Mergu

Sr. Full Stack .Net Developer

LinkedIn Url: linkedin.com/in/raviteja-mergu-3873441b4

Mail Id: *************@*****.***

Contact Number: +1-314-***-****

Professional Summary:

●Highly motivated IT professional with progressively responsible experience of around 10 years in development, testing, documentation & production support customized applications.

●Experience in Waterfall and Agile-Scrum Methodology.

●Experience in building web applications using C#.NET, SQL Server, ASP.NET Core, ASP.NET MVC, Web API, ADO.NET and Entity Framework.

●Expertise in designing applications using modern architectures like Micro Services, N-Tier, Service- Oriented (SOA) and Client/Server Model.

●Skilled in developing user interfaces (UI) using various technologies, including HTML5, CSS, React JS, Java Script, XML, J Query, JSON, AJAX, TypeScript, Angular, Bootstrap, and Web UI applications.

●Developed Micro Services to handle business logic and make the application light weight for better performance.

●Experience in working with ADO.Net, Entity Framework and LINQ (LINQ to Object, LINQ to SQL, LINQ to XML, Lambda).

●Experienced in using Python libraries such as Pandas, NumPy, and SQLAlchemy for data analysis, transformation, and database interactions.

●Proficient in RDBMS utilization, specializing in SQL query optimization, PL/SQL development.

●Skilled in designing and implementing robust database solutions using SQL Server, Oracle, MySQL, DynamoDB, and MongoDB.

●Experienced in integrating and managing PostgreSQL and BigQuery on Google Cloud Platform (GCP) and developing Python-based data pipelines for analytics and ETL.

●Developed and maintained Windows Forms applications for clients in the finance and healthcare sectors. Created Single Page web applications with rich and responsive user interface using UI technologies.

●Experienced in multi-cloud environments, leveraging AWS (RDS, Lambda, S3, EC2, CloudWatch, API Gateway), GCP (PostgreSQL, BigQuery, Dataflow, Cloud Functions, Cloud Storage), and Azure (DevOps CI/CD, App Services, Azure SQL Database) to design, deploy, and manage scalable, secure, and high-performance applications.

●In-depth understanding of Object-oriented Programming concepts and Design Patterns.

●Extensive understanding of creating and managing Views, Partial Views, View Model in ASP.NET MVC.

●Extensively worked in writing T-SQL Queries, Stored Procedures, Triggers, Cursors, Exception Handlers, Crystal Reports, SSIS and SSRS.

●Well versed with Test Driven Development, used JUnit and Visual Studio Test Tools for Unit testing.

●Experience in working with GIT, Team Foundation Server (TFS) source control. Created new team projects under team project collections, merging and branching to support parallel development.

●Hands on Code Reviews, Change, Configuration, Release & Build Management and Administration of applications.

●Excellent communication, analytical, problem-solving skills, strong teamwork orientation, dedicated to quality output for the team or to individual assignments as required by the work environment.

●Willing to learn new technologies, ability to learn fast, and determined to achieve.

TECHNICAL SKILLS:

Languages

C, C#, JAVA, VB.Net, Python, COBOL.

.NET Technologies

.NET Framework 6.0, ASP.NET MVC5, ASP.NET Core 3.1, ADO.NET,

ASP.NET Web Forms, LINQ, WCF, RAZOR, BLAZOR.

Web Technologies

HTML5, CSS3, JavaScript, AJAX, jQuery, ReactJS, Angular 4/5/6/7/9/12/13/14, Bootstrap, WinForms, Node.JS, XAML, XSL, XSLT, Kendo UI, Knockout JS.

Databases

SQL Server 2012/16/19, T-SQL, PL/SQL, MySQL, SQL Server client management studio, MongoDB, Oracle 10g/91/81, PostgreSQL.

ORM Frameworks

Entity Framework, Dapper.

Cloud Technologies

Microsoft Azure, AWS.

Web Servers/Services

IIS, Web API (Rest/Http) Services, XML, JSON, SOAP.

Testing Frameworks

Unit Testing (N-Unit and X-Unit) frameworks, MOQ Framework,

Ms-Test, Mocking, Visual Studio Unit Test, J unit, Jasmine, Selenium.

CICD Tools

Azure DevOps, Jenkins, Docker, GitLab and Bamboo.

Methodologies

Agile, Waterfall and Kanban.

Version Control

Bit Bucket, Git, GitHub, TFS, VSTS.

Other tools

SSRS, SSIS, Crystal Reports, Kafka, RabbitMQ, Postman, JIRA, Vera Code

Professional Experience:

Client: Equifax – Saint Louis, Missouri Aug 2023 – Present

Role: Sr.NET Full Stack developer

Responsibilities:

●Following Agile Scrum methodology with task and sprint management through JIRA, collaborating across teams to ensure timely delivery.

●Following Agile Scrum methodology with task and sprint management through JIRA, collaborating across teams to ensure timely delivery.

●Modernizing the legacy application originally built with VBScript and VB.NET (.NET Framework 4.0) by rewriting it to .NET 8 with Blazor for the front-end, improving performance, maintainability, and long-term scalability.

●Supporting hybrid environments involving C# (.NET), Classic ASP, VBScript, and ADO.NET to ensure backward compatibility during transition.

●Applying Clean Architecture with layered separation (API, Application, Domain, Infrastructure), using Dependency Injection to simplify unit testing and improve code maintainability.

●Rewriting the front-end using Blazor components with Razor syntax and reusable UI elements, ensuring responsive layouts and interactive features tailored for modern browsers.

●Developing and structuring Blazor pages using components, dependency injection, two-way data binding, event handling, and routing for maintainable and component-driven UI architecture.

●Reengineering the back end with C# and ASP.NET Core Web API on .NET 8 to replace legacy VB.NET services and enable scalable, cross-platform development.

●Implementing Entity Framework Core in .NET 8 using a code-first approach, leveraging migrations to manage schema changes and ensure consistent deployment across development, staging, and production environments.

●Designing RESTful endpoints using ASP.NET Core to support over 10 critical workflows, with proper routing, versioning, and data contracts for consumption by Blazor components and external consumers.

●Implementing asynchronous processing in .NET 8 using async/await, Task Parallel Library (TPL), and background services to handle long-running operations without blocking HTTP request threads.

●Securing APIs using OAuth2 with JWT tokens to enforce role-based access and ensure secure communication between Blazor UI and the server.

●Using Redis Cache to minimize SQL Server load and accelerate frequently accessed data retrieval for Blazor-based dashboards and grids.

●Writing efficient T-SQL queries and optimizing SQL Server performance through indexing strategies, statistics maintenance, and routine DB integrity checks.

●Developing ETL processes using SSIS and delivering operational dashboards and reports via SSRS, embedded within Blazor for real-time data visualization.

●Successfully migrated the SQL Server 2016 database from on-premises to AWS Cloud, ensuring continuity of dev operations in the cloud.

●Upgrading the SQL Server engine version from 2016 to 2019 for DPA compatibility and improving performance and long-term support, while reducing storage footprint by 40% through utilization analysis and downsizing RDS provisioned capacity to achieve cost savings without impacting performance.

●Setting up AWS DMS for real-time data replication, enabling separation of read and write workloads to reduce load on the production database and improve performance for analytical and reporting operations.

●Deploying event-driven workloads via AWS Lambda and managing compute/storage via EC2 and S3 respectively, with real-time observability through CloudWatch.

●Configuring Amazon API Gateway to expose .NET APIs for Blazor consumption with request throttling and centralized access control.

●Testing API endpoints using Postman collections and validating schema/documentation through Swagger UI to ensure smooth handoff to Blazor-based front-end teams.

●Addressing vulnerabilities and enforcing secure coding practices through static code analysis using Fortify, SonarQube, and F4D scans.

●Maintaining source control with Git and GitHub, handling branching, PR reviews, and version management through Git Flow.

●Automating builds and deployments via CI/CD pipelines using Visual Studio and AWS native tools for reliable and repeatable releases.

Environment:

.NET 8, C#, Blazor (Server & WebAssembly), ASP.NET Core Web API, Entity Framework Core, Razor Components, ADO.NET, Classic ASP, VBScript, VB.NET, SQL Server 2016/2019, T-SQL, SSMS, SSIS, SSRS, Redis Cache, AWS (RDS, EC2, S3, Lambda, DMS, API Gateway, CloudWatch), JIRA, Postman, Swagger UI, OAuth2, JWT, Serilog, Fortify, SonarQube, F4D scans, Git, GitHub, Visual Studio, CI/CD Pipelines.

Client: Mayo Clinic- Rochester, Minnesota July 2021 – Aug 2023

Role: Sr.NET Full Stack developer

Responsibilities:

●Employed Agile Scrum methodology for application implementation in a regulated healthcare environment, using Confluence pages for documenting processes, system errors, and Medicaid case management issue tracking.

●Designed and implemented a microservices architecture in .NET to modernize the Medicaid and case management system, enabling independent deployment, scalability, and maintainability for DMH and DSS programs.

●Utilized Node.js for server-side JavaScript processing in microservices, enabling asynchronous communication with Medicaid eligibility, claims processing, and external partner systems.

●Created RESTful web services for secure data exchange between microservices, state Medicaid systems, and DMH/DSS external integrations.

●Applied Entity Framework Core in .NET microservices for efficient, HIPAA-compliant access to SQL Server healthcare data, including patient case records and claims history.

●Performed security remediations to meet HIPAA and state compliance standards by identifying vulnerabilities and applying configuration/code changes to protect PHI.

●Worked extensively with JSON for structured data exchange between Medicaid APIs, eligibility services, and DSS reporting systems.

●Deployed microservices on Azure Cloud with API Gateway for centralized management, routing, and monitoring of Medicaid-related API requests.

●Implemented OAuth2 authentication and role-based authorization in microservices to secure access to sensitive healthcare data across DMH/DSS-integrated applications.

●Developed Angular front-end components integrated with microservices APIs to provide responsive, user-friendly interfaces for Medicaid case workers and mental health service providers.

●Designed and styled responsive UI with HTML, CSS, and Bootstrap to ensure accessibility for healthcare staff across devices.

●Enhanced UI functionality using JavaScript and TypeScript for real-time data updates and case status tracking in Medicaid workflows.

●Designed and maintained SQL Server databases, performing query tuning, index optimization, statistics updates, and execution plan analysis to improve performance of high-volume Medicaid transaction processing.

●Developed ETL workflows with SSIS to integrate claims, eligibility, and outcome data from multiple healthcare systems into DSS/DMH reporting databases.

●Created SSRS reports for Medicaid service utilization, claims processing timelines, and DMH outcome tracking to support operational decision-making.

●Applied microservices design patterns and participated in peer code reviews to ensure secure, maintainable, and scalable healthcare application code.

●Implemented unit testing for front-end components using Karma and Jasmine, and for microservices using xUnit, ensuring reliability in production healthcare environments.

●Used Postman and Swagger UI for API validation, contract testing, and documentation to ensure Medicaid/DSS APIs met state integration requirements.

●Configured CI/CD pipelines in Azure DevOps for automated build, testing, and deployment of healthcare microservices.

●Integrated Azure SQL Database and Azure Blob Storage with microservices for secure, scalable storage of Medicaid-related documents and case data.

●Collaborated with state IT security teams to implement HIPAA-compliant coding practices, storing sensitive keys and credentials securely with Azure Key Vault.

●Conducted SonarQube static code analysis for early vulnerability detection, ensuring adherence to HIPAA and state security standards.

●Managed source control via Azure DevOps Git workflows, ensuring collaborative development and proper version management.

●Proactively learned and integrated new healthcare security and cloud tools such as Wiz.io to strengthen Medicaid application monitoring and remediation strategies.

Environment: .NET 8, ASP.NET Core Web API, Microservices, Node.js, RESTful Web Services, Entity Framework Core, JSON, Azure Cloud, API Gateway, OAuth2, Angular 16, HTML, CSS, JavaScript, Bootstrap, TypeScript, SQL Server, SQL Server Performance Tuning, SSIS, SSRS, Apache Kafka, xUnit, Azure DevOps CI/CD, Azure Services, Visual Studio, JIRA.

Client: State of NC - Raleigh, NC Feb 2019 – Jun 2021

Role: .NET Full Stack developer

Responsibilities:

●Involved in the SDLC of requirement analysis, design, and development of the web-based application in the Fast-paced agile methodology.

●Utilized MVC architecture for modular and organized software design, scalability and maintainability of applications.

●Developed robust web application using Asp.Net Core 2.0 framework, leveraging Model-View-Controller architecture for code separation and flexibility.

●Efficiently designed Views, Partial Views, View Models and Action Filters in ASP.NET MVC.

●Designed RESTful APIs for seamless communication and data exchange between client and server components.

●Implemented HTML Helper MVC Web Grid with jQuery for boosting the pagination performance and load

graphical data with JSON. Also supporting custom searching along with sorting the data with partial views.

●Implemented Entity Framework for the data access layer, leading to a 40% reduction in data retrieval and update times compared to previous methods such as ADO.NET and LINQ queries.

●Developed responsive user interface using HTML, CSS, JavaScript, Bootstrap, and Ajax within the MVC framework.

●Created Typescript reusable components and services to consume REST API's using Component based architecture provided by Angular.

●Utilized SQL Server database for efficient data storage and retrieval based on project requirements.

●Implemented unit tests using X Unit framework to ensure code quality, functionality, and maintainability of .NET applications.

●Utilized Azure Storage solutions, including Blob, File, Queue, and Table storage, for highly available, secure, and scalable cloud storage, optimizing data access and application performance.

●Managed codebase effectively using TFS for version control, collaboration, and code management across development teams.

●Utilized Visual Studio and SQL Server Management Studio for development, debugging, and building the application.

Environment: MVC architecture, Asp.Net Core 2.0, ADO.Net, RESTful APIs, Entity Framework, JSON, HTML, CSS, JavaScript, Bootstrap, Ajax, SQL Server database, LINQ, X Unit framework, Azure, TFS, Visual Studio, SSRS, SSMS.

Client : Concert AI - Cambridge, MA Nov 2016 – Jan 2019

Role: .NET Full Stack developer

Responsibilities:

●Employed Agile methodologies to ensure iterative development and continuous improvement throughout the software development lifecycle.

●Implemented Onion Architecture to achieve separation of concerns, maintainability, and scalability in the project's software design.

●Developed APIs with Node.js to enhance data exchange and connectivity between server-side and client-side components of web applications.

●Designed and implemented RESTful web services to enable seamless interaction and data exchange between different modules of the application.

●Implemented Blazor application by using the Razor component model to create dynamic and data-driven web pages.

●Utilized Entity Framework Core as the ORM framework for efficient and secure database access, implementing encryption for PHI storage and data manipulation in line with HIPAA standards.

●Used JSON for lightweight and structured data exchange between the backend services and client applications.

●Used Amazon API Gateway with AWS Lambda to run our services without setting up servers, making it easier and cheaper to handle changes in the number of users or amount of data.

●Developed user interfaces using Angular 10 for interactive and responsive client-side experiences.

●Utilized HTML, CSS, JavaScript, and Bootstrap for designing and styling web pages and user-friendly interfaces.

●Utilized MongoDB, a NoSQL database, for efficient data storage and management, enhancing flexibility and scalability in the project's data layer.

●Designed and implemented flexible schema structures in MongoDB to handle complex data relationships and unstructured data.

●Implemented robust backup and recovery strategies for MongoDB to safeguard data against loss and ensure business continuity.

●Implemented X Unit testing framework for .NET Framework to conduct unit tests and ensure code quality.

●Used Karma and Jasmine for testing front-end components and functionality of Angular applications.

●Leveraged Postman, SOAP UI, and Swagger UI for API testing, documentation, and validation, ensuring robustness and reliability of APIs.

●Configured and maintained Azure DevOps CI/CD pipelines to automate build, test, and deployment processes from a developer's perspective.

●Utilized AWS (Amazon Web Services) for cloud-based services and infrastructure to enhance scalability, reliability, and performance of the project.

●Utilized Git for version control, branching, merging, and collaboration with development teams, ensuring codebase

integrity and version management.

●Used Visual Studio and Visual Studio Code as build tools for developing, debugging, and building .NET applications and components.

●Integrated JIRA as the project management and issue tracking tool, facilitating Agile methodologies, task prioritization, team collaboration, and project progress monitoring.

Environment: Onion Architecture, ASP.NET Core 2.2, NodeJS, RESTful web services, Entity Framework Core, JSON, Amazon API Gateway, OAuth2, Angular 10, Blazor, HTML, CSS, JavaScript, Bootstrap, MongoDB, MS MQ, XUnit, Karma, Jasmine, Postman, SOAP UI, Swagger UI, Azure DevOps, AWS, Git, Visual Studio, JIRA.

Client: Virtusa - Hyderabad, India Mar 2015 – oct 2016

Role: Junior .NET Developer

Responsibilities:

●Implemented Agile SDLC methodologies for iterative development and continuous improvement, ensuring rapid feedback and flexibility in project execution.

●Utilized the ASP.NETMVC architecture for creating scalable and maintaining the application, enhancing code organization, and separating concerns effectively.

●Employed ADO.Net as the ORM framework for efficient data access and manipulation, enhancing database interactions within the application.

●Optimized business workflows by implementing SOAP web services, which provided a reliable framework for standardized, XML-based messaging across heterogeneous systems, improving operational efficiency.

●Developed user interfaces using HTML, CSS, JSP, JavaScript, jQuery, and Ajax for interactive and responsive web experiences.

●Utilized Oracle as the relational database management system (RDBMS) for efficient data storage, retrieval, and management, leveraging its robust relational data model and SQL capabilities.

●Wrote Queries, Stored procedures, joins to process large collection of products and retrieve data from database using Oracle database.

●Developed complex PL/SQL packages to automate monthly financial reporting processes, reducing processing time.

●Conducted unit tests using X Unit testing framework for .NET Framework, ensuring code quality, functionality, and maintainability.

●Optimized Oracle database performance in AWS environments by tuning PL/SQL queries and procedures.

●Developed and deployed the application on AWS EC2 instances, configuring them to interact with Oracle databases hosted on RDS, ensuring high availability and scalability for data-intensive operations.

●Employed AWS Identity and Access Management (IAM) to secure access to Oracle databases on RDS.

●Utilized JIRA as the project management and ticketing tool, facilitating task prioritization, team collaboration, and project progress tracking.

Environment: ASP.NETMVC 5, SOAP web services, ADO.Net, XML, HTML, CSS, JSP, JavaScript, jQuery, Ajax, Oracle, RDBMS, PL/SQL, X Unit, AWS, SVN version control, Visual Studio, JIRA.

Education:

Bachelor of Technology - JNTU, India. 2015

Contact this candidate