Vivek Ranjan Sharma

Data Analyst and Project Manager @Delhivery

Gurugram, IN

Project Management & Service DeliveryLed cross-functional projects on logistics and service optimization using Power BI and Excel-based trackers to align with KPIs and timelines.Service Call AutomationAutomated workflows using JavaScript, Python, and Google Apps Script, reducing resolution time by 30%. Built a chatbot-enabled Automatic Service Response System managing 80% of queries for Havells, Swiggy, and Zomato.Logistics Operations OptimizationStreamlined workflows using Looker Studio, Power BI, and routing tools, cutting logistics costs by 20% via better warehouse and route planning.Resource Allocation & Service QualityManaged resource planning through real-time dashboards and Google Sheets, enhancing service quality and reducing response times.Vendor & Stakeholder ManagementNegotiated contracts using SLA data from Power BI, achieving 12% annual savings. Ensured alignment via Slack, Microsoft Teams, and Zoom.Operational EfficiencyBoosted backend productivity using Trello Butler automation and Zapier, increasing dispatch efficiency and cutting manual work by 25%.Cost Optimization & MonitoringBuilt Power BI dashboards for cost leak and zone-wise performance tracking, reducing logistics spend by 20%.Risk & Exception ManagementDeveloped a risk heat map and SLA tracker in Google Sheets (with conditional formatting) to identify delays and trigger contingency actions.CCTV Infrastructure RolloutDeployed surveillance across centers using standardized templates and SOP-aligned rollout tracking.Advanced Monitoring SolutionsIntegrated ANPR, Facial Recognition, and shipment tracking into surveillance systems; ensured GDPR compliance.Fleet & Security ManagementDeployed GPS tracking to reduce theft and improve compliance. Designed secure COD handling with CCTV, smart lockers, and real-time alerts.