Case Study Of

Master Data Management for Retail

Case Study : Master Data Management for Retail


Our client is an American upscale fashion retailer tailored to solving unique customer requirements for large scale deployments of mission critical IT assets through innovative engineering solutions. They have 271 stores operating in 36 states, which includes 117 Full-Line stores and 151 discount stores.


Our client asked Divensi to help them build a master data management hub on SQL Server.


Divensi developed ETL workflows using SSIS, used BizTalk for workflow and data cleansing and exposed WCF services for third-party to consume master data. Divensi conducted a long-term engagement to gather business and technical requirements, design and develop the appropriate solutions, and assure the quality of the deliverables against the requirements and the existing data warehouse. The team provided deliverables on a monthly basis.

The delivery began with a pilot phase that focused on development of ETL workflows using SSIS. The goal was to fully understand and document the EDW architecture and our client’s internal processes.


  • Control Flow Components
  • Data Flow Components
  • Transformation included RDBMS, Flat Files, XMLs, Index Log Files, and Binary Files
  • Workflow Monitor
  • BizTalk for workflow and data cleansing
  • Informatica


  • Helped standardize master data from 15 locations that included in-house applications and applications maintained by third-party
  • 11% productivity gain over 2 years
  • Client meets 100% SLA maintaining sync between master data across systems

© Divensi 2021