Retail planner is legacy system made by us for our client who is a mastermind with experience of 20 years into Retail Industry. It captures data from all verticals of a cloth or shoe manufacturer and gives a glimpse of company’s financial performance within minutes of calculations. This helps them to know their Stock, Sales, Gross profit etc. this year compared to last year. Data gets refined upto 5 levels of granularity to know the performance in each department like Sneakers, heels, gender-wise data, location wise and sub group wise. We made this in Asp.net with SQL. Weekly 60 millions of records used to get stored in database and then calculations have to be in process in the background for the board of directors to see the weekly report.