Headline

Data Analyst | Power BI · SQL · Python · Advanced Excel | MIS Reporting & Dashboard Automation | Open to Analyst Roles Pan-India

About

Data Analyst with hands-on experience turning raw operational data into decisions. I've worked across the full analytics cycle — data cleaning, SQL querying, KPI dashboard design in Power BI, and automated MIS reporting — on datasets ranging from 10,000 operational records to 200,000+ e-commerce transactions. At CEPTA Infotech, I built and maintained Power BI dashboards tracking real business KPIs, implemented automated validation workflows, and drove a 20% improvement in reporting efficiency. I don't just build dashboards — I make sure the numbers behind them are trustworthy. My project portfolio covers three end-to-end analysis case studies: ride-sharing operations (OLA, 100K+ records), inventory management (Excel automation, 60% reduction in report time), and e-commerce customer analytics (RFM segmentation, CLV modelling using Python + SQL). Core skills: Power BI · SQL · Advanced Excel · Python (Pandas, NumPy) · MIS Reporting · Data Cleaning · EDA · KPI Tracking · Dashboard Design · Stakeholder Reporting Final-year B.E. Computer Science, Kurukshetra University (CGPA 7.5). Available immediately after June 2026 graduation. Open to Data Analyst, MIS Analyst, Business Analyst, and BI Developer roles across Gurugram, Delhi NCR, Bengaluru, Hyderabad, Mumbai, Pune, or remote. Let's connect if you're looking for an analyst who ships clean data and clear insights.

Location

Karnal

Work experience

Data Analyst at CEPTA INFOTECH, Jul 2025 - Jan 2026 · 7 mos, MIS / Data Analyst Intern CEPTA Infotech · Jul 2025 – Jan 2026 · 7 months · Haryana, India Analysed operational datasets of 10,000+ records using SQL and Excel; identified reporting inefficiencies and automated validation workflows, improving reporting efficiency by 20%. Designed and maintained Power BI dashboards tracking KPIs and business performance metrics, enabling data-driven decisions for senior management across departments. Cleaned, validated, and structured raw data from multiple sources to ensure accuracy and consistency in MIS reports delivered to stakeholders weekly. Reduced manual reporting effort significantly by building automated reporting pipelines in Excel and Power BI, improving team-wide data quality.

OLA Ride Analysis Dashboard at Self-Employed, Apr 2025 - Apr 2025 · 1 mo, Analysed 100,000+ ride booking records using SQL to uncover revenue trends, booking drop patterns, and peak-hour demand shifts across ride categories. Built interactive Power BI dashboards for revenue tracking, cancellation analysis, and customer segmentation — enabling business stakeholders to identify a 15% estimated booking rate improvement opportunity during peak hours. Delivered actionable recommendations by correlating booking drop patterns with demand timing data, demonstrating end-to- end analytical storytelling.

Education

Bachelor of Technology - BTech, Computer/Information Technology Administration and Management, Seth Jai Prakash Mukand Lal Innovative Engineering & Technology Institute (JMIETI)

Bachelor of Engineering, Computational Science, Kurukshetra university