Yomari

Williams-Sonoma is a four billion dollar retailer based out of San Francisco, CA, that sells upscale household goods and furnishings through its stores and direct-to-customer channels. It has over 600 stores and owns such brands as Pottery Barn, West Elm and Williams-Sonoma Home.

Williams-Sonoma’s 2 TB data warehouse has over 650 active users running about 3000 on-demand reports every day.  Williams-Sonoma sought Yómarí’s expertise to develop and expand their retail data warehouse to a robust multi-channel and multi-brand enterprise reporting system.  Yómarí provided full life-cycle business intelligence consulting services that included everything from gathering end-user requirements to final production roll-out.

Williams-Sonoma uses Oracle’s Retail Data Warehouse (RDW) as the core of its data warehouse application, but has implemented significant custom solutions and functionality around this core. Data flowing to this application comes from dozens of applications including JDA, RMS, ReSA, IPMS, PKMS, etc.

Williams-Sonoma’s data warehouse uses Teradata as the database server, Ab Initio as the ETL tool, and MicroStrategy and Business Objects as the OLAP tools.

Gander Mountain is a billion dollar retailer based in St. Paul, MN with over 100 stores that operates the nation’s largest retail network of stores for hunting, fishing, camping, and marine products and accessories. 

Gander Mountain’s data warehouse has about 120 users who run approximately 1500 on-demand user-defined reports daily against a 3TB database. Yómarí was the leader in re-platforming their entire data warehouse from an Oracle database to a Netezza Performance Server, including re-writing legacy ETL programs, migrating data, and re-building end-user reports.

Gander Mountain uses Netezza as the database server, the Yómarí Oracle Retail Toolkit for data integration and ETL, and MicroStrategy as the OLAP tool.

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, RETL for data integration and ETL, and MicroStrategy as the OLAP tool.