Gaurav Deshpande

• Performing comprehensive statistical analysis to determine critical factors influencing crash and fatalities rate, and developed machine learning model to forecast occurrences and severity of accidents • Generated valuable business insights through data analysis utilizing text parsing and NLP techniques on reports to uncover markets for fraudulent activities and establish relationships between business in transportation industry • Created data visualizations in Tableau to uncover valuable insights on violations from transactional data and effectively communicate results through comprehensive reports and dashboards

• Teaching assistant for Undergraduate courseworks - WPC300: Problem Solving and Actionable Analytics and CIS405: Business Intelligence. • Guided students with assignments and projects. • Performed administrative work, proctored exams, and graded student exams, assignments, and projects. • Held weekly office hours to provide tutoring and assistance to students.

• Designed and implemented consolidated reports and dashboards on Salesforce and PowerBI, enabling the team to gain real-time insights into project progress, leading to the efficient on-time delivery of over 50 EDI launch projects and communicate updates to stakeholders • Proactively identified potential project risks and implemented effective mitigation strategies, while also conducting thorough post-mortems to analyze project outcomes and identify opportunities for future improvement • Utilized effective project management techniques to lead bi-weekly calls with resellers and carriers, delegating tasks to analysts and ensuring project expectations were met

• Conducted root-cause analysis and resolved data-related issues in ApteanMES using SQL Server Management Studio, ETL procedures and Data Warehousing, resulting in improved data accuracy • Assisted clients in creating custom reports and dashboards on PowerBI and ApteanMES interface, resulting in increased efficiency of manufacturing operations • Configured and managed integration between Server and Client’s Automation hardware, ensuring seamless and reliable data transmission between systems and reduced downtime • Developed Salesforce dashboards to track and analyze support KPIs, increasing team’s SLA to 100% and providing valuable insights for future improvement

• Experience in leading and managing teams, including supervising a team of 16 students in the design and fabrication of fixed-wing UAVs for the SAE Aero Design Competitions, managing operations, finances and successfully raising $17,300 for the Aero Club through sponsorships and organizing aeromodelling workshops called 'Aerotach' at schools, and implementing 5S, Continuous Improvement processes and improving labour utilization in the workshop to enhance productivity and efficiency

My responsibilities included: - In raising sponsorship of ₹1,50,000/- for the club by signing MOU's with the sponsors. - In the design of 2 UAV prototypes. - In the fabrication and testing of the prototype

• Studied, developed, and implemented TLMS (Live dashboard developed using Macros in Excel VBA) in the production of R-Transmission of high-performance Sport Utility Vehicles (SUV) using Six Sigma DMAIC methodology in hard machining under Cutting Point Management (CPM) of the Toyota Production System (TPS) by monitoring the manufacturing processes

Relevant Coursework: Data Mining, Descriptive and Predictive Analytics, Data – Driven Quality Management, Analytical Decision Modelling, Advanced Marketing Analytics, Deep Learning