Power Bi Sql Server

Krishna

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

Direct : 312-***-****

PROFESSIONAL SUMMARY:

A result driven software professional with 10+ years of progressively responsible experience in Data Analysis, Design, Implementation, Administration and Support of Business

Expert in designing various ETL Pipelines on top of Azure with consuming data from Event hub to Data bases.

Intelligence, OLTP (Batch Processing, Online Processing), OLAP, ETL, Data warehousing, Data mining, DBMS and Data Modeling using Confidential SQL Server 2012/2008R2 /2008/2005.

Expert in creating and developing Power BI Dashboards into rich look.

Imported Data from multiple data sources into power BI desktop and transforming data in power query editor and generating reports.

Good Knowledge on extracting the data from various data sources by using import and direct query connection modes.

Experience on the concepts of star schema and snowflake schema, Dimension and fact tables.

Expertise on creating the calculated column and measures with the use of DAX expressions like Aggregate and Filter functions, text functions, logical functions.

Experience in creating custom filters for YTD, MTD, QTD, WTD, PD Growth analysis.

Experience in creating different data visualizations like slicers, line chart, bar chart, Card, Matrix, chiclet slicers, area chart, Pie chart and donut chart etc.

Experience in creating edit interactions of highlight action, Filter action add interactivity to the visualization and also created bookmark for reports.

Knowledge on how to implement row level security to assign the permission and security to the end users.

Experienced in creating and managing workspaces using PowerBI Admin Portal workspaces and Tenant Settings.

Responsible for creating SQL datasets for Power BI and Ad-hoc Reports.

Expert on creating multiple kind of Power BI Reports and Dashboards.

Created, Maintained & scheduled various reports in Power BI like Tabular Reports.

Experienced on creating multiple kind of Report in Power BI and present it using Story Points.

Good experience in publishing reports to power bi services and setting up the necessary connection details and scheduling the report.

Worked on on-premises data gateway to schedule on refresh the data in the data source from power bi service.

Good exposure on power pivot Data model.

Ability to work with various types and stages of Software Development Life Cycle (SDLC) processes including Analysis, Design, Development, Testing and Implementation.

Skillful in ETL - Extraction Transformation Loading, Operations Data Store concepts, data marts and OLAP-Online Analytical Processing technologies.

Proficient knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes schemas, ETL processes, dimensional modeling and reporting tools.

Proficient in writing T-SQL (DDL, DML), new features like CTE, Ranking Functions.

Knowledge in all types of Database migrations with all the versions of SQL Server.

Expertise in designing SSIS packages to import and transform data between databases and external data sources using various transformations.

Experience in configuration and maintain Report Manager and Report Server for SSRS, Deployed and Scheduled the Reports in Report Manager

Developed OLTP system (s) and involved in creating facts, dimensions and Star Schema representation for the data mart.

Expertise in SSAS Tabular and Multidimensional Models – Proficient in designing, developing, and managing SSAS Tabular/Multi-dimensional models for analytical reporting.

Performance Optimization – Implemented partitioning, aggregations, indexing, and query optimization techniques to enhance SSAS model performance.

SSAS Cube Development – Built and deployed OLAP cubes, defining dimensions, hierarchies, measures, perspectives, and calculated members.

Integration with Power BI – Connected SSAS Tabular and OLAP cubes with Power BI Live Connection to create dynamic and interactive reports.

Hands on experience on Tableau Desktop versions 7/8.2, Tableau Reader and Tableau Server.

Expertise in OLAP and OLAP Cubes in SSAS.

Performed data cleaning, data validation, and data analysis using data analysis expressions (DAX)

Used DAX (Data Analysis Expressions) functions for the creation of calculations and measures in the Tabular

Models.

Experience in Ad-hoc reports, data driven subscription reports by using Report Builder.

Experience in developing Dashboard Report, Parameterized Reports, Linked reports, Sub reports by Region, Year, Quarter, Month and Week.

Experience in Migrating databases from SQL 2008 R2 to SQL 2012.

