SRAVANTHI PENNAM

• Provided technical support for academic systems, software tools, and digital learning platforms.
• Assisted faculty with data analysis, research activities, and academic reporting projects.
• Managed and maintained databases for academic and administrative purposes.
• Helped maintain course materials, online resources, and university digital platforms.
• Supported troubleshooting and issue resolution for students and faculty related to software and system access.
• Performed data validation, database updates, and report generation to improve data accuracy and accessibility.

• Delivered AI-driven automation solutions for clients, reducing manual processing effort and improving operational efficiency.
• Designed custom intelligent assistants and workflow automation tools to streamline customer support, data processing, and business operations.
• Built backend architectures and data pipelines to support AI-powered applications and mobile platforms.
• Developed recommendation, search, and data-analysis features using machine learning and natural language processing technologies.
• Led end-to-end project execution, including solution architecture, client consultation, development, deployment, and post-production support.
• Collaborated directly with business stakeholders to translate operational challenges into scalable technology solutions.
• Integrated AI services and third-party platforms to enhance application capabilities and user experiences.
• Engineered secure and scalable APIs to facilitate communication between mobile applications, databases, and AI services.
• Implemented data collection, transformation, and analytics workflows to generate actionable business insights.
• Successfully delivered multiple client engagements while maintaining high standards for performance, reliability, and user satisfaction.

Project Title: OPRS – Online Passenger Reservation System

Client: Gujarat (GSRTC), Tamil Nadu (SETC), Orissa (OSRTC)

OPRS – Online Passenger Reservation System (OTRS) is a web-based application developed using 3-Tier Server Centric Architecture with a centralized database system. The centralized database stores and manages advance reservation booking transactions from multiple remote locations. The application enables KSRTC operators, franchisees, and the general public to book tickets online. The system contains major modules such as Enquiry, Reservation, Admin, and Reports. The enquiry module allows users to check trip availability and reserve tickets in advance. The admin module handles operations such as service class creation, layouts, fare generation, and user management. The reports module generates reservation and collection reports for business operations.

Technologies, architecture, and tools used:

Spring Boot (Java 8), Hibernate, RESTful Web Services, SQL Server, and Microservices Architecture.

Roles and Responsibilities:

• Understanding and analyzing business requirements.
• Created REST application configuration in the Cloud Configuration Server.
• Implemented core Java concepts, including Exception Handling, Collection Framework, and Thread Communication.
• Developed functionalities using design pattern-oriented architecture, including Controller layer implementation.
• Implemented CRUD operations for the reservation and admin modules.
• Implemented entity relationships, HQL queries, and lazy loading using Hibernate.
• Integrated payment gateways, including ICICI, Paytm, and PhonePe.
• Implemented S2S integrations and webhook functionalities for payment gateways.
• Participated in debugging, testing, and deployment activities.

• Designed, developed, and maintained MySQL databases for training management and internal business applications.
• Created and optimized complex SQL queries, stored procedures, functions, triggers, and views to support application requirements.
• Performed database design, normalization, indexing, and query optimization to improve system performance.
• Managed database backups, recovery processes, and data migration activities.
• Worked closely with developers and business stakeholders to gather requirements and implement database solutions.
• Monitored database health, resolved performance bottlenecks, and ensured data integrity and security.
• Generated reports using SQL queries and supported business analytics requirements.
• Participated in troubleshooting production issues and database-related bug fixes.
• Maintained documentation for database schemas, procedures, and deployment activities.
• Supported testing and deployment of database changes across development and production environments.