Data Analyst/BI Consultant at Infosys - Canada

Designed and implemented ETL pipelines using Azure Data Factory and SSIS to integrate sales, promotions, and inventory data across 120+ stores. Built interactive Power BI dashboards with advanced DAX measures for real-time sales and product performance tracking. Modeled data using star and snowflake schemas and built SSAS cubes for multidimensional analysis. Automated dataset refreshes and deployments through Git-based CI/CD pipelines, improving reporting efficiency by 30%. Partnered with cross-functional teams to translate KPIs into visual insights, enhancing decision-making for category managers. Multi-Store Operational Insights (Azure+ Power BI): Developed Power BI dashboards to monitor KPIs like footfall, staffing efficiency, and product availability. Built end-to-end ADF pipelines integrating HR, ERP and store performance data. Implemented row-level security for regional data access and governed workspace permissions. Enable 12% improvement in regional performance through action

Data Analyst/ ETL Developer at CTS - INDIA

Retail Data Migration to Hybrid Cloud Warehouse (Azure): Migrated 7+ years of transactional and customer data from on-prem OLTP systems to Azure SQL and SQL Server 2016. Built dynamic SSIS packages and PowerShell scripts for data ingestion, scheduling, and monitoring. Conducted data profiling, cleansing, and validation using T-SQL and metadata audits to ensure 100% accuracy. Delivered Power BI and SSRS reports post-migration, enabling real-time sales visibility for leadership. Documented source-to-target mappings and trained business users in dashboard navigation and SQL queries for ad-hoc analysis.