Power Bi Sql Server

Tharun G

Role: Power BI Developer

Contact: 323-***-****

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

Professional Summary:

Over 7+ years of experience working in Microsoft BI tools and designed, developed Power BI reports and dashboards from multiple data sources using data blending, Development, testing and implementation of projects in Healthcare/Insurance, Supply chain management, Telecom, Manufacturing, and Software industries

Proficient in Microsoft BI Tools (SSIS/SSRS/SSAS) and T-SQL using SQL Server 2005/2008R2/2012/2014/2016.

Proficient in design, development, customization of various Office 365 applications like Power BI, Power Automate, Power Apps, SharePoint Online.

Advanced proficiency in MS Office applications (Outlook, Word, Excel, PowerPoint, VisualBasic)

Worked with end user customers/ stakeholders/ business analysts to refine business requirements and then transform that into a technical requirement, data models, dimensions, architectural diagrams, reports, and dashboards.

Strong knowledge in Power BI on import, shape, and transform data for business intelligence (BI), visualize data, author reports, schedule automated refresh of reports and create and share dashboards based on reports in Power BI desktop.

Hands on calculated columns and measures using DAX in Power BI based on report requirements.

Experience on creating Power BI dashboard from scratch and handling Workspaces, Apps and User Security in Power BI Service

Strong understanding and hands on related to Data modelling in Power BI Relationships.

Created reports using visualizations such as Bar chart, Clustered Column Chart, Waterfall Chart, Gauge, Pie Chart, Tree map etc. in Power BI.

Experience in T-SQL (DDL, DML and DCL), Creating, developing new database objects by like Tables, Views, Indexes, Complex stored procedures, function (UDF), cursors, and triggers, locking issues, BCP, common table expressions (CTEs), Backups, Recovery and SQL Server Agent profiler using SQLSERVER 2000/2005/2008 R2/2012.

Have strong knowledge of database management in writing complex SQL queries, Joins, query optimization and resolving key performance issues.

Expert skilled in SQL development, SQL fine tuning, Optimization and SQL Admin activities.

Having good Experience in Designing and developing the SSIS Packages with different types of Control Flow Tasks and Data Flow Transformations, Securing and Deploying the Packages.

Excellent hands-on Experience in ETL (Extraction Transformation and Loading) by extracting large volumes of data from various data sources using SSIS.

Experience in developing OLAP Cubes by using SQL Server Analysis Services (SSAS), and defined data sources, data source views, Dimensions, Measures, Hierarchies, Attributes, Calculations using multi-dimensional expression (MDX), Perspectives and Roles.

Experience in Creating Reports using SQL Server Reporting Services (SSRS).

Transforming data in Azure Data Factory with the ADF Transformations

Proficient in building Star schema and Snowflake schema depending on business requirements.

Building the pipelines to copy the data from source to destination in Azure Data Factory.

Prepared user manual and Trained End Users on developed Power BI Applications.

Expert in Unit, System and User Acceptance Testing and Performed Data Validation for all the reports and dashboards generated from various database sources.

Strong influence management skills, reporting and analytical/problem solving skills with attention to detail.

Technical Skills:

Programming: SQL, PL/SQL, VBScript, UML and XML

Databases: Oracle 11g,Amazon Redshift, SQL Server, MySQL, Access, JIRA, SAP

Reporting tools : Power BI (Power View, Power Pivot), SAP BO, SSIS, SSRS, SSAS

Data Warehouse / Business Intelligence Tools: SQL Server Integration Services (SSIS), Visual Studio 2016/2014/2013/2010/2008, SSAS, Business Intelligence Development Studio (BIDS) 2008, MS Data Tools 2012 / Visual Studio Shell

Data Modelling and Project Management Tools: MS Visio, MS Project, MS Office (Word/ Excel/ Access/ Power Point), Share point, JIRA, Smart Sheet

Software Development Life Cycles: Agile (Scrum), Waterfall

Office Applications: MS Outlook, MS-Word, MS Project, MS-Excel, MS-Access

Education:

Master’s in computer science from Eastern Illinois University

Professional Experience:

Client: Amwell Role: Sr. Power BI Developer Duration: Nov 2023- Till Now

Responsibilities:

Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications. Designed, developed, and tested solutions for business user specified requirements to achieve desired business results.

