Chandan Gaur

Business Analyst and Workforce Analytics professional with 10+ years of experience translating operational data into actionable business insights, performance reporting and decision support. Experienced in requirements gathering, KPI analysis, dashboard development, trend analysis, root-cause analysis, forecasting, capacity planning, data validation and reporting automation. Strong hands-on capability in Advanced Excel, Power BI, SQL/PL-SQL, Tableau and executive reporting, with experience partnering with stakeholders to convert business requirements into scalable analytical and reporting solutions.

Team Lead – WFM - Tech Mahindra - Noida

(2025-12)

• Translate workforce and operational requirements into KPI reporting, dashboards and analytical solutions for business stakeholders.
• Lead workforce analytics, executive reporting and performance analysis across SLA, abandonment, productivity, occupancy, capacity utilization and service metrics.
• Automate recurring analytical reports using Advanced Excel and reporting tools, improving reporting efficiency and reducing manual intervention.
• Perform trend analysis and root-cause analysis on service-level, abandonment and capacity metrics to support corrective business actions.
• Prepare revenue projections, accruals, stakeholder presentations and ad-hoc business analysis to support management decisions.
• Own data validation, reporting governance and SOPs; convert stakeholder requirements into standardized and scalable reporting solutions.

Team Lead – WFM - Flipkart Internet Pvt Ltd - Bengaluru

(2025-01 - 2025-12)

• Partnered with customer-operations stakeholders to identify reporting and analytical requirements and translate them into dashboards and reporting frameworks.
• Designed Advanced Excel reporting solutions and automated recurring reports to improve accessibility and consistency of business information.
• Prepared weekly/monthly business reviews, KPI scorecards and management analysis highlighting operational performance and trends.
• Supported manpower planning, billing validation, revenue reporting and business performance analysis using operational data.
• Gathered requirements and translated business needs into reporting enhancements and standardized dashboards.

Team Lead – WFM - Flipkart (via Teamlease Services Pvt Ltd) - Bengaluru

(2021-06 - 2025-01)

• Built automated MIS and analytical dashboards, reducing manual reporting effort by 30% and improving reporting scalability.
• Analyzed operational performance through scorecards, executive dashboards, SLA trends, forecasting and workforce analytics.
• Used data-driven insights to support staffing, service-level and workforce decisions across customer operations.
• Maintained data accuracy and reporting governance across recurring and ad-hoc analytical deliverables.
• Worked with stakeholders to deliver customized reports, insights and process-standardization initiatives.

Software Analyst - Optimum Solutions (Marina Bay Sands) - Singapore

(2018-09 - 2019-12)

• Developed and maintained data integration services and reporting databases supporting structured data extraction and reporting.
• Performed data validation, database administration and process optimization to improve data reliability and reporting processes.

Data Analyst - Google (via GlobalLogic) - Gurugram

(2017-06 - 2018-06)

• Created PL/SQL scripts for data extraction, transformation and reporting, with analytical reports supported by accuracy and compliance controls.
• Supported business stakeholders with data-driven insights and reporting requirements.

Associate – Accounts Payable - Hays Business Solutions - Gurugram

(2016-07 - 2017-06)

• Implemented process automations and supported audit-compliant reporting, maintaining accurate records and reporting documentation.

B.Com - Indira Gandhi National Open University (IGNOU) (2016)

Certification - Oracle 11g - NIIT

Certification - Python - NIIT