• Excel in extracting, transforming, and loading raw data into warehouses, fueling analytics and insights while ensuring data integrity.• Developed robust Power BI reports and dashboards for in-depth visualizations.• Developed SSIS packages and a Web UI/UX application for front-end SSIS job execution, resulting in a 38% optimization in SSIS package execution.• Developed Power Automate flows to automate the end-to-end process, including data cleansing and email notifications.• Expertise in database objects, such as tables, stored procedures, views, indexes, and functions, collaborating with DBA teams to ensure performance and security. • Specialized in developing Canvas Apps and Model-Driven Apps for secure patient data management, user-friendly appointment scheduling interfaces, EMR integration, claims processing automation, and robust reporting for healthcare systems.• Implemented version control systems in Azure DevOps to manage report and data model changes, making it easier to roll back to previous versions if needed.• Tuned refresh for Power BI Import mode throughput and monitored Power BI dataset refresh memory and CPU usage with Log Analytics.• Used DAX Studio to know performance of Data Model and to clear the Vertipaq Engine cache.• Performed Sentimental analysis on Healthcare Measures and Walmart products using R Programming and Text Analytics from Azure Cognitive Services in Power Query • Developed Python Custom visuals in Power BI Desktop using Pandas and Matplotlib libraries.• Created a PowerShell package for deploying Pbix and RDL files to the Power BI Report Server, leading to substantial time and resource savings.

• Collaborated with cross-functional teams, provided premium support to customers in resolving issues in Power BI Desktop, Power BI Service, and Gateway usage.• Implemented data security, Managed workspaces, and report scheduling, ensuring real-time updates for diverse clientele in EMEA and APAC regions.• Excelled in building reporting dashboards, data modelling, and data pipeline creation while maintaining and optimizing multiple Power BI dashboards for customers.• Configured Gateways for automated refreshes, produced paginated reports, and served as a Power BI Service Administrator to meet customer-specific requirements.• Supported self-serve analytics, visualizations, and data alerts, addressing performance issues, and optimizing reports and Dataset queries.• Managed subscriptions and refresh extracts, ensuring business-critical data access and satisfaction for customers in both EMEA and APAC regions.• Expertise in Testing Performance of Power BI Reports in the Browser and In SQL Server Profiler• Resolved break and fix issues and provided solutions in Power BI Community to customers.

• Understanding business requirements from stakeholders and providing tailored insights.• Analyzing raw data to extract valuable data points for business enhancement.• ETL (Extract, Transform, Load) processes to fuel analytics and business insights.• Developed stored procedures, functions, and triggers for deriving multiple insights.• Collaborating with major clients like Pepsi, Kellogg’s, Campbell’s, and Pfizer.• Replicating Excel logic in data modelling for accuracy assessment.• Designed charts, graphs, and interactive Power BI reports.• Efficient data replication and automation through data models.• Implemented complex SQL cube and rollup logic to aggregate data at various levels, enabling insights into product adjacencies and brand blocking, while collaborating with major clients like Pepsi, Kellogg’s, Campbell’s, and Pfizer.• Leveraged Python Apriori algorithm for market basket analysis, revealing product affinities and optimizing strategies for Pepsi, Kellogg’s, Campbell’s, and Pfizer retailers. These insights benefited from data-driven decision-making, improving their market competitiveness and overall business performance KPIs.