PUJITHA Gopireddy

Key Contribution:
Developed scalable and maintainable code, ensuring long-term stability of the software and enabling seamless enhancements across automation for multiple projects in INSURANCE account for the client named "GAIC"(Great American Insurance Company)

• PDF to HTML Forms Automation (GARS): Developed a Streamlit-based Python tool to convert PDF forms into HTML, saving ~25 hours/month and enhancing client satisfaction through improved efficiency and usability.
• Mailbox Macro Extraction (CUBE): Automated the retrieval of Excel macros from Outlook mailboxes using Python and Streamlit, reducing hours of manual effort. Ensured robustness with Pytest-based test coverage.
• OOB Policy Mismatch Analyzer (GARS): Built an XML comparison tool to detect and correct policy mismatches between systems, improving data consistency and reducing manual reconciliation.
• Majesco Billing Summary Automation (MAJESCO): Designed a solution to auto-generate daily billing reports by integrating SQL queries with Excel templates, streamlining reporting processes.
• Pipeline Data Surveyor Automation (GASLABS): Created a script to extract key pipeline data from multiple Git repositories and auto-generate configuration files, significantly reducing manual errors and time.
• Patch Update Aggregator (COTS): Initiated automation to consolidate patch updates from Oracle and Google Calendar into a single Excel report, simplifying monthly maintenance tracking.(Ongoing)

Hands-on GenAI Projects During On-the-Job Learning:

• Integrated new technologies into existing systems, increasing capabilities and improving overall performance.
• Integrated new technologies into existing systems, increasing capabilities and improving overall performance.
• Integrated GenAI technologies into enterprise systems, enhancing automation capabilities and improving performance across multiple business functions.
• Built and evaluated RAG (Retrieval-Augmented Generation) pipelines, implementing both retrieval and generation evaluation metrics such as Citation Match, Retrieval Relevance, and BERT Score to ensure high-quality, contextually accurate outputs.
• Developed an Audio-to-Text Translation system using LLMs and Python libraries like speech_recognition and AudioSegment, supporting multilingual translation and pronunciation features.
• Designed a Knowledge Graph-based RAG system to enhance semantic search and natural language query understanding, integrating LLMs for intelligent query processing and pattern recognition.
• Applied hybrid RAG architecture to real-world scenarios such as customer support and conversational AI, including the implementation of a real-time budget file analysis system. This solution ingested PDF budget documents, retrieved relevant financial data using semantic search, and generated accurate, context-aware responses tailored to organizational needs—enabling faster decision-making and improved data accessibility.

• Trained in Core Java, Spring Boot, and Angular as part of an intensive 2-month internship program.
• Successfully completed three project milestones and received a Certificate of Completion for outstanding performance.
• Project: Resort Booking Web ApplicationDeveloped a full-stack resort booking system with RESTful APIs for performing CRUD operations.
  Backend: Java, Spring Boot, MySQL
  Frontend: Angular, TypeScript, HTML, CSS
  Built an Admin Panel for managing resort listings (Add, Update, Delete) through secure login.
  Implemented User Portal allowing users to register/login, book or cancel resorts, view booking history, and read reviews.