Back to Developers
rahul bhardwaj

rahul bhardwaj

Data Analyst

Noida, Uttar Pradesh 2+ yrs exp 84 · Excellent

About

Results-driven Data Analyst and MIS Analyst with 1.5+ years of experience delivering enterprise-level reporting and business intelligence solutions for large-scale clients including BPCL. Proven expertise in Power BI, Advanced Excel, SQL, and Python with hands-on experience in ETL pipeline development, KPI dashboard design, and data validation. Adept at translating complex datasets into actionable insights for senior stakeholders, driving operational efficiency and data-driven decision-making.

Skills & Expertise (34)

Dashboard Development Advanced
8.0/10
2
Years Exp
Power Query Advanced
8.0/10
2
Years Exp
Excel Macros Advanced
8.0/10
2
Years Exp
DAX Advanced
8.0/10
2
Years Exp
Data Visualization Advanced
8.0/10
2
Years Exp
MIS Reporting Intermediate
7.5/10
2
Years Exp
KPI Tracking Intermediate
7.5/10
2
Years Exp
Business Intelligence Intermediate
7.5/10
2
Years Exp
Data Analysis Intermediate
7.5/10
2
Years Exp
Analytical Thinking Intermediate
7.0/10
2
Years Exp
Cross-Functional Collaboration Intermediate
7.0/10
2
Years Exp
Data Validation Intermediate
7.0/10
2
Years Exp
Data Transformation Intermediate
7.0/10
2
Years Exp
ETL Pipelines Intermediate
7.0/10
2
Years Exp
NumPy Pivot Tables Power Pivot Business Requirements Gathering Stakeholder Reporting Data Reconciliation VLOOKUP Data Loading XLOOKUP Automated Reporting Interactive Dashboards Pandas Query Optimization Data Extraction Stored Procedures CTEs Subqueries Joins Data Modelling Trend Analysis

Work Experience

MIS Executive – Data Analyst

Inknowtech Private Limited (Client: BPCL)

Jan 2025 - Present

Developed and maintained 10+ MIS and operational dashboards in Power BI and Advanced Excel, providing real-time visibility into KPIs for BPCL plant stakeholders across multiple locations. Built automated alerts resolution reporting system tracking, monitoring, and closing system-generated alerts across multiple plants, reducing manual follow-up time by 40%. Engineered ETL workflows using SQL to extract, transform, and load data from multiple enterprise sources, ensuring 99%+ data accuracy across all reports. Designed DAX-driven Power BI dashboards with interactive visuals and trend analysis for downtime frequency, alert patterns, and resolution timelines, enabling faster operational decisions. Automated daily, weekly, and monthly MIS summary reports using Power Query and Excel macros, reducing manual reporting effort by approximately 5 hours per week. Performed data validation and reconciliation across datasets, implementing logic checks to maintain consistency of filters, measures, and calculation logic across all reports. Collaborated directly with business users and senior stakeholders to gather reporting requirements and deliver data-driven insights aligned with BPCL operational standards.

MIS Executive

Enrich (Aptara)

Mar 2024 - Dec 2024

Collected, organized, and analyzed MIS data related to automotive branding including product descriptions, features, and specifications for structured reporting. Developed and maintained Excel-based MIS reports and Power BI dashboards to support business operations and management decision-making. Monitored industry trends and best practices to continuously improve MIS systems, processes, and reporting accuracy.

Education

B.Tech – Electronics and Communication Engineering - MJP Rohilkhand University

- · Afghanistan

Certifications

No certifications added yet

Interested in this developer?

Profile Score Breakdown

📷 Photo 10/10
📄 Resume 10/10
💼 Job Title 10/10
✍️ Bio 10/10
🛠️ Skills 20/20
🎓 Education 10/10
⏱️ Experience 9/15
💰 Rate 0/5
🏆 Certs 0/5
Verified 5/5
Total Score 84/100

Profile Overview

Member sinceJun 2026

Availability Details

Visa Status

Need Sponsorship

Relocation

Depends on Offer