Led the development and customization of a full-featured Business Intelligence (BI) platform using Apache Superset, tailored to handle large-scale datasets and deliver secure, real-time analytics to cross-functional teams. 🔧 Key Contributions: ✅ Custom Feature Development Custom Superset Plugins: Developed and integrated custom visualization and data source plugins to support business-specific metrics and non-standard data workflows. SSO Integration: Implemented secure, enterprise-grade Single Sign-On (SSO) using OAuth2 and JWT to streamline authentication and improve user management. Dashboard Embedding: Enabled seamless dashboard embedding into internal tools with granular token-based access and scoped data views for specific users/roles. Custom Report Scheduling: Built a Jinja2-powered custom reporting engine that generates dynamic scheduled reports, supporting conditional formatting and logic-based templates. Jinja Templating: Extensively used Jinja for building dynamic filters, SQL-based conditions, and custom alerts in reports and dashboard queries. 📊 Data & Analytics Work Created advanced dashboards for order lifecycle analysis, system health monitoring, vendor onboarding, and conversion funnels. Modeled virtual datasets and materialized views to reduce query complexity and optimize dashboard performance. 🔐 Security & Access Control Designed role-based access control (RBAC) and row-level security (RLS) for multi-tenant analytics environments. Configured secure reverse-proxy deployment using NGINX and enabled HTTPS across the stack. 🚀 Automation & DevOps Set up CI/CD pipelines for deploying Superset custom builds and plugins via Docker and GitHub Actions. Automated report delivery to stakeholders via email, improving engagement and cutting down ad-hoc queries by 70%.