Data Analysis, Machine Learning, Data Science

YASH KAKKAD

Dearborn, MI ***** ad6lg8@r.postjobfree.com 313-***-**** linkedin.com/in/yash-kakkad007 OBJECTIVE

Dynamic and results-oriented Analyst with 3+ years of experience in leveraging data for strategic decisions. Proven track record of collaborating cross- functionally to develop data-driven solutions that optimize processes and aids business growth. Expertise in predictive modeling, data warehousing, data governance, data visualization and machine learning algorithms. EDUCATION

Master of Science, Data Science with specialization in Business Analytics August 2022 - April 2024 University of Michigan – Dearborn, MI

Data Security and Privacy, Big Data Analytics and Visualization, Advanced Artificial Intelligence. Bachelor of Technology, Mechatronics Engineering August 2018 - April 2022 Parul University – Vadodara, India

Data Structure and Algorithms, Advanced C programming, Machine Learning, Artificial Intelligence. PROFESSIONAL EXPERIENCE

Data Analyst - Internship June 2023 - August 2023

Yazaki North America - Canton, MI

Automated ETL of vendor data through Python algorithms to generate BI dashboards that enhance the vendor selection process based on pricing and delivery time of raw materials.

Formulated BI dashboards using Microsoft Business Intelligence (BI) tools like PowerApps, Power Automate and Power BI - to highlight leading and lagging KPIs of purchasing and procurement teams.

Implemented advanced SQL queries in Microsoft Access to reduce the time of generating material arrival time report(s) by 80%.

Collaborated with 6 different business units to understand their IT and Analytical needs and hence support thorough optimum solutions.

Updated 35 + excel forms using MS Excel lookups and Visual Basic Application (VBA) to align with current PO, Inventory, and Purchasing form formats.

Teaching Assistantship January 2023 - April 2024

University of Michigan - Dearborn, MI

Generated individual student report(s) using Business Intelligence dashboards and MS Excel to avail the professor with student insight(s) throughout the course.

Implemented python code-based machine learning (ML) algorithms to analyze performance of 90 + students, to provide personalized feedback.

Digitized the content for course of Strategic Business Management to improve virtual learning experience. Robotic Process Analyst December 2021 - July 2022

Bot Hive - Chennai, India

Improved input data quality of 2000 + products on the admin dashboard using SQL queries for standardizing data format, units, dimensions, and labels.

Enhanced product manual selection process using Python programming to reduce exploratory data analysis (EDA) time by 90%.

Automated product research process using python web scraping for 150 + product manuals.

Designed and developed interactive Power BI dashboard to provide real-time insights of company’s robotic product (coupler). SKILLS

Analytical tools - ETL pipeline development, Python, Windows PowerShell, R, C/C++, Google analytics, MS-Excel, Spark.

Visualization tools - Power-BI, Tableau, MS- Power point, SharePoint, PowerApps, Power Automate.

Database management - SAP Snowflake, AWS, Amazon Athena, Apache Kafka, SQL, MySQL ACADEMIC PROJECTS

Real-time Streaming Analytics for Stock Market Analysis:

Designed and implemented a scalable ETL pipeline for stock market data using EC2 instance on AWS and Apache Kafka.

Established and managed the consumer and producer ends of the Kafka server using Windows PowerShell.

Developed an efficient Python code schema to ensure low-latency processing.

Achieved 60% accuracy in predicting stock market movements to identify trading opportunities. Identification of optimal material shipment modes using Tableau.

Designed descriptive Tableau dashboard visualizing performance trends of all shipment modes.

Implemented time series analysis to find seasonality patterns in delivery time through different shipment modes and hence improve ETA by 60%. Root Cause Analysis (RCA) of failure modes of Turbo engines using ML.

Analysis of 1000 + turbo engine cycles to find correlation between process parameters and breakdown using linear regression and SVM models.

The effecting variables are further checked to estimate the remaining useful life of the turbo engine with 85% accuracy. Text Summarization for text content using NLP.

Abstract summarization of lengthy legal documents using natural language processing (NLP) to improve the processing time of contracts.

Tested the model on sample documents to achieve 96% accuracy. ACCOMPLISHMENTS & CERTIFICATIONS

LinkedIn learning skill badge – (Microsoft Power BI)

Python for Data Science – (IBM skill badge)

Advanced Google Analytics

SQL and Relational Databases (IBM Certificate)

Contact this candidate