Lakshmi Sai Kundeti

Business Intelligence Developer with 4+ years of experience delivering enterprise reporting, data analytics, and business intelligence solutions across financial services and healthcare. Skilled in SQL, Power BI, Amazon Redshift, Tableau, and data modeling to build scalable dashboards, optimize reporting performance, and support data-driven decision-making. Experienced in KPI reporting, data validation, query optimization, and cross-functional collaboration to transform complex data into actionable business insights.

Business Intelligence Developer - Allstate - USA

(2025-06)

• Engineered scalable Power BI, Amazon Redshift, and SQL data models to support insurance operations, claims, policy, and customer analytics, enabling faster KPI reporting across datasets exceeding 50M+ records.
• Designed interactive executive dashboards using Power BI, DAX, and optimized SQL queries to monitor claims performance, policy trends, customer retention, and operational KPIs, improving visibility for business and leadership teams.
• Optimized complex SQL queries using CTEs, window functions, and advanced aggregations within Amazon Redshift, reducing dashboard refresh times and improving reporting performance for enterprise-scale analytical workloads.
• Automated recurring reporting pipelines and scheduled data refresh processes using SQL and Power BI, reducing manual reporting effort while improving reporting consistency and delivery across Claims, Underwriting, and Operations teams.
• Implemented comprehensive data validation, reconciliation, and quality assurance processes using SQL, ensuring accurate reporting across policy, claims, and financial datasets while strengthening trust in executive dashboards.
• Partnered with Claims, Underwriting, Finance, Operations, and Data Engineering teams to translate business requirements into scalable BI solutions, delivering standardized KPI reporting and expanding self-service analytics capabilities.
• Performed trend, variance, and customer portfolio analysis using SQL and Power BI to identify operational improvement opportunities, support claims performance monitoring, and enable data-driven business decisions.

Business Intelligence Analyst - Mphasis - India

(2020-07 - 2023-11)

• Analyzed 100M monthly healthcare datasets using SQL and BI tools, supporting KPI tracking, revenue cycle reporting, and operational decision making across multiple business units to improve business performance.
• Developed interactive dashboards in Power BI and Tableau to track SLA performance, financial metrics, and operational KPIs, improving reporting visibility for stakeholders across business functions supporting informed decisions.
• Assisted in designing dimensional data models using star schema for reporting data marts, contributing to improved dashboard performance and scalability across analytics and reporting systems in enterprise environments.
• Optimized SQL queries across PostgreSQL and Oracle, reducing execution time by 40% and improving report generation efficiency for large scale datasets and analytical workloads supporting faster insights delivery.
• Collaborated with cross functional teams including Finance, Operations, and Product to gather requirements and deliver data driven reporting solutions supporting business decisions and operational improvements across business units.
• Performed trend, cohort, and variance analysis to identify operational patterns and support business decision-making.
• Automated recurring reporting processes using SQL and scripting, supporting data extraction, transformation, and reporting workflows, reducing manual effort by 45% and improving turnaround time.
• Supported implementation of data validation and reconciliation checks, improving data accuracy and consistency across reports.
• Delivered ad-hoc analysis and reports to support operational improvements and day-to-day business decisions.

Masters - Computer Science - University of Central Missouri (2024-01 - 2025-12)