Hosur, Tamil Nadu · India
atAYUSH TRIPATHISUPPLY CHAIN & PROCUREMENT
HomeProjects
📂 PROJECTS / CASE STUDIES

The approach behind
the execution.

Five documented studies across store operations, team management, procurement and supply chain analytics.

01TVS

Store operations

Transaction & store operations control

THE CHALLENGE

High-volume transactions made it difficult to maintain a clear view of records, pending documentation and operational exceptions.

MY APPROACH

Organised inward and outward records, coordinated with related teams and used Excel tracking to follow pending issues through to closure.

BUSINESS VALUE

A more disciplined operating process with better visibility of daily activity. The case demonstrates how reliable records support inventory control and supply-chain execution.

Explore the working approach
  1. Maintain a structured inward/outward transaction register.
  2. Review incomplete documents and exceptions during daily follow-up.
  3. Coordinate ownership and record closure of pending issues.

A cleaner transaction trail

Receipt and issue records matter most when each item can be traced from request to movement to final reconciliation.

  1. 01 · CaptureRecord the material, quantity, department, document reference and movement time.
  2. 02 · CheckMatch physical receipts or issues with supporting documents and identify discrepancies.
  3. 03 · ResolveAssign an owner to each pending exception and confirm closure in the tracking sheet.

📍 What to watch: open exceptions, unposted receipts, reconciliation gaps and ageing follow-ups.

Inventory controlExcelDocumentation
Read original case study ↗Download PDF ↓
02TVS

Operations management

High-value operational flow management

THE CHALLENGE

A significant transaction flow required several activities to stay coordinated while protecting accuracy and continuity.

MY APPROACH

Applied Identify → Prioritise → Coordinate → Execute → Verify. Focused attention on critical activities, clear communication and repeated process gaps.

BUSINESS VALUE

Supported smoother day-to-day execution and developed practical capability in balancing speed, accuracy and cross-team coordination.

Explore the working approach
  1. Identify critical work and dependencies before execution.
  2. Track follow-ups and escalate unresolved exceptions.
  3. Verify completion to reduce repeated process gaps.

Control the flow of critical work

The process separates the urgent from the important and gives every high-value transaction a clear hand-off.

  1. 01 · IdentifyMap the request, deadline, dependency and team responsible.
  2. 02 · PrioritiseEscalate blockers that could stop materials or disrupt a downstream task.
  3. 03 · VerifyConfirm the transaction, document status and next owner before closing the loop.

📍 What to watch: pending approvals, document hand-offs, repeat exceptions and resolution time.

PrioritisationProcess improvementCoordination
Read original case study ↗Download PDF ↓
03TITAN

People & operations

Large store operations & team management

THE CHALLENGE

The role required coordinating 9+ executives and manufacturing canteen material needs while maintaining service continuity and cost awareness.

MY APPROACH

Allocated responsibilities, monitored business-critical priorities and strengthened communication and follow-up during busy operating periods.

BUSINESS VALUE

Strengthened management capability across people, process and cost, supporting a progression toward supply-chain and procurement leadership.

Explore the working approach
  1. Allocate team responsibilities around daily operating priorities.
  2. Keep follow-up and communication consistent during busy periods.
  3. Review unnecessary activities with a cost-conscious mindset.

Connect people, stock and service

Manufacturing support and canteen materials need a dependable daily rhythm across requirements, supply, issuing and team coordination.

  1. 01 · PlanReview the day’s demand, available stock and outstanding purchases with the operating team.
  2. 02 · DeploySet priorities for receipts, issues, vendor follow-up and service readiness.
  3. 03 · ReviewCompare actual usage with records and flag discrepancies for the next shift.

📍 What to watch: material availability, overdue supply, issue accuracy and escalation ownership.

Team leadershipStore managementCost awareness
Read original case study ↗Download PDF ↓
04INDEPENDENT

Conceptual SCM model

Procurement cost & supplier evaluation

THE CHALLENGE

A low quoted price can conceal poor delivery, quality issues or longer lead times. Purchase price alone is an incomplete basis for supplier decisions.

MY APPROACH

Designed a conceptual scorecard that considers price, quality, delivery, lead time, responsiveness and compliance. Introduced total-cost thinking into comparison.

BUSINESS VALUE

A structured basis for supplier review, risk identification and negotiation. This is an independent model, not a claim of measured employer savings.

Explore the working approach
  1. Define consistent supplier evaluation criteria.
  2. Compare commercial terms with quality and delivery risk.
  3. Use the scorecard to support periodic supplier discussions.

Look beyond the quoted price

This is an independent framework for comparing supplier trade-offs without presenting fictional vendor scores.

  1. 01 · QualifyCheck specification fit, quality evidence and compliance requirements.
  2. 02 · CompareReview price alongside delivery reliability, lead time and responsiveness.
  3. 03 · DecideDocument the reason for selection and set a review cadence for future orders.

📍 What to watch: total landed cost, on-time delivery, rejected quantities and supplier response time.

Supplier scorecardsCost analysisExcel / Power BI
Read original case study ↗Download PDF ↓
05INDEPENDENT

Analytics concept

Supply chain KPI & inventory dashboard

THE CHALLENGE

Operational records can be plentiful while teams still lack a single view of slow stock, delayed suppliers and the KPIs needing attention.

MY APPROACH

Designed a dashboard concept combining stock value, ageing, movement, pending orders, lead time, inward/outward records and operational exceptions.

BUSINESS VALUE

Shows how records can become decision support for inventory turnover, supplier OTD, procurement cycle time and stock availability.

Explore the working approach
  1. Bring inventory, purchase-order and exception data into one view.
  2. Monitor fast, slow and non-moving stock alongside supplier delivery.
  3. Use Excel → SQL → Power BI → Python as a development path.

Turn records into useful signals

The dashboard concept joins inventory, purchase orders and exceptions into a single set of management questions.

  1. 01 · PrepareClean material codes, dates, quantities and supplier names before combining data.
  2. 02 · ExplainDefine each KPI clearly so the same metric is calculated consistently.
  3. 03 · ActUse ageing, stock availability and open-order views to assign follow-up actions.

📍 What to watch: inventory turnover, supplier OTD, PR-to-PO time and stock availability. The home dashboard displays sample values only.

KPI reportingPower BISQL / Python roadmap
Read original case study ↗Download PDF ↓

Public portfolio summaries exclude confidential company information and vendor identities. Independent models illustrate a proposed approach, not a production deployment.

▶ DATA & DECISION SUPPORT

Making information useful.

⌘ From records to repeatable analysis

Python and structured data skills form part of my development roadmap. The aim is to reduce repetitive preparation and make operational reporting easier to review.

Illustrative footage · not a recording of employer operations

📊 A clearer view of performance

A useful dashboard brings stock movement, supplier delivery and pending actions into one conversation. The KPI case study develops this decision-support concept.

Illustrative footage · not a recording of employer operations
THE NEXT CONVERSATION

Good operations start
with the right people.

↓ Download résuméEmployer enquiry ↗