Aditya kashyap

<p>Designed and launched role-based Looker Studio dashboards for 4 operational teams, each filtered by employee email with live status update capability, eliminating manual status-check calls.</p><p> Built Process Pulsar (Master Dashboard), a leadership-facing hub aggregating all operational trackers with date, team, and sheet-level drill-down filtering.</p><p> Designed 4 live Flow Management Systems (FMS) with planned vs. actual TAT tracking for O2D, Audit, HR, and Payroll workflows, reducing delivery delays by 25%+.</p><p> Built recurring checklist analytics systems for 3 teams with frequency scheduling (daily/weekly/monthly), planned vs. actual time tracking, and per-employee delay visibility.</p><p> Developed payroll and HR analytics suite including conveyance claim tracker, attendance compilation, timesheet productivity analysis, and client cost and profitability reporting.</p><p> Automated WBR reporting, reducing manual reporting effort by 40% and reporting cycle time by 35% through templated KPI dashboards.</p>

<p>Built automated SQL pipeline to flag cancelled-but-unprocessed orders in real time, diagnosed courier allocation failures, and reallocated 60% of unassigned orders, directly recovering 60% revenue leakage.</p><p> Optimized end-to-end SQL reporting pipeline, automating hourly workflows and cutting query turnaround from hours to minutes, a ~50% improvement, enabling real-time stakeholder decisions.</p><p> Developed Power BI dashboards for senior supply chain leadership, tracking SLA compliance, capacity utilization, backlog, and logistics performance across 3+ business units.</p><p> Managed 2-hourly non-serviceable pincode identification pipeline, enabling proactive courier reactivation and reducing reverse logistics losses by 50–60%.</p><p> Built last-mile delivery performance tracking across couriers and pincodes, covering first-attempt delivery rate, delivery TAT, and out-for-delivery to delivered conversion to flag underperforming lanes.</p><p> Analyzed NDR (non-delivery report) reasons and RTO trends in last-mile operations by courier and pincode, and shifted volume to better-performing partners to reduce failed deliveries.</p><p> Conducted Supply Chain Opex Analysis, identifying cost leakages and efficiency gaps through KPI deep-dives across reverse logistics and fulfilment operations.</p>

<p>Owned daily, weekly, and monthly lead profiling and sales analytics for software sales leadership, building Advanced Excel and Power BI reports driving data-driven targeting decisions.</p><p> Built unified interactive dashboard combining lead, profiling, and sales metrics, reducing manual reporting time and improving team-level performance visibility.</p><p> Designed SLA compliance and operational performance dashboards for service teams across multiple accounts.</p>