Case Study Of
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.
© Divensi 2017