Sai Ahalya Abhinuthi Rao Velishala

I will design, create, and test all interfaces and data exchanges required for two projects: Inmate Records Information System (IRIS) and Integrated Justice System (IJS). The IRIS project will implement a new Jail Management System (JMS) for the Sheriff's Office and the IJS project will modernize the remaining components in the legacy Criminal Justice Information Control (CJIC) system that will work with new JMS.

Responsibilities:

• Involved in complete SDLC - Requirement Analysis, Development, System, and Integration Testing.
• Developed custom adapters, connectors in .NET to bridge the gap between legacy sheriff department systems and modern judicial related systems, enabling seamless data flow and interoperability.
• Implemented SOA architecture through WCF and Web Services which are used to rapidly build service-oriented applications that communicate across the web and the enterprise with features of Serialization, Versioning, Interoperability, and hosting.
• Developed ASP.NET Web pages using various ASP.NET web server controls that include Menu, Tree View, Grid View, and Details View, also design a uniform layout and code reusable components like custom user controls.
• Developed RESTful APIs and microservices using .NET Core, adhering to REST principles for communication between frontend (Angular) and backend layers (.NET).
• Developed backend components and services using .NET Core, ensuring high performance and reliability of data integration processes.
• Integrated C# applications with SQL Server, leveraging stored procedures and functions to handle complex business logic and data processing tasks, ensuring seamless backend operations.
• Configured HTTP requests in Postman, including GET, POST, PUT, DELETE, and PATCH methods, with custom headers, query parameters, request bodies, and multipart/form-data payloads.
• Designed asynchronous processing workflows utilizing Azure Service Bus triggers and HTTP triggers to achieve responsive and resilient application architectures.
• Worked with Object-Relational Mapping (ORM) tools such as Entity Framework for database interaction.
• Implemented security policies such as OAuth 2.0, API keys, and JWT authentication to secure APIs against unauthorized access.
• Automated workflows and integrations using Azure Logic Apps to connect various services and systems.
• Implemented and configured API gateways using tools like Azure API Management to centralize API management and ensure consistent API access.
• Designed system architecture diagrams, data flow diagrams, and component diagrams using Lucid Chart, capturing key architectural decisions, dependencies, and interactions to guide the development process.
• Developed and optimized SQL queries, stored procedures, functions, and triggers using SSMS, ensuring efficient data retrieval, manipulation, and storage in SQL Server databases.
• Designed and modeled database schemas, tables, relationships, and constraints using SSMS's database diagramming tools, ensuring data integrity, normalization, and scalability.
• Implemented Create, Read, Update, and Delete (CRUD) operations using EF's DbContext, DbSet, and EntityState APIs, enabling efficient data manipulation and persistence in .NET applications.
• Reduced software bugs by conducting thorough unit testing and debugging, ensuring a smooth user experience.

Responsibilities:

• Developed RESTful APIs using .NET Core Web API, adhering to best practices for designing endpoints, request/response handling, and authentication mechanisms.
• Designed and developed XML Schema Definition (XSD) documents to define the structure and constraints of XML data in accordance with project requirements.
• Integrated desktop applications with external APIs for data exchange, enhancing functionality and providing real-time information to users.
• Developed and maintained SQL Server databases, implementing T-SQL scripts, stored procedures, and user-defined functions to support robust data operations across multiple applications.
• Leveraged Entity Framework and LINQ in conjunction with stored procedures and functions to streamline data access layers, improving the overall performance of .NET applications.
• Developed SOAP-based web services using ASP.NET and WCF to enable communication between distributed systems.
• Developed serverless applications using Azure Functions to execute code in response to events or HTTP triggers.
• Developed JSON-based APIs using ASP.NET Web API, enabling data exchange between web applications and clients.
• Developed ETL processes using .NET technologies such as C#, ASP.NET, and SQL Server Integration Services (SSIS).
• Designed and implemented data extraction procedures to gather information from various sources, including databases, web services, and flat files.
• Utilizing Azure DevOps Boards for sprint planning, backlog grooming, and task management in Agile/Scrum development environments & work items to track user stories, bugs, and tasks throughout the development lifecycle, ensuring transparency and accountability within the development team.
• Created data transformation logic to standardize, clean, and enrich data using SQL queries, LINQ, and custom C# code.
• Conducted thorough code reviews, ensuring code quality, consistency, and adherence to best practices.

Responsibilities:

• Designed, Developed, and Tested phases using C#, XML, ADO.NET, JavaScript, HTML, CSS, and AJAX Control Toolkit and Angular Framework
• Integrated .NET Core Web API with various databases including SQL Server, utilizing Entity Framework Core for ORM (Object-Relational Mapping) and efficient data access
• Worked on a Visual Studio code/.NET CORE 2.1 framework for an N-tiered application with an Angular and SPA front-end
• Worked with ASP.NET Web Forms, Web Services, State Management, caching features, configuring optimizations, and securing the web application
• Provided database connectivity using ADO.Net and created procedures, Indexes, and Triggers using MS SQL Server 2008
• Implemented Entity Framework with C# in Visual Studio 2013 to establish connections between server-side web applications and an MS SQL Server
• Implemented PowerShell scripts for automating routine tasks, reducing manual effort and enhancing system efficiency
• Developed the reusable framework for the application using .NET framework 3.5 and implemented the MVC (Model View Controller) architecture
• Integrated JSON APIs into client-side applications, utilizing JavaScript frameworks such as Angular
• Successfully integrated Restful APIs, expanding data sources and enriching the database with real-time information
• Managed versioning of SOAP services to ensure backward and forward compatibility
• Collaborated closely with cross-functional teams to gather and analyze requirements, translating them into detailed architectural plans
• Facilitated code review sessions with development teams, fostering a collaborative environment for sharing ideas, knowledge, and expertise across team members.

Responsibilities:

• Developed GUI, Business, and Data tier using .Net 3.0, 2.0, C#, and ADO.NET
• Designed and implemented the user interface, focusing on user experience and responsive design principles
• Developed POC’s following multiple different approaches
• Developed custom controls and user controls using ASP.NET 3.0, 2.0
• Developed code behind classes and reusable components in C#
• Extensively used the ASP.Net controls Grid View, Repeater, and Data List for effective interface design
• Implemented AJAX controls
• Created custom Angular components and directives to encapsulate complex UI functionality and improve code modularity, reusability, and maintainability
• Used JavaScript and jQuery to perform client-side validations
• Developed complex Grid Views, Master Pages, and Controls using ASP.NET.