Marketing Data Scientist

• Jul 2020 - Present

• Responsible for building out the data infrastructure of the organization. Oversaw data mapping, data movement, interfaces and analytics across the company ensuring all DW/BI standards & guidelines. • Built & migrated scattered data of the organization across dozens of platforms - shopify stores, advertising platforms, etc. - to a centralized cloud Data Warehouse – Google Bigquery. Set up, maintained, troubleshoot & improved on all the ETL jobs, data pipelines and also experience working with third party ETL solutions. • Built data marts with use of scheduled SQL queries that power all the reporting dashboards almost real time. • Designed & published live & fast interactive dashboards in Data Studio/Tableau for each department – Marketing, Finance, SEO, Product, Logistics & top-level Executive Board of the company to track key metrics & business KPIs to streamline understanding of business health in the past, present & future facilitating quick decision making. • Extensive use of Python, ML, SQL to curate, clean, visualize, analyze & forecast data to write reports that answer various ecommerce business questions – be it price optimization, subscription-based growth, revenue & discounts, etc. along with quick data delivery to customer service & logistics departments. • Presented and communicated the findings in an understandable and actionable way tailored to the user’s needs.

FinTech Analytics & BI

• Jan 2020 - Mar 2020

• Evaluated the sensitivity of stock categories & Close Price to the earnings surprise, from two yrs of FinTech data - Estimize. • Classify and impute meaningful labels to stocks describing their close price variation by combining two clustering models – one based on the trend and the other on the magnitude bands (K-means) they belong to. • A random forest model able to predict the above CP variation categories for each stock which rests upon the market cap, sector and the earnings reported in that quarter. • Provided Python scripts and an interactive Spotfire dashboard to monitor performance of stock portfolios and manage risks with an option to zero in on a profile of interest for the users, as part of the deliverable to the Focus List analytics of Point Focal.

Data Analyst

• Sep 2019 - Dec 2019

• Price Optimization to charge advertisers based on the costs incurred by Viacom for impressions aided by Facebook. • Data analysis on 2 yrs of Viacom’s extensive ad traffic data & cost-per-1000-impressions (cpm) estimates by Facebook. • Discovered the changes adopted by Facebook in cpm calculation from Feb’19 and corrected the offset model to perform CPM imputations for the Viacom pages that predicts the future costs. • Merged & joined 20 large data files, performed demographic clustering on page impressions, created a conversion funnel to calculate the frequency and target demographic for deeper engagement with the content of each page.

Note-Taker at Disability Resource Center

• Sep 2018 - Dec 2018

Real Estate Analyst

• Aug 2017 - Jan 2018

Business Development Intern

• Jan 2017 - Apr 2017