Participated in the daily stand-up with business teams to resolve the business issues and Data challenges.

Hands-on experience in the design, development of end user applications for the data presentation and analytics, including scorecards, dashboards, reports, monitors, and graphic presentation (Information Visualization &Analysis) using POWER BI.

Create reports in Power BI Desktop and Service utilizing the connectors

Expertise in creating reports from importing, Direct Query and Live data from several data sources

Collaborated with senior management, subject matter experts, and IT teams to define business requirements.

Worked extensively on Power BI reports, creating data models, data transformations, used custom build visuals from marketplace, used DAX extensively for creating measure and modelling.

Extract Transform and Load data from sources systems to SQL using a combination of Azure Data Factory Pipelines, T-SQL, and U-SQL Azure Data Lake Analytics Create and Maintain Data pipeline in Azure Data Lake and COSMOS

Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs such as legal case matter, billing hours and case proceedings along with slicers and dicers enabling end-user to make filters.

Wrote and modified various Stored Procedures used in the application using T-SQL.

Utilized Power BI gateway to keep dashboards and reports up to date with on premise data sources.

Creating Row level securities and integrating with Power BI service portal.

Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.

Designing current databases by adding tables, relationships, creating stored procedures, views and performance tuning of SQL queries.

Built a Tabular Model cube from scratch data and by MDX and DAX queries fetched data to SSRS and Power BI reports.

Analysed the Business Requirement Document (BRD) to design a conceptual model, participate in all phases of SDLC process to implement T-SQL, SSIS, SSAS and SSRS to develop a solution.

Define reporting requirements and gather data, using Access and create management reports, also export data from MS access to MS excel to create pivot table for management do more analysis.

Extensively involved in Designing and Developing ETL Processes data from external sources like Azure blob Storage, Azure Data Lake Gen2 and ORC/Parquet/Text Files into Azure SQL Data Warehouse (Azure Synapse).

Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.

Utilized Query Editor to clean and format data and eliminate redundant information and append and merge tables from various data sources.

Environment: PowerBI Desktop, PowerBI Service, PowerBI Gateway, SSIS, SSAS, SSRS, MS SQL Server 2012/2014,Excel, CSV files, Star and Snowflake Schema, Azure Cloud, Azure SQL Database, Azure Data Lake.

Client: JPMC Role: Sr. Power BI Developer Duration: Apr 2022- Sep 2023

Responsibilities:

Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.

Directly involved into requirement gathering and understanding business functions with the end users.

Provided valuable suggestions to users in terms of database design and new application implementation to overcome existing performance and reliability issues.

Involved discussion with business users and provided technical guidance for Power BI Desktop and Power BI Service.

Managed Power BI Portal - Data refreshes / User management and set up gateway data refresh.

Participating in Daily stand up Agile/Scrum meetings to discuss regarding the enhancements to be made for the existing requirements.

Created advanced formulas, user defined functions and formulaic arrays for data analysis.

Design the Microsoft Power BI reports using various features like conditional Formatting, Custom tooltips, bookmarks, templates, button, and custom visuals.

Created reports by using Joins in multiple tables form multiples database using complex SQL queries.

Performed tuning of SQL queries and Stored Procedure for speedy extraction of data to resolve and troubleshoot issues in OLTP environment.

Created charts like Lines, Pies, Scatter, Tree map, Slicer, Bar chat, Funnel chart etc.

Responsible for development, coding, testing, debugging and documentation of Power BI Reports and the associated Databases of one or more user areas.

Build regular ad-hoc reports using SSRS SQL Server Reporting Services with help of various tools such as Group by, Drill-down, Cascading, Summarized, Matrix, Map and Cross-join.

Worked on Migrating SSRS reports to Power BI Reports Using Report Builder. Creating Paginated reports to deploy the SSRS report same view in Power BI.

Used SSIS to create ETL packages to validate, extract, transform and load data to Data Warehouse databases.

Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile apps.

Perform all the Admin activities in Power BI Service such as Creation and providing access to the Workspaces. Create Dataflows in the workspace, Schedule the incremental refresh or the regular refresh of all the datasets present in the workspace, assign members or groups to the roles created for Row Level Security.

Involved in the creation of tabular model using SQL Server Analysis Services to keep the data live for the reports and dashboards.

