Power Bi Sql Server

Power BI /SSIS /SQL Server Developer

S. Mahammad Rafi

Mobile No: +91-970*******

Email: **********@*****.***

Professional summary:

• Having around 5.2 years of experience in working with Business Intelligence using Microsoft Technologies as a Power BI Developer along with SQL Server and SSIS.

• Good experience in Power Query for data extraction and transformation, Power Pivot for data modeling, Power View for interactive visualizations, and Power Map for geographical data visualization.

• Developed and deployed Power BI reports and dashboards, including maps, line charts, and pie charts.

• Ensured data Quality and integrity through effective data cleaning techniques, and analyzing the data sources from Excel/SQL Server to design and test reporting solutions in Power BI.

• Created Calculated Measures and Columns using DAX functions, including Date and Time, Filters, and arithmetic Functions.

• Having experience in creating new measure for YTD, MTD, QTD growth analysis in power desktop.

• Installed and managed Power BI Gateways for scheduled data refreshes and ensured dashboard accuracy and collaborating with stakeholders to understand their data needs and requirements.

• Collaborated with business users to gather requirements and develop Power BI reports and visualizations.

• Experience in Imported and processed data from SQL Server into Power BI for comprehensive reporting and applied various filters in Power BI, including Visual, Page, and Report Level Filters.

• Designing and creating data models, dashboards, reports, and other data visualizations, Troubleshooting and resolving issues with Power BI solutions.

• Experience in using Azure Data Factory for building, scheduling, and monitoring pipelines to move and transform data across cloud and on-premises sources.

• Experience in Developing and optimized SQL database solutions, including stored procedures and functions using correction projects, such as resolving issues with duplicate values in databases.

• Experience in implement Row-Level Security on data and have an understanding of application security models in Power BI.

• Expertise in SQL sub-languages and in creating the database tables. Improve the database Performance and Availability.

• Good experience in writing the simple and complex Queries by using joins, Sub Queries, CTE to validating the data.

• I have experience on Query optimization in SQL. Analyzed and optimized slow- performing queries by examining execution plans, missing indexes, and parameter sniffing issues

• Replaced cursors and nested loops with set-based operations and window functions to improve performance by over 70%.

• Good experience in concepts like Temp tables, views, stored procedures, joins, Indexes and Constraints.

• I have used some of the functions like Aggregation functions, string functions, Rank functions, Date and Time functions, Null functions and convert functions.

• Experience in ETL processes using SSIS, including Data Flow tasks, Execute SQL tasks, and Bulk Insert tasks.

• Good experience in ETL to extracting the data different sources and perform the various Transformations like multi cast, conditional split, Sort transformation, merge, Union all and Aggregation Transformation and Load the data different destinations.

• Designed and implemented ETL processes using power Query to transform and load data into Power BI Desktop.

• Excellent communication, analytical, and problem-solving skills. Educational Qualifications:

• M.tech in Jawaharlal Nehru Technological University Kakinada 2019 PROFESSIONAL EXPERIENCE

• I worked as a Software Engineer at DELTA ITECH SOLUTIONS from April 2020 to June 2025

Technical Skills:

• Reporting tool : Power BI

• Database : SQL Server

• ETL tool : SSIS

• Operating Systems : Windows

• And I have experience on Azure data factory and Python

• I have good knowledge on AWS

Project: 1

Project Name: United Health Group

Role: Power BI Developer

Tools: Power BI, SQL Server, SSIS, Azure Data Factory Project Description:

United Health Group Incorporated is an American for-profit managed health care company based in Minnetonka, Minnesota. It offers health care products and insurance services. In 2020, It was the second-largest healthcare company (behind CVS health) by revenue with

$257.1 billion, and the largest insurance company by Net Premiums. United Health care revenues comprise 80% of the Group’s overall revenue. Roles & Responsibilities:

• Involved in reviewing business requirements and analyzing data sources from Excel/SQL server for design, development, and testing and production roll over of reporting and analysis project within Power BI Desktop.

• Developed and scheduled ADF pipelines to automate data integrate from SQL Server to Azure storage for Power BI reporting.

• Integrated ADF with Power BI to enable near real-time data reporting via Blob storage and schedule refreshes.

• Used different types of filters in Power BI Visual level filters, Page level filters, Report level filters, Drill through the Filter and Slicer.

• Created various Power BI reports like Maps, Line charts, Area Charts, Column Charts, Bar Charts, Pie Charts and Donut Charts

• Worked on Power BI transformations split columns, Group by Column, Append Queries, Merge Queries, Pivot and Custom Columns.

• Crated calculated Measures and Columns with DAX Functions, worked on some of the DAX Functions those are Date and Time, Filters, Logical and Text Functions.

• Installed Power BI Gateways to keep the dashboards and reports up to date by scheduling the refresh.

