Developed queries/tables for sales/inventory/in-transit commodities/distribution center data to understand the accuracy of offer on the product. Developed stored procedures for sales forecasting based on current sales and sale-index and predicting end-of-sale inventory. Developed excel template for exporting report data with formatting for daily leadership meeting. Generating code for automation of report/exporting data to excel and deployment. Regression testing and design change to accommodate data load on server by breaking data chunks in parts. Customized report for generating data for particular SubBrand used by SubBrand owners. Conducted training sessions for user-group for report.