Apr 2025 – Present · 1 yr 1 mo · Gurugram · Remote

• Connecting SMEs with right funding options.
• Architected and implemented scalable, automated pipelines for data extraction, transformation, and analysis within a Data Mesh framework, optimizing data flow and ensuring high availability and performance across the Partner Credit Services domain.
• Proficient in data storytelling, transforming complex data insights into simple, easy-to-understand narratives and presentations for cross-functional teams.

Aug 2024 – Apr 2025 · 8 mos · Gurugram · Hybrid

• Engineering data pipelines to support high-volume processing, leveraging MWAA, SQL, DBT,
• Appflow tailored to client needs, optimizing business outcomes across multiple pharmaceutical
• subdomains, including Sales, Customer, Marketing, Engagement etc.
• Architected multi-layered DBT models leveraging ETL/ELT best practices, implementing snapshots
• and incremental strategies (SCD1/SCD2), and collaborated with cross-functional teams to deliver
• scalable data solutions supporting key business requirements.
• Built a centralized data repository for a pharmaceutical client by ingesting multi-domain (Customer, Sales, Marketing, Engagement etc.) data from sources including Veeva CRM, IQVIA, and Salesforce, modelled the data to deliver analytics-ready datasets that enabled downstream reporting and insights generation.
• Leveraged DBT materializations (incremental, materialized views, tables) and implemented snapshots and custom macros to design efficient load strategies including SCD1, SCD2, and truncate-load, optimizing data transformations, maintainability and model refresh performance.
• Conducted data quality checks on datasets exceeding 20M+ records, collaborated with QE team to identify and resolved 150+ DQ issues, ensured readiness for production deployment and achieved 99.9% data accuracy.
• Collaborated with cross functional teams to deliver the solutions as per the client requirements that optimize their business outputs.

Apr 2024 – Jul 2024 · 3 mos

• Integrated enterprise data from diverse sources (SFTP, APIs, databases) into Oracle and Snowflake
• via Python, Airflow, DBT, and AWS ETL pipelines, enabling scalable storage and unified access.
• Designed and implemented a scalable data warehousing and transformation framework, optimizing Airflow pipelines, managing feature delivery and rollback strategies, and maintaining system reliability and documentation.
• Led the modernization of legacy on-prem SybaseIQ database by orchestrating the migration of 120+ production tables (avg. 30GB each) to Snowflake using Airflow pipeline templates for seamless data transfer via AWS S3, reducing operational costs from several million to under $290K.
• Designed robust and scalable batch data pipelines to ingest Equity/ Stocks/ Indexes/ Securities data from on-prem Sybase IQ into Snowflake via Amazon S3 as an intermediate storage layer, processing CSV, JSON, and Parquet formats, and optimizing data storage with date-based partitioning and columnar compression for efficient querying and cost-effective processing.
• Orchestrated data pipelines in Airflow to perform historical and incremental data loads, implementing sharding for parallel processing of high-volume datasets, retry and failure handling, and building fact and dimension tables in Snowflake; leveraged zero-copy cloning and Time Travel for data recovery, and enforced robust data quality checks to ensure accuracy, reliability, and trusted reporting.
• Implemented data governance protocols to ensure data quality and compliance, resulting in improved data accuracy and security measures.
• Engineered a stats aggregation process to monitor DBT’s Snowflake Warehouse utilization, automating monthly and quarterly reporting and eliminating 4+ hours of manual effort per report.

Apr 2023 – Jun 2024 · 1 yr 2 mos

Aug 2022 – Jun 2023 · 10 mos

Mar 2022 – Aug 2022 · 5 mos

• Started delivering very quickly straight out of college & always appreciated for fast
• learning & proactiveness.

Sep 2021 – Jan 2022 · 4 mos · New Delhi, Delhi, India · Remote

• Assisted in the design and implementation of AWS cloud solutions for clients
• Collaborated with the team to troubleshoot and resolve technical issues on AWS platforms
• Conducted research and provided recommendations on AWS best practices and cost optimization strategies