Digvijay Dilip Raut
Pune
Summary
Results-driven Power BI Developer & Data Analyst with over 4 years of experience crafting and sustaining interactive dashboards and reports. Specializes in Power BI, SQL, and Advanced Excel, with robust capabilities in data modeling, ETL (Power Query, Dataflow), and DAX. Demonstrated success in delivering high-performance BI solutions, automating reporting, and generating actionable insights across Finance, HR, Procurement, Operations, and Manufacturing domains.
Overview
5
5
years of professional experience
Work History
Power BI Developer (Data Analyst)
Arabian Industries India Pvt. Ltd.
01.2024 - Current
- Developed 12+ interactive dashboards using Power BI, supporting HR, Finance, Procurement, and Maintenance teams.
- Built optimized star schema data models, improving dashboard performance and achieving 25% faster load times.
- Automated recurring reporting using Power Query & Scheduled Refresh, reducing manual efforts significantly.
- Integrated Excel, SQL Server, Web APIs, and OneDrive data sources into consolidated dashboards.
- Implemented Row-Level Security (RLS) and role-based access in Power BI Service to ensure secure data access.
- Created executive-level HR, Financial, and Proposal reports for senior stakeholders.
Data Analyst
TeleGlobal I ternational Pvt Ltd
Pune
10.2023 - 12.2023
- Assisted in the creation of Power BI reports highlighting key performance indicators for stakeholders.
- Developed dashboards using visualization tools to present data effectively.
- Collaborated with cross-functional teams to gather requirements for data projects.
- Conducted data quality assessments to ensure accuracy and reliability of information.
Data Analyst
Yashaswi Institute For Skill Development
06.2021 - 05.2023
- Executed data cleaning, transformation, and summarization using Power Query for operational reporting.
- Developed interactive Power BI dashboards featuring slicers, drill-through options, and filters to enhance decision-making.
- Analyzed sales performance, customer behavior, and product profitability through comprehensive KPI dashboards.
- Optimized DAX measures and data models, reducing report refresh time by 30% for quicker insights.
Education
Bachelor of Engineering - Automobile Engineering
Dhole Patil Collage of Engineering
Kharadi Pune01.2019
Skills
- Business intelligence tools
- Data visualization
- Cross-functional collaboration
- Requirements analysis
- End user support
- Testing and debugging
- Power BI and SQL expertise
- Data analysis and reporting
- Data modeling and visualization
- ETL and integration processes
- Advanced Excel skills
- Dashboard creation and optimization
- KPI development and tracking
- Star and snowflake schemas
- Fact and dimension tables
- Relationship management strategies
- Row-level security (RLS)
- Custom visuals and slicers
- Performance tuning techniques
- Problem solving
- DAX proficiency
- Power Query Editor (M-Language)
- Team collaboration
- Analytical thinking
- Dashboard automation
- Requirement gathering
- Domain knowledge in finance, HR, procurement, maintenance, and manufacturing
Projects
- Employee headcount report - designed dashboards to track headcount, hiring, attrition, and demographics (integrated ESS server and Excel) .
- Financial KPI Tracker - Built a finance dashboard visualizing budget versus actuals for better financial control .
- Predictive maintenance report- applied text analysis and word cloud for early fault detection, reducing costs by 15% .
- Cashflow automation- automated complex cashflow tracking using DAX, saving 30+ hours per month for finance teams .
- Bids proposal report- developed a reporting system for bid tracking and analysis, improving success rates and growth opportunities .
Languages
- English, Professional
- Hindi, Fluent
- Marathi, Native
Timeline
Power BI Developer (Data Analyst)
Arabian Industries India Pvt. Ltd.
01.2024 - Current
Data Analyst
TeleGlobal I ternational Pvt Ltd
10.2023 - 12.2023
Data Analyst
Yashaswi Institute For Skill Development
06.2021 - 05.2023
Bachelor of Engineering - Automobile Engineering
Dhole Patil Collage of Engineering