Experienced in all facets of Software Development Life Cycle (Analysis, Design, Development, Testing and maintenance) using Waterfall and Agile methodologies.

RDBMS/DBMS:

MS SQL Server 2016/2014/2012/2008R2/2008/2005/2000

Database Technologies/Tools:

SQL Server Entreprise Manager, Microsoft Management Console, SQL, T-SQL, Data Transformation Services (DTS), OLTP, BCP, SSIS, SSAS, OLAP. Microsoft Visio, ER Studio

Reporting Tools:

PowerBI, SQL Server Reporting Services, Excel.

Operating Systems:

Windows XP, 2000, NT, 98, 95, Windows 2003, Windows Vista, Windows 7

Programming Languages:

T-SQL, PL/SQL

Design Technologies/Tools:

Erwin, MS Visio, Rational Rose

Data Warehouse / Business Intelligence Tools

SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Visual Studio 2013/2010/2008, Business Intelligence Development Studio (BIDS) 2008, MS Data Tools 2012 / Visual Studio Shell

Cloud Resources

Azure SQL, Azure PostgreSQL, Azure Data Explorer, Azure Data Factory, Azure Synapse, Azure Databricks.

WORK EXPERIENCE

Client: Ryder, Miami, FL (Nov 2022– Till date)

Designation: Senior Power BI Developer

Ryder, is an American provider of transportation and supply chain management products, and is especially known for its fleet of rental trucks. Ryder specializes in fleet management, supply chain management, and dedicated contracted carriage.

Project Specific Activities:

Developed Power BI model used for financial reporting of P & L and Headcount.

Designed and documented the entire Architecture of PowerBI Poc

Collaborated with business users to gather requirements for new reports and dashboard enhancements.

Conducted feasibility analysis for user requests, considering cost, time, and system compatibility.

Expertise in writing complex DAX functions in PowerBI and Power Pivot.

Explorer to Azure Data factory to Azure SQL to Realtime Power BI reports.

Experienced in creating and managing workspaces using PowerBI Admin Portal workspaces and Tenant Settings.

Designed and implemented dynamic Power BI dashboards with interactive visuals for executive-level reporting, enabling real-time monitoring of KPIs across departments.

Created drill-through and drill-down functionality in reports to enhance data exploration for end users.

Implemented DAX measures to calculate advanced metrics, such as YOY growth, average percentage totals, and trend analysis across time periods.

Migrated dashboards from internal systems to external/public-facing platforms using Power BI Service and Data Gateways.

Developed solutions to manage dependent slicers, ensuring seamless filtering of data across hierarchical levels (e.g., Director -> Rental Manager).

Designed and developed SSAS Tabular and OLAP models to provide robust data structures for analytical reporting.

Established seamless integration between SSAS Tabular models and Power BI through Live Connections, enabling real-time data analysis.

Designed and maintained data extraction, transformation, and loading (ETL) processes between multiple sources, including on-premises SQL databases, cloud services, and Power BI datasets.

Conducted rigorous testing, including User Acceptance Testing (UAT), to validate data accuracy, report performance, and compliance with business requirements.

Automated the data processing and refresh schedules for SSAS models using SQL Server Agent and SSIS, ensuring timely updates of data for Power BI reports.

Utilized Bookmarks and Buttons to toggle in visualizations, optimizing report usability for diverse stakeholders.

Integrated multiple data sources, including SQL databases and APIs, into a single Power BI model, ensuring data accuracy and consistency.

Migrated legacy SSRS reports to Power BI while maintaining reporting accuracy and compliance with business requirements.

Enhanced existing SSRS reports with parameterized queries, enabling flexible filtering options for end users.

Automated report subscriptions and delivery through SSRS for operational and financial teams, ensuring timely access to critical data.

Ensured compliance with data security policies and best practices for handling sensitive business data in Power BI.

Conducted performance tuning of SSRS reports, optimizing query execution and reducing load times.

Collaborated with stakeholders to gather requirements, define report objectives, and prioritize development tasks.

Tested and validated data models and visualizations to ensure alignment with business needs and reporting standards.

