Yash Mhatre Email & Phone Number

Phoenix, Az, Us

Litchfield Park, Arizona, United States

Implemented and maintained databases on AWS, including schema design and data population, and created a data pipeline for efficient storage, retrieval, and management of extensive house listing data and image data.Executed SQL queries to perform data transformation, aggregation, filtering, manipulation, and categorization and performed quality checks as per tasks assigned in JIRA tickets to maintain the database in AWS S3 buckets.Optimized pre-trained computer vision techniques using AWS Rekognition for image tagging and visual search features and developed a recommendation engine utilizing collaborative filtering, increasing the accuracy of image-based queries by 25%.Coordinated with technical and business teams to understand data requirements and shared solutions and progress reports to the CEO.

Tempe, Arizona, United States

Initiated improvement process using Six Sigma methodology and diagnostic data analysis to identify the bottleneck and root cause and resolve production line issues, reducing downtime and saving costs by 30%.Utilized Excel-VBA and Power BI to collect, clean, and analyze data by creating dashboards to monitor KPIs and suggested improvements to the Production Manager that led to an increase in production output of 33% for the same time.Collaborated with Managers, Technical Staff, Supervisors, and Production Staff to ensure production readiness and meet deadlines and delivered insightful reports to the CEO, improving decision-making efficiency.

Tempe, Arizona, United States

IEE380 - Probability and Statistics for Engineering Problem SolvingIEE474 - Quality ControlFacilitated testing, grading, and reviews of examination responses to ensure maximum accuracy for over 200 students.Conducted weekly office hours to provide additional support and understanding of course material to students.

Mumbai, Maharashtra, India

Generated 12-month rolling forecast by reviewing historical sales trends, marketing, and financial forecasts, and evaluated forecast accuracy to present insights to Demand Planning Manager and Supply Chain Manager to meet deadlines. Derived data insights for business verticals by identifying and tracking KPIs such as fill rate, service levels, inventory velocity, customer retention, and on-time in full (OTIF) to reduce gaps in inventory, reducing cost by 20%.Conducted annotation and classification of large datasets for products, enhancing data accuracy and enabling efficient demand planning processes using SAP-IBP for short-term forecasts, and increased forecast accuracy by 12%.Coordinated with Purchasing, Inventory, and Business Teams to manage inventory through product life cycle and minimized obsolete products by allocating resources to high-selling products.

Master Of Science - Ms, Industrial Engineering, 3.6

Relevant Coursework - Supply Chain Modelling and Analysis, Statistics in Data Mining, Data Science Decision System Analytics, Regression.

Bachelor Of Engineering - Be, Instrumentation Technology/Technician, 7.94

Activities and Societies: aeroRGIT - Logistics Head - Aero Modelling Club of College International Society of Automation (ISA) - Member

Hsc, Electronics

Activities and Societies: College Chess Team