● Solid experience in Microsoft Fabric and Azure Cloud with different services like Azure Blob Storage, Azure Data Factory, Azure Virtual Machines, Key Vault, Azure SQL MI, Data Bricks, Azure Logic Apps, Azure Analysis Services.
● Engaged in end-to-end Data Analytics project lifecycle, from data ingestion to reporting with Power BI, leveraging batch and real-time processing for descriptive analytics and applying machine learning techniques for prescriptive analytics.
● Collaborated closely with business stakeholders to understand objectives, align priorities, and translate business needs into clear, actionable technical requirements
● Contributed significantly to the migration project from On-premises to Azure Cloud and worked on various data use cases project for data integration, data analysis and report delivery.
● Architected and deployed a distributed, cloud-native data platform (Microsoft Fabric) that processes gigabytes of data per day across multiple regions
● Created data pipelines using Data Factory to extract data from various source systems – ERP, Rest API(OAuth), SharePoint, Shared Drives, different file formats (csv, JSON, parquet) into Analytics platform.
● Developed and optimized data ingestion pipelines using notebooks (PySpark/Spark SQL) to load data from source to medallion architecture layers (bronze,silver,gold), Designed and managed Delta tables, implementing ACID transactions, schema enforcement, and time travel features for reliable analytics
● Strong experience in SQL development using T-SQL for handling business logics. Good experience in creating dynamic procedures, usage of analytics functions, cursors, loops, creating database objects.
● Expertise knowledge in core Data Modeling using Azure Analysis Service and SSAS by building relationships, transforming data, created Hierarchies, created KPIs for metrics for better decision making.
● Access management to end users based on Role Levels in Power BI workspace and in data models using Azure Active Directory for different reports. Hands on experience in applying Row Level Security to restrict access to measures and KPIs inside the report.
● Set up Data Quality Framework for analytics on different business scenarios for monitoring, logging, and alerting pipelines to ensure visibility into data platform health, latency, and error rates.
● Good experience in performance tuning of the jobs by creating indexes, keys and changing business conditions to improve performance
● Experience with CI/CD using Azure Pipelines for build & deployments of the code; Maintaining the code in Azure Repos