Subham Saha

AI Conversational Analytics Platform

• Built an end-to-end AI analytics solution by ingesting operational data into Snowflake and creating curated analytical datasets.
• Developed semantic models defining business metrics and dimensions to enable accurate interpretation of natural language queries.
• Implemented Snowflake Cortex Analyst to convert business questions into optimized SQL queries using LLM-powered text-to-SQL capabilities.
• Created an AI agent in Snowflake Intelligence to provide conversational analytics, allowing users to ask questions like “Show the dates that have maximum sales in January” and automatically retrieve insights from Snowflake datasets.
• Delivered a self-service analytics interface, allowing business users to explore operational data without writing SQL.

Power BI Dashboards

• Developed interactive Power BI dashboards to visualize profit, expenses, and key business KPIs, enabling stakeholders to analyze dealership performance by store ID with a single click. This solution replaced four static PDF reports, improving reporting efficiency and accessibility.
• Built a Power BI dashboard to track JIRA tickets raised by the team with monthly, quarterly, and yearly insights, streamlining monitoring and reducing manual reporting workload by 80%.
• Automated the team’s data validation process by developing optimized SQL queries in Snowflake, improving data processing efficiency and accelerating team performance by 70%.

• Performed in-depth analysis to drive insights from different data related to operations that drive key business decisions and generate high revenue by reducing 70% defect inflow and enable visualizations to get more clarity on organization data.
• Generated backend using SQL to visualize data according to business requirement through Dashboard.
• With the help of the Dashboard the dedicated team works on the most priority case and fix it or one can use this dashboard to analyze different data like number of defects opened/closed in a particular month of a particular year.