Identify gaps in inventory visibility and provided real-time dashboard visibility for KPIs such as on-hand/on-order inventory, inventory aging by customer, branch, and warehouse. Led on average to an overall net reduction of over $5M in unnecessary inventory.
Provide real-time visibility into warehouse KPIs such as Cost Per Line Item and On Time Delivery (OTD). Align on Global Operational Definitions. Develop Data Warehouse and BI platform. Led on average to an overall warehouse cost reduction of $3.2M YoY and OTD increase of 10%.
Provide real-time P&L including cost allocations, rebate calculations, volume purchase agreement calculations, DSO and DPO calculations. Ability to slice P&L by 8 dimensions such as customer, supplier and business unit.
Align on KPIs and provided real-time visibility into transportation cost recovery and order consolidation. Led on average to an overall recovery of $2.6M YoY.
Create bookings, billings, backlog, and inventory real-time dashboards. Add benchmarks and automated time period comparisons such as MoM or QoQ. Has uncovered unnecessary on-hold orders totaling $1M in recovery.
Automate EHR data and reporting. Eliminate the manual process required for data extraction from 3rd party EHR systems (AllScripts, Amazing Charts, eCW, NextGen, EPIC, MicroMD, etc.) used for metrics reporting, predictive modeling, and risk management.