Pankaj Chaubay

Leveraged data engineering, advanced analytics, and workforce analytics to optimize workforce metrics, eliminate reporting anomalies, and support HR digital transformation and people analytics initiatives. Developed an anomaly-detection framework improving data accuracy by 30% across global systems. Automated Workday integration pipelines, cutting manual entry by 95% and reporting time by 40%. Completed a corporate-sponsored thesis on GenAI-driven workforce demand forecasting (BayWa r.e., Renewable Energy).

Led cross-functional Digital Transformation, M&A Post-Merger Integration, and Operational Excellence programs as a Lean Six Sigma practitioner across US, Ireland, Colombia, Philippines & India. Directed a global innovation program generating $30M+ verified savings (2023). Led digitization cutting transaction costs 70% ($1.64→$0.50). Standardized 50+ process maps/SOPs during M&A integration. Used Lean & Value Stream Mapping to cut cycle times 20% and boost process efficiency 20%

Business/Data Analyst bridging backend data assets, data governance & organizational transformation. Partnered with Six Sigma Executives on Fleet Management data workflows, unlocking $40M in savings (single FY). Built a Data Governance Framework tracking Green/Black Belt initiative impact. Automated global Finance data consolidation, cutting tracking discrepancies. Engineered ETL pipelines & optimized SQL/RDBMS queries, boosting processing speed 30%.

Business Analyst focused on operational scaling, BI reporting, and cross-functional solution design. Gathered technical/functional specs across business units, translating bottlenecks into optimized data tracking systems. Built SQL-driven BI dashboards for Talent Acquisition & HR, enabling real-time visibility into capability gaps and training compliance. Standardized reporting parameters across 2 major business segments, reducing manual duplication and improving consistency.

Managed a team of 10 data analysts across delivery reporting, database migrations, and workforce analytics. Migrated legacy Excel reporting into automated SQL architectures, cutting processing time. Ran Pareto root-cause analysis across 7,000+ employees, cutting attrition 30%. Led ISO Audit compliance to green-status certification. Automated performance trackers, eliminating 500 hrs/week manual effort. Implemented cross-system data governance, ensuring 100% data integrity.

Defined and deployed reporting structures and process improvement initiatives for major telecom clients — the foundation of a long-term career in operational excellence and process transformation. Redesigned Airtel Operations reporting, cutting report count 60% and improving efficiency 65%. Led Virgin Media's reporting/analytics migration from UK to India. Drove post-migration automation, reducing reporting turnaround time by 75%.

Delivered business reporting, process automation, and quality analysis to support leadership decision-making. Drafted MBR/QBR reviews, identifying pain areas for corrective action. Built a real-time data collation tool, achieving a 40% productivity gain. Implemented new dashboarding and reporting standards. Analyzed defect trends for Quality Council documentation. Engineered VBA-based process automation, cutting manual effort 80% and boosting accuracy to 100%.

Key Accomplishment - Work distribution and collection post the processing is done - Downloading data from website and maintaining data on local machine to fill missing details. - Collation of all Internal & External MIS reports of mid and large market business segment. - Automate basic reports to reduce workload on processors.