Configured and managed Power BI Data Gateways for secure connectivity between on-premises and cloud-based data sources.

Developed and maintained reports using SAS for statistical analysis and business intelligence insights.

Created technical documentation for Power BI dashboards, ETL workflows, and SQL data models to support business users and developers.

Integrated GIS and spatial data visualization into Power BI reports using custom map visuals, ensuring accurate geographic insights for business decisions.

Ensured compliance with data security policies and best practices for handling sensitive business data in Power BI.

Provided end-user training and documentation for Power BI and SSRS tools, fostering self-service analytics capabilities.

Assisted in training end-users and stakeholders on Power BI report usage, self-service analytics, and data-driven decision-making.

Optimized Power BI data models using best practices, including aggregations, indexing strategies, and efficient DAX calculations to improve performance.

Reduced dashboards refresh times and improved report interactivity through query optimization techniques. Implemented Row-Level Security (RLS) to manage user access control based on department and role-specific needs.

Ensured compliance with data security policies and best practices for handling sensitive business data in Power BI.

Developed and optimized SQL queries to extract and transform data from relational databases for seamless integration into Power BI reports and dashboards.

Created complex Joins, subqueries, and CTEs to consolidate data from multiple tables and deliver actionable insights.

Utilized SQL scripts to calculate metrics, KPIs, and aggregated values, ensuring accurate data representation in Power BI visuals.

Designed and embedded interactive Power BI dashboards into web applications and enterprise portals (e.g., Salesforce, SharePoint, or custom applications).

Utilized Power BI Embedded and REST APIs for seamless integration and report automation.

Used Direct Query, Import Mode, and Aggregations to optimize performance for embedded analytics.

Developed Power Automate workflows for report distribution and scheduling.

Worked closely with front-end developers, UX/UI teams, and business stakeholders to create seamless embedded BI solutions.

Used Application Insights and Power BI Audit Logs for monitoring usage and performance.

Designed SQL queries to filter and preprocess data for improving Power BI report performance and reducing data load times.

Integrated SAS datasets with Power BI to develop interactive reports and dashboards for data-driven decision-making.

Utilized SAS SQL procedures (PROC SQL) to extract, transform, and load (ETL) data for Power BI reporting.

Conducted data validations to verify accuracy and completeness of query outputs before loading into Power BI.

Developed and optimized SQL queries to extract and transform data from Snowflake and Amazon Redshift databases for seamless integration into Power BI reports and dashboards.

Designed SQL queries to filter and preprocess data in Snowflake and Amazon Redshift, improving Power BI report performance and reducing data load times.

Environment: MS SQL Server 2017/2016/2014, SQL Server Management Studio, Power BI Desktop, PowerBI Service, PowerBI Pro, PowerBI Premium, PowerApps, PowerBI Report Builder, DAX, PowerBI Admin, PowerBI Mobile, T-SQL, Visual Studio 2017, Azure Data Lake Storage, Azure Data Lake Analytics, Azure Data Factory, Report Builder(SSRS),MS Excel, Oracle,Snowflake.

Client: Spirit Airlines, Miami, FL (Jan 2021 – Oct 2022)

Role: Power BI Developer

Spirit began a transition to an ultra-low-cost carrier, following a fare model involving charging for amenities that are often included in the base ticket price of traditional carriers.

Project Specific Activities:

Worked closely with Business users. Interacted with ETL developers, Project Managers, and members of the QA teams.

Used various sources to pull data into Power BI such as Sql Server, SAP BW, Oracle, SQL Azure etc.

Installed and configured Enterprise gateway and Personal gateway in Power bi service.

Created Workspace and content packs for business users to view the developed reports.

Scheduled Automatic refresh and scheduling refresh in power bi service.

Wrote calculated columns, Measures queries in power bi desktop to show good data analysis techniques

Weekly presentation to the business users about the reports and their changes as required.

Worked on all kind of reports such as Yearly, Quarterly, Monthly, and Daily.

Worked on all types of transformations that are available in Power bi query editor

