Power BI Developer with 5 Years Experience

Nitin Mohadikar

Power BI Developer

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

mobile- +91-958*******

Professional Summary:

Having 5 years of experience as a Power BI Developer with strong skills in Power BI and SQL Server.

Proficient in Power Query, Power Pivot, and Power View for building effective reports and dashboards.

Experienced in creating interactive and colorful reports with visuals.

Skilled in publishing reports to Power BI Service, creating workspaces, apps, and applying Row Level Security

(RLS).

Hands-on experience in filters, slicers, drill-down reports, sync slicers, and visual interactions for better analysis.

Strong knowledge of DAX functions (aggregate, date, filter functions) to build business calculations.

Expertise in bookmarks, page navigation, and actions for report navigation and toggling.

Knowledge of SQL Server (DDL, DML operations) with ability to manage data sources and relationships. Professional experience:

Working as Power BI Developer in winspectrum business solutions, Nagpur from Nov-2020 to Till Date Education:

Completed Bachelor of Computer Application (BCA) from RTMNU NAGPUR University.

Completed Higher Secondary School (HSC) from Maharashtra State Board. Technology Skill set:

TECHNOLOGY TOOLS

Primary Skills Microsoft Power BI

Databases SQL Server 2021

Programming languages SQL Server

Operating systems Windows 10, Windows 11

Project Description:-

project 4 Inventory & Warehouse

Client IBM (Pune)

Role Power Bi Developer

Duration Dec-24 To Till Date

Description:-

The Cigna Insurance Domain Project focuses on building a regional data warehouse and Power BI reporting solution for policy, premium, claims, and enrolment data. It integrates multiple systems into a single source of truth using a dimensional star schema model with fact and dimension tables.

The project provides executive dashboards for Finance, Underwriting, Claims, and Provider Networks to monitor performance and risks.

It enables data-driven decision-making through KPIs like Total Premiums, Claims Paid, Loss Ratio, and Claim Severity. Security and governance are ensured with row-level security, data lineage, audit trails, and automated refresh schedules.

Roles and responsibilities:-

1. Developed Power BI dashboards to track KPIs such as Total Premiums, Total Claims Paid, Loss Ratio, and Claim Severity.

2. Designed and implemented a Star Schema data model connecting Fact tables (Claims, Premiums, and Enrolment) with relevant Dimensions (Policy, Provider, Customer, Plan, Region, Time). 3. Created DAX measures for financial and operational KPIs ensuring consistency and accuracy across reports. 4. Integrated data from multiple systems into a centralized data warehouse for unified reporting and analytics. 5. Developed interactive visuals (KPI Cards, Trend Lines, Maps, Waterfalls, and Drill through pages) for executive and operational insights.

6. Implemented Row-Level Security (RLS) to restrict access by Region and Business Unit for data governance. 7. Configured scheduled refresh in Power BI Service ensuring real-time and up-to-date reporting. 8. Collaborated with finance and claims teams to define business logic, KPIs, and analytical requirements. 9. Optimized report performance through summarized tables, proper relationship modelling, and minimized bidirectional filters.

10. Provided ad-hoc analysis and insights on claim trends, premium growth, and provider performance Project 3 Inventory & Warehouse Executive Dashboard Client Best Buy (USA)

Project Name INVENTORY and WAREHOUSE Projects.

Role Power BI Developer

Duration Aug 2023 to Nov 2024

Description:

Best Buy is an American multinational consumer electronics retailer Best Buy sells products like software, video games, music player, mobile phones, digital cameras, car stereos in addition to home appliances like washing machines, dryers, and refrigerators.In my recent project for best buy my domain was inventory and warehouse management. In this our major responsibilities are like managing inventory turnover, stock availability, and profitability, especially during high-demand timelike holiday sales. Roles & Responsibilities:

1. Worked on Inventory & Warehouse Management dashboards for Best Buy to track stock, costs, and warehouse performance.

