Pranav Rupwate

About Pranav Rupwate

At Tata Consultancy Services, my role as a System Engineer has been defined by a strong foundation in data engineering and warehousing. Our team\'s focus on building scalable ETL pipelines in Snowflake has enabled seamless data movement and transformation across complex enterprise systems.By leveraging SQL, JavaScript stored procedures, and metadata-driven automation, we’ve created reusable solutions that improve performance and maintainability. My commitment lies in driving innovation in the modern data stack, harnessing the power of cloud platforms and automation to build robust data architectures that support informed business decisions.

Experience

1. System Engineer

   Tata Consultancy Services

   Feb 2022 — Present · Mumbai, IN

   Designed and implemented scalable ETL frameworks in Snowflake using JavaScript stored procedures Automated data movement across Staging → Active → Consumption layers using metadata-driven logic Integrated with AWS S3 for external file ingestion and built file validation, schema comparison, and load monitoring pipelines Developed reusable, parameterized procedures to avoid code duplication and simplify onboarding of new sources Managed complex transformation logic using CTEs, MERGE, and window functions for high-performance loads Tuned Snowflake performance using clustering keys, result caching, and micro-partition pruning Created and maintained custom metadata tables to track batch loads, reruns, and rejects with clear audit trails Implemented role-based access control (RBAC) and enforced secure access across environments Built interactive Power BI dashboards by integrating Snowflake datasets for real-time business reporting Applied data modeling best practices using star schemas, relationships, and row-level security (RLS) Authored complex DAX measures and calculated columns for accurate and scalable KPIs Automated Power BI refresh schedules and supported self-service BI through shared dataflows and templates Collaborated with business stakeholders to translate data into actionable insights through dynamic visualizations-Key Achievements: Migrated hardcoded ETL logic into fully dynamic, metadata-driven stored procedures Reduced manual intervention by 90% by automating batch handling, file validation, and rerun logic Improved ETL load time by 70% through optimized transformation and performance tuning techniques Delivered real-time executive dashboards with Power BI, enhancing decision-making for leadership Improved data quality and governance with schema enforcement, secure access, and audit trail Recognized for delivering scalable, high-performance BI solutions across large financial data environment

Education

• Sandip Foundation's Sandip Institute of Engineering and Management, Mahiravani, Trimbak Road, Nashik 422213

  Bachelor of Engineering - BE

  2018 — 2021