Created stored procedures and SQL queries to pull data into power pivot model.

Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.

Automated data refresh and scheduling in Power BI using SAS data feeds to ensure up-to-date reporting.

Created custom SAS macros to preprocess and transform data before importing it into Power BI.

Database creation (DDL, DML, DCL), database tuning, SQL tuning, performance planning.

Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.

Transformed complex business logic into Database design and maintaining it by using SQL objects like Stored Procedures, User Defined Functions, Views, T-SQL Scripting and Jobs.

Creating and Modifying Tables, Stored Procedures.

Created Jobs Performance report that queries system tables to track the duration of each job and weekly-average duration using SSRS.

Integrated Smart Sheets for data collaboration, project tracking, and workflow automation within Power BI reporting solutions.

Worked with ArcGIS and geospatial data to create Power BI visualizations incorporating geographic mapping and spatial analysis.

Created data integration and technical solutions for Azure Data Lake Analytics, Azure Data Lake Storage, Azure Data Factory, Azure SQL databases and Azure SQL Data Warehouse

Designed and created data extracts, supporting, POWER BI other visualization tools reporting applications.

Creating data blending in case of merging two different datasets using Power BI

Created Datasets in T-SQL, stored procedures for SSRS.

Developed Excel Power View, Power Query and PowerPivot dashboards for data analysis

Developed confidential proprietary analytical tools and reports with Confidential Excel, and Power Pivot and Power Point.

Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost using index tuning wizard.

Created SSIS packages to import data from Access, Excel, XML, OLE DB Source and Flat Files.

Designed and created data extracts, supporting Power BI, other visualization tools reporting applications.

Created Reports using Charts, Gauges, Tables, matrix.

Created Parameterized Report, Dashboard Report, Linked report and Sub Report by Year, Quarter, Month, and Week.

Created Drill Down Reports, Drill Through Report by Region.

Environment: MS SQL Server Azure Data Explorer, Azure Data factory, Azure SQL, SQL Server reporting services, MS SQL Server 2016T-SQL, DAX, SQL Server, Power BI Desktop, Power BI Service, Power BI Mobile, Power BI Report Server, Power BI Premium, Power BI Embedded, Power BI Report Builder, Microsoft Visual Studio, Excel, Azure, SSMS, SharePoint, Gateways.

Client: Ryder, Miami, FL (Mar 2016– Dec 2020)

Designation: Power BI Developer

Ryder, is an American provider of transportation and supply chain management products, and is especially known for its fleet of rental trucks. Ryder specializes in fleet management, supply chain management, and dedicated contracted carriage.

Project Specific Activities:

Involved in Analysis, Planning and Defining data based on business requirements and provided documentation.

Designed Power BI data visualization utilizing cross tabs, maps, scatter plots, pie, bar and density Charts

Designed and optimized relational database models in SQL Server, Snowflake, and Azure SQL for high-performance querying and reporting.

Utilized Power Query in Power BI to Pivot and Un-Pivot the data model for data cleansing

Provided continued maintenance and development of bug fixes for the existing and new Power BI Reports.

Experienced in embedding PowerBI reports into salesforce and web page using PowerBI URL parameters

Developed Power BI reports and Dashboards from multiple data sources

Experienced in managing organization visuals and Embed Codes in PowerBI Admin Portal.

Created Drill Down Reports, Drill Through Report by Region.

Created workspace and content packs for business users to view the developed reports.

Experienced in setup and manage PowerBI Premium capacities using PowerBI Admin Portal capacity settings.

Managed ETL processes and data transformations, ensuring data quality and consistency for reporting and analytics.

Experienced in creating and managing workspaces using PowerBI Admin Portal workspaces and Tenant Settings.

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

Developed statistical models in SAS (e.g., regression analysis, forecasting) and visualized insights in Power BI dashboards.

Extracted data from SAS Viya and SAS Enterprise Guide to create Power BI dashboards for business intelligence reporting.

Used SAS OLAP cubes as data sources in Power BI to enable multidimensional analysis and drill-through reporting.

