Missguided
Cloud Migration, BI Development
On-site
During this contract, Missguided was the fast-growing UK-based company specialising in fast-fashion clothing and accessories for young women, mainly online but also with two dedicated retail outlets in London and several concession outlets in Selfridges department stores.
They were selling over a million pounds of clothes every day as well as dealing with returns and promotions, which created a lot of complex and fast-changing data in numerous systems and wildly different formats (SQL Server, MySQL, SAGE, Magento and SAP).
They contacted me during the early stages of a migration project to move their back-end systems from SQL Server to SAP. Following several trial runs and carefull planning, we succesfully migrated the entire business over to the new system in just a couple of hours during the night, using automated scripts, in time for the next morning shift to start without a hitch.
Key achievements
- Successfully migrated data operations from a SQL Server-based system to an SAP-based system
- Overcame multiple issues with key-violation and key-departure integration issues
- Moved stock, finance, product management and sales data in a timely manner between systems
- Learned a lot about SAP and double-entry book-keeping
- Worked with many departments simultaneously and at many levels of the business (this was a very person-oriented role)
- Validated systems using SSAS, Power BI and Excel Power Pivot
- Extensive use of SQL Server Integration Services provided ease of re-runs and greatly assisted process validation