Raghav Sood Email & Phone Number

New York, New York, Us

New York, New York, Us

- Implemented EKS based infrastructure to run python jobs orchestrated by Airflow- Setup Spark based pipelines on EMR to generate metrics on Blockchain Properties- Implemented local dev internal tool for running Big Data AWS Services (Athena, Glue, EMR, MWAA) using Localstack- Responsible for AWS infrastructure for Data Platform team in the Investments group- Setup core services and infrastructure using Terraform for the Market-intel team- Designed Data Warehousing solution using Redshift, Kafka-Connect, Spark and Airflow

San Francisco, California, Us

• Handled all ETL jobs and data pipelines for the central Data Engineering team• Responsible for maintaining the Snowflake data warehouse and Airflow cluster of the company• Handled movement of Real time Streaming data near a petabyte scale using services like AWS Kinesis, Firehose, SQS, S3, Athena, Glue, Elastic search etc.• Maintained real time AWS Elastic search sourced analytics BI dashboard based on node.js with visualizations using d3 and angular.js• Performed key Data Platform integrations to cater to Data Science solutions

Pittsburgh, Pa, Us

NoSQL Database ManagementAgile MethodsResponsibilities involve grading of assignments and interacting with students via online forums and Office Hours.

Dover, Delaware, Us

Quantifying Relationship between Car rental and Airline Industries - Capstone, CMU• Understanding the car rental and airline data and performing Exploratory Data Analysis• Fitting regression models to understand key features and feature importances• Understand a basic auto regressive model and its nuances in a seasonal market• Building a classification model to predict any increase/decrease in car rental prices across different time cohorts using learnings from car rental data as well as airline data

Bengaluru South, Karnataka, In

•Setup & maintained Redshift based analytics data warehouse•Monitored the reporting for company metrics by guiding and managing the team of all internal analysts across functions•Ingested semi-structured and structured data and built, maintained tables/views•Designed, implemented, and maintained new high-availability real time data pipelines with event-driven system using AWS Lambda•Maintained, supported and improved the performance of existing ETL applications in production and troubleshot data issues•Worked closely with stakeholders like analysts, data scientists, product, biz-strategy teams to extract actionable insights from data•Monitored website downtime and reduced load on the system by executing timed data migration solutions•Actively engaged in architecture design, data dictionary documentation and code reviews•Performed SQL tuning to reduce the data load time.•Worked on and released an internal scoring system which was based on client performance framework to score users on the grounds of performance in the system using various factors. The scoring system went on to get adopted by the entire operations team to work with in order to achieve respective targets•Worked on churn analysis, insights of which helped in achieving a 30% decrease in overall consumer churn within a year•Assisted in adopting new pricing and tenure strategies by providing the important insights derived out of various cohorts of consumers resulting in an increased tenure retention and a higher average revenue per user•Created and maintained key BI and analytics dashboards for different functions and products•Designed, developed, & supported data analytics ETL solutions from PostgreSQL database to Amazon Redshift using Python•Responsible for all ad-hoc analysis and tracking performance of all products across the organization. Analyzed results of various projects that required A/B testing resulting in product growth insights

Teaneck, New Jersey, Us

Completed training in Advanced Java and SQL

Masters, Information Systems Managment

B. Tech, Information Technology