Preparation of Script to generate the Trunc Sales for Jam. Extracted and compared the Sales data of Anne Klein, Champion, Clarks, Hamleys, Jessica, Kenneth Cole, Longchamp, Polo Ralph Lauren, Tommy Hilfiger, Tory Burch, and TWG brands in Pentaho and JDA. Endorsed the brands and dates with variance for refresh in Pentaho.