Power Bi Developer

Mohit Matale

M O H I T M A T A L E

Power BI Developer (Immediate Joiner)

E-mail Id: *****.**********@*****.***

Mobile: +91-805*******/937-***-****

Professional Summary:

Having 5.6 years of experience in Information Technology, in those 5.6 years of experience as BI Developer, Proficient in providing BI solutions using Power BI, SQL Server & Excel.

Having good experience in Power query, Power pivot and Power view for creating the effective reports and dashboards in Power BI.

Experience in creating different type of colorful reports using Power BI desktop.

Worked on Custom Visualizations like Chiclet Slicer, Waterfall Chart and Pulse Chart.

Publishing the reports into Power BI Service and sharing the reports & dashboards with users.

Creating workspaces, apps and applying row level security (RLS) on top of datasets.

Experience on enabling various types of filters for reports and enabling slicers for reports.

Created drill down and drill through reports and used sync slicers to filter data in different pages.

Involved in importing data from transformed excel into Power BI Desktop using get data option.

Used DAX functions like aggregate, date Functions & filter functions to create some of business calculation based on requirement.

Created visual interactions using edit interactions to enable interaction between visuals.

Experience on creating bookmarks and enabling action types like page navigation, bookmarks, web URL & back actions to perform toggling and navigations.

Worked on On-Premises Gateway to refresh the data sources and dashboards.

Experience on creating analysis service tabular models and deploying them to analysis server.

Importing tables and creating data sources, relationships, translations, roles and prospectives.

Experience on creating dashboards, pinning visuals, and sharing with users.

Experience on installing gateways and configuring data sources and enabling schedule refresh.

Have knowledge on SQL Server database and performing DDL, DML operations.

Have good comminution skills and connected with different location clients to have meetings.

Professional Experience:

Working as Power BI Developer in Accenture Ltd. (Payroll of Dynfolics Technologies Pvt Ltd) from Feb- 2022 to Till Date

Working as Power BI Developer in Wipro LTD. (Payroll of Dynfolics Technologies Pvt Ltd) from Jan-2020 to Dec-2021

Mohit Matale

Education:

- Bachelor of Engineering From MIET Gondia

- Diploma in Computer Technology, Government Polytechnic,Sakoli

- Higher Secondary (HSC): Pass out: 2009 from Adarsh Jr. College, Amgaon

Technology Skill set:

TECHNOLOGY TOOLS

Primary Skills Power BI, DAX, Power Query, Azure (ADF) Databases SQL Server 2018, Oracle, Excel, CSV, Snowflakes. Programming languages SQL, DAX

Operating systems Windows 7, Windows 10

Project #5 : Sales Analysis

Client : 321 Sports - UAE

Duration : Oct-2024 to Present

Tools : Power BI Desktop, Oracle, Excel, Power Query, Power BI Services.

Project Details:

The purpose is to monitor, analyze, and optimize the sales performance of the sports club across various revenue streams to support decision-making, boost revenue, and enhance operational efficiency. Tracking revenue sources, monitoring sales trends over the period of time, evaluating membership sales Track New vs renewing members details. Categories segment members by type, student, adult, senior citizens. Keep tracing sales performance by channel like Compare in-person, online, and third-party sales. Evaluate the effectiveness of promotions or marketing campaigns. Mohit Matale

Responsibilities:

Involved in documents creation for all development activities.

Involved in importing data from developed excel into power bi desktop using get data option.

Created different type of visuals with different business measures and dimension attributes.

Created drill down, drill through reports and created buttons with actions to navigate.

Implemented Visual Level, Page level, report level filters and pinning in dashboards.

Created bookmarks and used selections tab to hide and enable visuals based on the actions.

Written simple DAX calculation as per the requirement to maintain business measures.

Worked on report permissions and dashboard permissions to provide access to different users.

Used Quick insights to get various types of visuals to match the requirements.

Experience on relationship tab to provide cardinality between fact and dimension tables.

Involved creating effective reports, dashboards, and publishing into Power BI Service.

Creating the roles for the dashboards, sharing the developed dashboards to the client.

Involved in configuring gateways and performing schedule refresh for dashboards. Project #4 : Supply Chain Management.

Client : HCA Healthcare – U.S.

Duration : Feb-2024 to Oct-2024

Tools : Power BI, SQL Server, Snowflake.

Project Details:

HCA Health care uses Supply Chain Management Dashboard is executive Dashbaord for top level management for decision making and analysis real time visibility, performance tracing, also balancing demand and supply, to control risk management, manage all cost optimization and budgeting. Analyze logistics, inventory holding, procurement, and manufacturing costs to improve profitability.

Responsibilities:

Based on the functional documents we have crated technical documents and get the approvals.

Created drill down, drill through reports and created buttons with actions to navigate.

Implemented Visual Level, Page level, report level filters and pinning in dashboards.

Created bookmarks and used selections tab to hide and enable visuals based on the actions.

