Jul 2020 – Jan 2024 · 3 yrs 6 mos · San Francisco Bay Area

• As the first Data Engineer in the company, I built core datasets that represent users, enterprises, marketing, revenue and logging events
• Worked with cross functional stakeholders from data science, sales, account managers to identify and prioritize data requirements for building foundational datasets that help measure the topline revenue metric, ARR and other related revenue metrics
• Built patterns and abstractions for ingesting and consuming data from external data sources like Salesforce, Clearbit, Google Ads, etc. into the data warehouse and rich information about users, enterprise accounts ,etc.
• Use Airflow and AWS stack (S3, Redshift, Redshift Spectrum) to build data pipelines that process 10MM+ rows of raw data daily.
• Contributed to the in-home ETL testing framework to setup data validation rules constraints like null checks, primary keys, value limits, etc.
• Optimized ETL queries to bring down the ETL run-time to help with clear cluster resources during business hours.

Feb 2019 – Jul 2020 · 1 yr 5 mos · San Francisco Bay Area

• Led the migration of the Homes Checkout data foundation, partnering with Engineering to define and validate the core logging schema, updating the checkout data model & ETL pipelines and defining conversion & user behavior metrics for identifying key frictions in the checkout flow
• Unblocked experimentation for product teams by identifying root causes of experiment imbalance, finding bugs in the product & experimentation setup, using ad-hoc analyses for informing high stakes iterations
• Collaborated with Data Scientists across Payments, Membership and Trust teams on an executive dashboard to surface trends in key partner team metrics and assess the impact of checkout sub-flows on conversion
• Conducted company-wide SQL training to empower cross functional partners to independently answer their data questions

Feb 2017 – Feb 2019 · 2 yrs · San Francisco Bay Area

• Identified limitations of a complex weighted top line metric used by Branded Content team and moved the team to a simpler metric aligned with the team’s goals.
• Empowered business operations team with a dashboard for creator leads powered by an ETL pipeline using page similarity data for sourcing new creators similar to the existing creators
• Flagged policy violating partnership posts using a pipeline to look for fraudulent creators based on posting patterns
• Built a propensity scoring model to identify users that are likely to pay for creators
• Provided opportunity sizing for starting a new Creator marketplace program and awarding ad credit coupons to creators
• Managed a Data Science intern to scope out the work for identifying key factors impacting retention and churn for subscriptions

Feb 2016 – Feb 2017 · 1 yr · Greater Boston

• Implemented an article recommendation engine using Text Analytics and Collaborative Filtering using Python.
• Built a Tableau dashboard for visualizing sales attribution calculated through an R-based marketing mix model.
• Provided consultation to the data platform team on requirements for setting up the AWS based data analytics platform for a client.
• Built a RShiny based tool for a healthcare client

Sep 2015 – Dec 2015 · 3 mos · Greater Pittsburgh Region

• Worked with Prof Rema Padman on aggregating and analyzing data to identify relationship between patients’ diagnosis, lab readings, medications, demographics, pulse, temperature and sleeping patterns with severity of the chronic kidney disease.

May 2015 – Aug 2015 · 3 mos · San Francisco Bay Area

• Enhanced, on-boarded and productionized key metrics related to LinkedIn’s News Feed consumption.
• Performed exploratory & segmentation analysis to show how the feed consumption varied across different segments.
• Identified several data irregularities and worked closely with the engineering team to get the issues rectified.
• Built daily reports that reported how metrics were changing over time.
• Gathered data related to video sharing on the Feed to help understand the extent to which spam videos were being shared.
• Helped uncover the reason behind a critical drop in consumption metrics using data segmentation and visualization.

Jan 2015 – Apr 2015 · 3 mos · Greater Pittsburgh Region

• Performing univariate and multivariate analysis on PNC bank's customer' financial transactions data to find out anomalous patterns that indicate deteriorating financial health of a customer.

Jun 2010 – Jul 2014 · 4 yrs 1 mo · Pune/Gurgaon/Bangalore

• Led a team of engineers to build a D3.JS based frontend application to help match employee skills with client project requirements
• Used Scala on Play Framework with AngularJS to build a Single Page Web application for User Registration flow
• Built a Java based multithreaded asynchronous Invoice Generation system using custom parsers for JSON and XML input
• Trained 30+ developers on Unit Testing, Functional Testing, Design Patterns, Test Driven Development, Refactoring, Pair Programming, Object Oriented Design, Continuous Integration and Continuous Deployment