I learned and worked on various technologies like Snowflake, dbt, Airflow, Terraform, AWS and more.I worked on building an ELT pipeline to process and analyze Customer, Order and Supply data.Used Terraform to provision the infrastructure like S3 bucket, roles and more.Used Snowflake to implement three layers of the ELT process namely, Raw, Curated and Consumption.Used dbt to implement models and tests to apply transformations and automated the process with Python scripts, Airflow and used Github Actions for CI/CD.Worked on writing complex business queries to analyze various KPIs and used Tableau for interactive dashboarding, consuming data from Consumption layer which implemented a hybrid of star and snowflake schemas.

Worked on descriptive analytics by building interactive dashboards using Highcharts, Crossfilter and dotONE.Worked on testing of SQL queries to verify data integrity and consistency among dashboards, database and cloud data warehouse for different KPIs while the data was being migrated from MySQL to Snowflake.