Keshu Ranjan is an accomplished analytics professional with experience across retail, manufacturing, and e-commerce, specializing in customer insights, data warehousing, audience segmentation, and performance optimization. At Tredence Analytics, he has driven high-impact initiatives for global retailers by building advanced SQL logic, conducting order-level customer experience analysis, and creating severity-based fulfillment scoring systems that reduced high-impact issues by 22%. He has also played a key role in launching and scaling a multi-million-dollar retail media network, developing 500+ audience segments, optimizing large-scale data pipelines, and improving campaign performance and ROI through A/B testing, PySpark pipelines, and interactive dashboards. Previously at Accordian (Merilytics), Keshu worked extensively on data modeling, performance analytics, COGS optimization, and warranty lifecycle reporting. He designed reporting infrastructures, integrated multi-source datasets into unified warehouses, improved SSAS model performance by 80%, and created executive dashboards that boosted sales revenue by 15% and reduced lead times by 30%. His work enabled granular visibility into key operational, financial, and product metrics for Fortune 500 retail clients. Before that, at Adani Group, he led production and operational analytics initiatives, identifying inefficiencies, developing Excel-based data models, and implementing improvements that enhanced productivity by 25% and generated $2.5M in annual savings. He also streamlined reporting workflows, reducing turnaround time by 40%. Keshu began his journey at Myntra, where he delivered customer cohort analyses, retention insights, lifetime value models, and RFM-based segmentation. His work helped drive a 20% improvement in retention, 15% growth in customer lifetime value, and a 25% increase in purchase frequency for high-engagement cohorts. Across all roles, Keshu has demonstrated expertise in SQL, Power BI, Azure Databricks, PySpark, Tableau, Excel, and data modeling—consistently delivering business impact through data-driven decision-making and scalable analytics solutions.