- Set up and ran Power BI Environment, creating app workspaces, publishing apps, and setting up Power BI Gateway.- Worked in Reconciliation of Data By Creating Different Databases.- Data Integration Reconciliation.- Published Power BI Reports in the required originations and made Power BI Dashboards available in web clients.- Involved in creating data visualizations like Clustered Column Chart, Line Chart, Slicer, Gauge Visualization etc. with Power BI.- Utilized Power BI gateway to keep dashboards and reports up to date with on premise data sources.- Developing visual reports, dashboards and KPI scorecards using Power BI desktop- Sharing of Power BI reports and managing workspaces in Power BI service.- Created views, triggers, user defined functions to incorporate the flow of business and automated stored procedures.- Coded and tested SQL queries based off the persistent table using Inline Views, Dynamic SQL, Merge statements. - Involved in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes.- Data management and data processing solutions using SSIS, this includes Error Handling and Slowly Changing Dimensions.- Worked with various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, ftp task, send mail task.- Designed and implemented End-to-end Data pipelines in Databricks, integrating various data sources , performing ETL operations , and ensuring data quality and consistency.- Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers.- Querying and manipulating multidimensional cube data through MDX Scripting in SSAS.- Wrote extensive T SQL / P SQL query for Join conditions, Unions, Aggregations and Expressions for SSRS Report

- Gathered report requirements and determined the best solution to provide the results in Power BI reports to support organizations strategic decisions.- Worked on DAX query to create calculated columns and calculated measures based on Requirements. - Developed Power BI dashboards, visualizations, and interfaces with SharePoint and SSRS to deliver meaningful and actionable insight. - Set up and ran Power BI Environment, creating app workspaces, publishing apps, and setting up Power BI Gateway.- Published Power BI Reports in the required originations and made Power BI Dashboards available in web clients.- Involved in creating data visualizations like Clustered Column Chart, Line Chart, Slicer, Gauge Visualization etc. with Power BI.- Utilized Power BI gateway to keep dashboards and reports up to date with on premise data sources.- Developing visual reports, dashboards and KPI scorecards using Power BI desktop- Integrate Power App with Power BI to enable the write back feature from Power BI.- Sharing of Power BI reports and managing workspaces in Power BI service.- Created views, triggers, user defined functions to incorporate the flow of business and automated stored procedures.- Proficient in leveraging ServiceNow reporting an Analytics Capabilities to extract meaningful insights from IT service management data.- Demonstrated expertise in extracting and transforming data from various ServiceNow modules, such as incident management, change management and problem management.- Coded and tested SQL queries based off the persistent table using Inline Views, Dynamic SQL, Merge statements. - Involved in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snowflake Schema for developing Cubes.- Created SSIS packages to extract, transfer and load data into the data warehouse on the daily basis.

- I worked on maintaining the reports in Power BI services and sharing with other team members in the organization.- Granted users access to different capabilities in ThoughtSpot.- Used Power BI Power Pivot to develop data analysis prototype and used Power View and Power Map to visualize reports.- Designed and developed Power BI dashboards, Reports and published it on Power BI sites.- Published Power BI reports from Power BI desktop to Power BI service.- Setting up Power BI Environment, creating app workspaces, publishing applications and setting up Power BI Gateway. - Collaborated with Cross-functional teams by sharing Databricks notebooks and insights, facilitating effective communication and data driven decision making.- Used various sources to pull data into Power BI such as SQL Server, SAP BW, Oracle, SQL Azure etc.- Generated dashboards in POWER BI Desktop and POWER BI Service using super-fast slice and dice and modern data visualization features. - Implemented Copy activity, Custom Azure Data Factory Pipeline Activities. Primarily involved in Data Migration using SQL, SQL Azure, Azure storage, and Azure Data Factory, SSIS, Power Shell.- Worked on creating SQL Server Reports, handling sub-reports, and writing queries to perform Drill through and drill down operations in SSRS. - Designed and developed new ETL/SSIS package that load data from OLTP into our existing Data Warehouse based on technical specifications and business requirements. - Created C# applications to load data from Azure storage blob to Azure SQL, to load from web API to Azure SQL and scheduled web jobs for daily loads.- Implemented Copy activity, Dataflow, Trigger in Azure Data Factory Pipeline Activities for On-cloud ETL processing.- Created packages and scheduled them in SQL Agent jobs to get data from OLTP.- Designed, Developed and Deployed reports in MS SQL Server using Microsoft SQL Server Reporting Services (SSRS).

