In my experience of 14+ months working with ZS Associates, I have learned and contributed to different areas of business intelligence/big data.I have been playing major role in orchestrating the system using python scripts and developing scripts for loading and processing of data on Hive,impala and pig. I was involved in the reconciliation of sales data across newly developed database and existing legacy systems.I also developed an automated validation tool for the same using python and VBA. My next project included transforming data warehouse platform from Teradata to Redshift with the ultimate goal to reduce the run times for Cognos reports and Online Dashboard bursting. During this project I performed various PoCs for finalizing data load approach (Single, Hybrid and Union ALL), getting best suitable (Compound and Interleaved) and perfect order of sort keys etc. for our use case.