Aspiring Data Analyst with experience in Data Analyst tools

Vaibhav Verma  • Peerlist

- Cleaned and transformed multi-country Zomato data using Power Query to ensure standardized and optimized modeling.- Engineered a star-schema model that includes a Date Dimension, along with modular DAX KPIs for analyzing restaurant counts, rating aggregations, vote metrics, and service availability.- Developed interactive drill-downs across cities and cuisines to provide clear and actionable business insights.

Zomato Restaurants Analysis

•Designed and deployed a scalable Azure Databricks pipeline using PySpark, DeltaLake, and Autoloader to enable incremental data ingestion following the Medallion architecture. • Orchestrated a star-schema pipelines with SCD Type 1 & 2, surrogate keys, and automated fact tables for robust dimensional modeling. • Integrated Lakeflow/DLT and DBT to deliver declarative ETL workflows with automated data quality validation. • Improved transformation performance by 3x through optimized Spark configurations and adaptive query execution for near real-time analytics.

Azure/Databricks | Databricks End-to-End Data

• Developed a modern data pipeline using PySpark and Delta Lake with layered (Bronze–Silver–Gold) architecture for efficient and scalable data processing. •Automated dimension and fact table creation using SCD Type 1 logic with incremental updates and surrogate key generation, significantly reducing manual ETL maintenance. • Integrated DBT for modular transformations and validation, ensuring consistency and reliability across multiple data layers.