Pawan Mehra

Analytics (Data & Insights)

• Developed and maintained SQL and Looker Studio dashboards, delivering insights for data pipelines populating Google's Knowledge Graph for Search Features (Weather, Air Quality, Sports, etc.).
• Verify and ensure accuracy, integrity, and consistency of data before publishing into the Knowledge Graph with 99% precision.
• Identify trends and patterns in pipeline performance to drive business decisions impacting real-world users.

Operational Excellence

• Managed 100+ critical pipelines, ensuring 98% uptime by proactively identifying and resolving technical errors.
• Automated manual data validation processes using SQL scripts and Excel macros, resulting in a team productivity gain of 25+ hours per week.
• Resolved an average of 200 critical bugs per month, maintaining a strict 95% SLA.

Stakeholder Management

• Led monthly client meetings and quarterly stakeholder reviews to present pipeline performance reports and clarify complex data concepts.
• Collaborate with cross-functional teams to support the complete lifecycle of visual analytical applications.

• Process Optimization: Completed 1200+ audits across the supply chain, improving hub performance scores from 80% to 92% using data analysis and Kaizen methodologies.
• Insight Generation: Synthesized large datasets to drive variance analysis and forecasting inputs for senior leadership.
• Risk & Fraud Detection: Detected 40+ lakhs in fraud via system-based investigations, preventing 62.61% in potential losses.
• Training & Development: Delivered 3500+ hours of training to frontline teams to standardize learning and improve cross-hub performance.