Ekta Derwal

Case Project 1: Hospital Pharmacy Inventory & Expiry Control

• Performed requirement mapping, fit-gap analysis, and FDD preparation for a hospital pharmacy case project; configured Inventory Organization, Item Master with lot control & shelf-life attributes in Oracle Fusion SCM.
• Designed and executed UAT test scripts in lab instance, validating expiry alerts, lot tracking, and stock depletion workflows in the healthcare inventory processes.

Case Project 2: Healthcare Equipment Procurement & Distribution

• Conducted business requirement gathering, BRD preparation, and fit-gap analysis for procurement cycle; configured Supplier Registration, Purchase Requisition & PO approvals in Oracle Procurement Cloud.
• Prepared traceability matrix & test cases, executed UAT for procurement workflows including three-way match, supplier onboarding, and sourcing events.

• Spearheaded market research across the Cladding & Building Material Industry with 800+ dealers, architects, sales team & end consumers to identify gaps and suggested solutions for process improvements.
• Ideated the development of Al-based visualizer to enhance real-time product visualization, improve client satisfaction, reduce sales TAT by up to 90% and increase market share.