Orscheln is a billion dollar retailer based in Moberly, MO that sells farm and home related products. It has about 150 stores mostly across the Midwest United States.
Yómarí led the Oracle Retail Data Warehouse implementation at Orscheln. The data warehouse is used by merchants, buyers, planners, and store managers to perform analysis on inventory management, sales performance, pricing and promotions effectiveness, vendor compliance, loss prevention, etc. Yómarí was in charge of all project activities related to the successful conversion from a legacy data warehouse to the new Oracle data warehouse.
Orscheln uses Oracle as the database server, ETL for data integration and ETL, and MicroStrategy as the OLAP tool.