Mar 2024 – Sep 2025 · 1 yr 6 mos · Remote

• E-commerce client:
• Led end-to-end Data Engineering and Analytics projects for an e-commerce client, significantly enhancing operational efficiency.
• Spearheaded the migration from Google BigQuery to Snowflake, achieving a 52% cost reduction (~$8,500 saved monthly) while improving processing performance.
• Developed automated Mirakl commission data pipelines and customer data analysis workflows, saving ~2 hours of manual efforts daily.
• Implemented real-time product stock status updates for the website, improving customer visibility into availability.
• Transitioned key Lightdash dashboards to Snowflake, ensuring seamless data exports for business users.
• Enhanced analytics with a Customer Lifetime Value (CLTV) dashboard, enabling deeper customer insights.
• Built DBT models for proactive email alerts and commission validations, significantly improving data accuracy and completeness.
• E-commerce client:
• Designed and implemented DBT modeling for marketplace events data, created a semantic layer in Looker, and developed dashboards for liquidity and checkout metrics.
• Optimized data pipelines, reducing both execution time and cost of DBT models and Looker charts.
• Finance client:
• Ingested data from multiple sources (Postgres, Singular, CleverTap, Mixpanel, Intercom) into Redshift.
• Architected a Customer 360 model using DBT, with Cube as the semantic layer.
• Created investor reports in Metabase for business stakeholders.
• Internal projects:
• Built a Finance data app for budget planning using Streamlit, supporting internal product-related data initiatives.
• Developed an automated setup guide generator for data ingestion connectors, reducing manual documentation effort from hours to seconds.

Jul 2022 – Feb 2024 · 1 yr 7 mos

• - Led data engineering projects and tasks supporting the Real Estate and Sales business streams at Frontdoor, Inc.

Oct 2020 – Jul 2022 · 1 yr 9 mos

• Started working for Frontdoor, Inc. (contract) from Jan'21.
• Delivered a Proof of Concept (POC) for J&J in Dec'20, a complex RPA project using UiPath (Excel, PDF, and Web automation) that reduced manual processing time from 8 minutes to 16 seconds.
• Previously worked as an RPA Developer, building three internal end-to-end automation projects using UiPath until Nov'20.

Jul 2022 – Sep 2023 · 1 yr 2 mos

• Took responsibility of Data Engineering projects supporting Real Estate and Sales business streams.
• Architected and developed a system to standardize addresses, properties, and listings data ingested from multiple vendors, ensuring data consistency and accuracy across downstream systems.

Dec 2021 – Jul 2022 · 7 mos

• Built outbound data pipelines to transfer business-critical data:
• Developed a GCP Cloud Function (Python) to extract data from Snowflake, retrieve private SSH keys from S3, and securely send files to Extole using SFTP, orchestrated using Cloud Scheduler.
• Designed and implemented architecture to convert Snowflake stored procedures into dbt models, improving maintainability and scalability.
• Developed a pipeline where Snowflake staging and production tables (materialized using dbt) were processed with Python scripts, containerized in Docker, executed on AWS Fargate, and sent to S3 in JSON format, orchestrated with Airflow DAGs, and finally integrated into Salesforce - increasing daily home warranty sales by ~30%.
• Built inbound data pipelines (ETL):
• Automated ingestion of files uploaded to S3 using event notifications and Snowpipe, transformied them using dbt, materialized into production tables using incremental load logic, scheduled through Airflow DAGs.
• Designed incremental load strategies for complex dbt models involving multiple sources, reducing computational cost and execution time.
• API integrations and automation:
• Created a Python GCP Cloud Function to extract data from Snowflake and push to Qualtrics via API, scheduled with Cloud Scheduler.
• Developed complex SQL queries from scratch on new Datamarts to meet evolving reporting needs.
• Consumed external APIs to ingest data, materialized it into Snowflake tables, and enabled reporting using Looker.
• Stakeholder support:
• Partnered with business stakeholders to resolve critical data issues, performing root cause analysis and timely fixes to ensure accuracy and reliability of business reports.

Jan 2021 – Dec 2021 · 11 mos

• Designed and delivered visually impactful dashboards in Looker to support data reporting. Extracted, interpreted, and analyzed data to deliver key metrics, transforming raw data into actionable insights that drove major business decisions.
• Built data modeling solutions for multiple estimate review reports, reducing Looker’s monthly cost by 10x.
• Collaborated with business stakeholders across India and the USA (from marketing, product & engineering, operations, real estate, sales, and finance) to define KPIs and deliver insights using Looker and complex SQL queries.
• Automated daily data manipulation tasks using Python scripts, leveraging Looker’s Custom Action Hub and JavaScript for business-specific requirements.
• Partnered with the Data Engineering team to resolve data quality issues, with Snowflake as the data platform.
• Additional responsibilities:
• Integrated Looker with Airtable to export and update/append user-requested columns.
• Automated export of additional business input data from Looker dashboards to Google Sheets via Looker Form Action for extended business use.
• Conducted training sessions for the team on Python (OOP concepts, inheritance, exception handling), Flask, and ML model deployment using Flask.
• Implemented an end-to-end automation: generating PowerPoint presentations directly from Looker dashboards using Python scripts and Looker API.

Mar 2019 – Dec 2019 · 9 mos · Pune/Pimpri-Chinchwad Area

• Organized the Image Capture Campaign at Pune Institute of Computer Technology.
• Motivated students from FE to BE to contribute data for Google Crowdsource, supporting the development of various Google algorithms.

Nov 2018 – Oct 2020 · 1 yr 11 mos · Pune/Pimpri-Chinchwad Area

• - Contributed to the Assistant Tutor Campaign and other initiatives such as Image Label Verification and Handwriting Recognition under Google Crowdsource.

Sep 2018 – Aug 2019 · 11 mos · Pune/Pimpri-Chinchwad Area

• Mentored and groomed a team of juniors to take on responsibilities within the Electronics domain.
• Conducted sessions to guide the team in successfully organizing ElectroQuest for Pulzion 2019.

May 2018 – Aug 2018 · 3 mos · Pune/Pimpri-Chinchwad Area

• Initiated a new event 'ElectroQuest' under Pulzion, the annual technical fest of PASC, for both junior and senior categories.
• Formed and led a team to design two rounds: Quiz + Treasure Hunt and Circuit Implementation.
• Successfully organized and executed ElectroQuest at Pulzion'18, attracting strong participation from engineering colleges across Maharashtra with 200+ participants in this single event.