Venkata Penumadu

Experience

1. Business Analyst

   Genpact

   Dec 2024 — Present

   Designed and implemented a knowledge-based chatbot using Azure OpenAI, LangChain, and FAISS, enabling efficient retrieval of insights from various structured and unstructured data sources- Developed data preprocessing pipelines to automate document ingestion, text chunking, and embedding creation, improving response accuracy by ensuring structured vectorized storage- Integrated Azure OpenAI\'s LLM models with secure API key authentication, ensuring seamless and controlled access to advanced AI capabilities for query resolution- Optimized chatbot performance by fine-tuning retrieval strategies to align with LLM processing constraints, enhancing accuracy and reducing response latency- Implemented this solution to minimize manual intervention in email-based client query resolution, leading to an efficient workflow, reduced workload, and a 24/7 user-friendly interface for seamless customer interactions- Executed data validation and analysis protocols on specialty pharmacy datasets utilizing SQL and R, enhancing data quality by 20%- Designed and maintained dynamic Excel dashboards, leveraging pivot tables, advanced formulas, and data visualizations to track key performance metrics and provide real-time insights- Developed and presented visually compelling reports and dashboards using Tableau and Excel, ensuring data-driven decision-making through clear and concise weekly stakeholder presentations- Wrote and optimized SQL scripts to update and manage databases efficiently, ensuring data integrity and accuracy for reporting and analytical purposes- Provided cross-functional support to neighboring teams, assisting with R scripting and data automation, improving overall workflow efficiency and analytical capabilities.