Union City, California, United States
Full-time Pivotal Retail Group employee contracted to Ross Stores. Supported the Store Operations team by consolidating data from 3rd party sites and other sources onto a local SQL server. Collaborated with Store Operations and Business Intelligence teams to improve trend analyses and inventory forecasts using large data sets. Developed and maintained a full-stack data storage ecosystem using Microsoft Access and Excel add-ins as the interface.
Full-time Pivotal Retail Group employee contracted to Ross Stores. Trained and led a team of five Purchasing Agents for the Store Refresh Project. Coordinated and scheduled procurement deadlines to ensure adequate working time for Purchasing Agents and manufacturing time for vendors. Overhauled and streamlined processes, assimilating procurement duties from the New Store and Special Project teams. Continuously improved team efficiency by developing automated processes with VBA macros in MS Office suite.
Full-time Pivotal Retail Group employee contracted to Ross Stores. Procured fixtures for the Store Refresh project. Assisted in calculating fixture forecast using historical procurement history and projected demand from planned CAD drawings.