• Designed and developed Proof of Concepts (POCs) according to business user requirements.• Implemented best practices and enforced code consistency across development, test, pre-production, and production environments.• Developed automated data refresh schedules using Power BI Service to ensure real-time data availability, reducing manual data update efforts.• Worked with the migration of Data Analytics from Tableau to Power BI, designing and implementing the migration process.• Designed and developed dashboards, scorecards, and KPIs in Power BI to provide actionable insights to stakeholders.• Utilized DAX functions for calculated columns and measures, including Calculate Table, Filter, YTD, QTD, and other time intelligence functions.• Developing and maintaining Power BI reports with drill-through actions and tooltips to provide additional context and detail.• Created daily jobs for data dumps to support various teams’ data requirements.• Implemented security measures using Row-Level Security (RLS), both static and dynamic, to control access to sensitive data.• Developing custom DAX (Data Analysis Expressions) measures and calculations in Power BI to derive meaningful insights from data.• Developed and maintained ETL process monitoring dashboards to provide insights into ETL performance and trends• Installed gateways and configured scheduled data refreshes using on-premises data gateways as per business requirements.• Deployed SSIS packages, SSRS reports, and SSAS cubes using command-line utilities, ensuring efficient data processing and reporting.• Implementing data governance policies and procedures to ensure data quality, consistency, and compliance within Power BI and MSBI solutions.• Monitor and report on key performance indicators (KPIs) and metrics related to master data quality and governance.• Continuously evaluate and improve MDM processes, tools, and technologies to adapt to changing business needs and requirements.

• Extracted data from OLTP and OLAP sources using SSIS, leveraging various tasks and transformations in Control flow and Data flow items.• Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.• Conducted thorough data analysis to identify trends, patterns, and insights that informed business decisions.• Developed SSIS packages to extract data from multiple sources and consolidate it into a single source for Power BI reports.• Managed project insights via Azure DevOps, tracking assignments and providing daily progress updates.• Developed calculated columns and measures using DAX in Power BI to enhance data analysis capabilities.• Utilized tabular model cubes as sources in Power BI to visualize data effectively.• Collaborate with cross-functional teams to define and implement Master Data Management (MDM) strategies and policies.• Performed data cleaning and transformation tasks to prepare data for analysis, improving data quality and reliability.• Supported senior analysts in data modeling and report development, contributing to the delivery of high-quality BI solutions.• Conducted data profiling and data validation to ensure data accuracy and completeness during ETL processing.• Conducted ad-hoc data analysis to support business decisions, providing timely insights to stakeholders.• Conducted exploratory data analysis (EDA) to uncover hidden insights and relationships in the data.• Performed data cleansing and preprocessing tasks to ensure data quality and consistency.• Developed and managed SSAS Tabular models, including the design of Dimension and Fact Tables.• Conducted statistical analysis on datasets to derive actionable insights and support decision-making.• Implemented DAX Expressions and managed Partitions in Tabular models for efficient data analysis.• Designed shared dimension tables, measures, hierarchies, levels, cubes, and aggregations on MS OLAP/OLTP/Analysis Server (SSAS) in Tabular Model.

• Gathered and refined requirements from customers to develop reports in Power BI.• Created data analytics and visualizations using Power BI, integrated with SharePoint via Power View.• Developed business calculations using DAX/MDX queries.• Built and published customized interactive reports and dashboards, and scheduled reports using Power BI service.• Developed Power BI visualizations and dashboards using Power BI Desktop.• Created grouping, sorting columns, and wrote expressions according to business requirements.• Transferred data using SSIS packages.• Developed complex SQL queries, stored procedures, triggers, functions, and views to support application development and reporting requirements.• Optimized SQL queries for performance improvements, ensuring efficient data retrieval and manipulation.• Designed and implemented database schemas, including tables, indexes, and relationships, to support business applications and data warehousing.• Conducted database performance tuning and optimization using indexing strategies, query analysis, and optimization techniques.• Extensively worked with the SSIS tool suite, designed, and created mappings using various SSIS transformations such as OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast, and Lookup.• Used SSIS to create ETL packages for validating, extracting, transforming, and loading data into Data Warehouse databases.• Created SSIS packages to export data from text files to SQL Server Database.• Developed SQL Server Reports and wrote queries for generating drill-down and drill-through reports using SSRS.• Identified and worked with parameters for parameterized reports in SSRS.• Used SSRS to create, customize, and generate on-demand and ad-hoc reports; involved in analyzing multi-dimensional reports.• Generated ad-hoc reports on a timely basis to meet immediate requirements.• Utilized star and snowflake schema designs for creating SSAS packages.