Yash Malhotra Email & Phone Number

West Haven, Ct, Us

Essex, Connecticut, United States

United States

▪ Extracting data from the admissions warehouse of the university and cleaning and preprocessing it to analyze the pattern trends for internationalstudents at each intake (Fall and Spring).▪ Analyzed and interpreted complex datasets, including student’s behavior data, sales data, and market trends, to identify patterns, trends, andopportunities for process optimization and revenue growth.▪ Assisting the Data Engineering team with scalable computing needs of research projects, developing infrastructures and data pipelines for machinelearning experiments, and supporting documentation, training, and research publications.▪ Designed and implemented data pipelines using Hadoop Spark, and Kafka for processing large volumes of data from various sources.

Texas, United States

▪ Implemented SDLC and Agile/Scrum methodologies and communicated with internal clients to ensure accuracy was more than 75%.▪ Conducted analysis, A/B testing and assessments and devised new operational processes to translate client needs into formal requirements; therebygoverning reports that led to a 40% increase in productivity.▪ Developed and maintained ETL processes using Python and Airflow to extract, transform and load data into a centralized data warehouse.▪ Designed and implemented data modeling solutions for the data warehouse using snowflake schema.▪ Developed and implemented statistical models and algorithms to perform predictive analytics, customer segmentation, and forecasting, resulting in a15% increase in customer acquisition and a 10% improvement in retention rates.▪ Worked with different teams to understand their data requirements and designed data solutions to meet their needs.▪ Created automated testing frameworks to ensure data quality and accuracy.▪ Conducted data analysis and developed reports using SQL and business intelligence tools such as Tableau and Power BI to support business decisions.

West Haven, Connecticut, United States

Mumbai, Maharashtra

▪ Spearheaded a SaaS infrastructure initiative website that includes custom competitions among employees or students, to ensure employeecorporate social responsibility, leading to 4x more participation.

Mumbai, Maharashtra, India

▪ Extracted service logs using SQL, performed A/B testing on modules to pinpoint specific times and modules of occurrence of issues to resolve servicerequests related to data warehouse and user dashboard issues.▪ Managed a cross-functional team of 10 members resulting in 2+ new feature updates with a 10% reduction in save/load time and 15% operation time.▪ Improvised and consolidated end-to-end service processes restructured the communication flow among different departments to increase theaccuracy of the ML models by 5%.▪ Mentored and provided guidance to junior analysts, assisting in their professional development and enhancing the overall analytical capabilities of theteam.▪ Developed and maintained SQL queries and data extraction scripts to retrieve data from multiple databases and data sources.▪ Conducted ad-hoc analysis and prepared reports on key performance indicators (KPIs) for various departments, including sales, marketing, andfinance.

Mumbai, Maharashtra, India

▪ Manipulated data sets using Google BigQuery to conduct statistical analysis and perform quality checks on analytic results using SQL queries.▪ Formulated Python codes with statistical methods to consolidate data, along with an automated verification process for efficiency, confirming 80%accuracy of the gathered data.▪ Effectively implemented and communicated daily workflow procedures to fellow team members, resulting in a 15% increase in productivity. ▪ Led data analysis and reporting initiatives for multiple departments, including finance, sales, and marketing, to support business decision-making andstrategy development.▪ Collaborated with the marketing team to design and execute A/B tests, analyze campaign performance, and optimize marketing strategies, leading toa 25% increase in conversion rates.

Master'S Degree, Data Science, 3.53 Out Of 4

Activities and Societies: - Senator for the Graduate Student Council - Director of Operations, Data Scientist Alliance - Secured the first.

Bachelor Of Engineering - Be, Information Technology, 8.55

Activities and Societies: 1. Colloquium: Participated in 2017, Runnerup for Project Competition in 2018, 1st prize for Poster Presentation.

Diploma, Information Technology, 89%

Activities and Societies: 1. Academics: Two Certificate of Honor for securing the third position in academic year 2013-14 and 2014-15. 2..

School, Std 10Th, 76.33%

Activities and Societies: Grade 6 Graded Examination in Spoken English Entry Level Certificate in ESOL International (Speaking.