Sql Server Power Bi
Resume:
VARDHAN REDDY K
Email: reddyveera***@gmail com
Phone: 469-***-****
SQL BI (SSIS/SSRS/SSAS/Power BI/OBIEE)Developer/Azure Data Engineer Professional Summary:
Over 8 years of professional IT experience in architecting, designing, developingBusiness Intelligence solutions across multiple domains like Insurance, Investment Banking, Information Technology, Healthcare &Financial services, Aviation & Marine parts sales industries.
Extensive experience in implementing Microsoft BI/Azure BI solutions like Azure Data Factory, Power BI, Oracle BI Solutions (OBIEE), Azure Databricks, Azure Analysis Services, SQL Server Integration Services, SQL Server Reporting Servicesand Tableau.
Highly experienced Azure Cloud professional with strong experience in migrating oracle and SQL Server on prem Datawarehouse to Azure SQL Datawarehouse (Synapse Analytics).
Highly experienced in providing solutions in Data Quality, data governance and further Identifying and resolving Data anomalies in complex Data Integration systems.
Experienced in designing & developing complex data models in both Star Schema & Snowflake schema for solutioning an end to end Data warehouse implementation using Kimball methodology &Inmon methodology.
Expert in implementing various business rules for Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous Systems using Azure Data Factory (ADF) and SQL Server Integration Services
(SSIS).
Extensive experience in developing tabular and multidimensional SSAS Cubes, Aggregations, KPIs, Measures, Partitioning Cube, Data Mining Models, deploying and Processing SSAS objects.
Experienced in working with SQL Query Analyser, SQL Server Management Studio and Business Intelligence Development Studio, scheduling jobs with SQL Server Agent, SQL Server Storage Structures, Security Architecture and SQL Profiler.
Expertise in creating & automating ETL workflows using SSIS packages with experience in setting up Logging, SQL Mail, Check Points, configuratoin, Custom Control Flows, Auditing, Variables, resolving complex issues and Error Handling in SSIS.
Experience in Performance Tuning of SSIS packages by using Row Transformations, Block and Unblock Transformations.
Expert in writing Parameterized Queries for generating Tabular reports, Sub reports using Global variables, Expressions, and Functions, Sorting the data, Dashboard, Scorecards, Drill-down and Drill-through reports, Defining Data sources and Subtotals for the reports using SSRS and integrating them with SharePoint server and native mode.
Experience in configuration of report server and report manager scheduling, give permissions to different level of users in SQL Server Reporting Services (SSRS).
Involved in importing the data from various source systems and create rich dashboards using Power BI graphical and visualization solutionsusing DAX functions and Power Query, setting up gateways, schedulingdata refresh, and publishing the dashboards/reports from Power BI Desktop and maintaining them on Power Bi Service.
Expert knowledge of architecting and developing Power BI solutions by configuring the data security and assigning the licenses and sharing the reports and dashboards to the difference user groups in the organization.
Experience in supporting web based, mission critical applications including Logical and Physical Database Design, Development, Performance Tuning and Change Management.
Expertise in design and development of the three layers (Physical,Business&Presentation layer) of an OBIEE Metadata Repository (.rpd)usingOracle BI Administration Tool.
Highly skilled at configuring OBIEE Metadata Objects including repository, variables and in designing customized interactive dashboards, and reports using drill down, guided navigation, prompts, filters, and variables and scheduling iBots in Oracle BI Delivers to provide real-time, personalized and actionable intelligence data to subscribers.
Page 2 of 6
Experienced in developing Dimensional Hierarchies, Level Based Measures, and adding multiple sources to business model objects in the oracle repositories.
Extensive experience in building complex dashboards/reports in tableau and admin functionalities of tableau server.
Excellent Interpersonal and Customer Relational Skills, proven communication, organizational, analytical skills and in-built leadership qualities.
Technical Skills:
Database Technologies SQL Server 2008/2012/2014/2017, Oracle 9i/10g/11g/12c/18c, Polybase Azure SQL Database, Azure SQL Datawarehouse, Snowflake Datawarehouse. Business Intelligence Power BI, Azure Data Factory (ADF), Azure Databricks, U-SQL, Azure Analysis Services(SSAS), Databricks Delta(Delta Lake),Azure Data Lake Analytics, Azure Data Lake Store (ADLS), Power Apps, SSRS, SSIS, Microsoft Flow, Azure Logic Apps, Log Analytics, Spark SQL, Python, Scala, MDX, DAX, XMLA, Power Query(M Language), Pentaho, Tableau, Azure Event Hubs, Azure Stream Analytics, Oracle Business Intelligence Enterprise Edition(OBIEE) Tools Visual Studio 2005/2008/2010/2017, MS Office 365, Attunity Tools( Qlik Compose, Qlik Replicate)
Languages SQL, PL SQL, HTML, XML, Python
Operating System Windows Server 2003,2008 and 2012 and Linux DEVOps Absolute Telnet, Putty, Shell scripts
Data Visualization Tools Power BI, SSRS, OBIEE, Tableau Webserver IIS 6.0 and IIS 7.0
Defect
Tracking
Tool
IBM Rational Rose Clear quest, Mercury Quality Centre, Team Track Project Details:
Client:Caresource Location:Cincinatti, Ohio Duration:12/2023– Till Date Role: Azure Data Engineer
Contribution:
Involved in developing the end to end ETL pipelines for migrating the on-premises Oracle database to Azure SQL Datawarehouse.
Involved in Configuring and Upgrading the On Premises Data gateway between various Data sources like SQL Server to Azure Analysis Services and Power BI service.
Involved in creating the external and internal tables in Azure SQL Datawarehouse and created stored procedures to move the data from external to internal tables.
Involved in performance tuning of Azure SQL Datawarehouse by detecting the data skew problems by creating the right distribution for each of the dimension and fact tables.
Created Stored Procedures to transform the Data and worked extensively in PL/SQL for various needs of the transformations while loading the data.
Created staging database for temporary processing, consolidation and loading data into Target database using SSIS.
Created different SSIS packages to extract data from Excel and SQL Server connection source to create dimensional model for reporting purposes.
Page 3 of 6
Worked on maintenance and Administration of SSIS by creating Jobs, Alerts, SQL Mail Agent, and schedule SSIS Packages.
Created several SSIS Packages from different data sources like CSV Files, Excel Files, Oracle DB, SQL DB, MS Azureby using different data Transformations like Derived Column, Lookup, Conditional Split, Pivot, Union and Execute SQL Task to load data into Database.
Created new SSIS packages as per the requirement and assigned SQL Jobs through Job agent.
Optimized ETL loads by using proper selection of SSIS transformations, tuning the embedded SQL and dropping indexes during load.
Modified and created new stored procedures, views and SSIS packages for the existing ones to reduce their execution time.
Created a SSISDB catalog with SQL 2012 to support SSIS package deployments with environment variables respective to each environment.
Configured SSIS Send Mail Task on multiple Control Flow Tasks to send email during failure using SMTP Connection Manager.
Designed and developed interactive business intelligence dashboards, analytical reports and data visualizations using power BI by creating multiple measures using DAX expressions for user groups like sales, marketing, operations and finance team needs.
Generated 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.
Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.
Created new logical columns, dimensional hierarchy, calculated measures, and aggregate mappings in the BMM layer as per the business requirements.
Designed and developed various Interactive Dashboards and reports with drilldowns, guided navigation, filters, and prompts.
Configured BI Scheduler and Oracle BI Delivers- iBots to deliver alerts and publish updated content to subscribed users as per the schedules and requirements.
Integrated BI Publisher with OBIEE to build reports in word, excel and doc format.
Provided guidance and support to end users during the implementation and in production.
Developed Reports and Dashboards with different Analytics Views including Pivot Table, Chart, Gauges, Column Selector, and View Selector with global and local Filters using Oracle BI Presentation Services.
Configured schedulers and used iBots to generate and deliver reports based on business requirements. Technologies:MS- SQL, Power BI, Azure, ADF, Oracle Database, SQL Server, PL/SQL,Databricks,SSAS, SSIS, SSRS, Pyspark, Scala, Spark SQL, DAX, Power Query,OBIEE Administration tool,BI Publisher. Client:Inventory Locator Services (ILS) Location: Memphis, TN Duration: 04/2022– 12/2023 Role: Power BI/Azure SQL Developer
Contribution:
Involved in Architecting and developing the Azure data factory pipelines by creating the datasets and source and destination connections to move the data from oracle database to Azure Data Lake.
Performed Extraction Transformation and Loading the data from Sources Systems to Azure Data Storage services using a combination of Azure Data Factory, T-SQL, Spark SQL Azure Data Lake Analytics. Involved in Data Ingestion to one or more Azure Services - (Azure Data Lake, Azure Storage, Azure SQL, Azure DW) and processing the data in Azure Databricks
Involved in creating the external and internal tables in Azure SQL Datawarehouse and created stored procedures to move the data from external to internal tables.
Involved in performance tuning of Azure SQL Datawarehouse by detecting the data skew problems by creating the right distribution for each of the dimension and fact tables. Page 4 of 6
Involved in developing complex Azure Analysis Services tabular databases and deploying the same in Microsoft azure and scheduling the cube through Azure Automation Runbook.
Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases
Design and develop business intelligence dashboards, analytical reports and data visualizations using power BI by creating multiple measures using DAX expressions for user groups like sales, operations and finance team needs.
Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.
Utilized PowerBIgateway to keep dashboards and reports up to-date with on premise data sources.
Utilized Power BI (Power Pivot/View) to design multiple scorecards and dashboards to display information required by different departments and upper level management.
Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.
Utilized Power BI (Power Pivot/View) to design multiple scorecards and dashboards to display information required by different departments and upper level management.
Developed metadata repository using OBIEE Administration tool in Physical, Business Model and Mapping, and Presentation Layer.
Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.
Used Package Configurations to make use of same SSIS package in Dev/Testing/Prod Environments
Created SQL Jobs to schedule SSIS Packagesand process the automation from the SSIS Db catalog
Worked with various tasks of SSIS include Transform Data Task, Execute SQL Task, Active Script Task etc.
Enhancing and deploying the SSIS Packages from development server to production server.
Performed Documentation for all reports and SSIS packages.
Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc
Experience with SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints and scripting with Active-X and VB.NET in SSIS.
Created reports utilizing SSRS, Excel services, Power BI and deployed them on SharePoint Server as per business requirements.
Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
Experience in creating Tabular Reports, Matrix Reports, Parameterized Reports, and Sub Reports using SQL Server Reporting Services (SSRS).
Technologies:MS-SQL, SSAS, SSIS, SSRS, Azure, ADF, Databricks, Power BI, Pyspark, Scala, Spark SQL, Tableau, DAX, Power Query,OBIEE Administration tool,BI Publisher,Oracle Databases, SQL Server, PL/SQL Client:AIG Location: Charlotte, NC Duration: 02/2020– 03/2022 Role: Power BI Developer / SQL Developer
Contribution:
Design and develop business intelligence dashboards, analytical reports and data visualizations using power BI and providing access to different user groups like sales, operations and finance team needs.
Involved in creating the notebooks for transforming data from raw to stage and then to curated zones using Azure databricks.
Involved in Architecting, Design, developing complex Azure Analysis Services tabular databases and deploying the same in Microsoft azure and scheduling the cube through Azure functions.
Design and develop the data factory pipelines to move the data from oracle database to Azure Data Lake Data Lake Store.
Page 5 of 6
Involved in creating the external and internal tables in Azure SQL Datawarehouse and created stored procedures to move the data from external to internal tables and used polybase to move data to Azure SQL DW.
Created Azure Data Lake Analytics U-SQL jobs for transforming data in Azure Data Lake Store to move from Raw to Stage and then to Curated zones.
Created staging database for temporary processing, consolidation and loading data into Target database using SSIS.
Created different SSIS packages to extract data from Excel and SQL Server connection source to create dimensional model for reporting purposes.
Worked on maintenance and Administration of SSIS by creating Jobs, Alerts, SQL Mail Agent, and schedule SSIS Packages.
Involved in re-design and deploy new data extractions using SSIS and designed and produced documentation of data transformations for all extractions.
DeployedSSISpackage into production environment and used package configuration to export various package properties to make package environment independent and scheduledJobsusingSQL Server Agent.
Building Ad-Hoc reports in Power BI depending on Business requirements is one of the major responsibility.
Reports developed with Flat files, SQL Database.
Used to connect different data sources like SQL DB (SQL Query), Tabular Model (MDX Query), Web Trends to Power BI and generate reports with different visualizations.
Created Calculated Columns and Measures in Power BI and Excel depending on the requirement using DAX queries.
Built a Tabular Model cube from scratch data and by MDX queries fetched data to SSRS and Power BI reports.
Involved in Configuring and Upgrading the On Premises Data gateway between various Data sources like SQL Server to Azure Analysis Services and Power BI service.
Assigning Power BI Pro licences to the users, configuring role base security by creating different roles in Azure Analysis services and providing access to app workspaces and apps.
Wrote DAX expressions to create new measures, calculations per business requirements.
Determined calculations (measures) to generate new fields in Power BI reports with Data Analysis Expressions (DAX) formulas.
Effectively used data blending, filters, actions, and hierarchies feature in Power BI.
Analyzed the data using Statistical features in Power BI to develop trend analysis. Technologies: Databricks, Power BI, SSIS, AAS, Azure SQL Database, ADF, ADLA, Tableau Client:OneSource Virtual, Inc Location: Atlanta, USA Duration: 03/2018 – 02/2020 Role: Senior MSBI Developer
Contribution:
Understanding the OLAP processing for changing and maintaining the Warehousing, Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
Created reports using stored procedure and Experience in building Reports on Analysis Services cubes.
Designed and implemented Dashboards and Scorecards with business KPIs using Performance Point Server.
Setting the Policies, Limits for the Azure Data Lake Analytics and provide access to the users.
Architecting, Designing and developing complex SSASdatabases and constantly monitoring the daily schedules and provides data to the adhoc requests from the business users.
Modified SSAS Tabular models with dimensions and fact tables from data sources.
Involved in Dimensional Data Modeling and Cube partitioning in SSAS.
Developed Multi-Dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS).
Designed Dimensional Modeling using SSAS cubes for End-User. Created Hierarchies in Dimensional Modeling.
Support and resolve any issues that occur with SSRS and SSIS packages that run daily.
Troubleshoot and tune Reporting Stored Procedure (SSRS) performance issues. Troubleshoot blocking issues. Page 6 of 6
Hands On experience in developing ETL Packages and SSIS Packages for integrating data using OLEDB connection from various sources like excel, csv, Flat file by using multiple transformations provided by SSIS Packages.
Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
Experience in creating Tabular Reports, Matrix Reports, Parameterized Reports, and Sub Reports using SQL Server Reporting Services (SSRS).
Involved in design and development of multiple Power BI Dashboards and reports.
Managing data privacy and security in Power BI
Extensively involved in designing and developing the power BI Data model using multiple DAX expressions to build calculated columns and calculated measures.
Involved in building Data Marts and multi-dimensional models like Star Schema and Snowflake schema.
Calculated measures and dimension members using multi-dimensional expression (MDX). Technologies:SSIS, SSRS, SSAS, Power BI, AAS, ADF, Azure, SQL Server Client:Fidelity Business Services India Pvt Ltd Location: India Duration: 03/2015 – 11/2015 Role: MIBI (SSIS, SSAS, SSRS)/ Data Analyst
Contribution:
Involved In designing and implementing the SSAS cube using the Star Schema dimension model.
Created multiple dimensions from the Named Queries and Various measures for calculating the Average Settled Value, Last Pending Value measures for the fact tables.
Created SSIS Packages for moving data from Excel Files and SQL Server to datawarehouse.
Involved in designing and creating the New Database Schema andcreating the database objects like Stored Procedures and Views.
Involving in the development and designing of SSRS Reports like Target Fund code, Fund Allocation and Fund Target Percentage from the SSAS Cube.
Involved in Tabular Data warehouse and DAX operations for SSAS 2012 and 2008 OLAP databases.
Involved In designing and implementing the SSAS cube using the Star Schema dimension model.
Involved in the analysis of the requirements and gathering requirements for closed loop project.
Created Technical Report Requirement document for the Standard Reports.
Actively involved in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs
Created an SQL Server Integration Services project for extracting the data from Excel Files,SQL server OLTP database to the data warehouse.
Involved in designing and creating the New Operational database schema also in Creating the database objects like Stored Procedures and Views.
Developed multiple power BI Dashboards and deploying them on the SharePoint environment.
Developed and maintained multiple Power BI dashboards/reports and content packs.
Responsible for building Power BI Dashboards using Tabular and Multi-Dimensional Models. Design and model data sets with Power BI desktop based on measure and dimension requested by customer and dashboard needs. Technologies: SSIS, SSRS, Power BI, SSAS, SQL Server 2012 Academic Profile:
• Master’s in Computer and Information Sciences from Sacred Heart University, Fairfield, CT.
• Bachelor of Commerce in Computer Application from Osmania University, Hyderabad, India.
Contact this candidate