Years of Experience
Architecting scalable cloud data warehouses and lakehouses on Snowflake and GCP BigQuery with optimized partitioning, clustering, and dimensional models.
Building robust modular data transformation pipelines using dbt, SQL, and PySpark following the Medallion Architecture (Bronze → Silver → Gold).
Implementing automated CI/CD deployment workflows, schema validation, and stringent data quality checks that eliminate 20+ hours of weekly manual toil.
Reverse-engineered 300+ complex SQL queries into 105 centralized dbt mart models on Snowflake, significantly reducing cloud compute costs while ensuring data integrity.
Architected end-to-end retail data pipelines with automated dbt tests and native Snowflake Alerts, establishing an INFORMATION_SCHEMA DQ system.
Cleaned and transformed multi-layer retail transactional datasets across Medallion architecture using Dataproc, Dataprep, and BigQuery on Google Cloud Platform.
Batch & streaming ingestion from retail POS logs, marketing APIs, transactional databases, and event streams.
Immutable append-only raw storage. Preserves source fidelity, lineage audit history, timestamps, and schema-on-read flexibility.
Deduplication, schema enforcement, data type casting, business logic transformations, and data quality testing via dbt models.
Star & snowflake dimensional schemas optimized for low-latency BI queries, executive reporting, and downstream ML features.
INFORMATION_SCHEMA and scheduled audit tasks to enforce schema validation, referential integrity, and business rule conformance.
Built automated data extraction and transformation pipelines using Python and SQL. Streamlined reporting and audit reconciliation routines, reducing analysis turnaround time by 60% and eliminating 20+ weekly manual operational hours.
Dr. B. R. Ambedkar National Institute of Technology Jalandhar
Premier technical institute established under the NIT Act by the Government of India, recognized for engineering and research excellence.
Architecting and operating high-throughput production data pipelines on Google Cloud and Snowflake, ensuring critical sales, customer, and marketing datasets are delivered with high availability.
Certified in cloud data warehousing, performance optimization, data sharing, security governance, and scalable storage architecture.
Verify Credential
Demonstrated expertise in building modular, tested, and documented analytics engineering transformation workflows with dbt Core.
Verify Credential
Certified in architecting data processing systems, operationalizing machine learning models, and building scalable BigQuery & GCP pipelines.
Verified Professional
Honored with enterprise recognition for outstanding engineering performance, dedication, and exceptional contribution to retail client projects.
Excellence Honor