Business Intelligence Analyst with 5+ years in Power BI & Data Analytics
AI is analyzing your overall score…
Identifying your key strengths…
Evaluating your skill match against the job requirements…
Assessing your cultural and operational fit
Results-driven Business Intelligence Analyst with 4.7 years of experience designing enterprise Power BI dashboards, automating workflows, and optimizing SQL query performance across finance, HR, sales, and manufacturing domains. Delivered real-time reporting solutions on datasets exceeding 50M rows, reducing manual effort by up to 60% and achieving 99.5% data accuracy. Proficient in Power BI, DAX, Power Query, SQL Server, SAP HANA Cloud, ETL pipelines, Power Automate, and Python. Proven track record of translating complex data into actionable business insights for 200+ stakeholders across MNC and large-enterprise environments.
Lovely Professional University
Bachelor of Science · Information Technology
August 1, 2022 – June 30, 2024
Seth Jai Prakash Polytechnic
Diploma · Electronics and Communication Engineering
August 1, 2018 – June 30, 2020
AITG Group
Data Analyst — Power BI | Power Automate | SAP HANA
July 1, 2025 – Present
Mumbai, Maharashtra, India
Dhananjay Group
MIS Reporting and BI Analyst — Power BI | Dashboard Developer
September 1, 2023 – June 1, 2025
Mumbai, Maharashtra, India
Warner Electronics Pvt. Ltd.
Excel Analytical Engineer — Business Intelligence
March 1, 2022 – June 1, 2023
Mumbai, Maharashtra, India
Bajaj Auto Ltd.
Trainee Analyst — Data Analytics
September 1, 2020 – December 1, 2021
Mumbai, Maharashtra, India
Real Time HR Cost Monitoring Dashboard
June 22, 2026 – Present
Built a dynamic HR cost tracking dashboard monitoring 8+ metrics across plants, automating variance analysis and reducing the HR cost review cycle from 3 days to 24 hours. Eliminated 100% of manual spreadsheet update cycles, reducing data entry errors by 95% through full automation of data refresh and and distribution workflows.
Revenue Growth Optimization Dashboard
June 22, 2026 – Present
Delivered INR 2.5 Crore in revenue growth by engineering YoY trend analysis and ABC product segmentation, enabling targeted sales strategy for high-performing SKUs. Improved gross margin by 8% through product and regional performance analysis; deployed self-service analytics with advanced DAX and drill-through reports to 200+ users.
Manufacturing Performance Dashboard
June 22, 2026 – Present
Engineered a real-time Power BI dashboard integrating live shop-floor and SQL data streams, providing production KPI visibility including OEE, machine uptime, and defect rates to 30+ plant managers. Reduced production downtime analysis time by 50% through automated anomaly detection, enabling faster root-cause analysis and corrective actions across facilities.
Real Time Sales Performance Dashboard
February 1, 2026 – March 1, 2026
Designed and developed an interactive Sales Dashboard in Power BI to track KPIs including Today Sales, Yesterday Sales, Total Sales, Customer-wise performance, YTD, YOY, MOM, and Monthly trends for Marathwada Auto Compo Group. Integrated real-time data from SAP HANA Cloud using API-based data extraction, ensuring up-to-date and accurate reporting across all business units. Built optimized DAX measures for dynamic calculations including sales comparison, trend analysis, and KPI monitoring, improving analytical depth for stakeholders. Performed comprehensive data transformation and cleaning using Power Query, ensuring data quality and consistency across all source systems. Implemented automated data refresh workflows using Power Automate, reducing manual intervention and ensuring continuous data availability. Enabled drill-down analysis by Plant, Customer, and Product filters, significantly improving business insights and decision-making speed for leadership.
SQL Query Optimization and Performance Tuning
Unknown
January 1, 2023 – Present
Advanced Excel Training with VBA and Macros
Unknown
January 1, 2021 – Present
Kaizen and Continuous Improvement Methodology
Endurance Technologies
January 1, 2021 – Present
Cultural Fit Analysis
The candidate's project diversity across sales, HR, manufacturing, and P&L, along with experience in both MNC and large-enterprise environments, suggests adaptability and a broad understanding of different business contexts. Their focus on continuous improvement (Kaizen certification and awards) indicates a growth mindset and a commitment to optimizing processes, which is a positive cultural fit for many organizations. The progression through roles from Trainee Analyst to Data Analyst also shows dedication and a desire for professional development.
Soft Skills & Operational Fit
The candidate demonstrates strong problem-solving skills, evidenced by their ability to reduce manual processes, improve data accuracy, and deliver measurable business impact. Their experience in stakeholder management and deploying self-service analytics to a large user base indicates good communication and collaboration skills. The Kaizen and Quality Circle awards further highlight a proactive approach to process improvement and operational excellence, which aligns well with a senior BI role.