Surajpal Singh

Data Analyst | MIS & Reporting

Gurgaon, Haryana 6+ yrs exp 90 · Outstanding

About

Data and MIS reporting professional with 4.5+ years of experience in management reporting, financial and operational data, KPI tracking, budget-versus-actual analysis, reconciliations, and dashboard reporting in a multi-location business environment. Strong foundation in Advanced Excel, data validation, trend and variance analysis, and translating operational data into clear management insights. Building a data analytics portfolio with SQL and Power BI projects.

Skills & Expertise (16)

Advanced Excel Advanced

8.0/10

4.5

Years Exp

Pivot Tables Advanced

8.0/10

4.5

Years Exp

MIS Reporting Advanced

8.0/10

4.5

Years Exp

Dashboarding Advanced

8.0/10

4.5

Years Exp

Power BI Advanced

8.0/10

4.5

Years Exp

stakeholder communication Advanced

8.0/10

4.5

Years Exp

Data Visualization Advanced

8.0/10

4.5

Years Exp

Data Cleaning Advanced

7.5/10

4.5

Years Exp

validation Advanced

7.5/10

4.5

Years Exp

KPI Tracking Advanced

7.5/10

4.5

Years Exp

Variance Analysis Advanced

7.5/10

4.5

Years Exp

Data Reconciliation Advanced

7.5/10

4.5

Years Exp

Trend Analysis Advanced

7.5/10

4.5

Years Exp

Power Query Advanced

7.5/10

4.5

Years Exp

Process Improvement Advanced

7.5/10

4.5

Years Exp

SQL Intermediate

7.0/10

4.5

Years Exp

Work Experience

Assistant Manager – Facility & Business Support

Knight Frank India Pvt. Ltd

Apr 2023 - Present

Oversee day-to-day operations across branches — housekeeping, maintenance, security, repairs and SLA compliance (Daily/Weekly/Monthly/Quarterly MIS). Implement Repair & Maintenance (R&M) framework ensuring prompt resolution of all maintenance issues at assigned locations. Monitor CCTV, Access Control and Intruder Alarm Systems; ensure adherence to Electrical & Fire Safety Audit Calendars. Coordinate finalization of new rented offices, certify furnishing completions, and conduct measurement activities in liaison with Infrastructure/IRM at H.O. Ensure all AMC renewals and statutory compliance renewals (PF, ESI, Minimum Wages) are completed before expiry — zero lapses achieved. Implement ISO 9001–2015 guidelines across all assigned branch locations; ensure records and documentation are audit-ready. Monitor pest control, scrap disposal, horticulture, and cleanliness; act as escalation point for all FM-related issues. Manage end-to-end vendor lifecycle: onboarding, quotation, negotiation, PO via Oracle, billing, agreement renewal and termination. Maintain 100% adherence to NO PO = NO Work policy; prepare and update vendor agreement tracker and AMC tracker for M&E equipment. Achieve consistent 10%+ cost savings through rate benchmarking and introduction of competitive vendors. Prepare facility dashboards, monthly accruals and KPI reports for senior management; reconcile vendor, debtor and creditor data and flag inconsistencies. Track budget vs. actual operating expenses, analyze variances, consolidate billing inputs and submit accurate reports to Finance within deadlines.

MIS Executive – Facility & Administration

Knight Frank India Pvt. Ltd

Sep 2020 - Apr 2023

Prepared MIS and management reports; analyzed facility, financial and operational data; supported transaction processing and finance systems. Consolidated procurement, budget and vendor data across multi-location facility operations to support reporting and business decisions. Coordinated repair services (plumbing, electrical, carpentry, painting) and ensured food service hygiene and supply standards. Prepared Budget vs. Actual reports, tracked deviations, validated inputs and summarized key findings for administration and finance stakeholders.