About Me

Turning Raw Data into Actionable Strategy.

I am an MIS Executive & Data Analyst with 2+ years of experience transforming complex, multi-source datasets into high-impact operational insights. My expertise spans SQL, Power BI (DAX, Power Query), Python (Pandas/NumPy), and Advanced Excel with VBA.

Whether automating repetitive ETL workflows to save hundreds of manual hours, building real-time SLA monitoring dashboards for C-level leadership, or performing predictive cohort analysis to boost conversion rates, I focus on driving tangible business metrics.

2+ Years Exp.
15+ Power BI Dashboards
100K+ Records Analyzed
30% ETL Time Saved

What I Do

  • Data Analytics & Power BI

    Design interactive executive dashboards with DAX & Power Query, tracking operational KPIs, SLA compliance, and business growth.

  • ETL & Automated Pipelines

    Automate manual compilation using SQL queries, VBA macros, and Power Automate—reducing reporting effort by 30% and improving accuracy to 99%.

  • Predictive & Cohort Analysis

    Analyze user records and sales channels, increasing applicant conversion rates from 18% to 28% through data-driven funnel optimization.

  • Real-Time Alerting Systems

    Engineer automated alerting triggers via Power Automate, reducing operational SLA incident response times by 40%.

Impact Highlights

  • SLA Compliance Boost (+12%)

    Performed regression analysis on 100K+ operational logs at QDIGI Services to pinpoint resolution bottlenecks, boosting team SLA compliance by 12%.

  • Conversion Rate Growth (+10%)

    Analyzed 18,000+ applicant dataset at UNIVO Education, driving conversion rates from 18% to 28% through cohort analysis presented to C-suite leaders.

  • 10+ Hours Saved Weekly

    Built automated weekly reporting macros using Excel VBA & Power Query, eliminating tedious manual copy-pasting for management.

Resume

Download Resume

Work Experience

  1. MIS Executive

    QDIGI Services | Data Analytics & BI March 2025 – Dec 2025 | Noida, U.P.
    • Constructed 10+ interactive Power BI dashboards tracking operational KPIs and SLA metrics for 50+ stakeholders.
    • Automated ETL workflows using SQL and VBA, reducing manual reporting effort by 30% and improving data accuracy to 99%.
    • Identified operational bottlenecks using regression analysis on 100K+ records, improving SLA compliance by 12%.
    • Engineered real-time SLA alerting system via Power Automate, reducing incident response time by 40%.

  2. Documentation Executive (Analytics Focus)

    UNIVO Education | Data Analytics August 2023 – November 2024 | Noida, U.P.
    • Analyzed 18,000+ applicant records, increasing conversion rates from 18% to 28% through targeted cohort analysis.
    • Developed 5+ Power BI dashboards tracking 40% YoY growth to inform executive recruitment strategies.
    • Contributed to 15% application growth by presenting predictive analytics models to C-level leadership.
    • Deployed automated weekly reporting via VBA, saving 10+ hours per week in manual compilation.

Education

  1. B.Tech in Mechanical Engineering

    Rajiv Gandhi Proudyogiki Vishwavidyalaya (RGPV) CGPA: 7.72 / 10.0

    Strong foundation in analytical problem solving, thermodynamics, quantitative modeling, and statistical techniques.

Technical Toolkit & Proficiency

  • SQL & Database Management (MySQL, Window Functions, CTEs)
    92%
  • Power BI & DAX (Power Query, KPI Modeling, SLA Tracking)
    90%
  • Advanced Excel & VBA (Macros, Automated ETL, Pivot Tables)
    95%
  • Python for Analytics (Pandas, NumPy, Matplotlib, Seaborn)
    85%
  • Process Automation (Power Automate, SLA Triggers)
    80%
MySQL DAX Power Query VBA Macros Pandas EDA Cohort Analysis Power Automate Git & GitHub

Portfolio & Projects

  • Power BI

    Agent Task Tracker Dashboard

    Power BI & Viz

    Tracking 15+ KPIs for 50+ agents in real-time. Built with Power Query & VBA macros to transform 10K+ daily raw logs.

  • Python / SQL

    E-Commerce Revenue EDA & RFM

    Python & EDA

    Analyzed 100K+ transaction records to identify high-value customer segments and revenue optimization strategies.

  • Automation

    Excel Shorts Studio

    Automation & Tools

    Automated 9:16 vertical Excel tips engine with animated canvas render, synthesized audio, and YouTube metadata.

  • Web App / Analytics

    EduSphere Course Comparator

    Power BI & Viz

    Widescreen desktop platform for comparing tech courses, tuition ROI, and curriculum depth across ed-tech providers.

  • SQL & Automate

    Real-Time SLA Alert Engine

    Automation & Tools

    SQL-driven automated alert system via Power Automate, reducing SLA incident resolution response time by 40%.

Data Insights & Articles

Contact

Based in Noida, Uttar Pradesh, India

Open for Remote Data Analytics roles & High-Impact Consulting Opportunities

Get in Touch