• Conducted optimization analysis to determine the best locations to stand up new DCs to increase network service levels• Maintain a weekly inventory rebalancing model that determines items and quantities to be transferred via trucks• Continuous usage of Open Solver to redirect inbound containers to different DCs to increase sales and satisfy current DC space and shipping constraints • Collaborated cross functionally with BI, Supply Chain and Finance to develop a projected ending inventory model in DOMO that is by SKU-Location• Established a tool that changes DC available inventory for specific SKUs to force sales orders to drop at optimal locations• Identified gap in Q4 capacity for a DC and quickly put forward a mitigation plan that includes shifting 200 inbound containers of specific items to different DCs• Placed over $100 million of POs for 200 SKUs with optimized weekly arrival times, locations, and inventory levels• Extensive use of NetSuite to issue POs, transfer inventory and create reports• Lead analysis and inventory transfer for launch of new DC, customizing hundreds of truck shipments with designated SKUs and quantities• Substantial use of MS Excel functions including regression, complex If statements, Vlookup, Pivot Tables, Solver and Macros• Improved forecasting accuracy by developing a process to record and account for missed sales due to out of stock inventory• Used Cube IQ Software to optimize container space and decrease landed costs• Automated acceptance of Amazon bulk orders based on projected inventory levels by location• Automated daily importance rankings of available containers to unload for multiple DCs based on forecasted lost revenue and projected container fee accrual costs

• Inspected interactive dashboards for minute data errors with sharp attention to detail• Discovered nine user interface and data discrepancy errors within first week• Received company-wide recognition for finding a critical dashboard error• Utilized new software programs such as mTAB for data quality control• Streamlined manual processes, increased accuracy and efficiency using Alteryx Analytics• Tested software updates using Testlink and oversaw edition/revision of new test cases• Performed competitor analyses to solve market research problems with limited instruction

• Strong background in Microsoft Excel and SPSS• Rigorous course centered around advanced MS Excel functions• Selected after earning A’s in relevant courses• Extensive experience with advanced Excel functions (pivot-tables, solver, macros, v-lookup)• Demonstrated exceptional patience and interpersonal skills helping students

• Successfully communicated with coworkers to serve up to 8 tables at a time• Used POS system in a timely manner to accept payments• Acquired excellent customer relations experience

• Promoted the new speaking club with speeches and student outreach to meet enrollment quota • Organized and lead weekly programs to improve public speaking• Used spreadsheets to assign and document club member roles and attendance for each meeting

• Conducted marketing research for launching a retail application in the iTunes store• Applied online and social media marketing techniques such as Google Adwords and Facebook promotion