BHARAT BISEN

Experience

• 

  Ford Motor Company

  Jul 2020 - now

  Data Analyst

  Responsibilities:• Spearheading the development of a proof-of-concept (POC) chatbot employing LLM and RAG (Retrieval-Augmented Generation) to empower user-driven data exploration. This innovative solution has substantially enhanced document retrieval speed, ensuring swift access to relevant information.• Pioneering a proof-of-concept (POC) chatbot named "Data Extraction Tool (DET)" to translate user inquiries into SQL queries, streamlining data retrieval processes for improved efficiency.• Crafting a data pipeline (utilizing Python, Alteryx, and Qlik) to pinpoint pivotal factors influencing technician churn. Innovatively constructing an interactive Qlik dashboard, showcasing KPIs and charts to facilitate data-driven decision-making.• Analyzed and refined multi-source data to enhance TAC performance metrics, which led to a commendable 20% reduction in overtime expenditure and vehicle downtime.• Orchestrated the development and automation of an ML pipeline (utilizing XGBoost, Random Forest, and Regression) to forecast technician attrition and pinpoint key drivers, which resulted in 30% reduction in technician attrition and has been recognized through inclusion in the company's Award and Recognition program.• Enhanced Alteryx workflows through meticulous analysis and modification, which resulted in a notable 30-40% improvement in runtime efficiency.• Recognized as a 'Top Achiever' (2021) at Ford Motor Company for demonstrating complete ownership of products, leveraging data analysis, and implementing necessary dashboard improvements. Show less