Apr 2025 – Present · 11 mos · Delhi, India · 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 Marketing domain.
• Proficient in data storytelling, transforming complex data insights into simple, easy-to-understand narratives and presentations for cross-functional teams.

Sep 2024 – Mar 2025 · 6 mos · Gurugram, Haryana, India · 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 – Aug 2024 · 4 mos · Panchkula, Haryana, India

• 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 – Mar 2024 · 11 mos · Panchkula, Haryana, India

Aug 2022 – Mar 2023 · 7 mos · Panchkula, Haryana, India

Feb 2022 – Aug 2022 · 6 mos · Panchkula, Haryana, India

Jan 2022 – Jan 2022 · 0 mo · Remote

• 𝐓𝐞𝐚𝐦 𝐒𝐢𝐳𝐞: 𝟔
• Worked on Java based Menu Management Application.
• Worked closely with team members to divide tasks, ensuring efficient project progress and timely completion.
• Supported fellow interns by providing assistance, sharing knowledge, and offering feedback to enhance individual and team performance.

Jun 2021 – Jul 2021 · 1 mo · Remote

• The '𝐎𝐧𝐥𝐢𝐧𝐞 𝐐𝐮𝐢𝐳 𝐀𝐩𝐩𝐥𝐢𝐜𝐚𝐭𝐢𝐨𝐧' is designed to reduce manual effort and save time by automating the quiz process. The application allows the admin to organize quizzes subject-wise, and students can attempt the quizzes online. 𝐓𝐞𝐚𝐦 𝐒𝐢𝐳𝐞: 𝟓
• 𝐅𝐞𝐚𝐭𝐮𝐫𝐞𝐬 𝐚𝐫𝐞:
• Quiz Organization
• Automatic Grading
• Effective Examination
• Question Management
• User-Friendly Interface