PRATIK SHARMA

Operations Coordinator (Supply Chain Associate)

Bamko | Aug 2025 – Present | Dehradun, India

• Manage cross-functional operations across procurement, logistics, and customer service to ensure 98% SLA compliance.

• Analyze order and inventory data using Excel VBA, Power Query, and ERP (SAP, Oracle) to improve delivery accuracy by 12% and reduce turnaround time by 20%.

• Implement lean workflow automation that reduced manual errors and shortened order fulfillment cycles by 15%.

• Develop KPI dashboards in Power BI and Excel to track on-time delivery, cost per order, and process efficiency.

• Partner with suppliers and logistics teams to enhance vendor performance and supply chain visibility.

• Drive continuous improvement (Kaizen) initiatives and process optimization to achieve operational excellence.

Operations & Customer Support Executive (Logistics Executive)

PAN Trinity | Jan 2019 – Feb 2023 | Dehradun, India

• Oversaw end-to-end order processing, logistics tracking, and customer support for Ayurvedic and antiviral product lines.

• Optimized digital product listings and e-commerce operations, improving product visibility and accuracy by 25%.

• Utilized Python and SQL for demand forecasting, trend analysis, and peak season inventory planning.

• Built interactive dashboards in Excel Power Query and Tableau, achieving 92% forecasting accuracy.

• Resolved client escalations with professionalism, improving customer satisfaction metrics by 18%.

• Collaborated with warehouse and logistics teams to reduce shipment delays by 10% and ensure SLA adherence.