Data Analyst
Infocowins Software Pvt Ltd · Jun 2024 – Present
- Designed and developed interactive Power BI dashboards with optimized Star Schema data models and DAX measures to track business KPIs across sales, operations, and customer performance.
- Wrote and optimized complex SQL queries (joins, subqueries, CTEs, window functions, stored procedures, views, triggers) to improve data retrieval efficiency and support business reporting.
- Performed end-to-end ETL operations using Power Query, SQL, and Python (Pandas) to clean, transform, and load data from multiple sources.
- Automated recurring reports and workflows using Advanced Excel, Power Pivot, and VBA, reducing manual reporting effort.
- Built fact-dimension data models (Star Schema) with dynamic date tables for scalable, high-performance reporting.
- Implemented Row-Level Security (RLS), drill-through, bookmarks, and dynamic titles to deliver stakeholder-specific, interactive dashboards.
- Conducted data validation, cleansing, and reconciliation to ensure accuracy and consistency across reports.
- Applied performance-optimization techniques to SQL queries and Power BI reports to reduce load times.

