Designed Pentaho ETL to generate and output SODI (current inventory) of MakeRoom with onhand items that have > 0 quantity. Creation of Extraction Transformation. Transformation to hold variable, Transformation to serialize inventory from JDA, Transformation to Store serialized inventory data to staging table, Transformation to add prefix and create SODI csv files.