• Combined views and reports into interactive dashboards in Power BI Desktop that were presented to Business Users, Program Managers, and End Users.

• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.

• Created reports using time intelligence calculations and functions, worked on all kind of reports such as yearly, quarterly, monthly, and daily.

• Executed dashboard setups and data manipulation using DAX.

• Participated in meetings, reviews, and user group discussions as well as communicating with client and users.

• Extracted data from different sources into staging area than cleaned the data using appropriate business rules and load the information into target tables.

• Worked on different control flow tasks for designing SSIS package like Data flow task, Execute SQL task, Bulk insert task, Execute package Task.

• Good experience on scheduling packages, package and project deployment and environment setup.

Project: 2

Project Name: Saipem Reporting & Analysis

Client : Saipem S.P.A

Role : Power Bi Developer

Description:

Saipem S.p.A. (Società Azionaria Italian Perforazioni E Montaggi lit. Drilling and Assembly Italian Public Limited Company) is an Italian multinational oilfield services company and one of the largest in the world. Until 2016 it was a subsidiary of Italian oil and gas supermajor Eni, which retains approximately 30% of Saipem's shares. Roles & responsibilities:

• Involved in reviewing business requirements and analyzing data sources from Excel/SQL Server for design, development, and testing and production rollover of reporting and analysis project within Power BI Desktop.

• Used different types of filters in Power BI Visual level filters, Page Level Filters, Report Level Filters, Drill through the Filter and Slicer.

• Created various Power Bi reports like Maps, Line charts, Area Charts, Column Charts, Bar Charts, Pie Charts and Doughnut Charts.

• Worked on Power BI transformations Split Columns, Group by Column, Append Queries, Merge Queries, Pivot and Custom Columns.

• Created Calculated Measures and Columns with DAX Functions, worked on some of the DAX Functions those are Date and Time, Filters, Logical and Text Functions.

• Installed Power BI Gateways to keep the dashboards and reports up to date by scheduling the refresh.

• Combined views and reports into interactive dashboards in Power BI Desktop that were presented to Business Users, Program Managers, and End Users.

• Good experience in row level security, Scheduled Automatic refresh and scheduling refresh in power bi service and data modeling in power pivot.

• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.

• Good experience on Scheduling packages, Package and project deployment and environment setup.

• Extracted data from different sources into staging area then cleaned the data using appropriate business rules and load the information into Target tables.

• Expertise in SQL sub-languages and in creating the database tables. Improve the database Performance and Availability.

• Good experience in writing the simple and complex Queries by using joins, Sub Queries, CTE to validating the data.

• Good experience in concepts like Temp tables, views, stored procedures, joins and Constraints.

• I have used some of the functions like Aggregation functions, string functions, Rank functions, Date and Time functions, Null functions and convert functions.

• Experience in ETL processes using SSIS, including Data Flow tasks, Execute SQL tasks, and Bulk Insert tasks.

• Good experience in ETL to extracting the data different sources and perform the various Transformations like multi cast, conditional split, Sort transformation, merge, Union all and Aggregation Transformation and Load the data different

• Designed and implemented ETL processes using power Query to transform and load data into Power BI Desktop.

• Worked on different control flow tasks for designing SSIS package like Data flow task, Execute SQL task Bulk insert task, Execute Package Task. Project :3

Project Name: Reliability Reporting Systems

Role: SQL Developer

Environment: SQL Server, ETL TOOL(SSIS)

Project Description:

The objective of the application is to extract data, securely transmit it to a data Warehouse, standardize the content, and generate reports. The project includes around 10-12 data sources whose data is merged together and put into a single database using various business logics to develop a complex cube with various perspectives and measure groups. It also involves complete understanding of their business and sales cycle model.

Roles and Responsibilities:

• Creating staging database for temporary processing of data, consolidating data and Loading into Target database using Integration services.

• Extract the Data from Heterogeneous like Flat files, Excel files & Multiple Database source systems like SQL server.

• Creating Packages on SSIS by using different data Transformations like Derived Column, Conditional Split, Multicast, Sort and Execute SQL Task in Dataflow level to load data into data warehouse.

• Created Packages using for loop Container, for-each loop Container & Sequence Container.

• Scheduling Jobs to execute SSIS packages using SQL SERVER AGENT.

• Involved in Incremental loading.

• Involved in Error Handling using Event Handlers, Progress Tab & Logging.

• Writing Queries, joins, stored procedure & Implemented Indexes for better Performance of Package.

• Created Configuration files for moving the packages from one environment to another environment.

• Implemented Breakpoints and Checkpoints.

• Involved in cube Testing.

• Created Table, Matrix, chart Reports according to the Requirement.

• Implement Drilldown and Drill Through reports.

Contact this candidate