Rakesh Maltumkar
Little Elm,TX
Summary
Visualization on cloud using Microsoft Power BI Certified (70-778). Querying Microsoft SQL Server 2012 Certified (70-461). Implementing a Data Warehouse with Microsoft SQL Server 2012 Certified (70-463). Microsoft Azure Fundamentals Certified (AZ-900). Having 10 years of professional experience in IT industry, out of which 6 years of extensive experience in Data warehousing projects with extensive usage of ETL, Reporting & Analysis Services like SQL Server, SQL Server Integration Services (SSIS), Azure Data Factory (ADF), Azure Analysis Service (AAS), Azure Data explorer (Kusto), SQL Server Reporting Services (SSRS) & SQL Server Analysis Services (SSAS) and Power BI Desktop & Power BI Cloud Service. Having 4 years of strong experience in ETL(SSIS), 2 years of experience in Azure Data Factory (ADF) and worked for development, migration and production support projects and having 3 years of experience in SSAS Tabular Model Cubes (On Premise & Azure) and 2.6 years of experience in SSRS. Have good exposure on Dimensional modelling and exposure on Star Schema and Snowflake schema Having 5 years of rich experience in Microsoft Power BI Desktop, Power BI Administration and DAX.
Overview
9
9
years of professional experience
1
1
Certification
Work History
Senior Power BI Consultant
Microsoft
Redmond, WA
07.2021 - 03.2022
- Project Description: Enable prioritization of Investment areas Feature teams (Engineers and PM) based on usages
- The main aim of the project is to understand the FS in-app (Web Portal) usage, where are users spending most of their time, how long does it take for users to do key tasks, what is a normal user flow, where do we have users starting the most tasks but not finishing them etc
- The activities doing under the field service that we are going to captured in the form of Visualizations based on different categories like User, Entity, and Events etc
- Responsibilities:
- Participate in discussions involving the application creation and understand the requirements and documents regarding Access database tools and their functionalities
- Developing simple to advanced SSAS Tabular models with complex and effective relationships between all Facts and dimension tables
- Creating DAX Expressions, calculated columns and measure groups within cubes
- Defining robust and effective relationships between all Facts and dimension tables (i.e., one-to-many and many-to-many relationships
- Adapting various time intelligence functions and filters in DAX to provide required data
- Deploying completed and validated cubes from development environment to UAT environment and subsequently to production environment
- Improved the Azure Analysis Service performance by applying different best practices
- Creating rich visualized dashboards using Power BI desktop
- Creating ad hoc Business Intelligence/Analytical Dashboards utilizing Power BI global filters, calculated columns and measures with complex DAX measure groups, calculations and transformations and using Query Editor and Power Query
- Implemented dynamic row level security in Azure Analysis Service.
Senior Engineer
Wunderman Thompson
Seattle, WA
02.2020 - 04.2020
- Project Description: Wunderman Thompson is a creative, data, and technology agency built to inspire growth for its clients
- Part creative agency, part consultancy and part technology company, our experts provide end-to-end capabilities at a global scale to deliver inspiration across the entire brand and customer experience Responsibilities:
- Created Stored Procedures and Views based on requirement
- Developed simple to advanced SSAS Tabular models with complex and effective relationships between all Facts and dimension tables
- Creating DAX Expressions, calculated columns and measure groups within cubes
- Adapting various time intelligence functions and filters in DAX to provide required data
- Defining robust and effective relationships between all Facts and dimension tables (i.e., one-to-many and many-to-many relationships
- Creation and maintenance of Power BI Dashboards from Tabular Model Cube
- Extensively worked on Row and Object level security in SSAS tabular models and Power BI reports
- Created rich visualized Dashboards in Power BI
- Extensively worked on Power BI Personal Gateways and Enterprise Gateways.
Data Engineer & SQL Developer
Microsoft
Hyderabad
02.2019 - 01.2020
- Project Description: Supply Chain Device care (SCDC) is a Microsoft project related with its digital products like Xbox, Surface Hub, Night Hawk, HoloLens
- Which is used to track the related products and Offers status, here we will provide the details of all products and status of products
- This will help to project managers to track the status and fallow up with respective team
- Responsibilities
- Developing simple to advanced SSAS Tabular models and Multidimensional cubes with complex and effective relationships between all Facts and dimension tables
- This include creating robust table partitioning, roles, perspectives and KPIs within the cube
- Responsible for designing frameworks for cube partitioning, deployments and scheduling cube processing using SQL Agent jobs
- Using Business Intelligence data modelling techniques to model the Cubes in Star-Schema and Snow-Flake Schema architectures, and creating simple to advanced measures/metrics, DAX expressions, calculated columns
- Creation and maintenance of Power BI Dashboards from Tabular Model Cube
- Created Rich visualized Pie Charts, Tree Map, Tabular and Matrix Reports Using Power BI
- Extensively worked on Power BI Personal Gateways and Enterprise Gateways
- Created rich visualized Dashboards in Power BI.
Data Engineer
Polaris Industries
Hyderabad
12.2017 - 02.2019
- SQL, SSAS, ADF, Project Description: Created the dashboards for the client Polaris which will gives the details about their products sales transactions to manage their business and created a warehouse for dealer retail information for Polaris’s client
- Here we are loading the dimensions and facts data by using the SQL server Integration services and created a Tabular model cube and created Power BI Dashboards by connecting to the cube
- Responsibilities
- Development and enhancement of ETL Using SSIS 2012
- Created Stored Procedures and Views based on requirement
- Creation SSAS Cubes (Tabular and Multidimensional)
- Creation of Power BI Dashboards from Cubes
- Created Rich visualized Pie Charts, Tree Map, Tabular and Matrix Reports Using Power BI
- Extensively worked on Power BI Personal Gateways and Enterprise Gateways
- Created rich visualized Dashboards in Power BI.
Data Engineer
Hyderabad
12.2016 - 12.2017
- Power BI, SQL, SSAS, ADF)
- Project Description: Created dashboards for the client Pharmerica which will gives the details about their long-term care facility transactions of the residents
- We created a warehouse which will maintain patients and their pharmacy related data
- Here we are loading the dimensions and facts data by using the SQL server Integration services, by using these warehouse we created a Tabular Cubes
- After creating the cubes we created Power BI Dashboards by using these cube
- Responsibilities
- Development and enhancement of ETL Using SSIS 2012
- Created Stored Procedures and Views based on requirement
- Creation Tabular SSAS Cubes
- Creation of Power BI Dashboards from Cubes
- Created Rich visualized Pie Charts, Combo Charts, Tabular and Matrix Reports Using Power BI
- Extensively worked on Power BI Personal Gateways and Enterprise Gateways
- Created Row level security mechanism in the Power BI reports.
Data Engineer
Microsoft
Hyderabad
07.2014 - 06.2016
- SQL, SSAS, ADF, Project Description: IDS is an Xbox 360 and Xbox One support application, which is used to track the XBOX related products and Offers status, here we will provide the details of all products related to Xbox 360 with status of products
- This will help to project managers to track the status and fallow up with respective team
- Here we also providing Offers on each product in different levels like country region with the help of SSRS reports and Power BI Reports and Web application
- Responsibilities
- Development and enhancement of ETL packages, Creating SPs and Views based on requirement
- Creating Packages on SSIS by using different data Transformations like Derived Column, Conditional Split and Execute SQL Task to load data into data warehouse
- Used Control Flow Tasks like For Loop Container, For Each Loop Container, Sequential Container, Execute SQL Task, Data Flow Task
- Created Cascading Reports, Drill down and Drill through Reports by Using SSRS
- Migrated SSRS Reports to Power BI Reports using Power BI Desktop
- Created Rich visualized Pie Charts, Tree Map, Tabular and Matrix Reports Using Power BI
- Extensively worked on Power BI Personal Gateways and Enterprise Gateways
- Created rich visualized Dashboards in Power BI.
Data Engineer
Westpac Group
Hyderabad
11.2011 - 07.2014
- Project Description: West pack is a leading global financial services company with operations around the world and their services are finance ,insurance ,consumer banking, corporate banking, investment banking, investment management, global wealth management, private equity, mortgages and credit cards
- We receive data from consumer banking, corporate banking , credit cards and finance modules which need to be loaded into data warehouse
- For loading data into Data ware house we are designing SSIS Packages and for data representation we are developing Reports by using SSRS
- Responsibilities
- Development and enhancement of ETL packages, Creating SPs and Views based on requirement
- Created ETL packages for Full load and Incremental Load
- Creating Packages on SSIS by using different data Transformations like Lookup, Conditional Split and Execute SQL Task to load data into data warehouse
- Used Control Flow Tasks like For Loop Container, For Each Loop Container, Sequential Container, Execute SQL Task, Data Flow Task
- Fixing problems in scheduled processes/jobs
- Contacting Source teams if the source data is not placed in time.
Education
Master of Science - Information Security And Computer Networks
Jawaharlal Nehru Technological University
Hyderabad,India07.2013
Bachelor of Science - Information Technology
Jawaharlal Nehru Technological University
Hyderabad,India04.2010
Skills
- Senior Business Intelligence Developer
- Star Schema and Snow Flake Schema
- Facts and Dimensions
- ETL Packages
- Pipelines
- Reporting
- Data Warehousing
- Dimensional Modelling
- SQL Server
- SQL Server Integration Services (SSIS)
- SQL Server Reporting Services (SSRS)
- SQL Server Analysis Services (SSAS)
- Tabular Models or Tabular Cubes
- Multidimensional Cubes (MDX)
- Azure SQL
- Azure Analysis Services (AAS)
- Azure Data Explorer (Kusto)
- Azure Data Factory (ADF)
- Azure Data Bricks
- Power BI
- Power BI Service
- Power BI Administration
- Power BI Enterprise Gateways
- Gateway Configuration
Certification
DW Technologies :Microsoft Business Intelligence (MS-BI)
RDBMS :SQL Server 2008-R2/2012/2014,2016
ETL Tools : SQL Server Integration Services (SSIS) & ADF
OLAP Tools : SQL Server Analysis Services (SSAS) – On Premise & Azure
Reporting Tools : SQL Server Reporting Services (SSRS) and Power BI
Additional Information
- Created Rich visualized Pie & Line Charts, Tree Map, Tabular and Matrix Reports Using Power BI. Extensively worked on Static & Dynamic Row & Object Level Security mechanisms in Power BI. Created rich visualized dashboards from multiple sources, Cubes (SSAS Tabular model) using Power BI Desktop. Extensively worked on SSAS Tabular Model Cubes (On Premise & Azure) and created dashboards using Power BI Desktop. Extensively worked on Power BI Personal Gateways and Enterprise Gateways. Created, maintained & scheduled various reports in Power BI Service. Extensively worked on Data Extraction, transforming the data by using SSIS & Azure Data Factory (ADF). Proven proficiency at Data Transformations like Derived Column, Conditional Split, Lookup, Multicast & Execute SQL Task to load data into Data Warehouse. Maintaining the Log and Audit information in the SQL tables. Have worked in multiple projects as BI Developer in designing and developing ETL Packages & Pipelines of the Projects. Hands on experience in creation of workflows with Tasks, Containers, and various Transformations Good exposure in identifying various dimensions and facts to implement data warehouse architecture. Developed different types of SSRS reports including Sales Report, Client Contact Report, Accounting Statement Report, Billing report and other reports by using SSRS and SQL Server 2012/2014.
Timeline
Senior Power BI Consultant
Microsoft
07.2021 - 03.2022
Senior Engineer
Wunderman Thompson
02.2020 - 04.2020
Data Engineer & SQL Developer
Microsoft
02.2019 - 01.2020
Data Engineer
Polaris Industries
12.2017 - 02.2019
Data Engineer
12.2016 - 12.2017
Data Engineer
Microsoft
07.2014 - 06.2016
Data Engineer
Westpac Group
11.2011 - 07.2014
Master of Science - Information Security And Computer Networks
Jawaharlal Nehru Technological University
Bachelor of Science - Information Technology
Jawaharlal Nehru Technological University