Created SQL Scripts to import 20,000 SKUs in 5 mins instead of 2 weeks
Summary
The tool to import new fashion SKUs into the RMS would crash and take weeks to load so I spent weeks learning how MS RMS updates it's SQL tables and once I mapped it out, I wrote scripts and created templates for the team so they could load all 20k SKUs in the one CSV template and then I manually would import it and push it down to all 62 stores across ANZ.
Skills Demonstrated
Impact
- It allowed for the company to sell right away instead of having to wait weeks.