2. Built data models using star schema, connecting fact and dimension tables with proper relationships. 3. Developed KPIs like Inventory Turnover, DSI, Stock Availability, Stock out Rate, and Carrying Cost using DAX measures.

4. Designed interactive dashboards with cards, bar/line charts, pie charts, heat maps, and drill-down visuals. 5. pplied row-level security (RLS) and filters for user-specific data access. 6. Validated data accuracy by cross-checking ETL, source systems (CRM, SAP), and DAX logic. 7. Published reports to Power BI Service, created workspaces, and shared dashboards with stakeholders. 8. Collaborated with business and ETL teams to resolve data quality issues and align reports with BRD/FSD requirements.

Project 2 SUPPLY CHAIN MANAGEMENT

Client Bridgestone

project Name supply chain management

role POWER BI developer

duration Mar 2022 to July23

Description:

This power bi project for Bridgestone (BS) focuses on end-to-end Supply Chain management performance analysis. It includes KPIs like Cash-to-Cash Cycle, perfect order rate, inventory turnover, and sales by market to track efficiency and profitability. The dashboard uses visuals such as cards, line charts, and bar charts for clear insight into operations. It helps management monitor sales, delivery delays, and logistics performance for data driven decisions Roles & Responsibilities

1) Designed and developed interactive Power bi dashboards and KPIS for supply chain performance tracking and management reporting.

2) Create and optimized DAX measures such as cash-to-cash cycle, perfect order rate, and inventory turnover for real time analytics

3) Built efficient data models and relationships between orders, finance, inventory and customer dimension table.

4) Integrated multiple data sources (orders, finance, freight, inventory) into a centralized power Bi dataset. 5) Implemented visualizations including cards, bar charts, line charts, and donut charts to represent KPIs and trends.

6) Worked closely with business stakeholders to gather requirements and validate insights for decision making. 7) Ensured data accuracy, performance optimization, and timely dashboard updates. Project 1 Pharmacy Inventory & Warehouse Management Project client CVS Health Corporation (USA)

Project Name Pharmacy Inventory & Warehouse Management Project Role Power Bi Developer

Duration Nov-2020 to Feb2022

Description

The CVS Health Pharmacy Inventory & Warehouse Power BI Project focuses on optimizing drug inventory, warehouse utilization, and cost efficiency across US regions. It uses a star schema data model integrating sales, expiry, and logistics data. The project builds interactive Power BI dashboards for KPIs like Inventory Turnover, GMROI, and Warehouse Utilization.

Its core goal is to support data-driven decision-making to reduce stock outs and expired drug loses Roles and Responsibilies

1. Developed interactive Power BI dashboards to monitor drug inventory, warehouse utilization, and cost efficiency.

2. Designed a Star Schema data model linking Fact Inventor with dimension tables (Product, Warehouse, Region, Date, and Customer).

3. Created DAX measures and KPIs such as Inventory Turnover Ratio, DSI, GMROI, and Stock Availability for actionable insights.

4. Built visual reports using Cards, Bar Charts, Line Charts, Pie Charts, and Heat Maps to track performance metrics. 5. Ensured data accuracy through cross-validation between ERP, POS, and Warehouse databases. 6. Optimized dashboard performance using summarized tables, relationship tuning, and efficient data modelling practices.

7. Monitored expiry trends and implemented filters for near-expiry drugs (within 90 days). 8. Collaborated with the Inventory & Supply Chain Analytics team to align dashboards with business requirements. 9. Delivered automated insights for management to reduce stock outs and minimize expired drug losses. 10. Maintained data refresh schedules and governance ensuring up-to-date and reliable reporting. Personal Details:-

NAME NITIN RAJENDRA MOHADIKAR

FATHER NAME RAJENDRA SHRAVAN MOHADIKAR

ADDRESS PLOT NO 877, DESHPANDE LAY OUT NEAR WATER TANK NAGPUR 440008

DATE OF BIRTH 12TH DECEMBER 1998

PAN NUMBER EOPPM6839L

MARITAL STATUS UNMARRIED

Contact this candidate