Ankit Dsouza

About Ankit Dsouza

Seven years managing Enterprise Master data using open-source tools. Data warehousing specialist with comprehensive experience in designing and executing end-to-end data pipeline changes, ensuring seamless project delivery through effective stakeholder engagement and task prioritization. Expert in leading technical deep dives and cross-functional conversations, leveraging SQL and Python to solve complex problems while optimizing for runtime. Committed to enhancing team performance by developing unit tests and validation queries, fostering a collaborative environment for continuous improvement.

Experience

1. Senior Data Engineer

   Grubhub

   Feb 2021 — Present · New York, NY, US

   Architected ads data mart which resulted in an in-house Advertising analytics asset. Solidified stakeholder expectations, confirmed data grain, field mapping, and a tangible data model. Subsequently designed and coded the ad impressions asset, complete with unit tests, validation queries, and user acceptance tests.2. Built ads discrepancy tracker to compare and highlight daily count differences across three sources: ads service, ads per clickstream, and Koddi (third-party ad ranker) daily exports. This helped to identify issues in ad activity and mitigate erroneous billing to GH advertisers based on visible Koddi ads.3. Enabled ads data to flow into the topics data pipeline which readily enabled ad-based distinction in downstream topics’ Tableau dashboards.4. Expanded search data coverage on the homepage by simplifying ETL to pull from search logs along with the regular clickstream. This resulted in improved marketing targeting for diners based on their last known location per search data.5. Onboarded and successfully coached a returner candidate to acquire a full-time position with GH.6. Designed and implemented a generic toolkit to compute quality metrics over time and highlight dates containing possibly faulty data since the last ETL refresh.

Education

• University of Connecticut

  Master’s Degree, Business Analytics and Project Management

  2016 — 2017

• Birla College of Arts, Science and Commerce

  High School, Science

  2007 — 2009

• Greens English School

  SSC, High School/Secondary Diplomas and Certificates

  1997 — 2007

• University of Mumbai

  Bachelor’s Degree, Computer Science

  2009 — 2013

Skills

• T-Tests
• C++
• Chi-Square
• Predictive Modeling
• Apache Pig
• Flume
• Sas Jmp
• Oracle Database
• Clustering
• Microsoft Excel
• Machine Learning
• Microsoft Powerpoint
• Numpy
• Hbase
• Ptc Integrity Client
• Java
• Text Classification
• Hive
• Oozie
• Microsoft Sql Server
• Software Development
• Python
• Apache Kafka
• Decision Trees
• Ibm Rational Clearcase
• C#
• Php
• Linear Regression
• Microsoft Visio
• Xml
• Tableau
• Anova
• Pandas
• Visual Studio
• A/B Testing
• Sqoop
• Programming
• Extract, Transform, Load (Etl)
• Wps
• Sql