~ Key Result Areas ~ Successfully delivered more than 25 data warehousing and data integration projects Designed and developed business critical multi-terabyte Business Intelligence (BI) Data Warehouses and Data Marts on AWS, Snowflake, Hive, Oracle, Greenplum Data lake implementation on AWS S3 for multi-terabyte data sourced from RDBMS, Cloud Applications and AdHoc files Expertise in different Data modelling techniques between RDBMS and Cloud DW’s Played a crucial role as a Data Architect to integrate more than 15 source applications into a Datawarehouse Implemented Data Quality checks for row counts, data anomalies, table refresh Good understanding of Lamda and kappa architecture Improved the reporting performance by 72%, due to which top 20 mostly used reports renders in < 20 secs Expertise in performance tuning of SQL’s, ETL jobs. Having track record of reducing data load window from 40+ hours to under 10 hours Led a team of 6 engineers to reengineer the data loads strategy which resulted in 75% reduction in load time Built an end to end AWS cloud data warehouse which resulted in o 23% reduction in overall cost of the project o Robust Scalable data warehouse which is immune to underlying source system changes o Built a Logical data model which is immune to reporting layer changes o 200+ Tableau reports supports more than 400 users Expertise in SQL performance tuning, have achieved more than 50% reduction in run times Extensive knowledge on Data virtualization using Denodo. Developed DV for more than 16 data sources Successfully implemented BBB (Billing, Booking and Backlog) Datamart which is the integration of SFDC, Oracle, Siebel and CSV files. Airflow implementation for orchestrating ETL and Data ingestion jobs Exposure to working closely with Data scientists and Good understanding of deploying ML in large scale environment – Currently pursuing DS career track in Springboard India Worked in US as a BI consultant across multiple locations Good in co-ordination with globally spread-out users’ group for business requirements and UAT cycle in EMEA, APAC, North America, South America, and Canada