Shreya Upadhye

Data Analyst

Cognizant Technology Solutions

Jun 2023 - Present

Built and maintained 10+ Power BI dashboards across sales, inventory, and operations, cutting manual report preparation time by an estimated 30% through automation and reusable templates. Designed interactive dashboards using custom visuals and UX best practices, improving report adoption among 20+ non-technical business users across Sales, Supply Chain, Operations, and Finance. Configured row-level security (RLS) and workspace-level access across multiple Power BI workspaces, ensuring secure, role-based data visibility for stakeholder teams. Managed report deployment, scheduled refreshes, and on-premises gateway configuration, maintaining refresh reliability while integrating Power BI reports into external applications via embedded analytics. Wrote SQL queries, joins, CTEs, subqueries, and stored procedures against enterprise data warehouse tables to extract and prepare reporting-ready datasets from multiple source systems. Built ETL and data mining processes in SQL and Power Query to clean, validate, and transform large datasets, catching and correcting data-quality issues before they reached the reporting layer. Designed scalable star-schema data models and developed complex DAX measures and calculated KPIs supporting executive-level management reporting. Applied data governance, security, and compliance practices when handling sensitive business and financial data across dashboards and reports. Gathered and documented business requirements with stakeholders, translating them into KPI definitions and actionable dashboards. Automated recurring reporting workflows using SQL, Python, and Power BI, reducing manual reporting. Performed data cleaning, validation, and reconciliation across large datasets, improving reporting accuracy and resolving data/reporting issues raised by business users. Conducted trend, variance, and root-cause analysis, delivering findings in monthly and quarterly management reports reviewed by leadership.