Create and Model complex Microsoft Power BI reports and dashboards for various users using parameters, data transformations, dynamic filtering, bookmarks, drill through filters, drill down filters using Microsoft Power BI desktop.

Environment: PowerBI Desktop, PowerBI Service, Power BI Gateway,SQL Server, MS SQL Server Reporting Services 2012, Excel, T-SQL

Company: Accolite Client: Novartis Role: Sr PowerBI Developer Duration: Feb 2019- Dec 2021

Responsibilities:

Developed Power BI reports and dashboards from multiple data sources using data blending.

Understand the reporting requirements and provide Power BI reporting solutions.

Scheduled jobs for creating snapshot of Power BI Reports and Dashboards and troubleshooting on datasets for Power BI sites

Created Power BI Visualizations and Dashboards as per the requirements.

Created various Power BI Reports that includes Charts, Filters, Scorecards, Drilldown and Drill-Through, Cascade, Parameterized reports that involved conditional formatting.

Provided production support on the existing Power BI Dashboards and other ETL processes to resolve the issues quickly and published Power BI Desktop reports created in Report View to the Power BI service.

Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.

Designed and developed the dashboards, Scorecards and KPI’s in the Power BI.

Carried all the Power BI Admin activities such as creating workspaces, providing access to the workspaces, creating apps, sharing reports and dashboards to users, implement row level security, applying schedule refreshes to the reports and dashboards, exporting reports as PDF and PowerPoint documents in Power BI Service.

Developed Power BI data visualization using Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails, and Density Chart.

Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and parametrized using Power BI.

Creation of ETL flow with SSIS packages by formatting source data using different transformations like Lookup, derived column, Conditional split, OLEDB command, data conversion, merge, merge join.

Actively involved in writing SQL Stored Procedures, functions, and triggers for updating customer usage information in the database and extensively used Joins and sub Queries to simplify complex queries involving multiple tables.

Extensively involved in deploying SSIS Packages, SSRS Reports and SSAS Cubes using command line utilities.

Experience in using the M language for Data transformation in the Power Query.

Scheduled the ETL Package Using SQL Server 2008 Management Studio.

Responsible for unit testing. Peer testing and Integration testing of data warehouse jobs.

Environment: MS SQL Server 2016/2014/2008, SSIS/SSAS/SSRS, T-SQL, SQL Server Profiler, Azure Cloud, Power BI Desktop, Power BI Service, Power Query, Power Pivot, Power Designer, Tabular Models, SQL Server Management Studio.

Company: Accolite Client: Jabil Circuit Role: BI Consultant Duration: Mar 2017 - Jan 2020

Responsibilities:

Created various database tables and procedures to update and clean the old data.

Developed Complex Stored Procedures, Views and Temporary Tables as per the requirement.

Excellent report creation skills using Microsoft SQL Server 2012/2008 Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.

Rendering the reports to PDF formats as per the requirement and printing all the reports in a batch process for Monthly Statements.

Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.

Responsible for creating dashboard and tabular reports using SSRS.

Worked on OLAP Data warehouse, Model, Design, and Implementation.

Involved in Creation of Dimensions using STAR and SNOW FLAKE Schema.

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.

Created cubes, dimensions and business critical KPIs using SQL Server Analysis Services (SSAS) representing aggregations in several different ways - hierarchically and using custom groupings that the company will use to analyze performance.

Extensively worked on Dimensional modeling, Data cleansing and Data Staging of operational sources using ETL processes.

Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.

Created calculated measures in tabular model using DAX Queries according to end user requests and reporting needs.

Created Tabular Models using DAX queries in analysis services and deployed it.

Used Open Query from SQL Server the SSAS Server to combine data from SSAS cube and DW database.

Created Calculated Measures and Key Performance Indicators in SSAS using MDX.

Querying and manipulating multidimensional cube data through MDX Scripting in SSAS.

Environment: MS SQL Server, SSRS, SSIS, Visual Studio, Agile, Visio, Enterprise Manager, Power BI, SQL Server Management Studio (SSMS), Agile/Scrum, Jaspersoft, Bravo Advantage, Windows 10, Windows Server 2008, MS Project, MS Office Suite (Word, Excel, PowerPoint), Smartsheet, Ultipro, OpenAir, JoinMe

Contact this candidate