Keerthana Venkat

• Delivered data analytics and KPI reporting for France's warehouse operations, analyzing inventory utilization, accuracy, aging, service levels, and optimization using Excel, Power BI, SQL, and ERP systems.
• Developed and automated standardized dashboards and performance reports, enabling leadership to identify trends, risks, and opportunities for cost reduction and operational efficiency.
• Ensured data integrity, validation, and audit readiness by performing reconciliations, spot checks, and documentation reviews in line with governance and compliance standards.
• Conducted inventory health and utilization analysis (excess, slow-moving, at-risk inventory), and provided data-driven recommendations to reduce waste and improve working capital.
• Optimized inventory parameters (PAR/reorder levels) using historical consumption and utilization trends to support demand alignment and minimize expiration risk.
• Partnered cross-functionally with Supply Chain, Operations, Finance, IT, and external vendors to resolve data discrepancies, align system records, and support informatics-driven decision-making using SAP WM.
• Working on KPIs like tax, volumes, etc., for beverages, snacks, and food for the entire France sector.

UK sector:

• Part of the Quality & Food Safety (QFS) and Make Operations team of the UK 3 manufacturing plants at Pepsico as a Data Analyst.
• KPI Monitoring, Management & Performance Optimization. KPIs included Quality complaint analysis, True Efficiency, Net efficiency.
• Waste and volume analysis of two manufacturing plants, dashboard management, and identifying the key areas of improvement on a weekly basis.
• Developed an interactive advanced Excel spreadsheet using Power Query to track KPIs.
• Developed automated KPI dashboards using Power BI to provide real-time visibility into supply chain performance for the QFS Head of the UK.
• Data extraction on SAP MM for all manufacturing volumes, and ERP for demand planning to land on KPIs like volume fill, PSA, waste metric, and downtime

• Neuland Laboratories (a pharmaceutical company and GMP manufacturer) is a contract manufacturing service provider for NCE APIs and a leading manufacturer of active pharmaceutical ingredients (APIs).
• End-to-end raw material planning for 33 CMS and scale-up API projects with an OTIF of 99%. Improved on-time delivery (OTD) by 30% through the establishment of a detailed performance tracking system.
• Data Driven Insights on procurement and planning the raw materials. Monthly dashboard preparation and providing risk assessment of the current market scenario to drive decisions toward the business goals.
• Member of cross-functional teams and single point of contact from SCM for CMS projects.
• Collaboration and stakeholder management across the organization with departments like R&D, project management, production, quality teams, and inventory management.
• Enabling the automation of the supply chain department by thoroughly digitalizing the entire process of the supply chain through identifying milestones.
• As a part of Strategic Sourcing, Supplier Relationship Management, alongside Risk Identification, and contingency plans for Vendors.
• Supply planning for all custom manufacturing projects and supporting the demand planning and forecast team as and when required.