Power Bi Sql Server

Suresh. T

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

Ph : +91-939*******

Having 6+ years of experience in IT on BI Tools/Technologies using Tableau, Power BI and SQL Server

3+ years of hands-on experience in, Power BI

Hands on Experience in installing, configuring, managing, monitoring and troubleshooting SQL Server 2019/2017/2016.

Hands on Experience in working with Quick sight and Power BI.

Hands on Experience in working with POWER BI.

Connect Tableau to data source and ensure efficient data retrieval via SQL queries.

Develop, design, and maintain interactive and insightful Tableau and Power Bi dashboards and reports.

Collaborate closely with business stakeholders, data engineers, and front-end developers to gather requirements and translate them into visual analytics.

Created and managed schema objects such as Tables, Views, Indexes and referential integrity depending on the requirements and converting them into technical specifications.

Experienced in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using Tableau.

Enhanced dashboard performance by optimizing LOD usage and reducing dependency on complex joins or custom SQL.

Experienced in creating various Parameterized, Linked and Drill-through & Drill-down reports.

Worked to enforce consistency in data warehouse for naming conventions and data types.

Hands on experience on Data Blending.

Designed and Deployment of Reports for the End-User requests using Tableau and Power Bi.

Developed interactive dashboards and reports in Power BI using tables, charts, and slicers to analyze business KPIs. Involved in End-to-End Implementation of BI Projects.

Created calculated columns and measures using DAX (Data Analysis Expressions) to enhance data insights.

Used Power Query for data transformation tasks such as data cleaning, merging, and filtering before loading into the model.

Published and scheduled Power BI reports in Power BI Service with proper dataset refresh configuration.

Created List, Cross Tab, Chart and map Reports with Quick Filters, Hierarchy Filters in Tableau.

Created Bar Charts, water fall charts, Heat Maps, And Geographical Maps in Tableau.

Good exposure in creating calculate measures, parameters and filters in Tableau.

Experience in creating Workbooks by Importing data, Defining Relationships using Tableau.

Experience in Marks, Action, Filters, Parameters, Cards, Publisher and Security using Tableau and Power BI.

Created Dynamic, Static Dashboards with Global Filters, Context Filters, Action Links.

Experience in Data Blending using Tableau.

Well versed knowledge on concepts of Data Warehousing like Star Schema, Snowflake Schema, Dimensions and Fact tables.

Quick learner with the ability to grasp new technologies and software.

Experience Summary:

Currently working as a Business Analyst & Data Visualization Engineer for Raks IT Solutions. Previous project working as software engineer Tech Mahindra, Hyderabad from Oct'2021 to Sep 2024. And previous project working as BI Developer for Aaxeleron Technology Solutions, Hyderabad from Apr' 2021 to Aug 2021. And my last project working as BI Developer for Sovereign IT Solutions Pvt Ltd Hyderabad from Nov' 2019 to Mar 2021.

Qualifications and Certifications:

B. Tech (Computer science and engineering) from Sree Kavitha engineering college, JNTUH University.

Technical Skills:

Databases : SQL Server, MySQL, DB2, PostgreSQL, Snowflake

OLAP Tools : Tableau BI, Power BI, Quick sight

Tableau - Designed and Deployment of Reports using Data Blending, creating various Parameterized, Linked and Drill-through & Drill-down reports Level of Detail (LOD) expressions (FIXED, INCLUDE, EXCLUDE) to create precise aggregations

Power BI – Report development, dashboards, and custom visuals

DAX – Calculated columns, measures, time intelligence

SQL – Data extraction, transformation, joins, stored procedures

Data Modeling – Star/snowflake schema, relationships, KPIs

Project#1 Oct 2024 to Present

Project Title : PGS BI Architecture

Client : GE VERNOVA

Environment : Tableau 2023.4, SQL Server

Role : Sr. Software Engineer

Description:

GE VERNOVA aims to streamline its Corporate Performance Management & Dashboard framework (referred to as the solution) to provide robust decision support for senior management. The primary objective of this initiative is to deploy a Strategy Management and Analytical Dashboards framework along with it’s This automation and server will also allow for daily management and viewing for the HD NU AE staff and team when desired/needed.

