Rushikesh Dhus

Created a Python utility that revolutionized data management by automating DDL conversion, seamlessly transforming 40,000 DDLs, and driving remarkable efficiency. Generated a Python script for automated MemSQL DDL to BigQuery conversion, ensuring a smooth migration and efficient data management in the cloud. Designed and implemented a Python utility that automates the conversion of SAP HANA Calculation View SQLs into BigQuery, streamlining the migration process and enhancing data management capabilities. Built a powerful Python-based ETL framework on GCP using BigQuery, GCS, and Airflow for enhanced group membership management. Implemented active user tracking and identification of removed users, improving overall data governance. Engineered an advanced IAM policy analyzer on GCP using log sinks, BigQuery, and UDFs, providing streamlined identity access management for tables, datasets, and projects. Successfully migrated a Snowflake warehouse to Google Cloud Platform (GCP) leveraging the power of Dataform, BigQuery, and Workflow. This resulted in an impressive 189% reduction in overall costs and a significant improvement of 45% in performance. Accelerated the migration from AWS Redshift to Google BigQuery within a two-month timeframe, resulting in cost savings of $7 Million in licensing fees for the client.