Jai Bot V4 for Jindal Steel and Power Limited.
Technologies: GCP, Vertex AI, Java, Spring Boot
- Created an advanced chatbot capable of reading and analyzing data from multiple CSV files, performing calculations, and generating detailed insights, and implemented a robust user management system supporting super admin, admin, and user roles for secure access and control
- Enabled users to create multiple customized GPTs, each linked with specific CSV files, tailored for different business needs.
- Provided functionality to easily share these GPTs with other users, promoting collaborative data analysis and decision-making.
Jai Bot V3 for Jindal Steel and Power Limited.
Technologies: GCP, Vertex AI, Java, Spring Boot
- Developed a user-friendly chatbot that dynamically reads data from MSSQL databases and supports natural language queries.
- Integrated Gemini to generate SQL queries from user input, which are then executed on MSSQL to fetch accurate results.
- Enabled users to view data in both graphical and tabular formats directly within the chatbot interface.
- Added export functionality to allow users to download query results as CSV files for further analysis.
Jai Bot V2 for Jindal Steel and Power Limited
Technologies: GCP, Vertex AI, Java, Spring Boot
- Developed a responsive chatbot capable of handling complex queries and delivering instant answers.
- Enabled users to export tabular results directly to CSV and request graphical representations of data.
- Integrated Gemini to extract accurate summaries from files and unstructured datasets (e.g., PDFs).
- Enhanced information extraction quality and reliability, empowering users to analyze data seamlessly.
Vodafone-Idea Share Logs to CLM Server.
Technologies: Java, Microservices, Big Query, Pub/Sub, App Engine.
- Designed a microservices-based solution to read Google Workspace (G Suite) logs from Big Query, including Service, Activity, Gmail, and GCP Firewall logs
- Developed Java services to process and push these logs to the CLM server using Google Pub/Sub for distributed delivery.
- Integrated Logstash and IBM QRadar to enable advanced security analytics and centralized log monitoring.
- Deployed on Google App Engine, ensuring scalable, real-time log sharing and enhanced compliance visibility for Vodafone-Idea.
Shopify app (order verification via IVR and OTP) technologies: React.js, Next.js, Java, Exotel, cloud telephony, AWS, Node.js, and Shopify Polaris
- Developed a Shopify app using React.js, Next.js, Java, Node.js, and Shopify Polaris to verify orders via IVR and OTP
- Integrated Exotel cloud telephony to automate call and SMS verification for COD (cash on delivery) orders
- Helped e-commerce stores significantly reduce RTO (Return to Origin) rates by ensuring genuine customer intent
- Deployed on AWS for scalable performance, providing a seamless and secure verification experience
Ecom Express Cloud Telephony - IVR's campaign
Technologies: Java, Exotel Cloud Telephony, Google Big Query, Google Apps Script, App Engine
- Built an automated IVR campaign system for Ecom Express using Java, Exotel Cloud Telephony, and Google App Engine.
- Fetched daily order data from Ecom Express API to trigger order confirmation calls to customers
- Integrated Google BigQuery and App Script to process call results and generate comprehensive daily reports
- Improved delivery accuracy and reduced RTO by verifying orders proactively through automated voice campaigns
ICICI Bank VRM, MSD, Exotel Integration.
Technologies: AWS, RDS, Spring Boot, Exotel.
- Handled inbound and outbound calls directly from Microsoft Dynamics CRM, including supervisor call barging functionality.
- Ensured secure data encryption, detailed logging, and efficient server auto-scaling for high reliability
- Mapped agents and relationship managers to customers, enabling personalized call handling
- Automated call reports to ICICI Bank APIs, improving traceability and operational transparency