Responsibilities:

Designing and automating reports to meet GE Client's requirements, leveraging Excel files and SQL Server database. Implementing HD NU AE Bowler and other metrics to eliminate manual calculations and inputs.

Creating sophisticated reports incorporating hierarchy, New Calculated Columns, Drill functionality, Tables, graphs, line Charts, and Bar Charts.

Implementing Parameters for enhanced functionality and customization.

Utilizing Dual Axis concept for comprehensive report visualization.

Developing Key Performance Indicators (KPIs) using calculated metrics and parameters.

Creating data visualizations such as cross tabs, heat maps, Geo Maps, Pie charts, and Bar charts.

Publishing reports and dashboards on servers for accessibility.

Implementing conditional filters and Action links to facilitate data filtering on dashboards.

Participating in technical discussions and decision-making processes regarding Business requirements, collaborating with Business Analysts, Client team, and Development team.

Proficient in database design process and data modeling, ensuring efficient data migration to SQL Server database.

Designing SQL Server Database with comprehensive Table Design, Schemas, Constraints, and Views.

Extracting data from various sources including DB2, SQL Server, CSV, Microsoft Excel, and Text files from Client servers.

Tableau Prep is a data preparation tool designed to help user’s clean, shape and transform data before using it for analysis and visualization in Tableau Desktop.

Tableau Prep users can automate data preparation workflows, making to handle raw data from multiple sources.

Implementing a variety of transformations in SSIS packages such as Slowly Changing Dimension, Lookup, Aggregate, Derived Column, Conditional Split, Multicast, Union All, Merge, Merge Join, and Data Conversion.

Developed Tableau workbooks to perform year over year, quarter over quarter,YTD,QTD and MTD type of analysis

Gathering Report Requirements and designing various types of reports including Table Reports with Drilldowns, Map Reports, Dashboards, Gauges, and Subscription reports.

Demonstrating strong knowledge of Data Warehousing methodologies, concepts, and implementing star schemas, snowflakes schemas, facts & dimensions.

Implementing consistent drill-down functionality in reports including Drilldown reports and Summary reports.

Used Level of Detail (LOD) expressions (FIXED, INCLUDE, EXCLUDE) to create precise aggregations, such as patient counts by physician or region, regardless of dashboard filters.

Project#2 Oct 2021 to Sep 2024

Project Title : Cardio Rhythmic Management (CRM)

Client : Boston Scientific Corporation (BSC)

Environment : Tableau 2021.4, MS SQL,

Role : Report Developer

Description:

Boston Scientific is the world’s largest medical device company dedicated to less-invasive medicine and the leader by providing a broad and deep portfolio of innovative products, technologies and services across a wide range of medical specialties. Boston Scientific acquired Cardio Rhythmic Management (CRM) with corporate mission and committed to developing ever-improving technology to help improve the lives of those with cardiac

Conditions. Boston scientific With Acquisition of CRM has a need to integrate CRM corporate data with Boston Scientific to allow the users the ability to focus in on key opportunities and key successes to drive decisions.

Responsibilities:

Designing the Reports as per client Requirement and created the reports using Excel file and SQL Server database.

Created complex reports utilizing the features like hierarchy, New Calculated Columns, Drill functionality, Tables, graphs, line Charts and Bar Charts.

Created Parameters to achieve desired functionality.

Implemented Binning & Blending concepts in my Tableau Reports.

Worked on Dual Axis concept while working with reports.

Created Filters, Groups, Sets on Tableau Reports.

Created and modified some of the existing reports and dashboards.

Publishing sheets and dashboards on server Using Tableau Desktop.

Created conditional filters and Action links to filter the data on dashboard.

Develop and maintain the documentation level to the team and business.

Developed package like data from multiple files to desired destination using ETL tools.

Extracted data from various sources like DB2, SQL Server, CSV, Microsoft Excel and Text file from Client servers.

Modified SSIS ETL packages for changed business requirements to load data from different source files to SQL Server tables in data warehouse.

