Publicly traded multichannel high-end fashion apparel retailer with more than 100 large footprint locations.
As a luxury retailer, the client’s business was highly dependent on vendor relationships with branded, high-end designers. To help gauge the value of its investment in each partnership, and to negotiate optimal assortments and vendor contracts, the client sought to deeply understand the cost and profitability of its relationships.
At the forefront of innovation
Across all of its business units, the client was implementing a strategy to unify data silos and develop a single view of the enterprise – vendors were now to become part of that single view. Delivering on the strategy would require finance data housed in Oracle E-Business Suite Financials (EBS) and merchandise data housed in Oracle Retail Analytics (RA) to be merged into a single schema – an unprecedented integration with no prior blueprint to follow.
With its deep understanding of RA, Oracle, and experience across many retail enterprise source systems, Yomari was tapped by the client’s primary systems integrator to help tackle the challenge. Yomari rapidly performed a gap analysis to determine the new components required in the Oracle Retail data warehouse and OBIEE business intelligence layer. Of course, as the project evolved, so did the business requirements. Yomari’s experience working directly with retail business users enabled the team to adapt to the changing requirements, ensuring
that the technical vision remained in lockstep.
Foundation for success
With requirements set and the implementation kicked off, Yomari designed processes to ensure data integrity across the enterprise data warehouse: ensuring that KPI’s were mapped back to their appropriate source systems, that batch processes were properly designed, and that new data model and table designs would help achieve the desired analytics goals. As the project proceeded, Yomari remained on-board to deliver a powerful vendor profitability solution for the merchandising team, and the technical underpinnings enabling future
expansion of their analytic capabilities.