Dhamodaran Mani

• Developed stored procedures and dashboards for real-time monitoring of NPA and credit card performance.
• Automated daily ETL pipelines using Python (Pandas) & SQL Server – reduced reporting time by 40%.
• Created Seaborn visualizations for internal risk prediction models.
• Designed and optimized 200+ stored procedures in SQL Server for regulatory and management reporting.
• Mentored junior analysts in BI tools, SQL optimization, and banking domain analytics.

Major Projects

1. SQL Automation with GenAI

• Situation: Manual SP creation and optimization were time-intensive.
• Task: Build an AI-driven SQL-to-SP automation tool.
• Action: Designed a 10-agent pipeline (SP generation, documentation, optimization, BRD creation). Built modular Streamlit UI with SQL Server authentication; integrated Ollama & OpenAI APIs for generation and validation.
• Result: Automated ~70% of repetitive SQL development tasks, freeing developers for strategic work.

2. GenAI – RAG-based Knowledge Assistant

• Situation: Business teams struggled with slow manual SQL query handling.
• Task: Develop a chatbot to convert text prompts into SQL queries and stored procedures.
• Action: Implemented a RAG pipeline with embeddings & vector DB for schema-aware retrieval. Integrated Ollama, Gemini, and SQL Server backend with Streamlit frontend.
• Result: Reduced manual SQL effort by ~60% and improved query turnaround speed.

3. Customer Segmentation using NLP & ML

• Situation: Needed better targeting based on customer feedback and transactions.
• Action: Processed and analyzed data using Pandas, NLP (tokenization, sentiment analysis), and clustering algorithms (KMeans, DBSCAN). Visualized insights using Streamlit dashboards.
• Result: Identified 4–5 customer clusters, improving campaign targeting efficiency by 25%.

• Designed BI reports using QlikView and Oracle for insurance and financial clients.
• Migrated legacy Excel dashboards to automated Oracle + QlikView systems.
• Built and maintained ETL workflows using Oracle PL/SQL for data warehousing and compliance.
• Collaborated with stakeholders to ensure data integrity and support regulatory reporting.

• Developed financial and operational reports using SQL and Excel automation for BFSI clients.
• Maintained database performance and backend integration for payment gateways.