Adtech (Sponsored Products)

• Backend Engineer responsible for building and maintaining data pipelines

• Work with Data at scale to process, store and generate reports that help making business decisions including but not limited to attribution for instore and online transactions

• Built Adtech campaign management system for Sponsored Products platform that helps updating campaign budgets realtime

• Primarily use Airflow as the data orchestration layer and Apache Spark framework for data processing needs that uses Google's dataproc clusters

• Extensively use Google Big query and Azure SQL for reporting and adhoc querying needs

• Have used Google cloud storage & Azure's Blob storage for storage needs

Media and Entertainment marketplace

• Led the team to design and implement revenue forecasting framework for media & entertainment clients

• Automated an end-end forecasting framework, leveraging AWS Glue, Python, SQL & RESTful APIs that allowed for running the data & forecasting pipeline thereby reducing manual effort by almost 80%

• Collaborated with the team to help design and implement star schema that included a combination of fact & dimension tables

• Genericizing of the framework to support any client data that could be leveraged across variety of

customers seamlessly thereby reducing manual effort of data configuration and setup

• Implemented a RESTful API endpoint that provided clients to medium to consume forecasts

• Designed integration framework by collaborating with client to integrate the forecasts got from the RESTful API response into Sales Force system that was used by the client

DEI Initiative

• Led the technical team to build descriptive analytics platform for Community policing

• Built KPIs to garner insights into Police agency performance in different Organizational & developmental

categories and how it impacts crime rate

• Designed & implemented the platform to benchmark each Police agency to other agencies in the same

geographical region or in certain Organizational & developmental categories of agency performance

• Architected the end-end system that included automating data pipelines for disparate data sources,

perform data mining to gain insights from data through PowerBI Dashboards

• Designed & implemented the data warehouse that incorporated star schema data modeling standard using

Azure MySQL DB

• Designed and led the team in implementing data pipelines that utilized Python, Azure MySQL & Azure

Data factory for updating data based on event driven and scheduled triggers

• Monetized the data by building a data repository that allowed for collecting & re-distributing data via

RESTful API endpoints

• Implemented dynamic pricing framework for a major online ticket resale marketplace utilizing A/B testing infrastructure for rapid ‘sense-and-respond’ that aided 4% revenue uplift. Tools: Python, R, Spark & Hive

• Developed a contextual, value-driven pricing framework for a large B2B food distributor using R

• Developed a suite for Machine learning & Business Insights. Tools: AWS, Tableau and Python

• Developed ensemble machine learning algorithm to predict sales for major automotive manufacturer

• Led the development of pricing framework for entertainment operators. Tools: Python, R, Excel, Tableau

• Created suite to scrape events, hotel prices, weather data etc. from websites intended to provide the team a platform to enrich data for exploratory analysis and model building. Tools: Selenium, Python, MySQL

• Design, Develop and test Media applications mostly Enhancement projects.

• Worked on embedded C and C++ with a reputed infotainment company as our client

• Responsible for Design, Development and Testing (White box & Black Box testing) of Application as per the requirements of the customer