Lakshmi Prasanna Kottakota

Data Analyst

Tata Consultancy Services Limited

Sep 2024 - Present

Gathered business requirements from stakeholders and developed interactive Power BI dashboards using KPIs, slicers, filters, drill-through, and bookmarks. Automated business reporting, reducing manual reporting effort while enabling faster, data-driven decision-making across multiple business teams. Designed scalable Star Schema data models and developed DAX measures, calculated columns, and KPIs. Performed ETL using Power Query, SQL, and Excel to cleanse and transform data, improving reporting accuracy and ensuring consistent, high-quality datasets. Performed optimized SQL queries using Joins, CTEs, Window Functions, Aggregate Functions, and Views to retrieve and analyze large datasets. Improved query execution and delivered reliable datasets supporting Business Intelligence and analytical reporting. Published reports to Power BI Service, configured scheduled refreshes, managed workspace access, and implemented Row-Level Security (RLS). Collaborated with business stakeholders, QA teams, and Agile cross-functional teams to deliver secure, scalable BI solutions while ensuring timely project delivery and reporting governance.