• Manual processes for ETL and consolidating data- took 3-4 days and scale was a big bottleneck. • Fulfillment for 18000+ stores all across India by analyzing the purchase behavior of customers to help Britannia identify the demand-supply pattern and keep up to date with the SKU's • Provisioned infrastructure on AWS - VPC, ETL instances, RedShift, Processing Server and Server which will host Tableau. • Established Site to Site VPN • Initiated one time dump of the data from On Premise SQL server to S3 • Authored ETL jobs for loading from multiple data sources from On-premise to AWS S3 and help Emisha team connect Tableau Server to the Redshift • Deployed and served ML model Workload S3, Redshift, VPC, EC2, Sagemaker Industry FMCG Britannia Industries Limited is one of the oldest existing Indian food-products corporations. Existing manual process of consolidating data for analytics and predictions on customer's buying patterns took 3-4 days, now replaced by a real time dashboard, thus making tracking and management easy.