Sameer Suman

Churn & Revenue Impact: Built a churn-risk scorecard (7+ KPIs) for Jindal Steel's HSM customer base, flagging 6.8% of trailing revenue in revenue-at-risk from a 9.8% churn rate — driven 3.5x higher by unresolved escalations — enabling targeted retention action.

Root Cause Analysis: Owned daily RCA for customer-complained defects, producing structured analysis reports covering defect origin and contributing reason, — drove a 54% complaint reduction.

Dispatch Clearance Pipeline: Architected an ETL pipeline consolidating process, quality-testing, and inspection data from Google Sheets and SAP and into a unified master framework — eliminating manual VLOOKUP workflows, improving material clearance rates by 70%, and reducing downstream reporting errors to near zero.

Data Analyst at Jindal Steel Ltd. (2024-01 – 2025-11)

• Churn & Revenue Impact: Built a churn-risk scorecard (7+ KPIs) for Jindal Steel's HSM customer base, flagging 6.8% of trailing revenue in revenue-at-risk from a 9.8% churn rate — driven 3.5x higher by unresolved escalations — enabling targeted retention action.
• Root Cause Analysis: Owned daily RCA for customer-complained defects, producing structured analysis reports covering defect origin and contributing reason, — drove a 54% complaint reduction.
• Dispatch Clearance Pipeline: Architected an ETL pipeline consolidating process, quality-testing, and inspection data from Google Sheets and SAP and into a unified master framework — eliminating manual VLOOKUP workflows, improving material clearance rates by 70%, and reducing downstream reporting errors to near zero.
• Automated Stakeholder Reporting: Deployed UiPath RPA bots to auto-extract finished-goods SAP reports on scheduled triggers and write them into Google Sheets, which fed Power BI directly — eliminating manual VLOOKUP-based preparation and cutting reporting latency from 6 hours to near real-time.

Data Analyst Intern at KreditBee (2023-01 – 2023-06)

• Modeled a 1million+ record loan portfolio in SQL/Pandas to track repayment patterns, identifying that borrowers with high debt-to-income ratios contributed to 62% of 60+ DPD defaults.
• Formulated a Cohort Analysis framework to evaluate 12-month default progression across credit tiers.
• Designed interactive Metabase dashboards to track daily collection efficiency and FPD spikes.

Bachelor of Engineering in Metallurgical and Materials Engineering – National Institute of Technology Jamshedpur (2019-07 – 2023-05)