Written simple DAX calculation as per the requirement to maintain business measures.

Worked on report permissions and dashboard permissions to provide access to different users.

Used Quick insights to get various types of visuals to match the requirements. Mohit Matale

Experience on relationship tab to provide cardinality between fact and dimension tables.

Involved creating effective reports, dashboards, and publishing into Power BI Service.

Creating the roles for the dashboards, sharing the developed dashboards to the client.

Involved in configuring gateways and performing schedule refresh for dashboards.

Prepare documentations for database applications.

Visualize data and created control reports in Power BI to monitor daily data loads.

Created drill down, drill through, reports as per the client requirements.

Created buttons concepts in reports to navigate from one page to another page in reports.

Handled Power BI report maintenance and resolving maintenance activities.

Creating excel data level reports based on maintenance activities to present to client.

Created Drill Down and Drill through reports based on requirements.

Created tooltips for most of the visuals based on data requirements.

Understanding star, snowflake schema of design of tables. Project # 3 : BS Reporting Management.

Client : Bridgestone

Duration : Feb-2023 to Jan-2024

Tools : Power BI, SQL Server, Excel.

Project Details:

Bridgestone (BS) is a key regional subsidiary of Tokyo-based Bridgestone Corporation, the world’s second largest manufacturer of tires and other rubber products. Bridgestone Corporation and its subsidiaries employ over 143,000 people around the world, operate 181 plants in 25 nations and sell products in more than 150 countries. Responsibilities:

Develop reports and Dashboard till UAT for BI reports to validate data accuracy and ensure alignment with business goals.

Worked with stakeholders to gather requirements and translate them into

actionable insights and Business Requirement Documents (BRDs). Built canvas and model-driven apps with intuitive interfaces to optimize business workflows.

Integrated Power Apps with Data verse, SharePoint, and external data

sources. Designed dynamic galleries, conditional forms, and implemented

automated validations to enhance user experience. Project # 2 : Service Transformation Dashboard

Client : AMTEC Industries Inc.

Duration : Jan-2022 to Jan-2023

Tools : Power BI, SQL Server, Excel.

Mohit Matale

Project Details:

Amtech Industries Inc is one of the top companies in world for Electrical panels manufacturing basically in this requirement they want to analyze overall nine applications which is used by their employees in day-to-day work Also they want track every KPI of these applications. RESPONSIBILITIES & Scope:

As a Power BI developer, I have involved in various phases of this project like Development, Testing and support.

Responsible for defining the scope of the project, gathering business requirements, doing analysis and Documents.

Building the relationships between the various Tables in Power Pivot.

Created New Columns, New Measures using DAX functions.

Created different filters like visual level filters and page level filters and report level filters as per reporting needs.

We have used various visualizations like Matrix, Column chart and Bar graph, Tree map and water fall charts and Card Visualizations.

Designed diverse types of reports like drill down, drill through, and Slicers.

Developed custom report tool tips for different reports to showcase the multiple data points in one report.

Created various Customized and interactive Reports and Dashboards in Power BI.

Created RLS security on region and zone level

Created All Final Documentation of reports while deployment & Handover to Client Project # 1 : Retails Sales Dashboard.

Client : American Super Market.

Duration : Jan-2020 to Dec-2021

Tools : Power BI, MySQL, Teradata.

Project Details:

Client is an American supermarket chain, based in Sylmar, Los Angeles, California has 50 locations in California. The chain caters to the growing Latino population of California and sells items usually not found in more Anglo- oriented American supermarkets.

Project caters to the management of the Sales and logistics data and provide an optimal Business intelligence solution to give better insights by extracting data from live databases, cleaning and analyzing the data by keeping it in a file system and providing a visually sound presentation in the form of Power BI reports to the key stakeholders for better decision making by identifying the trends for increasing Sales and thereby revenue. Mohit Matale

RESPONSIBILITIES & SCOPE:

As a Power BI developer, I have involved in various phases of this project like Development, Testing and support.

Responsible for defining the scope of the project, gathering business requirements, doing analysis and Documents.

Building the relationships between the various Tables in Power Pivot.

Created New Columns, New Measures using DAX functions.

Created different filters like visual level filters and page level filters and report level filters as per reporting needs.

We have used various visualizations like Matrix, Column chart and Bar graph, Tree map and water fall charts and Card Visualizations.

Designed diverse types of reports like drill down, drill through, and Slicers.

Developed custom report tool tips for different reports to showcase the multiple data points in one report.

Created various Customized and interactive Reports and Dashboards in Power BI.

Created RLS security on region and zone level

Created All Final Documentation of reports while deployment & Handover to Client Personal Details:

Date of Birth : 23-01-1992

Current Address : Hinjewadi Phase 2, Maan, Pune 411057 (MH) Permanent Address : Amgaon, Dist. Gondia 441902 (MH) PAN no : CSGPM5409P

Notice Period : Serving Notice Period 15 Days.

Contact this candidate