Pankaj Chaubay

HR department role covering process transformation and HR analytics. Led the SAP Signavio to GBTEC BIC migration for 1,000+ users (licence costs down 50%, 80% active within 30 days). Built the BPM governance model and a repository of 34 end-to-end processes. Built an attrition risk model for HRBPs (regretted attrition from 14.2% to 10.9% in 12 months) and Power BI HR KPI dashboards used by 85% of 140 managers. Connected BIC and LeanIX to Snowflake and Power BI.

Global HR Systems, Controlling & Analytics, alongside the full-time M.Sc. Built a data quality framework for personnel records in Workday and rexx (accuracy up more than 30%). Built a VBA integration of rexx data with Workday reports for the business reviews (mapping effort down 20%). Modelled target processes in BPMN 2.0 with stakeholders. Company-sponsored M.Sc. thesis on generative AI in workforce demand forecasting.

Black Belt for HR (Recruitment, Human Capital Partners, Talent Development) and finance processes. Led the Bright Idea programme across 4 regions with the COO. Value stream mapping cut recruiting cycle time by 15%. Onboarding efficiency up 20% (Philippines). Standardised 50+ process maps for Colombia Payroll and HR Ops. In 2023 led a team of 3 and presented the quarterly people review to the Executive Board. My span analysis turned a 120-role cut into merging 14 teams.

Built an FTE capacity and absence forecasting model (understaffing incidents down 15%). Automated ETL workflows and a central data hub for finance reporting (processing time down 30%). Designed a framework to validate the financial impact of Green and Black Belt projects. Built SQL dashboards for Talent Acquisition and ran KPI workshops with senior HR and business leads.

Built a Power BI people analytics dashboard on compliance and learning metrics (completion rates up 18%). Built SQL reporting on workforce productivity, capability build and compliance for the monthly and quarterly business reviews. Turned business requirements into KPI sets and standardised reporting definitions across 2 business segments.

Led a team of 10 reporting analysts. Ran Pareto root-cause analysis on voluntary attrition in a 7,000+ employee business unit. After the retention actions, voluntary attrition fell from 18% to 13% within six months. Delivered 10+ executive dashboards, moved manual Excel reporting to SQL, and represented the department in ISO audits (green status).

Rationalised the reporting portfolio for Airtel Operations, merging or retiring redundant reports. This cut the report count by 60% and contributed to a 65% efficiency gain. Managed the migration of Virgin Media analytics operations from the UK to India.

One of three reporting analysts. Prepared monthly and quarterly business reviews, built a data collation tool and new dashboards, and analysed defect trends for the quality council. Automated recurring reports with VBA, which freed about 40% of the team's reporting time for other work.

Distributed work to processors, collated internal and external MIS reports for the mid and large market segments, and automated basic reports to reduce the processing team's workload.