- Worked on Power BI Power Pivot to develop data analysis prototype and used Power View and Power Map to visualize reports.- Responsible for creating Ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning.- Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.- Worked on Creating custom visuals using Python and R# which is integrated into Power BI.- Developed Power BI Reports and Dashboards from multiple data sources using data blending.- Scheduled jobs for creating snapshot of Power BI Reports and Dashboards and troubleshooting on datasets for Power BI sites. - Involved in Data Migration, Developing Automated Test Scripts in Python and SQL to validate the data migrated from the Source to Target Systems involving NPI data.- Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.- Utilized Power Query in Power BI to Pivot and Un-pivot the Data model for Data cleansing and data massaging.- Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI. - Used various sources to pull data into Power BI such as SQL Server, SAP BW, Oracle, SQL Azure etc.- Writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors and User Defined Functions to implement the business logic.- Worked on Creating SQL Server Reports using SSRS and exported them to Excel format for managers and QA team for easy validation. - Deploying and scheduling reports using SSRS to generate daily, weekly, monthly, and quarterly reports run periodically. - Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers and Fuzzy Lookups etc. - Migration experience with DTS.- Worked on DAX calculated columns in power pivot worksheets to extract, import and join data that coming from different sources.

- Developed simple and complex TSQL Queries, Views, Triggers, and Stored Procedures that were implemented in different phases of the project.- Performed ETL process to load data from various sources like Excel, OLE DB and flat files into an upgraded database using SQL Server Integration Services (SSIS).- Used Conditional Split, Data Conversion, Derived Column, Merge Join and Sort All in different SSIS packages based on requirements. - Developed multiple complex ETL pipelines and activities stores for full and incremental data loads into Azure SQL DW. - Primarily involved in Data Migration using SQL, SQL Azure, Azure storage, and Azure Data Factory, SSIS, PowerShell.- Applied logging, error handling using event handler, break point, check point and custom logging for SQL Server Integration Services (SSIS) Packages.- Performed data cleansing using various transformation processes in SSIS, such as Slowly Changing Dimensions, Look up, Fuzzy Lookup, Aggregate, Derived Column, and Conditional Split.- Provided technical support to the operational data source ETL team in solving some of the major issues in SQL Server Integration Services (SSIS) projects development.- Created clustered, non-clustered indexes to optimize query performance using SQL Server Integration Services (SSIS). - Created mapping tables to find out the missing attributes for the ETL process. - Created SSRS data models projects using Microsoft Visual Studio and Reports Builder.- Developed reports models with report builder to support ad-hoc requests from users and management outside of scheduled work using SQL Server Reporting Services (SSRS).- Created Tables, Matrix and Charts reports as required and deployed those reports into Report Server.- Created scheduled and Ad-hoc reports using SQL Server Reporting Services (SSRS) to generate daily, weekly, monthly.- Worked to tune the SQL queries using SQL Profiler.

- Created SSIS Packages for integrating data using OLE DB connection from Heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all. - Created custom T-SQL procedures to read data from flat files to dump to SQL Server database using SQL Server import and export data wizard.- Created SSIS packages to populate data from various data sources.- Performance tuning, and optimization of procedures and queries.- Involved in Requirements gathering, Analysis and design of all the client requirements.- Developed ETL process using SSIS with Various Control Flow, Data Flow task and Store Procedures for Work Order Validation process. - Perform ETL data imports, exports, and modifications. - Collected requirements from business heads and Build Custom ETL process to automate the integration data flow.- Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Database.- Deployed reports & created report schedules and subscriptions. Managing and securing reports using SSRS.- Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheet, Text file, MS Access and CSV files to database.- Created many Complex Stored Procedures/Functions and used them in Reports directly to generate reports on the fly.- Used Joins, Correlated and Uncorrelated Sub-queries for Complex Business Queries involving.- Multiple tables & calculations from different databases.- Developed different types of reports like Tabular Reports, Matrix Reports, Drill-Down, Cross Tab Reports, Ad hoc reports, Drill through reports.