Created SSIS packages which involved a variety of transformations such as Slowly Changing Dimension, look up, Aggregate, Derived Column, Conditional Split, Multicast, Union All, Merge, Merge Join, and Data Conversion before loading the data into Data Warehouse.

Developed truncate and incremental data loads into DB server.

Created jobs to auto load data in windows and SQL server agent.

Project#3 Apr' 2021 to Aug 2021

Project Title : Capital Commercial Automation Project

Client : Capital One

Environment : Power BI, Snowflake, Quick sight

Role : Developer

Project Description:

This project is about migration of Power BI reports to Quick sight. In this project we acquired queries and data from Power BI. Making use of this query in snowflake, we run the queries and get data to design and develop reports in Quick sight which are present in Power BI. For the reports built in Quick sight we verified whether the data and format are correct and completed test cases for the developed reports. Worked on few ideas description to develop more features on Quick sight.

Capital Markets – Strong understanding of financial instruments including stocks, bonds, equities, and investment products

Project#4 Nov 2019 to Mar 2021

Project Title : CPM & BI Project Business Excellence

Client : National Thermal Power Corporation Limited (NTPC)

Environment : Tableau 2020.2, SQL Server

Role : BI Developer

National Thermal Power Corporation Limited (NTPC) is India’s largest power generating company. NTPC is emerging as a diversified power major with presence in the entire value chain of the power generation business. Apart from power generation, which is the mainstay of the company, NTPC has already ventured into consultancy, power trading, ash utilization and coal mining.

NTPC has three tier structure comprising of:

1. Corporate Centre

2. Regional headquarters and

3. Stations (SBUs).

The proposed software will be hosted at a centralized location at EOC data

Center at Noida and will be a web-based access by users. The access to this

Software will however be controlled and restricted to relevant functionalities and

Information.

Description:

NTPC wants to automate the Corporate Performance Management & Dashboard framework (hereinafter referred as solution) for effective decision support for the top management, Regional HQs and stations (SBUs). The purpose of this project is to implement the Strategy Management and Analytical Dashboards framework and its respective components including the IT enablement of the solution for the organization.

Responsibilities:

Designing the Reports as per client Requirement and created the reports using Excel file and SQL Server database.

Created complex reports utilizing the features like hierarchy, New Calculated Columns, Drill functionality, Tables, graphs, line Charts and Bar Charts.

Created Parameters to achieve desired functionality.

Worked on Dual Axis concept while working with reports.

Created different KPI’s using calculated metrics and parameters.

Developed data visualization using cross tabs, heat maps, Geo Maps, Pie charts and Bar charts.

Publishing reports and dashboards on server.

Created conditional filters and Action links to filter the data on dashboard.

Involved in Technical discussions and decisions for Business requirements, Interaction with Business Analysts, Client team and Development team.

Experienced in database design process and data modeling process.

Analyzed the Data quality, Data validating, Data Mapping to migrate data to SQL Server database.

Designed SQL Server Database and Table Design with Schemas, Constraints and Views.

Extracted data from various sources like DB2, SQL Server, CSV, Microsoft Excel and Text file from Client servers.

Created SSIS packages and involved in Package Configurations and deployments between Development and QA and Production servers so that various properties like variables, connection managers could be changed when moving the Package from one environment to another.

Created SSIS packages which involved a variety of transformations such as Slowly Changing Dimension, look up, Aggregate, Derived Column, Conditional Split, Multicast, Union All, Merge, Merge Join, and Data Conversion before loading the data into Data Warehouse.

Developed, Code Reviewed, fixed bugs, tested and deployed SSIS packages using SQL Server Business Intelligence Development Studio.

Gathered Report Requirements and designed Reports, Table Reports with Drilldowns, Map Reports, Dashboards, Gauge and Subscription reports.

Strong knowledge of Data Warehousing methodologies, concepts and implementation of star schemas, snowflakes schemas, facts & dimensions.

Developed reports with consistent drill-down functionality including Drilldown report and Summary report.

Place:

Date: - Suresh

Contact this candidate