Abhishek Medar
Hyderabad
Summary
Supply Chain Informatics and Analytics professional with over 5 years of experience transforming operational and inventory data into actionable insights. Strong expertise in data analytics, KPI reporting, inventory optimization, utilization tracking, audit support, and vendor coordination. Proven ability to automate reporting using Power BI, Excel, and SQL, improve data accuracy, and support cross-functional teams across Supply Chain, Operations, Finance, and IT environments.
Overview
6
6
years of professional experience
1
1
Certification
Work History
Supply Chain Associate
Accenture
08.2024 - Current
- Analyzed and monitored supply chain KPIs related to inventory utilization, capacity planning, and operational efficiency.
- Designed and deployed Power BI dashboards to automate reporting and visualize performance trends, reducing manual reporting time from 3 hours to 10 minutes.
- Supported Week-on-Supply (WoS) and buffer planning by forecasting inventory requirements across upcoming quarters.
- Ensured data integrity and compliance through routine validation checks, documentation updates, and exception handling.
- Supported end-of-life and decommissioning activities, maintaining accurate records for audit and compliance purposes.
- Collaborated with global stakeholders across Supply Chain, Operations, Finance, and IT to align data-driven decisions with operational objectives.
- Implemented data-driven recommendations through structured reporting and system updates.
Jr. Production Manager
Snackerstreet Pvt. Ltd
09.2023 - 08.2024
- Monitored material utilization, inventory accuracy, and production KPIs to improve efficiency and minimize waste.
- Maintained detailed usage documentation and audit-ready records to support internal quality and compliance reviews.
- Planned monthly raw material requirements, and coordinated with vendors to align supply levels with consumption trends.
- Supported internal audits by ensuring traceability of materials, batch usage, and inventory documentation.
- Collaborated with the Quality, Warehouse, and Dispatch teams to ensure adherence to SOPs and documentation standards.
- Supported demand forecasting and capacity planning to meet operational requirements, and reduce downtime.
Dispatch and Packaging Supervisor
Snackerstreet Pvt. Ltd.
04.2020 - 08.2023
- Managed finished goods inventory using FIFO methodology, ensuring freshness, accuracy, and compliance.
- Maintained detailed inventory records, and performed monthly stock reconciliations using Excel.
- Coordinated dispatch operations and resolved inventory or delivery discrepancies.
- Generated invoices and reconciled dispatch records using Tally ERP.
- Supervised transport vendors to ensure timely, cost-effective, and compliant deliveries.
Education
B.Tech. - Mechanical Engineering
Hyderabad Institute of Technology and Management
Hyderabad, India05.2019
Skills
Supply chain informatics and analytics
- Inventory utilization and optimization
- KPI monitoring and performance reporting
- Week on supply (WoS) and buffer planning
- Expiration and end-of-life inventory management
- Data integrity, validation, and documentation
Audit, compliance, and quality support
- Internal audit documentation support
- Usage reconciliation and accuracy checks
- SOP and compliance adherence
- Inventory and utilization audits
Tools and technologies
- Power BI (DAX, Power Query)
- Advanced Excel (Pivot Tables, Power Pivot)
- SQL / MySQL
- Tally ERP
Collaboration and operations
- Vendor coordination and inventory controls
- Cross-functional collaboration (supply chain, ops, finance, IT)
- Process improvement and automation
Certification
- Excel: Mother of Business Intelligence
- Power BI Data Analytics
- SQL Beginner to Advanced for Data Professionals
Languages
English
Proficient (C2)
C2
Hindi
Native
Native
Timeline
Supply Chain Associate
Accenture
08.2024 - Current
Jr. Production Manager
Snackerstreet Pvt. Ltd
09.2023 - 08.2024
Dispatch and Packaging Supervisor
Snackerstreet Pvt. Ltd.
04.2020 - 08.2023
B.Tech. - Mechanical Engineering
Hyderabad Institute of Technology and Management