Soujanya Dasari

Data Analyst

Tata Consultancy Services

Jun 2023 - Present

Performed end-to-end data analysis on enterprise datasets, translating business questions into Power BI dashboards and reports that tracked KPIs and operational performance for stakeholders. Acted as go-to Power BI and data analysis SME, guiding peers through complex data model and reporting issues and leading internal knowledge-sharing sessions. Led data migration and analysis effort to move an enterprise Qlik Sense privacy dashboard to Power BI, reverse-engineering 20+ business metrics and rebuilding the underlying data model on SAP HANA, improving report load time by 20% and overall scalability. Collected and integrated data from Snowflake, SAP HANA, SQL Server, and Excel into unified datasets to support consistent, accurate business reporting. Applied statistical logic and advanced DAX calculations to analyze trends, calculate KPIs, and support data-driven decision-making for business stakeholders. Cleaned, transformed, and validated data using Power Query, reducing data prep time by 35% and improving the accuracy and reliability of downstream reports. Used SQL to query, extract, and analyze large datasets from enterprise databases, streamlining data availability for reporting and reducing manual data-pull effort. Implemented Row-Level Security (RLS), drill-through views, hierarchies, and bookmarks to make dashboards secure, intuitive, and easy for non-technical stakeholders to navigate. Owned monthly data analysis and reporting for an internal leadership analytics program (Analytics Ninja), presenting findings and recommendations to senior stakeholders. Applied data visualization best practices, including optimal chart selection, KPI-focused layouts, and consistent formatting, to make complex data easier to interpret and act on. Built reusable reporting templates and contributed to BI governance and documentation standards, cutting development time by 25%. Leveraged Microsoft Copilot and GitHub Copilot to speed up data analysis, DAX/Power Query development, and reporting workflows. Built a Python-based proof of concept analyzing and automating secure file transfers between Qlik Sense and a Digital Rights Management (DRM) system, achieving 100% protected downloads and reducing report distribution time by ~40%.