Conducted data cleansing and transformation in SAS before loading it into Power BI for accurate visual analytics.

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

Experienced in managing users, admins, and groups in the office 365 admin center.

Experienced in creating and managing PowerBI data gateways using Power Platform admin center

Experienced in creating paginated reports using PowerBI Report Builder and in migrating

SSRS, Tableau, and Cognos reports to PowerBI

Experienced in loading data from various formats including traditional compressed CSVs to semi- structured data such as JSON/XML from Cloud storages like S3 or Azure in Snowflake.

Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.

Designed and normalized the databases, have written T-SQL Queries and created different objects like Tables, Views, Stored Procedures, User defined functions and Indexes.

Implemented Copy activity, Custom Azure Data Factory Pipeline Activities for On-cloud ETL processing

Transform and load data from different sources like Azure SQL, Blob storage and Azure SQL Data warehouse.

Integration runtime in Azure Data Factory to connect On-Premises SQL Server

Created data integration and technical solutions for

Data Lake Analytics, Azure Data Lake Storage, Azure Data Factory, Azure SQL databases and Azure SQL Data Warehouse

Used Copy Activity in Azure Data Factory to copy data among data stores located on-premises and in the cloud

Designed SAS reports and Power BI visualizations for executive and operational reporting.

Environment: MS SQL Server 2017/2016/2014, SQL Server Management Studio, Business intelligence development studio (BIDS), SQL Server Integration Services (SSIS), SSAS, Power BI Desktop, PowerBI Service, PowerBI Pro, PowerBI Premium, PowerApps, PowerBI Report Builder, DAX, PowerBI Admin, PowerBI Mobile, T-SQL, Visual Studio 2017, Azure Data Lake Storage, Azure Data Lake Analytics, Azure Data Factory, U-SQL, Azure Databricks, MS Excel.

Education: Master’s in Information Technology (Jan 2015 – Mar 2016)

Client: IQVIA (Dec 2011- Dec 2014)

Designation: SQL Developer

Project Specific Activities:

Requirements gathering from Business users to perform technical design, development and testing.

Worked extensively in writing and debugging complex stored procedures, views, triggers and user-defined

functions

Worked on designing databases according to industry standards and make tuning recommendations.

Designed the Data warehouse and done the mappings from Source to the Target tables.

Created views and Stored Procedures for generating report. Responsible for creating the reports based on the

requirements using SSRS.

Worked on several complex drilldown, parameterized reports and on reports that call sub reports using SSRS.

Performance Tuning of Stored Procedures and SQL queries using SQL Profiler and Index Tuning Wizard in SSIS.

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.

Created SQL Server jobs and scheduled them to load data periodically using SQL server Agent.

Identified the dimension, fact tables and designed the Data-Mart using Star schema.

Created and Configured Data Source & Data Source Views, Dimensions, Cubes, Measures, Partitions, KPI’s &

MDX Queries using SQL Server 2008R2 Analysis Services.

Transferred data from various OLTP data sources, such as Oracle, MS Access, MS Excel, Flat Files, CSV files into

SQL Server 2008R2.

Automated Processing – Scheduled SSAS data refresh and processing using SQL Server Agent and SSIS for efficient data updates.

SSAS Deployment and Maintenance – Experienced in deploying SSAS models to production environments, managing version control, and troubleshooting performance issues.

Generated multi parameterized reports in MS SSRS 2008R2 allowing users the ability to make selections before

executing reports; thus, making them user friendly.

Report Design and Coding for Standard Tabular type reports, including Drill down and Drill through functionality

and Graphical presentations such as Charts and Dashboard type metrics using SSRS

Created Ad Hoc and parameterized various Reports using SSAS and SSRS.

Assisted in handling escalating billing issues and propagating bug fixes in production environment.

Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer

representatives for various categories based on business needs.

Environment: SQL Server 2008R2, DTS, SQL Server Management Studio, SSIS, SSRS,SSAS, SQL Server Business Intelligence Development Studio (BIDS), SQL Server Query Analyzer.

Contact this candidate