Pawan Kumar

Detail-oriented MIS professional with 1.5+ years of experience in MIS reporting, data management, dashboard development, data validation, and reporting automation. Proficient in Advanced Excel, Google Sheets, Power BI, SQL, Power Query, Pivot Tables, XLOOKUP, and Zoho CRM. Experienced in preparing daily, weekly, and monthly MIS reports, maintaining KPI trackers, reconciling business data, and providing accurate performance reports to support management decision-making.

MIS Quality Analyst - Car Dekho Group - Gurgaon

(2026-03 - 2026-05)

Used Car Finance Operations – Contract-Based

• Prepared and maintained MIS reports and performance dashboards for all-India used car finance operations, enabling effective performance tracking and data-driven operational decision-making.
• Prepared regular reports covering productivity, MoM performance, disbursement, payout/payout%, targets, incentives, recovery, and deductions.
• Performed data collection, cleaning, validation, reconciliation, and quality checks to maintain reporting accuracy.
• Consolidated data from multiple business teams and maintained centralized trackers for operational and management reporting.
• Created and maintained KPI dashboards and trackers using Advanced Excel, Google Sheets, Power BI, SQL Server, Power Query, Pivot Tables, and XLOOKUP.
• Coordinated with Finance and field teams regarding payout, GST, hold, recovery, and deduction-related queries.
• Reduced manual reporting effort by automating recurring reporting activities using Excel and Google Sheets.

Data Management Executive - Vaish Industries

(2025-02 - 2026-01)

• Managed business data, MIS trackers, customer records, quotation data, and operational reports using Google Sheets, Advanced Excel, and Zoho CRM.
• Designed and implemented standardized MIS trackers for recurring reporting activities, reducing manual reporting effort across 2 teams.
• Automated quotation and CRM workflows, reducing quotation turnaround time by approximately 50%.
• Built dashboards and trackers to monitor quotation, customer, follow-up, and conversion-related performance.
• Performed data validation, reconciliation, and regular quality checks to improve data accuracy and reporting consistency.
• Automated lead creation, follow-up tracking, and customer record updates through Zoho CRM workflow rules.

Bachelor of Arts - Programme - Delhi University (2024)

12th - PCM – English (2020)

10th - English (2018)